As a follow up to our post yesterday, Brian Swan blogs about how to get the Azure Session Tracing ID in PHP, read his blog post here.

SQL Azure allows you to create your database in datacenters in North Central US, South Central US, North Europe, and Southeast Asia. Depending on your location and your network connectivity, you will get different network latencies between your location...

If you have been paying close attention, you will have noted that SQL Server Management Studio 2008 R2 has added a new property for connections to SQL Azure -- the Session Tracing ID. A session tracing identifier is a unique GUID that is generated for...

Transact-SQL includes a number of date and time functions that have values are derived from the operating system of the computer on which the instance of SQL Server is running.  The MCS UK Solution Development Team blogs about how these work on SQL...

When moving a SQL Server database to SQL Azure the first step is to generate a script that will transfer the schema of your SQL Server database to SQL Azure. SQL Server Management Studio 2008 R2 easily does this with a newly added advanced setting that...

BCP is a great way to locally backup your SQL Azure data, and by modifying your BCP based backup files you can import data into SQL Azure as well. In this blog post, we will learn: How to export data out of tables in SQL Azure server into a data...

From RBA Consulting Blogs , a video about creating a SQL Azure server and database using the SQL Azure portal .

From RBA Consulting Blogs , a video about quickly and easily loading AdventureWorks (Lightweight version) into SQL Azure.

In using the SQL Server Import and Export Wizard found in SQL Server 2008 R2 to export data to SQL Azure, I noticed that it was having trouble with a column that was the data type of varbinary(max) . This article will discuss how to the fix the issue...

Getting Started With SQL Azure Time: 3:15 PM – 4:30 PM, Saturday, May 22, 2010 Location: Franz Hall, Room 217 Bruce Kyle ( @brucedkyle ) will show how to get started using SQL Azure. Working with SQL Azure should be a familiar experience for most developers...

Buck Woody hosts the SQL Server News Hour with this week's guest David Robinson (Senior Program Manager, Microsoft) to discuss SQL Azure.

In this blog post we will show you how to export data from your SQL Azure database to a local SQL Server database using the SQL Server Import and Export Wizard in SQL Server Management Studio 2008 R2. This is a great technique to backup your data on SQL...

Starting with SQL Server 2008 R2, SQL Server Management Studio can connect directly to SQL Azure. The minimum install to do this is SQL Server Management Studio Express Edition ( download here for free ); however any version of SQL Server (except SQL...

SQL Azure currently supports 1 GB and 10 GB databases. If you want to store larger amounts of data in SQL Azure you can divide your tables across multiple SQL Azure databases. This article will discuss how to use a middle layer to join two tables on different...

This is a work in progress blog post that gives you easy links to SQL Azure resources. We will be updating it frequently with current links and additional resources. Make sure to book mark it. Management SQL Azure Portal : Where you manage your...

This paper in the wiki section of TechNet compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities. ...

“Why?” my five year old asks. “Because I said” is my usual response. In the blog comments, we have noticed an abundance of “Why do we have to have a clustered index on our tables?” In this case “Because we said” is not going to cut it and really does...

John R. Durant's has a great blog post about accessing SQL Azure data via Microsoft Excel 2010 on the MSDN blogs. Read it here .

When using a web enabled database like SQL Azure, it requires connections over the internet or other complex networks and because of this, you should be prepared to handle unexpected dropping of connections.  Established connections consist of: connections...

Every good DBA and developer knows that you should not use: SELECT * FROM [ Table ] in your queries to a database, especially if you are not using all the columns returned. Just return the columns you need in the SELECT statement. Using SELECT...

SQL Azure doesn’t support unencrypted connections. If you try to request a connection via SQL Server Management Studio that is unencrypted, SQL Azure signals SQL Server Management Studio to establish an encrypted connection. Likewise, you need to specify...

Our SQL Azure FAQ is available on the wiki section of TechNet. The paper addresses some of the frequently asked questions from our customers. You can read it here .

Here are two great MSDN videos to get you started on SQL Azure: MSDN Video: Microsoft SQL Azure RDBMS Support (Level 200) This session will cover the following topics: Creating, accessing and manipulating tables, views, indexes, roles, procedures, triggers...

Interested in learning firsthand about SQL Azure? Come meet our team at Microsoft TechEd North America . We will be presenting at six sessions and hosting an open lab so that you can experiment with SQL Azure. DAT209: What’s New in Microsoft SQL Azure...

This self paced free learning clinic from Microsoft Learning will introduction your to SQL Azure. This clinic covers the following topics: Understanding the SQL Azure Platform. Designing Applications for SQL Azure. Migrating Applications to...