This chapter covers:
- Creating a highly-available distributed Azure SQL database
- Restoring an Azure SQL Database
- Moving an Azure SQL Database between subscriptions
- Optimizing costs for Azure SQL Database
In the last chapter, you learned how to create a scheduled pipeline for processing data in Azure. Azure Data Factory lets you automate the common steps in the analytics processing workflow. In chapter 6, you saw another piece of the workflow, with Stream Analytics calculations that flowed into a SQL Server database.
In this chapter, you’ll learn more about the Azure SQL Database (SQLDB). You’ll learn how SQLDB abstracts the underlying SQL Server to make complex functionality work with only a few clicks. You’ll create a highly available database, and learn how to balance cost and performance. You’ll work through some of the most common tasks in working with SQLDB. By the end, you’ll have a system ready to support end users with analytic queries in SQL.