A scheduled job has recorded scheduling metadata as well as its actual execution history. I check both before promising a next run.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Keeping SSMS Up to Date
Keeping SSMS up to date means reading release notes, choosing a supported channel, planning side by side installs, and checking settings.
SQL SERVER – Change Collation of Database Column – T-SQL Script
How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.
Five DMVs Worth Memorizing
Five DMVs worth memorizing show SQL Server sessions, active requests, waits, index use, and file I/O during an incident.
What Breaks When You Upgrade, and How to Find It First
Prepare for a SQL Server upgrade by checking deprecated features, compatibility, collation, plans, and application behavior before moving.
SQL SERVER – Interesting Interview Questions – Revisited
Readers took my Interesting Interview Questions test seriously. See who got the correct answer, and why good T-SQL mattered more than the schema.
SQL SERVER – Find Collation of Database and Table Column Using T-SQL
A quick tip to find the collation of database and table column in SQL Server with DATABASEPROPERTYEX and sys.columns, using AdventureWorks.
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.