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

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

Author: Cihan Biyikoglu - SQL Azure Date: 11/22/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

Next>