Your Data in the Cloud
Cihan Biyikoglu [twitter @cihangirb]
Off to a brand new adventure...
After over a decade at Microsoft, I decided to start on a new adventure. I moved to Microsoft from...
Date: 03/13/2013
Database Scaling Done Right!
FullScale 180 folks have a great post on windrows azure blog today. Trent’s post provides great...
Date: 05/24/2012
Inside SQL Azure – Self-healing, Self-governing, Massively Scalable Database service in the Cloud.
This is a talk I did a few weeks ago that will take you under the hood of SQL Azure. I cover the...
Date: 03/24/2012
What would you like us to work on next?
10 weeks ago we shipped federations in SQL Azure and it is great to see the momentum grow. This...
Date: 02/28/2012
OData and Federations: yes you can… Just ask Maxim
In case you guys have not seen this; Maxim Glukhankov has a new sample on codeplex that shows how to...
Date: 02/21/2012
Implementing MERGE command using SQL Azure Migration Wizard by @gihuey
Well I am sure you noticed that federation’s support SPLIT AT and DROP AT commands but not...
Date: 02/20/2012
The New Pricing Model for SQL Azure Explained!
The new pricing model is an amazing improvement over the original model. In 60 seconds here are the...
Date: 02/16/2012
Fan-out Querying for Federations in SQL Azure (Part 2): Scalable Fan-out Queries with TOP, ORDER BY, DISTINCT and Other Powerful Aggregates, MapReduce Style!
Welcome back. In the previous post: Introduction to Fan-out Querying, we covered the basics and...
Date: 01/19/2012
Introduction to Fan-out Queries for Federations in SQL Azure (Part 1): Scalable Queries over Multiple Federation Members, MapReduce Style!
Happy 2012 to all of you! 2011 has been a great year. We now have federations live in production...
Date: 12/29/2011
…So Isn’t the Root Database a Bottleneck for Federations in SQL Azure?
Dan posted a great comment to my previous blog post and I think the question he is raising is worth...
Date: 12/15/2011
SQL Azure Federations is open for business!
Wooohooowwwy! Finally the day arrives! The year end update to SQL Azure is live and you can now use...
Date: 12/12/2011
Pricing and Billing Model for Federations in SQL Azure Explained!
Note: the article has been updated with the new pricing model that went into effect in Feb 2012. Now...
Date: 12/12/2011
Federation Metadata in SQL Azure Part 3 – Monitoring Ongoing Federation Operations
In part 2 we talked about federation metadata history views. Federation history views only report...
Date: 11/28/2011
Great work Herve!
Not sure if you all know Herve Roggero but he has been a great community leader and MVP driving...
Date: 11/26/2011
Federation Metadata in SQL Azure Part 1 – Federations and Federation Members
One of the great value propositions of federations is the ability to represent all the data...
Date: 10/29/2011
Coming up at the end of the year in 2011 with SQL Azure...
Hi everyone, hope you enjoyed the keynote this morning on SQL Azure. You can watch the azure section...
Date: 10/13/2011
New sample shows how to build multi-tenant apps with Federations in SQL Azure
Nice fresh sample from Full Scale180’s guys called Cloud Ninja. “The Cloud Ninja - SQL Azure...
Date: 10/04/2011
SQL PASS in Oct, SQL Rally and SQL Server Days in Nov
Federations is on its way out the door with the next update of SQL Azure. With that, I’ll be...
Date: 10/03/2011
Federations Migration Wizard Now Available!
One of the most popular tools for migrating your databases to SQL Azure is the SQL Azure Migration...
Date: 08/24/2011
Quick Tip - Federations in SQL Azure: How to automatically maintain the federation distribution key in federated tables with FILTERING connections.
In federations, federations member contain part of the data that is in a federation. The range of...
Date: 08/03/2011
Strict vs Eventual Consistency Model - Referential Integrity with Federations in SQL Azure
Referential Integrity in Federations Federation provide a great scale-out model with independent...
Date: 07/19/2011
Shipping Software Fast and Scoping It Right: Story of Sharding to Federations-v1 in 12 months
We first talked about SQL Azure Federation in Nov 2010 at PDC. We are getting ready to ship...
Date: 07/11/2011
Federations Product Evaluation Program Now Open for Nominations!
Recent Update: the program is at full capacity and nomination survey is now closed. Thank you for...
Date: 05/12/2011
Federation Repartitioning Operations: Database SPLIT in Action
Repartitioning operations is a large part of the value of federations. The ability to repartition...
Date: 04/22/2011
Considerations When Building Database Schema with Federations in SQL Azure
When working with federations, database schema requires a special consideration. With federations,...
Date: 04/16/2011
TechEd 2011 (Video) – Introducing SQL Azure Federations: Big data and Big Scale…
Here is the session I did this week at Atlanta on SQL Azure Federations. SQL Azure Federations: Big...
Date: 03/26/2011
SQL Azure Federations: Robust Connectivity Model for Federated Data
In this post I wanted to focus on connectivity enhancements that come with SQL Azure Federations....
Date: 01/18/2011
Great New Whitepaper on SQL Azure and Sharding
Just out… This whitepaper summarizes the sharding technique and highlights the new application...
Date: 12/15/2010
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...
Date: 11/07/2010
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...
Date: 10/29/2010
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...
Date: 09/02/2010
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...
Date: 08/13/2010
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...
Date: 07/19/2010
Transferring Schema and Data From SQL Server to SQL Azure – Part 1: Tools
Many customers are moving existing workloads into SQL Azure or are developing on premise but move...
Date: 06/29/2010
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...
Date: 06/26/2010
Migrating Applications to SQL Azure – TechEd 2010 @ New Orleans
Thanks to all of you that made it to New Orleans. For those of you who could not, here is the video...
Date: 06/10/2010
Pricing for the New Large SQL Azure Databases Explained
SQL Azure updated the pricing model in Feb 2012. With the recent update, this article no longer...
Date: 06/10/2010
See you all at Teched 2010 in New Orleans
Headed to TechEd on June 7th. My talk is on tuesday the 8th and will be covering how to easily...
Date: 05/29/2010
Larger Databases Sizes with SQL Azure
Today at MIX, we announced the availability of 50GB SQL Azure databases with our next service...
Date: 03/17/2010
Analyzing Query Performance just got easier with SQL Azure.
With the recent update we posted to the SQL Azure service (full details of the update here), the...
Date: 02/19/2010
Evaluating Application Performance and Throughput in SQL Azure
The discussion of performance and throughput came up a few times in discussion with customers at PDC...
Date: 01/05/2010
Feels good to be back.
Hi folks, I am back and blogging again about my new cause. Your data in the cloud with SQL Azure....
Date: 12/22/2009
How to improve application performance using the DEFAULT_SCHEMA setting
Here is my blog post at the ISV Team blog. DEFAULT_SCHEMA setting helped in a number of cases,...
Date: 03/30/2007
PASS 06: Hidden Gems in SQL Server 2005 - Slides available at the PASS website
Greetings, my pass talk is now available at sqlpass.org for download. The session was on some of the...
Date: 12/04/2006
MARS, Transactions and SQL Error 3997, 3988 or 3983
Mars and Transactions MARS (multiple active result-sets) does allow multiple commands to be active...
Date: 11/20/2006
Financial Services Developers Conference Presentation - Data Integration
FSG Dev. Conf. 06 is over. Thanks to the folks who attended. Here is the presentation and the Demos...
Date: 04/26/2006
SQL ISV Advisory Team Blog
ISV Advisory team is starting to blog as well. Good one to bookmark!...
Date: 03/28/2006
Forced and Simple Parameterization in SQL Server 2005
As the optimizer gets more and more sophisticated, cost of optimization naturally increases. When...
Date: 11/03/2005
SQL Server 2005 is out the door
Well, many lines of code and 5 years later, SQL Server 2005 is out the door. I have been in the lab...
Date: 10/30/2005