SQL Server on Azure Virtual Machines

SQL Server on Azure Virtual Machines

Copyright © 2020 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 authors, 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 endeavored 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.

Authors: Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, and Randolph West

Managing Editors: Aditya Datar and Siddhant Jain

Acquisitions Editor: Alicia Wooding

Production Editors: Ganesh Bhadwalkar and Deepak Chavan

Editorial Board: Vishal Bodwani, Ben Renow-Clarke, Ian Hough, and Dominic Shakeshaft

First Published: June 2020

Production Reference: 1010620

ISBN: 978-1-80020-459-1

Published by Packt Publishing Ltd.

Livery Place, 35 Livery Street

Birmingham B3 2PB, UK

Table of Contents

Foreword

Preface

1. Introduction to SQL Server on Azure Virtual Machines

Introduction

The Azure SQL portfolio

SQL Server on Azure Virtual Machines

Azure SQL Managed Instance

Azure SQL Database

SQL Server in Azure comparisons

SQL Server 2019 highlights

Intelligence over all of your data

Enhancements in developer experience

Performance enhancements

Security improvements

High Availability/Disaster Recovery (HADR)

Platform of choice

SQL Server IaaS scenarios and use cases

Lift and Shift

Extending your on-premises environment to the cloud

Development and test environments

Choosing an OS for SQL Server in Azure VMs

Reasons to choose either Windows or Linux for SQL Server

Differences between SQL Server on Linux and Windows

Summary

Chapter links

2. Getting started with SQL Server on Azure Virtual Machines

The benefits of deploying SQL Server using IaaS

Deployment choices for IaaS

Deployment methods

Common Azure VM deployment considerations for SQL Server

Licensing SQL Server in Azure

Azure VM hardware options

VM types and sizes

Storage

Summary

Chapter links

3. Hero capabilities of SQL Server on Azure Virtual Machines

Understanding platform availability in Azure

Availability Zones

Availability sets

Disaster recovery options for SQL Server in Azure

Beyond backups

Always On availability groups

Differences with availability groups in Azure

Availability groups for read-scale workloads

SQL Server on Azure VM resource provider

Performance optimized storage configuration

SQL Server performance in Azure VMs

Azure Storage

Disk layout for SQL Server on Azure

Backups

Gathering performance information

Query Store

Azure portal

Activity Monitor

Extended Events

Identifying disk performance issues with SQL Server

Key performance features in SQL Server

Security concepts

Connecting to Azure VMs

Network security groups

Azure Security Center

Authentication

SQL Server security

Advanced data security for SQL Server on Azure VMs

Azure Active Directory

Azure Key Vault

Transparent data encryption

Always Encrypted

Dynamic data masking

Azure Disk Encryption

Auditing

Data Discovery and Classification

Summary

Chapter links

4. SQL Server on Linux in Azure Virtual Machines

SQL Server on the Linux development ecosystem

Open-source development frameworks and tooling for SQL Server on Linux in Azure Virtual Machines

The extensibility framework and language extensions

Object-relational mapping (ORM) frameworks

Cross-platform tooling

Graphical tools

Command-line tools

Platform deployment and management for SQL Server in Azure

Supported base operating systems for running SQL Server on Linux in Azure IaaS VMs

Using an Azure Marketplace image with SQL Server on Linux pre-installed

Using a Linux Azure Marketplace image and installing SQL Server on Linux manually

Container-based deployments for SQL Server on Linux in Azure

Running multiple SQL Server containers on an IaaS VM in Azure

Container images available for SQL Server on Linux

Starting a container running SQL Server on Linux

Deploying SQL Server in containers in Azure

So many choices: which platform should you choose?

Which base operating system?

How should you choose between containers and VMs?

Why should you do this in Azure?

Summary

Chapter links

5. Performance

Performance best practices

Virtual Machine Storage

Memory

CPU

SQL Server configuration

Dynamic management views (DMVs) and Query Store

How to optimize SQL Server on Linux

Azure BlobCache

Summary

Chapter links

6. Moving workloads to SQL Server on Azure Virtual Machines

Migration tools and best practices

Best practices

Migration and analysis tools

Migrating databases to the cloud

Application considerations

Reporting in the cloud—Power BI

Summary

Chapter links

7. Hybrid scenarios (Microsoft SQL IaaS)

What is Azure Hybrid Benefit?

What is disaster recovery?

Recovery point objective

Recovery time objective

Accelerated database recovery

How does licensing influence disaster recovery?

Backing up databases to a URL

How to back up to a URL

Use cases for SQL Server on Azure VMs

As a backup-restore target

As an availability group replica

As a transactional replication subscriber

Hybrid scenarios

Scenario 1: Read scale workloads

Scenario 2: Migrating a workload

Scenario 3: Disaster recovery

Summary

Chapter links

Appendix A

Index

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset