This snippet is so nice, I’m posting it again! I’ve utilized the script below at least once a week, for either reports, or working with large data sets. Rather than reinventing the wheel, I’m posting my code here and to … Continue reading T-SQL Tuesday July 2018 – Working with Dates
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. Continue reading List all Active Directory Groups for users in an Active Directory group
See how to use built in stored procedures to grow the WorldWideImporters SQL Server database with new, current data. Continue reading Generate fresh data for WideWorldImporters
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 see. The script expects two … Continue reading Loop over dates in SQL Server
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#.
Continue reading “Stored Procedure Results in an SSIS Message Box”
Learn how to recover the Report Data tab in SQL Server Reporting Services (SSRS) Continue reading Recover the missing Report Data tab in SSRS
I was lucky to be picked to present at SQL Saturday 550 in San Antonio this year! But, not only do I love presenting, I also love attending as many sessions as I can. Here are the sessions I am … Continue reading SQL Saturday 550 – San Antonio – Sessions I’m Attending
