Professional Azure SQL Database Administration

Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases.

Key Features

• Implement backup, restore, and recovery of Azure SQL databases
• Create shards and elastic pools to scale Azure SQL databases
• Automate common management tasks with PowerShell
• Implement over 40 practical activities and exercises across 24 topics to reinforce your learning

Book Description

What you will learn

• Learn how to provision a new database or migrate an existing on-premise solution
• Understand how to backup, restore, secure, and scale your own Azure SQL Database
• Optimize the performance by monitoring and tuning your cloud-based SQL instance
• Implement high availability and disaster recovery procedures with SQL Database
• Develop a roadmap for your own scalable cloud solution with Azure SQL Database

Who this book is for

This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.