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]
Two approaches for generating random passwords. One with T-SQL, another with PowerShell. Which will I settle on?
[...Read More]
WITH RESULT SETS is no box of chocolates-you have to know what you're gonna get from sp_execute_external_script. Or do you?
[...Read More]
My 100th blog post coincides with T-SQL Tuesday: Folks Who Have Made a Difference.
[...Read More]
A stored procedure can return multiple result sets. Why can't I do the same with sp_execute_external_script? ??
[...Read More]
I've finally found a tangible example of something I could use R for.
[...Read More]
What happens when different DATETIME formats are used for a point in time database restore?
[...Read More]