You never see the termites, you only see the damage they have done. And by then it is often too late.
Same with corruption inside of your database. Often time most folks have no idea there is any issue until it is too late.
Wouldn’t it be nice if there was a quick and easy way to [...]
SQL MVP
The Minimalist Guide to Database Administration
Every great DBA I know is both driven AND lazy. They are driven to be as efficient as possible, so they can do less work. It’s a wonderful pair of personality traits to have as a DBA.
The unfortunate part is that the more driven they are, the more efficient and lazier they get, which often [...]
Stop Guessing About CPU Pressure
Ever try to troubleshoot something that doesn’t really exist?
I think this virtualization thing is here to stay, I really do, but the trouble I see people having with virtualization is that they don’t know where the bottleneck truly lies. There are so many layers involved that most standard troubleshooting techniques fall short. Just think for [...]
SQL 2012 Database Engine Tuning Advisor: Now With More Plan Cache!
I’m normally not one to advocate the use of the Database Engine Tuning Advisor (DETA), a tool available inside of Microsoft SQL Server. (To be fair, I’m not a fan of the SQL Tuning Advisor from Oracle, either.) But I recently came across a little nugget of information that I wanted to share with you regarding [...]
Is Your DBA Lying To You?
“Signs point to yes.” – Magic 8-Ball prophecy
You have probably heard this line at one point, the one that says “the best DBAs are the ones you never see or hear?” I used to think that was a result of some sketchy personal hygiene choices and later on understood it to mean that if everything [...]
Presenting at Tech-Ed(s) This Year
The announcements came out yesterday and I can now tell the world that I will be presenting at TechEd this year. Denny Cherry (blog | @mrdenny) and I will be doing a precon seminar at TechEd in Orlando in June. The title is “Microsoft SQL Server Performance Tuning and Optimization” and we are very excited to have [...]