Level: Intermediate
This session will get you ramped up quickly on SQL Database – the Windows 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 Windows 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:
- Setup and configure SQL Database
- Learn about SQL Database pricing, migration, security, backup, synchronization, and reporting
- Understand the differences between SQL Database and SQL Server