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]
SQL Server can tell you when [tempdb] is out of space. And you don't even have to ask!
[...Read More]
Can you remember all the date and time styles supported by CONVERT? Me neither!
[...Read More]
Two approaches for generating random passwords. One with T-SQL, another with PowerShell. Which will I settle on?
[...Read More]
Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS...again.
[...Read More]
Dave ponders Machine Learning Services and sp_execute_external_script WITH RESULT SETS.
[...Read More]