Backing Up SSAS Databases

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

New Tip Over at MSSQLTips

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

What Causes Deadlocks?

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