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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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,...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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....
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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....
Author: Cihan Biyikoglu - 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,...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu - SQL Azure 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...
Author: Cihan Biyikoglu Date: 04/26/2006
SQL ISV Advisory Team Blog
ISV Advisory team is starting to blog as well. Good one to bookmark!...
Author: Cihan Biyikoglu 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...
Author: Cihan Biyikoglu 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...
Author: Cihan Biyikoglu Date: 10/30/2005