Index
A
Accelerated database recovery (ADR)
Accelerated networking
Accelerating and tuning performance
AdventureWorks
application latency
increasing memory/workers
I/O performance
scaling CPU capacity
SQL Server
Access
Access control list (ACL)
Access to sensitive data
Active directory authentication
Activity log
Administrator account
Advanced data security (ADS)
ASC
ATP
Azure SQL Database
configuration
data classification
SeeData classification
vulnerability assessment
Advanced threat protection (ATP)
AdventureWorks
AdventureWorksLT database
AdventureWorks sample
ALTER DATABASE reference
Altering databases
ALTER SERVER CONFIGURATION
Always Encrypted
Always On Availability Groups (AG)
Always on failover cluster instance
Amazon elastic compute cloud (EC2)
Amazon web services (AWS) suite
Analytics as a service
Application programming interface (API)
ARM template
Asynchronous messaging techniques
Auditing
Azure SQL Database
configuration
log analytics dashboard
log analytics workspace
query editor, view data
security insights dashboards
selection
storage account, creation
storage details, configuration
tracking connections
viewing audit
managed instance
SQL Server Audit
tracking logins
Audit record for DROP statement
Audit records after DROP statement
Authentication
Azure Active Directory
Azure RBAC
Azure SQL Database
AAD
SeeAzure Active Directory (AAD)
contained users
Azure SQL Managed Instance
Auto-failover groups
Automated patching
Automatic backups 106
and Point-In-Time restore
retention
schedule, activity
storage consumption and costs
Automatic indexing
Automatic plan correction (APC)
Automatic Tuning
AdventureWorks example
details, index recommendation
index recommendation notification
performance overview
performance recommendations
query performance insights
setting automatic tuning options
T-SQL script, index recommendations
Azure SQL Database
index recommendations
Autopause delay
AutoPilot
Auto-shutdown
Availability
auto-failover groups
backup and restore
built-in high
and connectivity
and consistency
geo-replication
HADR capabilities
monitoring
SLA
zone redundancy
Availability set
Availability zones in Azure
az CLI
AzCopy
az deployment
az sql vm CLI
Azure account
Azure Active Directory (AAD)
admin, Azure SQL Database
authentication
Azure Data Studio
Azure SQL Database
options
Azure Active Directory logins
Azure Active Directory Services (AADS)
Azure advisor
Azure Arc
Azure automation
Azure availability set
Azure availability zones
Azure Backup
Azure Blob Storage
Azure Cloud Shell
Azure Cognitive Search
Azure datacenter
Azure Data Factor (ADF)
Azure Data Studio (ADS)
Azure Dedicated Host
Azure DevOps
Azure ecosystem
accounts and subscriptions
API and CLI
ARM
Azure Marketplace
Azure Monitor
Azure portal
regions and datacenters
SLAs
Azure Event Hub
Azure feedback
Azure Hybrid Benefit (AHB)
Azure IOT Hub
Azure IOT reference architecture
Azure Key Vault
Azure Key Vault integration
Azure Kubernetes Service (AKS)
Azure locks
Azure Marketplace
Azure metrics
SQL Server
virtual machine
Azure Migrate Server Migration
Azure Monitor
Azure policy
Azure portal
features
home page
Azure PowerShell
Azure redundancy
Azure regions worldwide
Azure Reserved VM Instances
Azure Resource Manager (ARM)
activity log
interfaces
locks
RBAC
resource groups
system
templates
Azure REST APIs
Azure role-based access control (RBAC)
Azure Search
Azure SQL Database
database and table
explorer
index build notification
indexer, creation
integrates with Azure SQL Database
search-as-a-service cloud solution
search index, customizing
Azure Security Center (ASC)
Azure Security Center for SQL
Azure Service Fabric
Azure Service Health
Azure Services Platform
Azure SQL
databases
deployment options
features and capabilities
lineup
managed instance
SeeManaged Instance
services and marketplace
virtual machines
Azure SQL resources
Azure SQL Database
advanced data security and ILDC team
vs. Azure SQL Managed Instance
basic, standard, and premium editions
capabilities
configure firewall rules
customers
DTU
editions
engineering model
Ibiza
intelligent performance and MDCS
managed instance
options
business critical
DTU vs. vCore
elastic pool databases
general purpose
Hyperscale
serverless
private and public preview
restrictions
significant events
sterling (SAWAv2) project
Azure SQL Database architecture
Azure SQL Data Warehouse
Azure SSIS
Azure status dashboard
Azure Storage
Azure subscription
Azure Synapse
Azure Virtual Machine
SeeVirtual Machine (VM)
Azure Virtual Network Gateway
az vm CLI
B
Backup retention policies
Backups
BACPAC file
Blackbird
Bring your own key (BYOK)
Bring Your Own License (BYOL)
Buffer Pool limits
Built-in high availability
Azure SQL deployment
business critical (BC)
general purpose (GP)
hyperscale
investment
Bulk copy program (bcp)
Business Critical (BC)
HADR waits
high-availability
bwazuresqlauditstorage
bwazuresqldb
bwazuresqldbbc
bwazuresqlserver
bwazuresqlserver2
bwazuresqlserversouth
bwsql2019
C
CampBrain
Capabilities
managed
restore
Catalog views
Classic virtual machines
ClearSale
Cloud-based database service
Cloud computing
CloudDB
clouddrive
Cloud first approach
CloudLifter
Cloud OS
Cloud provider
Cloud service provider (CSP)
Cluster
Column level encryption
Columnstore indexes
Command-line interfaces (CLI)
Community technology preview (CTP)
Configuration
Azure SQL Database
altering databases
databases, creation
network configuration
Azure SQL Managed Instance
databases
edition
master and model
networking
sp_configure
Tempdb
trace flags
VM
options
resizing
security
stopping vs. deallocating
Connection policy
Connectivity
CREATE DATABASE statement
Cross-database queries
Cumulative updates (CU)
Customer feedback
Customer-managed key
D
DAC
SeeDedicated admin connection (DAC)
Database availability
Database collation
Database compatibility level
Database configuration
Database consistency
Database copy
Database crash recovery algorithms
Database encryption key (DEK)
Database engine instance
DATABASE engine instance of SQL Server
Database Mail
Database migration service (DMS)
Database restrictions
Database scoped credentials
Database server
Database service
Database transaction unit (DTU)
Database Tuning Advisor (DTA)
Data centers
Data classification
access to sensitive data
audit records
Azure SQL Database
dashboard
log analytics dashboard
recommendations
Data disks
Data encryption
Data exposed
Data loading
ADF
additional resources
AzCopy
BACPAC file
bcp
BULK INSERT and OPENROWSET
database copy
replication subscriber
RESTORE to managed instance
spark connector
SQL data sync
SSIS
Data Migration Assistant (DMA)
Data protection
always encrypted
BYOK
DDM
encrypting connections
TDE
Data residency
dbmanager
Dedicated admin connection (DAC)
Deploy Azure SQL Database
additional settings
basics options
business critical
with CLI
completed deployment
connecting
final screen
hyperscale
implementation details
dedicated rings and instances
hyperscale
logical server
resource governance
serverless
storage, compute, and gateways
networking choices
overview screen
serverless
tags
verifying deployment
Deploying Azure SQL Managed Instance
activity log
CLI
connection
SSMS, jumpbox
VM
implementation details
overview screen
verifying deployment
Deployment choices, Azure SQL
deployment method
hardware
option
price
purchasing model
region
resource limits
service tier
sizes
Deployment, VM
activity log
advanced options
availability options
image
management options
pricing
in progress
region
resource group
SQL Server Gallery Images
virtual machine name
Distributed transactions (DTC)
DMVs
SeeDynamic management views (DMVs)
DTC
SeeDistributed transactions (DTC)
Dynamic data masking (DDM)
Dynamic Management Views (DMVs)
Azure SQL Database
deep troubleshooting
dive deeper
E
Elastic Database
Elastic job agent service
Elastic jobs
agent properties and job history
agent service
create and execute
create the job
credentials, logins and users
database
databases concurrently
monitor job execution
run the job
services and resources
target groups and members
target logical server and database(s)
view jobs via Azure portal
Elastic pools
Encryption of connections
End User Licensing Agreement (EULA)
Engineering team
Enterprise Agreement (EA)
ERRORLOG configuration
Error reporting
Exchange hosted archive (EHA)
Extended event format
Extended Events (XEvent)
Azure SQL Database
Azure SQL Managed Instance
session
track queries, ATP
Extensible Key Management (EKM)
External data source
EXTERNAL_GROUP
External tables
Extract Transform and Load (ETL)
F
Fabric controller (FC)
Failover
Failover cluster instance (FCI)
Failover group after deployment
Failover group name
FCI
SeeFailover cluster instance (FCI)
Federal Information Processing Standards (FIPS)
Filegroups
Files
Files, Azure
File snapshot backups
File Source Resource Manager (FSRM)
Firewall rule
Free trial
Full-text search
Fully Qualified Domain Name (FQDN)
G
Gallery images
Gateways
General Availability (GA)
General Data Protection Regulation (GDPR)
General distribution releases (GDR)
General purpose (GP) high-availability
Geography
Geo-redundant storage (GRS)
Geo-replication
vs. auto-failover groups
Geo-restore
H
HADR
SeeHigh availability and disaster recovery (HADR)
Handling errors
Hardware generation
Hardware security modules (HSMs)
High availability and disaster recovery (HADR)
always on availability groups
always on failover cluster instance
Azure availability
Azure Storage
Backups
capabilities
automatic backups and Point-In-Time restore
Azure redundancy
built-in high availability
database availability and consistency
geo-replication and auto-failover groups
SQL Server replication
SQL Server and Linux availability
High Availability (HA)
Host group
Hot patching
Hyperscale
architecture
compute nodes
data files
deployment
fault tolerant
landing zone
log service
long-term log storage
page servers
read-scale replicas
snapshot backups
zero to four secondary replicas
Hyperscale deployment options
Hyperscale read-scale monitoring
Hyper-V virtual machine
I
Ibiza portal
Inbound traffic
Incubation
Indexes
Infrastructure as a Service (IaaS)
In-Memory OLTP
Input/Output Per Second (IOPS)
Insights
Instant File Initialization (IFI)
Intelligent performance
APC
automatic tuning
SeeAutomatic Tuning
capabilities
IQP
Intelligent query processing (IQP)
Interfaces, Azure SQL
ADS
az CLI
Azure Portal
PowerShell
REST API
SQL CLI
SSMS
TDS and T-SQL
Visual Studio tools
Internet Information Server (IIS)
I/O latency
I/O performance
I/O waits
J
Job management
Azure automation
elastic jobs
SQL Server Agent
Jumpbox
K
Kusto Query Language (KQL)
L
Latch waits
Latency performance
Lifting customers to Cloud
Lightweight mode
Lightweight query profiling
Linked servers
Locally redundant storage (LRS)
Locked pages
Lock waits
Log governance
Logical master database
Logical server
loginmanager
Logon auditing
Log rate governance
Logs
Log service
Long-term backup retention (LTR)
Long-term log storage
LTR
SeeLong-term backup retention (LTR)
M
Machine learning services
Machine learning technology
Maintaining indexes
Maintenance, Azure SQL
Managed Instance
vs. Azure SQL Database
business critical
capabilities
customers
deployed with CLI
deployment options
additional settings
basics
deploy
networking
tags
general purpose
pool deployment
pools
restrictions
SeeRestrictions
SQL server on Azure VM
verifying deployment
Management endpoint
Management groups
Marketplace
Max degree of parallelism (MAXDOP)
Max server memory
Memory
Memory grants
Memory management
Memory-optimized tables
Microsoft Azure
Microsoft Developer Center Serbia (MDCS)
Microsoft distributed transaction coordinator (MSDTC)
Microsoft Israel Development Center (ILDC)
Microsoft technical support
Migration
Migration process, Azure SQL Database
Migration process, managed instance
application changes
assessment and planning
migration
post migration
Minimal logging
Mixed mode security
Monitoring availability
backup and restore history
failover reasons
instance, server and database
region, data center and service
replica status
system center management pack
Monitoring security
auditing
SeeAuditing
Azure ecosystem
Monitoring tools and capabilities
Azure Monitor
DMV
extended events
lightweight query profiling
performance visualization
query plan debugging
query store
MSDTC
SeeMicrosoft distributed transaction coordinator (MSDTC)
Multi-tenant databases
N
Networking
deploying Azure SQL Database
VM
Network security
Azure SQL Database
private link
public endpoint
Azure SQL Managed Instance
Network security group (NSG)
New-AzSqlVM
New-AzVM command
New support request
Node
Node isolation
Noisy neighbor problem
O
Object Explorer (OE)
Online migration strategy
OS guest diagnostics
Outbound traffic
P
Partitions
Pay-as-you-go
Paychex
Performance best practices
Performance capabilities
indexes
in-memory OLTP
intelligent performance
maximum capacities
partitions
SQL Server 2019 enhancements
Performance monitoring
Azure metrics
insights
logs
Performance scenarios
resources, example
running scenario
SeeRunning scenario
running vs. waiting
Performance tiers
Performance visualization, Azure Portal
Pipelines
PITR
SeePoint-in-time restore (PITR)
Plan cache eviction
Platform as a Service (PaaS)
Point-in-time restore (PITR)
Polybase
Post migration
Pottermore
Power Apps
Power Automate
Power BI
PowerDetails
Power Platform
integration with Azure SQL
Power Apps
Power Automate
Power BI
PowerShell cmdlets
PowerShell Azure cmdlet
Premium
Privacy policy
Private and public preview
Private endpoint
Private link
Proximity placement groups
Public endpoint
Purchasing model
Q
Query performance insight
Query plan debugging
Query plan regression
Query store
R
RBEX
SeeResilient Buffer Pool Extension (RBEX)
Read-access geo-zone-redundant storage
Recovery point objective (RPO)
Recovery time objective (RTO)
RedDog
Red Dog Front End (RDFE)
Red Hat Enterprise Linux (RHEL)
Redirect connection policy
Regions
Reliability
Remote Desktop Client (RDP)
Remote Desktop Protocol (RDP)
Replication subscriber
Representational State Transfer (REST) API
Resilient Buffer Pool Extension (RBEX)
Resizing
Resource capacities and limits
Resource Governor
Resource groups
Resource health
Resource limits
Resource reservations
Restore backups from deleted databases
RESTORE DATABASE statement
Restore in Azure SQL Managed Instance
Restoring database
Restrictions
Azure SQL Database
Managed Instance
ALTER SERVER CONFIGURATION
database restrictions
ERRORLOG Configuration
error reporting and customer feedback
FILESTREAM and availability groups
instant file initialization
locked pages
logon auditing
mixed mode security
server collation
server proxy account
start and stop services
startup parameters
Role-based access control (RBAC)
RPO
SeeRecovery point objective (RPO)
R Services (Advanced Analytics)
RTO
SeeRecovery time objective (RTO)
Runbook
Running scenario
query store
sys.dm_exec_procedure_stats
sys.dm_exec_query_stats
waiting
S
Scalable web applications
Scaling
Scaling CPU capacity
SCOM
SeeSystem center operations management (SCOM)
SDS hosting system
Security capabilities
active directory authentication
advanced data security
auditing
Azure RBAC and locks
data encryption
dynamic data masking
Security playbook
Security tasks
advanced data security
authentication and authorization configuration
data protection
monitor
set up and configure network security
Seeding
Self-service database restore
Sensitive data
Server admin login
Server collation
Server Data Tools (SSDT)
Serverless
Serverless compute models
Serverless compute options
Serverless query service
Serverless scale
Server proxy account
Server tools and business (STB)
Service broker
Service fabric
Service-level agreement (SLA)
Service-Level Objective (SLO)
Service/pricing tier
Service Tier
Set-AzSqlServerActiveDirectoryAdministrator cmdlet
Short-term backup retention
Simple Mail Transfer Protocol (SMTP)
Single database
Sizes, VM
account, port, and OS licensing
choices for Azure
CLI and ARM template
configuration options, deploying SQL Server
advanced
management
networking
OS disks
SQL Server settings
tags
deploying SQL Server on Linux
deployment
Dv2/Dv3
migration
portal navigation
RDP connection
reserved instances and dedicated hosts
size option, selection
SQL Server Containers, deploy
SQL Server Installation
SLA
SeeService-level agreement (SLA)
SMTP
SeeSimple Mail Transfer Protocol (SMTP)
Snapshot backups
Socrates
Software as a Service (SaaS)
Space management
Azure SQL Database
Azure SQL Managed Instance
Spark connector
sp_configure
Specific performance scenarios
BC HADR waits
hyperscale
log governance
worker limits
SQL Authentication
SQL Azure
logo
management portal
on Windows Azure (SAWA) project
SQL Database
SQL Database auditing
SQL Database Hyperscale
SQL data services (SDS)
SQL data sync
SQL elastic pools
SQL Information Protection policies
SQL injection
SQL on-demand
SQL Server 2019 Enterprise Windows Server 2019
SQL Server Agent
SQL Server Audit
SQL Server Containers
SQL Server Gallery Images
configuration choices
installation
SQL Server IaaS Agent Extension
SQL Server Integration Services (SSIS)
SQL Server License
SQL Server Management Studio (SSMS)
SQL Server on Azure Virtual Machines
SQL Server on Linux
SQL Server replication
SQL Server settings
authentication
automated backup
automated patching
Azure Key Vault integration
license
networking
storage configuration
storage optimization
SQL services
SQLSERVR.EXE instance
SQL Virtual Machine resource provider
SSMS
SeeSQL Server Management Studio (SSMS)
Stack dump
Stale page detection
Statistics, maintaining
Sterling
architecture
Azure SQL Database
v12
Storage configuration
Storage optimization
Storage performance
Stream analytics
Subscription offers
Subscriptions
Supporting Azure SQL
handling errors
stack dump
troubleshooting resources
UserVoice
Surface area, Azure SQL
cross-database queries
database mail
documentation references
DTC
external table
full-text search
linked servers
machine learning services
service broker
xp_cmdshell
sys.database_event_sessions
sys.databases
sys.dm_db_missing_index_details
sys.dm_operation_status
sys.filegroups
sys.sensitivity_classifications
System assigned managed identity
System center operations management (SCOM)
T
Tabular data stream (TDS)
Tags
TDE protector
Team foundation services (TFS)
Teledoc
Tempdb
Templates
Terms of use
TPS_TdService_session_control
Trace flags
Tracking logins
Transaction/snapshot replication system
Transparent data encryption (TDE)
Transparent Layer Security (TLS) protocol
Troubleshooter
Troubleshooting resources
T-SQL statements
U
Underlying hosting system
User accounts
UserVoice
V
v12
vCore model
Versionless
Versionless SQL Server
Virtual cluster
Virtual Machine (VM)
deploying
SeeDeployment, VM
overview screen
Visual Studio Code
VM generation
VNet2VNet gateway
VNet Peering
Vulnerability assessment
W
Waiting scenarios
query store
sys.dm_exec_requests
sys.dm_os_waiting_tasks
sys.dm_os_wait_stats
Wait types
Windows Azure admin portal
Windows Azure SQL Database
Windows Fabric
Windows server failover clustering (WSFC)
WinFab application
Worker limits
X, Y
XEvent
SeeExtended events (XEvent)
xp_cmdshell
Z
Zone redundancy