Professional Azure SQL Managed Database Administration

Professional Azure SQL Managed Database Administration
Author :
Publisher : Packt Publishing Ltd
Total Pages : 725
Release :
ISBN-10 : 9781801073325
ISBN-13 : 1801073325
Rating : 4/5 (325 Downloads)

Book Synopsis Professional Azure SQL Managed Database Administration by : Ahmad Osama

Download or read book Professional Azure SQL Managed Database Administration written by Ahmad Osama and published by Packt Publishing Ltd. This book was released on 2021-03-08 with total page 725 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master data management by effectively utilizing the features of Azure SQL database. Key FeaturesLearn to automate common management tasks with PowerShell.Understand different methods to generate elastic pools and shards to scale Azure SQL databases.Learn to develop a scalable cloud solution through over 40 practical activities and exercises.Book Description Despite being the cloud version of SQL Server, Azure SQL Database and Azure SQL Managed Instance stands out in various aspects when it comes to management, maintenance, and administration. Updated with the latest Azure features, Professional Azure SQL Managed Database Administration continues to be a comprehensive guide for becoming proficient in data management. The book begins by introducing you to the Azure SQL managed databases (Azure SQL Database and Azure SQL Managed Instance), explaining their architecture, and how they differ from an on-premises SQL server. You will then learn how to perform common tasks, such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you will study how you can save costs and manage and scale multiple SQL databases using elastic pools. You will also implement a disaster recovery solution using standard and active geo-replication. Finally, you will explore the monitoring and tuning of databases, the key features of databases, and the phenomenon of app modernization. By the end of this book, you will have mastered the key aspects of an Azure SQL database and Azure SQL managed instance, including migration, backup restorations, performance optimization, high availability, and disaster recovery. What you will learnUnderstanding Azure SQL database configuration and pricing optionsProvisioning a new SQL database or migrating an existing on-premises SQL Server database to an Azure SQL databaseBacking up and restoring an Azure SQL databaseSecuring and scaling an Azure SQL databaseMonitoring and tuning an Azure SQL databaseImplementing high availability and disaster recovery with an Azure SQL databaseManaging, maintaining, and securing managed instancesWho this book is for This book is designed to benefit database administrators, database developers, or application developers who are interested in developing new applications or migrating existing ones with Azure SQL database. Prior experience of working with an on-premise SQL Server or Azure SQL database along with a basic understanding of PowerShell scripts and C# code is necessary to grasp the concepts covered in this book.


Professional Azure SQL Managed Database Administration Related Books

Professional Azure SQL Managed Database Administration
Language: en
Pages: 725
Authors: Ahmad Osama
Categories: Computers
Type: BOOK - Published: 2021-03-08 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Master data management by effectively utilizing the features of Azure SQL database. Key FeaturesLearn to automate common management tasks with PowerShell.Unders
Professional Azure SQL Database Administration
Language: en
Pages: 562
Authors: Ahmad Osama
Categories: Computers
Type: BOOK - Published: 2019-07-19 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Leverage the features of Azure SQL database and become an expert in data management Key FeaturesExplore ways to create shards and elastic pools to scale Azure S
Professional Azure SQL Database Administration
Language: en
Pages: 398
Authors: Ahmad Osama
Categories: Computers
Type: BOOK - Published: 2018-07-31 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

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
SQL Server 2017 Administration Inside Out
Language: en
Pages: 1125
Authors: William Assaf
Categories: Computers
Type: BOOK - Published: 2018-02-26 - Publisher: Microsoft Press

DOWNLOAD EBOOK

Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. Th
Azure SQL Revealed
Language: en
Pages: 408
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2020-10-30 - Publisher: Apress

DOWNLOAD EBOOK

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundame