Latest Blog Posts:
Ever wondered what makes your SHRINK go so damn slow? It’s more common than you think, and not impossible to solve! Continue reading Troubleshooting Long-Running SHRINK Operations
The lethal #COVID19 strain of the #Corona virus is officially a Pandemic, and we quickly realized how fast such a thing can spread in this era of Globalization. With the virus pandemic also arrives a pandemic of blog posts and social network noise. Everyone’s writing and talking about this topic. So, I guess I must too. Continue reading Surviving the COVID-19 Dystopia
We all know the error log used by SQL Server to audit failed logins by default. But is it really good enough? For many scenarios, it isn’t. It’s actually missing a lot of important information. But, worry not, for there are better solutions! Continue reading Finding the Details Missing from the SQL Server Failed Logins Audit
This script performs compression savings estimation check across the ENTIRE database within which it is executed, AND generate the relevant remediation scripts for you. Continue reading The Ultimate Compression Savings Estimation Script for an Entire Database
This month’s #tsql2sday, hosted by Jess Pomfret, is asking us to write about our favorite “life hacks” that make our lives easier. This topic has actually been pretty hot on my list for the past year or so, so I’m happy to share my experience. Continue reading T-SQL Tuesday #123: Life hacks to make your day easier
I never managed to find an online reference page for the rules run by the SQL Vulnerability Assessment tool. So I figured “why not do it myself?”. Cool script attached! Continue reading SQL Vulnerability Assessment Tool – Rules Reference List
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Other ways to find me: