Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Object Explorer Details in SSMS: Bulk Scripting and Quick Counts
Press F7, select a group of tables and script them in one go. Then check the grid’s row counts with two short queries.
SQL SERVER – SSMS: Schema Change History Report
Who created, dropped or altered a database or object? Young DBAs in Delhi gave me many answers, but the SSMS Schema Change History report answers it quickly.
Metadata-Only Column Changes: Which ALTER COLUMN Is Instant
Six ALTER statements look equally small, but their log cost is not. Here is how to measure each one before the change window.
The SQL Server Permission Hierarchy
Understand the SQL Server permission hierarchy from server to database, schema, and object, including GRANT, DENY, and role paths.
SQL SERVER – SSMS: Configuration Changes History
My friend Joe’s new job needed standard server settings. The SSMS Configuration Changes History report shows when settings changed. Here is how it helps.
SQL SERVER – Automate Database Operations for Success – Notes from the Field #035
It is not about how busy you are, but how valuable you are. Brian Kelley explains how to automate database operations and get more important work done.
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.