Monthly Archives: August 2010

SQL Saturday Advice – Keynotes

Continuing on with my Thursday series of SQL Saturday posts, this time I wanted to talk about keynotes. I’ve been to a few events in my time, and one of the things that seems to get many people going in … Continue reading

Posted in Blog, Uncategorized | Tagged | Comments Off on SQL Saturday Advice – Keynotes

Does Column Order Matter in SQL Server

The short answer is it doesn’t. I guess that’s the long answer as well. A few people have posted questions about whether the PK needs to be the first column, and does it matter if you have CHAR or VARCHAR … Continue reading

Posted in Blog, Uncategorized | Tagged | Comments Off on Does Column Order Matter in SQL Server

SQL Server Backup File Confusion – Log Shipping

I saw a post recently where a person working with SQL Server had log shipping setup. They were asking if they needed to run separate backups for their database in order to restore this server in the event that it … Continue reading

Posted in Blog, Uncategorized | Tagged | Comments Off on SQL Server Backup File Confusion – Log Shipping

SQL Saturday #28 – Two Weeks Away

It’s a little less than two weeks until SQL Saturday #52 in Baton Rouge. I attended last year, and thoroughly enjoyed my time in Baton Rouge, and I decided early on this was one event I wanted to return to. … Continue reading

Posted in Blog, Uncategorized | Tagged | Comments Off on SQL Saturday #28 – Two Weeks Away