Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Investigating a Past Slowdown With the system_health Session
Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.
SQL SERVER – Learning More About SQL Wait Stats
Are SQL Wait Stats still relevant for performance tuning? Absolutely. Here is what I told a customer in Delhi and where to start learning about them.
Permissions I Have in SQL Server: Check Database, Server and Object Access
The permissions I have in SQL Server depend on my database and security context. These read-only queries, tested with a loginless user, a role and a column DENY, separate database, server and object checks and show which grant supplied each permission.
Recovering a Deleted Agent Job From an msdb Backup
Someone deleted the wrong Agent job. Here is how to get it back from an msdb backup without touching the live msdb.
SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7
Are redundant indexes good or bad? This final wrap of my seven part series recaps every part and its demo, so start here if you missed any.
SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007
Want to know about a problem before your users do? Mike Walsh explains SQL Server alerts, why they matter for server health and how to use them.
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.