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

Understanding Azure SQL Database and SQL Server in Azure VMs

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)

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

Microsoft Samurai: SQL Databases in the Cloud

By Erik Ralston

Made with Slides.com

Microsoft Samurai: SQL Databases in the Cloud

An introduction to using Microsoft SQL Server in Azure

  • 1,023

More from Erik Ralston