SQL Azure Integration In SQL Server 2008 R2

[This article was contributed by the SQL Azure team.] Today is T-SQL Tuesday #7 and the SQL Azure team is blogging as part of T-SQL Tuesday for the first time. This  Tuesday’s topic: “What’s your favorite hot new feature in the SQL Server 2008 R2?” Of course, SQL Azure integration is our favorite topic of…


Finding Your Clustered Indexes

[This article was contributed by the SQL Azure team.] Before migrating your SQL Server schema to SQL Azure, you need to create a clustered index on every table. You can read about why in this blog post. In this post, we will show how to find all the tables that don’t have a clustered index….


SQL Azure and Session Tracing ID

[This article was contributed by the SQL Azure team.] 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 every…


Generating Scripts for SQL Azure

[This article was contributed by the SQL Azure team.] 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…


Exporting Data from SQL Azure: Import/Export Wizard

[This article was contributed by the SQL Azure team.] 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…


SQL Server Management Studio to SQL Azure

[This article was contributed by the SQL Azure team.] 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 Server Express) that includes the…


Remember to Encrypt Your Connection

[This article was contributed by the SQL Azure team.] 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 in your connection strings that you want to…