Feeling constrained by the 50GB SQL Azure Limit? Try Sharding

  • Article

Database Sharding is a way to partition multiple SQL Azure databases to get around the 50GB maximum database size limit.  Using this technique you can implement a scale-out network of SQL Server databases that can handle massive capacity requirements.

Michael Heydt from Sungard has produced an outstanding tutorial on the subject. 

 

In the tutorial he also devotes some coverage to the upcoming SQL Azure Federation Service which will make scale-out via Sharding even easier.

Bill Zack