Monthly Archives: September 2010

Common SQL Server Mistakes – GUID as a Clustered PK

I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work with GUIDs. A GUID, or uniqueidentifier, looks like this:ECB6ECB4-ACCB-4382-84D1-19990D59CA2FNot exactly something I want to try and type or include in … Continue reading

Posted in Blog | Tagged , , | Comments Off on Common SQL Server Mistakes – GUID as a Clustered PK

Developer Deployment Frustrations

Why don’t developers like SQL Server? Probably a few reasons, but I’m sure this is one that really frustrates them. I found a Connect Item that was titled:  Why is Deploying SQL Server 2008 R2 sooooo FRUSTRATING?!! There really is … Continue reading

Posted in Editorial | Tagged , | Comments Off on Developer Deployment Frustrations

Virtual Labs – A Great Resource for SQL Server

I had someone send me a note recently asking some questions about how to get set up to work with SQL Server. This was a person that had used SQL Server in the past, but had become a manager and … Continue reading

Posted in Blog | Tagged , , | Comments Off on Virtual Labs – A Great Resource for SQL Server

Labor Day Bloopers

Happy Labor day to everyone. A day off for me, but I’m posting a few bloopers from the past couple months. These are the raw files, and I had about 40 minutes of stuff that I just dumped out raw … Continue reading

Posted in Blog | Tagged , , | Comments Off on Labor Day Bloopers