Chapter 5. Authentication, authorization, and data resiliency

In this chapter, I will discuss protecting access to your data through authentication over a secure network and granting permissions to authenticated users to perform tasks and access data. I will also discuss protecting and archiving your data using database backups and database exports. I will compare and contrast the mechanisms available to you with SQL Server in an Azure virtual machine and with Azure SQL Database. We will finish the chapter with a guided walk-through of configuring authentication and granting permissions in Azure SQL Database and a walk-through demonstrating how to use Azure SQL Database automated backups to recover from user error and to archive data.

Securing ...

Get Microsoft Azure Essentials Migrating SQL Server Databases to Azure 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.