Data Partitioning in SQL Server was introduced in the 2005 release. This was a feature that had been in Oracle and IBM’s DB2 for a while, but Microsoft is positioning to compete in the VLDB market ...

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 ...

In a previous blog entry I talked about the Sliding Window partitioning scenario. I even tried to involve Gwyneth Paltrow in a SQL Server Blog which is no mean feat. (When you teach classes over the ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

I get this request a lot: We have a single, huge database and want to keep part of the data on-premises and part of the data in the cloud. Is that possible? Of course. Enough time and money can solve ...