Chapter 1

Microsoft Azure SQL Database Primer

Learning Objectives

By the end of this lesson, you will be able to:

  • Describe the architecture of Microsoft Azure SQL Database
  • Identify the differences between the on-premises SQL Server and Azure SQL Database
  • Provision a SQL managed instance
  • Provision an Azure SQL database using the Azure portal and Windows PowerShell

This lesson introduces the Azure SQL Database architecture, the difference between Azure SQL Database and on-premises SQL Server, and Azure SQL Database managed instance (SQL managed instance).

Introduction

There are very few relational database systems as established and widely used as Microsoft's SQL Server. Azure SQL Database, released on February 1, 2010, is a cloud database ...

Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.