The execution plan picture only shows the shape. The properties window shows what really happened, and I walk through it on a tiny example.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
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.
Masking Test Data With REGEXP_REPLACE in SQL Server 2025
Before a production copy reaches a developer, replace the real emails and phone numbers. Here is a small, checked way to do it with REGEXP_REPLACE.
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.
SQL SERVER – FIX: Install Error: A Network-Related or Instance-Specific Error Occurred While Establishing a Connection to SQL Server
A network-related or instance-specific error usually hits applications, but my client saw it during SQL Server installation. Here is how to fix it in that case.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.