-
ANSI_NULLS: When indexes break a query
How often does adding an index in SQL Server break something? Let’s say it’s under normal operating conditions, no corruption, […]
-
Can you import this JSON?
In a recent project, I got the opportunity to learn way more about the SQL Server (2016 and later) JSON […]
-
Clean up your dbatools
It’s easy to get the latest version of the dbatools PowerShell module:Update-Module -Name dbatoolsHowever, this does not remove the old […]
-
Introducing ISDeploymentCmd
A few months back, after resuming SSIS development full-time on a new team, I began to look for ways to […]
-
SSRS and Kerberos with a Cluster
I recently came across an error involving SQL Server Reporting Services (SSRS) that I recognized immediately but still took me […]
-
Little fish, big pond
The SQL Server Community feels large. There are so many resources online at my disposal that I may even say […]