( * This blog has been updated from last year's.... )
We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics.
- “Excuse me while I kiss this guy”. Correct lyric: “Excuse…
( * This blog has been updated from last year's.... )
We have all done it. We think we know the lyrics to a song. We sing them passionately….and incorrectly. Here are a few classics.
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…
A customer recently asked me to clarify the option "Enable Backup Escalation" in Litespeed for SQL Server. The customer has been using Litespeed for a while so I was a bit surprised the question was asked. When we spoke further, I learned they had built…
Differential backups make perfect sense….backup only what has changed since the last Full backup. Differential backups dramatically reduce the storage needed to maintain backups, while lowering maintenance windows associated with Full backups.
…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…
Part I of II
One of the more interesting storage improvements in recent years was the addition of deduplication to what was traditionally “just plain storage”. Deduplication makes better use of storage by reducing the amount of duplicate information…