Daily Archives: September 8, 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