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.
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.
Free Tools Worth Having on a SQL Server
Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.
Generating Unique, Hard-to-Guess Voucher Codes in T-SQL
Random-looking codes can still be guessed. Build 20 voucher codes from random bytes, check them, and make redemption single-use.
BASE64_ENCODE and BASE64_DECODE in SQL Server 2025
Use BASE64_ENCODE in SQL Server 2025, decode binary and text safely, compare URL-safe output, and replace older XML encoding expressions.










