Moving a database to an older version of SQL Server is hard. Here's what worked for me.
[...Read More]
Shredding XML to get some meaningful output from sys.fn_xe_file_target_read_file is a pain in the ass. Let's fix that!
[...Read More]
Counting records in a CSV file is expensive, and sometimes slow. Can SQL Server help?
[...Read More]
After far too many years, I spend some time getting familiar with prepared T-SQL statements.
[...Read More]
A bespoke utility for exporting SQL Server data to Excel.
[...Read More]
Using a function for something it wasn't meant for...just for fun.
[...Read More]
Options for putting a SPID to sleep are a little weird.
[...Read More]
For T-SQL Tuesday #106, Steve Jones asks us to write about an experience with triggers, either good or bad.
[...Read More]