Tag Archives: databases

Data Improves Lives

Posted on March 30, 2011 by way0utwest

I’m not sure if this NYT article will get through, but I really liked “This Data Isn’t Dull. It Improves Lives“. It talks about how government data that’s around and using it to provide other services and enrich lives. Even … Continue reading →

Posted in Blog | Tagged | Comments Off on Data Improves Lives

ACID

Posted on September 17, 2010 by way0utwest

What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the exact meaning. For a (supposedly) senior DBA, that’s bad. I could, however, tell what it means and what it enforces … Continue reading →

Posted in Blog | Tagged , | Comments Off on ACID

Common SQL Server Mistakes – GUID as a Clustered PK

Posted on September 8, 2010 by way0utwest

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