Home Page Icon
Home Page
Table of Contents for
cover
Close
cover
by Joey D'Antoni, Louis Davidson, Allan Hirt,
SQL Server on Azure Virtual Machines
Foreword
Preface
About SQL Server on Azure Virtual Machines
About the Authors
Learning Objectives
Audience
Approach
Hardware and Software Requirements
Conventions
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
By Louis Davidson
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
By Allan Hirt
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
By Joey D'Antoni
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
By Anthony Nocentino
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
By Tim Radney
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
By John Martin
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
By Randolph West
Appendix A
SQL Server Configuration with OLTP
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
B16251_FM_ePub
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset