Note: I originally wrote this a few years ago but never posted it. It resurfaced when I migrated the blog so it’s being posted now.
After watching Kevin Kline’s (blog...
2022-06-13 (first published: 2022-05-16)
550 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Kenneth Fisher (blog | twitter) asks us to talk about our...
2022-05-11
2 reads
Is this thing on? If you’re reading this test post, it means DNS has updated properly and I’ve successfully migrated to Azure Static Web Sites. Welcome!
2022-05-10
5 reads
Over the next couple days (weeks?), a significant change is coming to my blog (and if you’re reading this text, it’s already happened). I will be leaving Wordpress behind...
2022-04-25
5 reads
If you’d asked me 5 years ago if I would ever speak at Summit, I’d have said “no way, not possible.” I didn’t even think I was able to...
2021-11-19
6 reads
A collection of links and resources related to my PASS Data Community Summit 2021 presentation Backup Basics with PowerShell and dbatools including bonus content! Resources dbatools main site dbatools...
2021-11-10
7 reads
A collection of the resources mentioned in my PASS Data Community Summit session Backup Basics with PowerShell and dbatools, including bonus content!
2021-11-10
9 reads
Over the summer, I spent some (a lot of) time working on updates to a script at work which runs multiple processes in parallel. Everything seemed to work OK...
2021-10-27
28 reads
Over the summer, I spent some (a lot of) time working on updates to a script at work which runs multiple processes in parallel. Everything seemed to work OK...
2021-10-27
6 reads
Kind of a diversion into a Visual Studio Code/Azure Data Studio tip here (this works in both, as well as SQL Server Management Studio). I’m not a regular expression...
2021-08-31
32 reads
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
hi for the 2 years i've been here I believe we've had "encryption" turned...
Hi I have an overnight process that moves allot of claims records Been working...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers