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

Why is my database slow? Ever wonder why software slows down as you enter more data?

One of the important considerations when creating a data-driven application is database performance.  Often, when adequate load testing is not performed, problems are camouflaged because even the poorest database designs are still very fast for small amounts of data. For … 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