Professional Azure SQL Database Administration
Language: English
Published by Packt Publishing Limited, GB, 2019
- Softcover
- New
Seller: Rarewaves USA, HEBRON, KY, U.S.A.Rarewaves USA
AbeBooks seller since June 10, 2025
Condition: New
£ 51.41
Quantity: Over 20 available
Add to basketItem description from seller
This book is your one-stop solution to learning all that is needed to 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.
Seller Inventory # LU-9781789802542
- Title
- Professional Azure SQL Database Administration
- Author
- Ahmad Osama
- Publisher
- Packt Publishing Limited, GB
- Publication year
- 2019
- Condition
- New
- Binding
- Paperback
- Language
- English
- ISBN 10
- 1789802547
- ISBN 13
- 9781789802542
- Edition
- 2nd Edition
Leverage the features of Azure SQL database and become an expert in data management
Key Features
- Explore 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 learning
Book 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 learn
- Understand 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 instances
Who 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 Contents
- Microsoft Azure SQL Database Primer
- Migrating a SQL Server Database to an Azure SQL Database
- Backing up Azure SQL Database and Managed Instances
- Restoring an Azure SQL Database And Managed Instances
- Securing an Azure SQL Database
- Scaling out an Azure SQL Database
- Elastic Pools
- High Availability and Disaster Recovery
- Monitoring and Tuning an Azure SQL Database
- Database Features
"Synopsis" may belong to another edition of this title.
About the Author
Ahmad Osama works for Pitney Bowes Pvt Ltd as a database engineer and is a Microsoft Data Platform MVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premises and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation. Other than his day to day work, he regularly speaks at user group events and webinars conducted by the Dataplatformlabs community.
"About the title" may belong to another edition of this title.
Shipping rates within U.S.A.
| Item | 13 to 14 business days | 13 to 16 business days |
|---|---|---|
| First item | £ 0.00 | £ 0.00 |
Payment methods
Seller's business information
Rarewaves USA
10100 West Sample Road, Ste 101
Coral Springs, FL U.S.A. 33065
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 USA, Coral Springs, Florida, U.S.A., 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:
Afghanistan
Bhutan
Brazil
Brunei Darussalam
Channel Islands
Chile
Israel
Lao
Mexico
Russian Federation
Saudi Arabia
South Africa
Yemen
Please do not attempt to place orders with any of these countries as a ship to address - they will be cancelled.