Browse by Tags - SQL Azure Team Blog - Site Home - MSDN Blogs

Browse by Tags

Tagged Content List
  • Blog Post: SQL Azure Integration In SQL Server 2008 R2

    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 SQL Server 2008 R2. SQL Server tools, including...
  • Blog Post: Finding Your Clustered Indexes

    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. One of the techniques for migration is to update your SQL Server...
  • Blog Post: SQL Azure and Session Tracing ID

    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 connection to SQL Azure. On the server side...
  • Blog Post: Generating Scripts for SQL Azure

    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 allows you to target SQL Azure as you engine type...
  • Blog Post: Exporting Data from SQL Azure: Import/Export Wizard

    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 Azure to your local SQL Server. We have installed...
  • Blog Post: SQL Server Management Studio to SQL Azure

    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 SQL Server Management...
  • Blog Post: Remember to Encrypt Your Connection

    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 encrypt...
Page 1 of 1 (7 items)