Most Popular Technology Articles of 2012

Metro Design Principles for Windows Phone, Windows 8 & Xbox 360 Metro is the interface used by the Windows Phone, Windows 8 (the next version of Windows, currently in the preview phase), and the Xbox 360 (pictured below). Microsoft said … Read More

Do you really need a GUID in your Database Design?

One of the database design practices that I have seen more and more frequently in recent years is the use of GUIDs for primary keys.  Unless you are implementing merge replication, this is rarely useful and can be both a … Read More

Tips on Designing Clustered Indexes for your SQL Server Tables

In relational databases, a clustered index is an index that determines the organization of records in a table.  This is as opposed to non-clustered indexes, which exist separate from the table data and contain a reference to the row of … Read More