Microsoft SQL Azure delivers on the Microsoft Data Platform vision of extending the SQL Server capabilities to the cloud as web-based services, enabling you to store structured, semi-structured, and unstructured data.
Hands-On Labs
- Introduction to SQL Azure
In this lab, you will walk through a series of simple use cases for SQL Azure such as: managing logins, creating database objects and query your database.
- Migrating Databases to SQL Azure
In this lab, you will use the AdventureWorksLT2008 database and show how to move an existing on-premises database to SQL Azure including: modifying the DDL and moving data via BCP and SQL Server Integration Services.
- SQL Azure Tips and Tricks
In general, working with a database in SQL Azure is the same as working against an on-premises database. There are some additional considerations which are covered by this lab.
- Introduction to SQL Azure Reporting Services
Microsoft SQL Azure Reporting provides a complete, cloud-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Now developers can deliver highly visual, interactive reports as an integrated part of a Windows Azure-based solution.
- SQL Azure Data-tier Applications
In this lab, you will learn how to use Data-tier Applications to deploy and upgrade SQL Azure databases. Using the SQL Server Data Tools (SSDT) you will create new database projects to publish a database schema and upgrade it with new changes.
- SQL Azure Data Sync
In this lab, you will learn how to synchronize data between SQL Azure and on-premises SQL Server databases, using SQL Azure Data Sync.
- SQL Azure Federations
SQL Azure Federations is an integrated capability of SQL Azure Database that dramatically simplifies database sharding implementations. In this hands-on Lab, you will learn how to create a database with federations and develop applications that interacts with federated tables using both ADO.NET and Entity Framework.
