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 … Read more

Do You Make These 5 Database Design Mistakes?

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 … Read more

12 Things You Should Stop Doing in 2012

It’s the end of the year and already I am seeing the usual blog posts that either reflect on the year that was, or are pondering the year to come. I thought about writing another post covering all of the things that didn’t happen to me this past year but since I’ve already done that … Read more