O'Reilly logo

Microsoft Azure Essentials Migrating SQL Server Databases to Azure by Carl Rabeler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required