Many organizations have an aging or under-engineered data platform strategy. There's been a significant trend of moving existing systems to the cloud, building new applications quickly by using the cloud, and offloading some on-premises costs. You need a plan for how to move some workloads to the cloud. And you need to understand how to set up your organization for success. You also need to understand how the role of a database administrator (DBA) or data professional stays the same, and what changes you'll have to make. In this module, you'll start with a brief history of why and how Microsoft built Azure SQL. You'll then learn about the various deployment options and service tiers, including what to use for your organization, and when. These options include Azure SQL Database, Azure SQL Managed Instance, and SQL Server in an Azure virtual machine. Understanding what platform as a service (PaaS) encompasses and how it compares to a traditional SQL Server environment will help you understand what you do and don't get when you move to the cloud.
In this module, you'll learn how to:
- Describe the evolution of SQL Server in Azure.
- Determine which deployment option is best for workloads in your organization.
- Select the purchasing models, service tiers, and hardware that best fit a workload.