Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or ...

Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology ...

As any developer knows, the technology industry is defined by innovation discoveries and new emerging solutions. One of the most popular growing movements in current times is the switch to NoSQL ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a ...