You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Recording Table Row Counts Every Day
Recording table row counts each day creates a useful SQL Server trend when a scheduled job, history table, and change review support it.
Replaying a Production Workload After Distributed Replay
Capture a production workload with Extended Events and replay it on a restored copy using WorkloadTools or ostress after Distributed Replay.
SQL SERVER – History of SQL Server Database Encryption
Michael Coles, co-author of Expert SQL Server 2008 Encryption, let me share his history of SQL Server database encryption, starting from SQL Server 2000.
Setting MAXDOP and Cost Threshold Sensibly
MAXDOP and cost threshold work together to shape parallel plans; inspect current values, test a change, and watch real workload effects.
SQL SERVER – Information Related to DATETIME and DATETIME2
A reader comment explains the precision issue between DATETIME and DATETIME2: values lose precision when converted between types. Here is the workaround.
SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use
Error 3702: cannot drop database because it is currently in use. Set it to SINGLE_USER WITH ROLLBACK IMMEDIATE, then drop it. Best kept for demo servers.
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.