Want to drop a column? First find column used in stored procedure code. I share the T-SQL script that searches every stored procedure for a column name.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Width Sensitive and Width Insensitive Collation: An Example
What is a width sensitive collation? I explain it with a simple example that compares half-width and full-width characters under both collation settings.
SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]
A reader shared a handy SSMS tip: press CTRL+] to switch between two parenthesis and jump from an opening bracket to its closing one in long queries.
SQL SERVER – Effect of Case Sensitive Collation on Resultset
A simple example of how a case sensitive collation changes the result of the same query, and why you should not change collation without knowing the business need.
Debug Button in Older SSMS: SQL in Sixty Seconds #020
The Debug button in older SSMS could be mistaken for Execute, and the debugger is gone from current versions. This page keeps the 2012 episode and tests four ways to debug T-SQL without it on SQL Server 2025: parse only, error line numbers, progress messages and the OUTPUT clause.
DATEDIFF Counts Boundaries, Not Time: Getting Durations Right
A report can say one year of service after a single day. Here is why DATEDIFF does that, and what to use instead.
SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always
A beginner asked why a query returns results sometimes but not always. I share where I would start looking and invite you to add your own answer.
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.