As we get more involved with the BI stack of tools we find ourselves learning some of the nuances of supporting all of these new environments. One such example is SSAS. When people build and deploy cubes to an instance of SSAS they (eventually) get around to asking about restores and recovery. And since the … Read more
OK folks, sorry about having to cancel practice last week but we didn’t want to take any chances with the current swine flu pandemic that is sure to be made into a TV movie to be shown during May sweeps next year. I know that many of you had a chance to practice on your … Read more
Ever have a customer request that you take a backup of a database, a restore using that backup, and then tell you that it is the wrong data? Every now and then it happens, so I decided to put together some t-sql to display details on what was done. The script essentially details when the restored … Read more
A few weeks back I was asked how long a backup took for a specific database. I knew the info was in the msdb somewhere so I pieced together a bit of code and then thought to myself “hey, this might be a good thing to share with others at MSSQLTips”. Well, OK, I actually … Read more
I have been quite busy the past few weeks. So busy that I completely forgot to blog about this last Friday. Oh well, better late than never. The early bird discount for the PASS 2009 Community Summit ends this Friday, May 1st. For a complete price breakdown, check out this page. If you (or your … Read more
Application code, that’s what causes deadlocks. Well, perhaps a combination of application code on top of database design, and access patterns, and transaction isolation levels, and… OK, here’s the point I need to make clear: the database engine does not suddenly seize up and start deadlocking transactions arbitrarily because it is tired one day. No, certain … Read more
