Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip
Want to validate syntax without running a query? I explain the little known SET NOEXEC setting that checks your T-SQL but does not execute it.
SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
How do you know if there is an open transaction before you restart a server? DBCC OPENTRAN shows the oldest active transaction in your database.
Nested Loops Join: When It Is the Right Choice
Loops in a plan are not always the villain. Count the inner executions and the reads before you force another join type.
SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Login failed, the user is not associated with a trusted SQL Server connection, Error 18452? Usually it is a wrong username or Windows-only login mode.
SQL SERVER – Check for Database Integrity – Notes from the Field #011
In this Notes from the Field episode, Tim explains why you should check database integrity often, so corruption is caught before it is too late.
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.