Rudy Rodarte . com

SQL Blogs

SQL and SQL Server database topics. Includes design, issue resolution and tips.

The following PowerShell script finds all of the Active Directory group memberships for users in a target Active Directory Group. All you need to provide is the target Active Directory group, and the script does the rest.

List all Active Directory Groups for users in an Active Directory group

The following PowerShell script finds all of the Active Directory group memberships for users in a target Active Directory Group. All you need to provide is the target Active Directory group, and the script does the rest.

Jan, 11
See how to use built in stored procedures to grow the WorldWideImporters SQL Server database with new, current data.

Generate fresh data for WideWorldImporters

See how to use built in stored procedures to grow the WorldWideImporters SQL Server database with new, current data.

Dec, 28

Loop over dates in SQL Server

I’ve written the script below at least once a month, for either reports, or working with large data sets. Rather than reinventing the wheel, I’m posting my code here and to GitHub for everyone to […]

Dec, 27

Stored Procedure Results in an SSIS Message Box

I was recently asked if it is possible to display the results of a query / stored procedure in an SSIS Message box. The answer is Yes, with a bit of C#. RudyRudy Rodarte is […]

Mar, 08
Learn how to recover the Report Data tab in SQL Server Reporting Services (SSRS)

Recover the missing Report Data tab in SSRS

Learn how to recover the Report Data tab in SQL Server Reporting Services (SSRS)

Jan, 13
You can use a VB or C# message box to view the current value of a variable. No more guessing!

View SSIS Variables via Message Box

You can use a VB or C# message box to view the current value of a variable. No more guessing!

May, 19

Training Links

At work, we are approved for 2 training classes per year. Here is a list of SQL Server training classes that I’ve found, aside the the popular ones everyone knows about: Global Knowledge Quick Start […]

Nov, 07

Navigation

Please use the navigation to move within this section.