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]
Some scripting options for running the SQL Server features discovery report.
[...Read More]
Concatenate With Separator-a new T-SQL function that "addresses" a real world problem.
[...Read More]
SQL Server 2017 gives us the new T-SQL function TRIM(), which has an added surprise.
[...Read More]
After stubbing my toe on return data types, I find the new SQL Server 2017 function STRING_AGG() is pretty cool.
[...Read More]
Can you remember all the date and time styles supported by CONVERT? Me neither!
[...Read More]