Professional Azure SQL Database Administration – Second Edition
$48.99
Price: [price_with_discount]
(as of [price_update_date] – Details)
[ad_1]
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 SQL databases Automate common management tasks with PowerShell Implement over 40 practical activities and exercises to reinforce your learningBook Description
Despite being the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. This book shows you how to administer Azure SQL database to fully benefit from its wide range of features and functionality.
Professional Azure SQL Database Administration begins by covering the architecture and explaining the difference between Azure SQL Database and the on-premise SQL Server to help you get comfortable with Azure SQL database. You’ll perform common tasks such as migrating, backing up, and restoring a SQL Server database to an Azure database. As you progress, you’ll study how you can save costs and manage and scale multiple SQL Databases using elastic pools. You’ll also implement a disaster recovery solution using standard and active geo-replication. Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions.
By the end of this book, you’ll be well versed with key aspects of an Azure SQL database instance, such as migration, backup restorations, performance optimization, high availability, and disaster recovery.
What you will learnUnderstand Azure SQL Database configuration and pricing options Provision a new SQL database or migrate an existing on-premise SQL Server database to Azure SQL Database Back up and restore Azure SQL Database Secure an Azure SQL database Scale an Azure SQL database Monitor and tune an Azure SQL database Implement high availability and disaster recovery with Azure SQL Database Automate common management tasks with PowerShell Develop a scalable cloud solution with Azure SQL Database Manage, maintain, and secure managed instancesWho this book is for
If you’re a database administrator, database developer, or an application developer interested in developing new applications or migrating existing ones with Azure SQL database, this book is for you. 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.
Table of ContentsMicrosoft Azure SQL Database PrimerMigrating a SQL Server Database to an Azure SQL DatabaseBacking up Azure SQL Database and Managed InstancesRestoring an Azure SQL Database And Managed InstancesSecuring an Azure SQL DatabaseScaling out an Azure SQL DatabaseElastic PoolsHigh Availability and Disaster RecoveryMonitoring and Tuning an Azure SQL DatabaseDatabase Features
Publisher : Packt Publishing; 2nd ed. edition (July 10, 2019)
Language : English
Paperback : 562 pages
ISBN-10 : 1789802547
ISBN-13 : 978-1789802542
Item Weight : 2.13 pounds
Dimensions : 9.25 x 7.52 x 1.16 inches
[ad_2]
4 reviews for Professional Azure SQL Database Administration – Second Edition
Add a review
Related Products
Jennifer Ann –
A “recipe” book for setting up and administering a DB
I liked many of the concepts, but my situation is different than his MS Azure set up. I am inheriting a MS Azure PaaS, and I need additional information other than if I had set up my PaaS exactly as he recommended. I would return the kindle book if this were a possibility.I really like Murach’s SQL Server for developers, but I needed something that would tell me where there are different commands in the cloud because I keep getting errors when using scripts that work in local SQL Server.
Marie Conti –
Der Autor führt Schritt für Schritt durch verschiedene Datenbankszenarien in Azure. Er stellt nicht nur Howtows vor, sondern, und das fand ich wesentlich spannender, erklärt auch den Blick unter die Haube, beispielsweise Index-Aufbau und Datenbankstrukturen in Azure. Sehr schön fand ich auch die Einbindung in Client-Tools wie das SSMS und das Verwalten von Azure Datenbanken durch Stored Procedures. Einige Kapitel behandeln das Thema Performance und, ganz wichtig, wie Metriken in Azure zur Leistungsmessung herangezogen werden können. Das Buch ist auch zur Vorbereitung auf das Examen DP -300 geeignet. Die Grafiken sind in schwarz-weià abgedruckt, können aber in Farbe von der Verlagsseite heruntergeladen werden.
Kindle Customer –
Very good content and helpful for dba to deal with Azure paas databases. Performance section is also good. If there will be dedicated content for deep performanceit will be very good.
Armugam Yogesh Kumar –
Bang for bucks – must for newbies