Find Out What Your Log Is Waiting For

Another tidbit from the PASS Summit that I am only now getting around to blogging about… Did you know that your transaction log file is circular in nature? That is, when your log has reached the end of the physical file it will go back to the very beginning and overwrite any virtual log file (VLF) … Read more

The SQL Potential for Google Wave

I received an invite to Google wave a while back. I used it sparingly but always kept a tab open in FireFox to see if anything was going to “happen”. In short, I just didn’t get it. And I probably still don’t. I think the first problem with Wave is that only a few people … Read more

Restoring SQL 2005 Master Using LiteSpeed

Less than 24 hours after posting a list of things I am thankful for, where I expressed Thanks for not having to restore master, I found myself awake at 3AM in order to restore master after we had a server lose its data drive. Before I got started I decided to check on the definition … Read more

SQL 2008 R2 Upgrade

I set aside some time today to install the latest SQL 2008 R2 CTP. You can download the CTP yourself by clicking on this link. I have a handful of test servers that I can use to install the CTP onto, and the idea was to do an in-place upgrade on an existing SQL 2008 … Read more

DBA Thanksgiving

Last month I went to visit some friends in Montreal. It just so happened to be the weekend right before the Thanksgiving holiday in Canada. While there we happened to meet some new people, which is always nice while traveling. During the discussions with our new friends we came about the topic of Thanksgiving, how … Read more