-
Useful SQL Server Date Formats
Here are a few date formats that I’ve found useful over the years. These all come from getdate() and are changed by using COVERT or FORMAT commands. I’ve chosen a few of the date formats I’ve used the most: YYYY-MM-dd YYYY-MM-dd HH:mm YYYYMMdd YYYYMMdd_HHmm You can take the results from the commands and assign them…
-
Finding the SSRS Log File
After many years working with SQL Server Reporting Services, I’ve gotten myself into a few situations where I had to examine the SSRS log to see what was happening with data sources, subscriptions, and other, unique SSRS particulars. For a time, I thought that the regular SQL Server Error Log was enough. But experience has…
-
T-SQL Tuesday March 2019 – Dipping into the Cookie Jar
This month’s TSQL Tuesday is hosted by Shane O’Neill (B/T). The challenge this month is to write about “Dipping back into the cookie jar” or using the memories of a past challenge or accomplishment to help you through a new issue.
-
T-SQL Tuesday July 2018 – Working with Dates
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 GitHub for everyone to see. The script expects two date parameters, a start date and…
-
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.
-
Generate fresh data for WideWorldImporters
See how to use built in stored procedures to grow the WorldWideImporters SQL Server database with new, current data.
-
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 see. The script expects two date parameters, a start date and an overall end date. The script will then assign…