Advanced SQL Azure

Introduction to SQL Azure

Create a LiveID

Setup Azure Account

Add SQL Azure subscription

Create SQL Azure server

Create SQL Administrators

After completing this module, students will be able to:

Determine the cost of storing data in Windows Azure

Setup SQL Azure databases through Developer Portal

In this module we take a look at supported Azure T-SQL including creating tables, columns and indexes. We will also explore how to work with temp tables and transactions.

RDBMS Support

Create SQL Azure Databases

Create SQL Azure Tables

Create Tables

Create Views

Create Stored Procedures

Create Indexes

Create Transactions

Working with Temp Tables

Invalid Azure TSQL statements

After completing this module, students will be able to:

Create SQL Azure Databases and Tables

Understand what TSQL is supported

Create SQL Azure views and stored procedures

In this module we take a look at the lessons of the module!

SQL Azure Security

Creating Logins and Users

Assigning Roles

Assigning Rights to Objects

After completing this module, students will be able to:

Describe how SQL Azure security works

Create and assign firewall rules

Create server logins

Assign permissions to users

Assign rights to objects

In this module we take a look at the various ways to access SQL Azure, some of the tools that make working with SQL Azure easier (Entity Framework and LINQ), and an advanced coverage of Sharding.

Programming SQL Azure

Accessing SQL Azure

Use SQL Server Management Studio

Use SQLCMD

Use Visual Studio 2010

Connecting to SQL Azure from code (.NET)

Working with LINQ

Working with Entity Framework

Secure data at Rest

Implementing Horizontal Partitions

Implementing Vertical Partitions

Programming with Enzo SQL Shared

After completing this module, students will be able to:

Connect to SQL Azure from your favorite tools

Program SQL Azure with Entity Framework

Secure your SQL Azure Data at Rest

Implement partitions using sharding

Understand how to use Enzo SQL Shard SDK

In this module we take a look at how to maintain SQL Azure databases, how to optimize databases and how to troubleshoot connectivity problems (DoS and Throttling).

Optimizing

Maintaining

Troubleshooting

Measure Latency to SQL Azure

Find database size

Monitor database sessions

Find top 5 queries (CPU and IO)

Rebuild a database index

Use Enzo SQL to perform baselines

Backup SQL Azure (Azure Storage Account)

Backup SQL Azure (SQL Management Studio)

Backup SQL Azure (BCP)

Backup SQL Azure (RedGate)

Restore SQL Azure (Azure)

Restore SQL Azure (SQL Management Studio)

Restore SQL Azure (BCP)

Using Query Analyzer

Using Client Statistics

After completing this module, students will be able to:

Maintain SQL Azure

Perform baselines for on-premise and SQL Azure Databases

Perform backups of SQL Azure using various tools

Perform a restore of SQL Azure

Use Query Analyzer and Client Statistics

In this module we take a look at how to migrate your databases to SQL Azure and how you can use Microsoft Synchronization Framework and Azure Data Sync to synchronize your Azure databases with on-premise databases.

Synchronizing to SQL Azure

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)

Working with Microsoft Sync Framework

Working with SQL Azure Data Sync

After completing this module, students will be able to:

Export your on-premise database schemas for SQL Azure

Migrate data to SQL Azure using various tools

Synchronize data with SQL Azure using Azure Data Sync

Synchronize data with SQL Azure using Microsoft Synchronization Framework

In this module we take a look at SQL Azure Reporting Services and how to use PowerPivot to connect Excel 2010 to SQL Azure data.

PowerPivot and SQL Azure

SQL Azure Reporting

Working with SQL Azure Reporting

Integrating PowerPivot and SQL Azure

After completing this module, students will be able to:

Create SQL Azure Reporting Services Server instances

Create data sources in SQL Azure Reporting

Create reports and deploy them to SQL Azure Reporting