Does the ARITHABORT setting hurt SQL Server performance? Yes, because with ARITHABORT OFF SQL Server can build a very different plan and queries may slow down.
Capturing Successful Logins With an Extended Events Session
A login event is a connection, not a user action. A small session shows how one query can leave three of them behind.
Countdowns in T-SQL: Days, Hours and Minutes Until an Event
A countdown that says 1 day for a one-second gap is counting boundaries, not time. Here is how to build one that tells the truth.
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation
A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.
String or Binary Data Would Be Truncated: Find the Column With Msg 2628
String or binary data would be truncated used to hide which column was too long. In SQL Server 2019, Msg 2628 names the table, the column and the value. Here is the same insert on 2017 and 2019, and what to do once you know the column.
How to Compile Queries and Not Execute Them? – Interview Question of the Week #219
How do you compile queries and not execute them? SET NOEXEC ON validates the syntax without running the statement, as this simple SSMS example shows.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151
Another SQL Server upgrade failure: upgrade step SSIS_hotfix_install.sql hit error 15151 because a user did not exist. Here is how I fixed it.