Level: Introductory
This session will get you ramped up quickly on SQL Database—the Microsoft Azure version of SQL Server. Lenni will start from square one: signing up for a Microsoft account and Windows Azure subscription. From there, you'll learn how to leverage a host of tools to connect with SQL Database, including the Azure and SQL Database management portals, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), PowerShell, and the Management REST API.
After covering setup and configuration, you'll learn about the SQL Database pricing structure. We'll then cover the most pressing cloud concerns with SQL Database, including data migration, security, and backup, as well as other topics, including synchronization with SQL Data Sync and reporting with SQL Server Reporting Services (SSRS) on a Windows Azure VM. We'll conclude by discussing important differences between SQL Database and SQL Server. Attend this session and get working with SQL Database today!
You will learn:
- About the SQL Database on Windows Azure
- How to setup and configure SQL Database
- About SQL Database migration, security, backup, reporting, and pricing