All is well. Megan is having a good day. She’s a SQLServer DBA and her environment is humming along. Then…. someone drops a critical table bringing efficient data retrieval to a screeching halt. Now what? It’s a weekday morning and business…

SQLServer Differential Backups make a lot of sense...they backup only what has changed. However, it seems that many Database Administrators choose not to leverage them. When digging into reasons for this, it is often because DBAs prefer to avoid some…

by Andy Grant

I read a post recently on The Grateful DBA that describes his analysis in testing different compression levels in LiteSpeed for SQL Server and their impact on both backup size and efficiency. In his own words this is a "non-scientific,…

by Jason Hall

Continuing a string of posts on tips and tricks for LiteSpeed, I thought I would take an opportunity to discuss how LiteSpeed allows you to select databases to backup in a maintenance plan. Whether or not to use maintenance plans to backup…