Tag Archives: sql server

Basic Computed Columns

Posted on August 16, 2011 by way0utwest

I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote this short piece in computed columns, mostly as a reminder for me. What’s a computed column? You can read the … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Going Big with SSDs

Posted on August 16, 2011 by way0utwest

I found a report recently that eBay had implemented 100TB of SSD storage from Nimbus Data for their virtual infrastructure. That’s a huge amount of very fast storage, which definitely helps explain how the eBay auctions seem to run so quickly. Apparently eBay isn’t … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Going Big with SSDs

When Do You Take a Full Backup?

Posted on August 15, 2011 by way0utwest

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011. When is a Full Backup Taken? Most people might answer this with “every day”, or … Continue reading →

Posted in Blog | Tagged , , , , , | 1 Comment

Two Types of Tail Log Backups

Posted on August 10, 2011 by way0utwest

In a recent thread I noted that a tail log backup is essentially a regular log backup, but made with the intention of restoring the database because something is wrong with your data file. Gail Shaw (blog | @SQLIntheWild) pointed … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Two Types of Tail Log Backups