Thursday, June 08, 2006

Covering Indexes

A Covering Index is one of my favorite performance techiques. B ascially - a covering index is one that completely covers the needs of the query without having to resort tot eh dreaded bookmark lookup. This last weekend I made a ScreenCast about Covering Indexes. Enjoy! And if you have any suggestiosn or requests for more SQL Server ScreenCasts, email me.

Wednesday, June 07, 2006


I've been playing with a new utility - Carbonite! - and I love it. Bascially it's a background automatic file backup utility that slowly backs up all your files over the internet. If you're connected it's backing up. I can't tell it's running. This solves a huge problem for me since making backups is such a pain for independent IT workers. So I encourge you to try it. The first 15 days are free, then it's $5 a month no matter how many files it backs up.