Professional Azure SQL Managed Database Administration: Manage Data Efficiently in the Cloud with Azure SQL, 3rd Edition

Price: $29.49
(as of May 21,2023 00:45:40 UTC – Details)

If you want to become proficient in data management, Master the techniques of efficiently using the features of Azure SQL database with Professional Azure SQL Managed Database Administration.

Key Features

• Automate common Azure SQL management tasks using PowerShell
• Understand various methods to generate elastic pools and shards for scaling Azure SQL databases
• Explore over 40 practical activities and exercises to develop a scalable cloud solution

Book Description

Professional Azure SQL Managed Database Administration is a comprehensive guide for managing, maintaining, and administering data on Azure SQL Managed Instance and Azure SQL Database. With the updated version, this book covers the latest Azure features, making it the go-to guide for modernizing data management.

The book starts by introducing you to the Azure SQL managed databases, explaining their architecture, and differentiating them from on-premises SQL servers. You will learn how to perform common tasks like migrating, backing up, and restoring a SQL Server database to Azure Database or Azure SQL Managed Instance.

The book progresses with discovering how to save costs, manage, and scale multiple SQL databases using elastic pools. Later, you will develop a disaster recovery solution using standard and active geo-replication. Finally, you will learn to monitor and optimize databases, the critical features of databases, and the phenomenon of app modernization.

By the end of this book, you will have mastered managing an Azure SQL database and Azure SQL managed instance, which includes migration, backup restorations, performance optimization, high availability, and disaster recovery.

What You Will Learn

• Understand Azure SQL database configuration and pricing options
• Provision new SQL database or migrate existing on-premises SQL Server database to Azure SQL database
• Back up and restore an Azure SQL database
• Secure and scale an Azure SQL database
• Monitor and tune an Azure SQL database
• Implement high availability and disaster recovery with an Azure SQL database
• Manage, maintain and secure managed instances

Who This Book Is For

If you are a database developer, a database administrator, or an application developer interested in creating new applications or migrating the old ones with Azure SQL database, then this book is for you. Prior experience with on-premise SQL Server or Azure SQL database, along with a basic understanding of PowerShell scripts and C# code, is necessary to follow the concepts covered in this book.

Table of Contents

1. Introduction to Azure SQL Managed Databases
2. Service Tiers
3. Migration
4. Backups
5. Restoration
6. Security
7. Scalability
8. Elastic and Instance Pools
9. High Availability and Disaster Recovery
10. Monitoring and Tuning
11. Database Features
12. App Modernization

ASIN ‏ : ‎ B08YJRJ3TJ
Publisher ‏ : ‎ Packt Publishing; 3rd edition (March 8, 2021)
Publication date ‏ : ‎ March 8, 2021
Language ‏ : ‎ English
File size ‏ : ‎ 103915 KB
Text-to-Speech ‏ : ‎ Enabled
Screen Reader ‏ : ‎ Supported
Enhanced typesetting ‏ : ‎ Enabled
X-Ray ‏ : ‎ Not Enabled
Word Wise ‏ : ‎ Not Enabled
Sticky notes ‏ : ‎ On Kindle Scribe
Print length ‏ : ‎ 724 pages
Page numbers source ISBN ‏ : ‎ 1801076529