Professional Azure SQL Managed Database Administration
Language: English
Published by Packt Publishing Limited, GB, 2021
- Softcover
- New
Seller: Rarewaves.com USA, London, London, United KingdomRarewaves.com USA
AbeBooks seller since June 11, 2025
Condition: New
£ 66.37
Quantity: Over 20 available
Add to basketItem description from seller
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.
Seller Inventory # LU-9781801076524
- Title
- Professional Azure SQL Managed Database Administration
- Author
- Ahmad Osama, Shashikant Shakya
- Publisher
- Packt Publishing Limited, GB
- Publication year
- 2021
- Condition
- New
- Binding
- Paperback
- Language
- English
- ISBN 10
- 1801076529
- ISBN 13
- 9781801076524
- Edition
- 3rd ed.
- Dimensions
- 19.05 x 4.17 x 23.5 cm
Master data management by effectively utilizing the features of Azure SQL database.
Key Features
- Learn 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 learn
- Understanding Azure SQL database configuration and pricing options
- Provisioning a new SQL database or migrating an existing on-premises SQL Server database to an Azure SQL database
- Backing up and restoring an Azure SQL database
- Securing and scaling an Azure SQL database
- Monitoring and tuning an Azure SQL database
- Implementing high availability and disaster recovery with an Azure SQL database
- Managing, maintaining, and securing managed instances
Who 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.
Table of Contents
- Introduction to Azure SQL managed databases
- Service tiers
- Migration
- Backups
- Restoration
- Security
- Scalability
- Elastic and instance pools
- High availability and disaster recovery
- Monitoring and tuning
- Database features
- App modernization
"Synopsis" may belong to another edition of this title.
About the Author
Ahmad Osama works for Pitney Bowes Pvt. Ltd. as a technical architect and is a former Microsoft Data Platform MVP. In his day job, he works on developing and maintaining high performant, on-premises and cloud SQL Server OLTP environments as well as deployment and automating tasks using PowerShell. When not working, Ahmad blogs at DataPlatformLabs and can be found glued to his Xbox.
Shashikant Shakya is a passionate technologist with decades of experience in the sphere of databases. He works for Microsoft as a senior support engineer. In his day job, he works on Azure SQL Database, Azure Database for MySQL, and PostgreSQL. Apart from his work, he is a regular speaker at the SQLBangalore community group.
"About the title" may belong to another edition of this title.
Rarewaves.com USA
London, London, United Kingdom
AbeBooks seller since June 11, 2025
Shipping rates from United Kingdom to U.S.A.
| Item | 9 to 14 business days | 9 to 14 business days |
|---|---|---|
| First item | £ 0.00 | £ 0.00 |
Payment methods
Seller's business information
RAREWAVES.COM LIMITED
Elsley Court, 20-22 Great Titchfield Street
London, United Kingdom W1W 8BE
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Rarewaves.com USA, Unit 144 The Lightbox, 111 Power Road, W4 5PY, London, London, United Kingdom, without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.
Shipping terms
Please note that we do not offer Priority shipping to any country.
We currently do not ship to the below countries:
Russia
Belarus
Ukraine
Please do not attempt to place orders with any of these countries as a ship to address - they will be cancelled.