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 [...]
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 [...]
“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 [...]
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 [...]
Look, everyone makes mistakes. It’s true. But not all of us have the chance to make mistakes that end up costing millions of dollars in hardware and production support costs.
Any one of the following five mistakes listed below will add additional costs to your company. It’s guaranteed. The costs could be hardware related (extra disk space, [...]
It’s new, it’s shiny, and it smells like frozen yogurt.
No, it’s not the blender you got for Christmas. It’s SQL 2012 (formerly known as codename ‘Denali’). And it’s here. And you want to use it, you know you do.
As much as you would like to believe that migrating to SQL 2012 is as easy as [...]