Microsoft Samurai

SQL Databases

in the Cloud

 

By @ErikRalston

Overview

• Introduction to MS SQL on Microsoft Azure

• Using the Azure Portal

• Using Visual Studio

Audience

• MS SQL DBA Wondering about the Cloud

• MS Developer looking to not rely on DBA

Platform-as-a-Service (PaaS)

Infrastructure-as-a-Service (IaaS)

Understanding Azure SQL Database and SQL Server in Azure VMs

SQL on VM (IaaS)

It's 100% real SQL Server

 

Storage

+ Time Per VM Tier

+ SQL Server License

+ Windows License

+ (Admin Time)

SQL Database (PaaS)

Azure SQL Database General Guidelines and Limitations

Very few limitations

• 150 Databases
• TCP Connections only
• IP Address White List
• Throughput Limitation Per Tier
• SQL Perf Tools Don't Work!

 

Storage + Time Per Tier

Azure Portal

Visual Studio

Thank
You