Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Finding Tables with Primary or Foreign Keys
How do you find which tables have a primary key or foreign key? Here are simple queries for finding tables with primary or foreign keys in a database.
SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive
At GIDS I talked about keeping data and log files on separate drives. Here is a script that shows which databases have data and Log Files on the same drive.
A Custom db_executor Role for Stored Procedure Access
The app gets a permission error while it works for you as a sysadmin. Here is how a db_executor role fixes it without opening everything.
SQL SERVER – Using “High Performance” Power Plan for SQL Server
A simple, often missed setting on a new server: switch Windows to the High Performance Power Plan. Here is why it matters for SQL Server and where to set it.
Interview Question of the Week #017 – Performance Comparison of Union vs Union All
Compare UNION vs UNION ALL with duplicate examples, compatible types, actual plans, and the extra work required for distinct rows.
SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function
The RAND() function returns the same value for every row in a query. Here is a simple trick to generate a different random number for each group.
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.