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)

SQL IaaS

SQL PaaS

Virtual Machine

SQL Server

SQL Database

Remote Desktop

Azure Portal

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)

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

Made with Slides.com