SSAS Weird Science

The other day we did an install of SSAS on a server without loading the database engine. Everything went fine, the end user started accessing the service and then we started talking about how we should make certain we are taking backups of the objects that are being created. Now, how would you think to … Read more

Chris Hansen Should Be a DBA

Thankfully I had yet another cross country flight yesterday. Why thankfully? Because the travel gives me ample time (and booze) to think about things like “If there was a DBA reality television show, what would it be like?” I started with the basics, something in a Survivor format, maybe a Big Brother, or The Apprentice, … Read more

When To Use Auto Shrink

Never, that’s when. Don’t want to believe me? Well then, who would you believe? How about the SQL Craftsman, a man with more MVP-ness than myself. What’s that? Not good enough for you? Well, then, let me introduce you to Paul Randal. He had some thoughts on the subject. http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx So why is this … Read more