Advanced SQL Azure

Module 2: Introduction to SQL Azure

Introduction to SQL Azure

Lab : Setup Azure Account

Create a LiveID

Setup Azure Account

Add SQL Azure subscription

Create SQL Azure server

Create SQL Administrators

Module 3: SQL Azure RDBMS Support

RDBMS Support

Lab : Creating Databases and Tables

Create SQL Azure Databases

Create SQL Azure Tables

Lab : Exploring Valid SQL Azure TSQL

Create Tables

Create Views

Create Stored Procedures

Create Indexes

Create Transactions

Working with Temp Tables

Invalid Azure TSQL statements

Module 4: SQL Azure Security

SQL Azure Security

Lab : SQL Azure Security

Creating Logins and Users

Assigning Roles

Assigning Rights to Objects

Module 5: Programming SQL Azure

Programming SQL Azure

Accessing SQL Azure

Lab : Connecting to SQL Azure

Use SQL Server Management Studio

Use SQLCMD

Use Visual Studio 2010

Lab : Programming SQL Azure

Connecting to SQL Azure from code (.NET)

Working with LINQ

Working with Entity Framework

Lab : Securing Data at Rest

Secure data at Rest

Lab : Implementing Partitions and Shards

Implementing Horizontal Partitions

Implementing Vertical Partitions

Programming with Enzo SQL Shared

Module 6: Maintaining and Optimizing SQL Azure

Optimizing

Maintaining

Troubleshooting

Lab : Maintaining SQL Azure

Measure Latency to SQL Azure

Find database size

Monitor database sessions

Find top 5 queries (CPU and IO)

Rebuild a database index

Lab : Performing Baselines

Use Enzo SQL to perform baselines

Lab : Backup SQL Azure

Backup SQL Azure (Azure Storage Account)

Backup SQL Azure (SQL Management Studio)

Backup SQL Azure (BCP)

Backup SQL Azure (RedGate)

Lab : Restore SQL Azure

Restore SQL Azure (Azure)

Restore SQL Azure (SQL Management Studio)

Restore SQL Azure (BCP)

Lab : Using Query Analyzer and Client Statistics

Using Query Analyzer

Using Client Statistics

Module 7: Migrating and Synchronizing to SQL Azure

Synchronizing to SQL Azure

Migrating to SQL Azure

Lab : Migrating to SQL Azure

Migrating the database schema

Migrating database data

Migrating with SQL Server Migration Assistant

Migration with SQL Azure Migration Wizard

Migrating with DAC Import/Export 2.0

Migrating with SQL Server Integration Services (SSIS)

Lab : Using Microsoft Sync Framework

Working with Microsoft Sync Framework

Lab : Using Azure Data Sync

Working with SQL Azure Data Sync

Module 8: Business Intelligence with SQL Azure

PowerPivot and SQL Azure

SQL Azure Reporting

Lab : Business Intelligence with SQL Azure

Working with SQL Azure Reporting

Lab : PowerPivot with SQL Azure

Integrating PowerPivot and SQL Azure