Fast Start for Microsoft Azure – SQL Server IaaS Workshop 1

Fast Start for Microsoft Azure – SQL Server IaaS Workshop 1

Section 1: Cloud Database Deployment Options Lesson 1: Introduction to IaaS, and PaaS Understanding the difference between IaaS and PaaS 3

Cloud Database Deploymen t Virtual IaaS PaaS 05/04/2023 SQL SERVER IN PRIVATE CLOUD Deploy mission critical SQL installation in Virtualized Machines Appliances SQL SERVER ON MICROSOFT AZURE VIRTUAL MACHINES MICROSOFT AZURE SQL DATABASE Migrate existing SQL private cloud workload to cloud-hosted virtual machines Take advantage of massive computational resources of Microsoft Azure SQL Database service 4

Hybrid Cloud Off premises Paa S Physical Database Services SQL Server in WA Virtualized Machines VM Virtual SQL Server Private Virtualized Cloud Machines Appliances SQL Server Physical Machines (raw iron) High Control SaaS Microsoft Azure SQL Databa IaaS Dedicated Higher cost SQL Server Cloud Continuum Shared Lower cost On premises Low Control

Microsoft Azure Virtual Machines (IaaS) IaaS introduces new functionality that allows full control and management of both Windows and Linux virtual machines along with an extensive virtual networking Offering. Flexible Easily migrate existing applications as-is to the cloud Assist new cloud app development by Integrating IaaS and PaaS functionality Set up new Virtual Machines in Microsoft Azure with only a few clicks Agentless deployment for Windows Servers Open Start from a pre-built image from our image library Upload your own virtual hard disk from on-premises Create your own customized images Support for community and commercial versions of Linux Move images back on premises as necessary Solid Run enterprise applications such as SQL Server, SharePoint, or AD DS in the cloud Easily create hybrid cloud and on-premises Solutions with virtual private network (VPN) connectivity between the Microsoft Azure data center and your own network

IaaS Workloads: It’s All About the App Line of Business Applications: Custom Applications Customer Relationship Management (CRM) Content Management System (CMS) Enterprise Resource Planning (ERP) Business Intelligence (BI) Application infrastructure: File servers Databases Identity Source control Developer, testing and staging environments: Quickly provision and un-provision entire environments Hybrid applications: Applications that span your data center and the cloud

Avoiding Lock-In Windows Virtual Machines can move freely between all three clouds. Microsoft Azure Other Service Providers Hyper-V Virtual Machine Customer Data Center

Flexibility of Azure IaaS Support for existing and new virtualized workloads on Azure. Multiple Ways to Get Started Management Portal Scripting (Windows, Linux, and Mac) Variety of Images to Select Persistent in Storage Boot Virtual Machine from New Disk Blob Storage Cloud Representational state transfer (REST) API

Key Key Scenarios Scenarios Delivery Delivery Options Options SQL Server and Azure SQL Database Public Cloud SQL Server in a Microsoft Azure Virtual Machine Move Existing Tier Two and Three Apps Develop and Test Backup Database to the Cloud Extend OnPremises Apps to Microsoft Azure Virtual Machine Microsoft Azure SQL Database (Formerly SQL Azure Database) Develop New Cloud-Designed Apps Extend On-Premises Apps to Microsoft Azure SQL Database Can Use both SQL Server in Microsoft Azure Virtual Machine and Microsoft Azure SQL Database in a single app.

Azure SQL DB - How It Works Client Layer Architecture PHP Client Layer: Used by the application to communicate directly with the SQL database. Services Layer: Gateway between the client layer and the platform layer. Platform Layer: Includes physical servers and services that support the services layer. Infrastructure Layer: IT administration of the physical hardware and operating system. Web Site SQL Server Applications and Tools Azure SQL Database S P S Open Database Connectivity Windows Communication Communication Foundation (WCF) Data Services ADO.NET Tabular Data Stream (TDS) TDS and Secure Socket Layer Services Layer Provisioning Provisioning Provisioning Provisioning Provisioning Provisioning Billing Billing and and Metering Metering Billing Billing and and Metering Metering Billing Billing and and Metering Metering Connection Connection Routing Routing Connection Connection Routing Routing Connection Connection Routing Routing Fault Domain One Platform Layer Fault Domain Two Fault Domain Three SQL SQL Server Server SQL SQL Server Server SQL Server SQL SQL Database Database Fabric Fabric SQL SQL Database Database Fabric Fabric SQL Database Fabric Managemen t Services Managemen t Services Managemen Managemen tt Services Services Infrastructure Layer

Azure SQL Database (V12) A step towards closing the T-SQL compatibility gap between Azure SQL database and SQL Server Better premium performance New architecture SQL core engine upgraded from SQL Server 2012 to SQL Server 2014 New Capabilities such as Row-Level Security, TDE for SQL DB, SQL Audit, Dynamic Data Masking, Full Text Search, online indexing, Columnstore Indexes and Azure SQL Database Query Store (Premium tier only) and other capabilities (many in Preview and based on region) 12

Who Manages What? Infrastructure (IaaS) Microsoft manages hardware and virtualization technology Platform (PaaS) Microsoft manages everything except your applications and data

IaaS Vs PaaS Full features of on premise SQL Server and BI Free from physical administration and management SQL Server Integration Services (SSIS) Quick provisioning for testing and POC; focus on the code SQL Server Analysis Services (SSAS) Elasticity with features like selfsharding and Data Sync SQL Server Reporting Services (SSRS) Full control over physical administration data files Easier migration path to the cloud for existing code 05/04/2023 14

Lesson Knowledge Check Question: What are the two ways of deploying SQL Server databases to Azure? Answer: SQL Server in a virtual machine, and Azure SQLDB Question: What features of SQL Server does SQL Server on IaaS provide ? Answer: Full features of on premise SQL Server and BI 15

16