Professional Azure SQL Database Administration
Copyright 2018 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavoured to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
Acquisitions Editors: Aditya Date, Bridget Neale
Content Development Editors: Naveenkumar Jain, Manasa Kumar
Production Coordinator: Samita Warang
First published: July 2018
Production reference: 1250718
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78953-885-4
www.packtpub.com
https://mapt.packtpub.com/
Mapt is an online digital library that gives you full access to over 5,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit https://mapt.packtpub.com/ website.
Why Subscribe?
- Spend less time reading and more time coding with practical eBooks and Videos from over 4,000 industry professionals
- Improve your learning with Skill Plans built especially for you
- Get a free eBook or video every month
- Mapt is fully searchable
- Copy and paste, print, and bookmark content
PacktPub.com
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at > for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.
Contributors
About the Author
Ahmad Osama works for Pitney Bowes India Pvt Ltd as a database engineer and is a Microsoft Data Platform Reconnect MVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premise and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation.
Other than his day to day work, Ahmad blogs at "dataplatformlabs" and has written over 100 blogs on various topics, including SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He regularly speaks at user group events and webinars conducted by the Dataplatformlabs community. You can reach him on LinkedIn at "ahmadosama3" or follow his twitter handle @_ahmadosama.
About the Reviewer
Mohit Gupta works as a Solutions Architect with Pitney Bowes India Pvt Ltd and is focused on Cloud technologies and DevOps methodologies. Mohit has more than 12 years of experience in Software Product Development and has worked on AWS and Azure technologies since 2012. Mohit has helped customers of all sizes design, architect, build, migrate, and manage their workloads and applications on various cloud-based products including AWS and Azure. He received his Bachelors of Technology from Kurukshetra University. Additionally, he holds many Industry-leading IT Certifications. Learn more about Mohit's work at his blogspot page "mogupta".
Packt is Searching for Authors Like You
If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.
Preface
Azure SQL Database is a scalable, high performing SQL Server based Managed Cloud Database Service offering from Microsoft.
Though Azure SQL Database is the cloud version of SQL Server, it differs in terms of management, maintenance and administration. It's important to know how to administer SQL Database so that you can get the most out of the features that it provides. The book addresses different management aspects of an Azure SQL Database such as Migration, Backup and Restore, Pricing, Security, Scalability, Monitoring and Performance Optimization, High Availability, and Disaster Recovery.
After completing this book, you will be able to:
- Explore the different configuration and pricing options available for Azure SQL Database
- Provision a new Azure SQL Database or Migrate an existing on-premise SQL Server database to Azure SQL Database
- Backup and restore Azure SQL Database
- Secure and 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
What This Book Covers
, Microsoft Azure SQL Database Primer , covers the fundamental architecture of Microsoft Azure SQL Database. We will provision an Azure SQL Database and learn to connect and query it. We will also discuss the differences between the on-premises SQL Server and Azure SQL Database.
, Migrating a SQL Server Databaseto an Azure SQL Database , discusses the features of the various Azure SQL Database service tiers that are available and the need for migration. We will talk about selecting the most suitable service tier, finding and fixing compatibility issues originating as a result of data migration, and selecting the most appropriate migration tool or method based on the scenario.
, Backing Up the Azure SQL Database , explains how to perform automatic and manual backups for Azure SQL Databases and discusses the benefits and strategies for each.
, Restoring an Azure SQL Database , covers the various restore options available on the Azure SQL Database. We will understand the features of each restore type, when and where they can be used, and how they are performed.
, Securing an Azure SQL Database , discusses various security mechanisms employable on the Azure SQL Database. We will talk about access control measures such as Firewall and Authentication and also cover proactive security measures, including Dynamic Data Masking, Auditing, and Threat Detection.
, Scaling Out Azure SQL Database , explains how to scale Azure SQL Databases, either vertically or horizontally, and how to shard a database. The lesson further talks about how to run cross-database queries.