封面
版权页
Preface
About
About the Book
Chapter 1 Microsoft Azure SQL Database Primer
Introduction
The Azure SQL Database Architecture
Provisioning an Azure SQL Database
Differences between Azure SQL Database and SQL Server
Introduction to Managed Instance
Connecting to SQL Managed Instance
Summary
Chapter 2 Migrating a SQL Server Database to an Azure SQL Database
Introduction
DTU Pricing Models
Choosing Between a vCore Pricing Model and DTU-based Service Tiers
Azure Database Migration Services
Summary
Chapter 3 Backing Up an Azure SQL Database
Introduction
Automatic Backups
Manual Backups
Summary
Chapter 4 Restoring an Azure SQL Database
Introduction
Restore Types
Summary
Chapter 5 Securing an Azure SQL Database
Introduction
Access Control
Authentication
Azure SQL Database Authentication Structure
Authorization
Creating Contained Database Users for Azure AD Authentication
Advanced Data Security
Auditing
Summary
Chapter 6 Scaling out an Azure SQL Database
Introduction
Vertical Scaling
Summary
Chapter 7 Azure SQL Database Elastic Pools
Introducing Elastic Pools
Elastic Database Jobs
Summary
Chapter 8 High Availability and Disaster Recovery
High Availability
Accelerated Database Recovery (ADR)
Disaster Recovery
Synchronous Replication
Summary
Chapter 9 Monitoring and Tuning Azure SQL Database
Introduction
Monitoring an Azure SQL Database Using the Azure Portal
Monitoring Queries Using the Query Performance Insight Blade
Monitoring an Azure SQL Database Using DMVs
Tuning an Azure SQL Database
Summary
Chapter 10 Database Features
Introduction
SQL Graph Queries and Improvements
Summary
更新时间:2021-06-11 13:11:47