Great New Whitepaper on SQL Azure and Sharding

Just out… This whitepaper summarizes the sharding technique and highlights the new application modeling best practices for best scalability and economics. Most importantly it focuses on how you can build sharded applications today on SQL Azure. http://social.technet.microsoft.com/wiki/contents/articles/sharding-with-sql-azure.aspx Happy reading…


Apps that will love SQL Azure Federations? Here are a few…

In previous posts I talked about scaling options and techniques and introduced the concepts for SQL Azure federations. Let’s solidify the concepts with a few sample scenarios that showcase federations. Don’t expect an exhaustive list… I am sure you all can come up with many other examples of how to use SQL Azure federations. Sharding…


SQL PASS 2010, Nov 8th to 12th in Seattle

Hi everyone, I’ll be presenting the following 2 sessions at PASS. If you get a chance, stop by and say hi! Building Large Scale Database Solutions on SQL Azure SQL Azure is a great fit for elastic, large scale and cost effective database solution with many TBs and PBs of data. In this talk we…


Building Scalable Database Solutions Using SQL Azure – Scale-out techniques such as Sharding or Horizontal Partitioning

As I spend time at conferences and customer event, the top faq I get has to be this one; SQL Azure is great but a single database is limited in size and computational capacity. How do I build applications that need larger computational capacity? My answer is; You build it the same way most application…


Database Copy Command & Handling Asynchronous Execution in T-SQL

Database Copy T-SQL command in SQL Azure, provide the ability to create a identical copy of a database through a pure server side process. You can think of database copy as a backup followed by a restore of a database rolled into a single command. General documentation provides the details and use cases… Database Copy…


Migration Assistant Released– Going from MySql and Access to SQL Azure just got much easier

I talked about this tool in previous postings. SSMA Mysql and Access just got released with SQL Azure support. Full details available here; http://blogs.technet.com/b/dataplatforminsider/archive/2010/08/12/microsoft-announces-sql-server-migration-assistant-for-mysql.aspx Enjoy. -Cihangir Biyikoglu Program Manager – SQL Azure


Power Tools for Migrating MySql Database from Amazon AWS – Relational Database Service (RDS) to SQL Azure – Part 2: Migrating Databases to SQL Azure

Migration Assistant team will be releasing a great power tool that can help you move your MySql databases directly into SQL Azure. The tool works against MySql instances hosted at Amazon’s Relational Database Service (RDS) as well. Here is a quick video that shows you how to move a database in Amazon AWS RDS service…


Six Data Centers Around the World with SQL Azure

With the recent release of SQL Azure, we are now available in 6 data centers around the world. This enables everyone to be able to create databases around the world, closer to where the usage will be. Beyond having your data closer to your location, the paired data centers help provide the ability to get…