GREATEST, LEAST, and recent T-SQL helpers replace bulky CASE patterns while preserving explicit rules for NULL and data types.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani
Balmukund Lakhani turns his popular SQL Bangalore UG session into a guest post: the story of the -m startup parameter and a lesser known way to use it.
Rebuilding One Partition Online Instead of the Whole Index
A big partitioned table does not need a full index rebuild every night. Here is how to rebuild one partition safely.
Enforcing Object Naming Rules With a DDL Trigger
Enforce procedure and index names with a DDL trigger, inspect EVENTDATA, audit rejected attempts, and list existing violations.
SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage
Six years after my first post, a follow up on QUOTED_IDENTIFIER ON/OFF with a quick example of double quotes in identifiers and a real world question.
Building a Portfolio as a Data Professional
A data professional portfolio should show a few complete projects, clear write-ups, and runnable code that explains decisions and tradeoffs.
SQL SERVER – SQL in Sixty Seconds – Need Your Opinion
Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.
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.