Moving to SSIS 2012 or 2014 and worried about losing the Package Configurations you built? Good news: the classic option is still there. Here is how to use it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL Server – Knowing the Use of Deprecated or Discontinued Features
After an upgrade, a DBA’s management asked if any deprecated or discontinued features were still in use. Here is how to find that out on a live server.
SQL SERVER – Generating Row Number Without Ordering Any Columns
ROW_NUMBER needs an ORDER BY clause, but what if you do not want to sort by any column? Here is a simple trick to generate a row number without ordering.
SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger
A reader’s database kept switching back to compatibility level 80 every day. Here is how a DDL trigger can catch who ALTERed the database and when.
Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics
Remove special characters with a corrected SQL Server loop and a 2025 regex expression, while defining ASCII and collation rules.
Great Indian Developer Summit 2015: Three SQL Sessions and a CPU Check
Great Indian Developer Summit 2015 brought me to Bangalore and Hyderabad for three SQL Server sessions. This page keeps the dates, topics and photos. It also adds a CPU check I would start with today, tested on SQL Server 2025, because one session was about CPU performance.
SQL AZURE – How to Disable and Enable All Constraint for Table and Database
sp_msforeachtable does not work in Azure SQL Database. Here is how to disable and enable all constraint for table and database in SQL Azure using DMVs.
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.