Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Professional Azure SQL Database Administration

You're reading from  Professional Azure SQL Database Administration

Product type Book
Published in Jul 2018
Publisher Packt
ISBN-13 9781789538854
Pages 398 pages
Edition 1st Edition
Languages
Author (1):
Ahmad Osama Ahmad Osama
Profile icon Ahmad Osama
Toc

Index

A

  • access control, Azure SQL Database security
    • about / Access Control
    • firewall rules / Firewall Rules
    • server level firewall rule / Firewall Rules
    • server level firewall rules, managing from Azure Web Portal / Managing the Server-Level Firewall Rules using the Azure Portal
    • server level firewall rules, managing from Transact SQL / Managing the Server-Level Firewall Rules using Transact-SQL
    • database level firewall rules, managing from Transact SQL / Managing Database-Level Firewall Rules using Transact-SQL
    • Authentication / Authentication
    • Authorization / Authorization
  • active geo-replication
    • about / Active Geo-Replication
    • database failover / Database Failover
    • configuring, for standalone Azure SQL Database / Configuring Active Geo-Replication and Performing a Manual Failover
    • configuring, for toystore database / Activity: Configure Active Geo-Replication
    • PowerShell script, executing / Executing the PowerShell Script
  • Add-AzureRmSqlDatabaseToFailoverGroup cmdlet
    • ResourceGroupName parameter / Activity: Configure Auto-Failover Groups
    • ServerName parameter / Activity: Configure Auto-Failover Groups
    • FailoverGroupName parameter / Activity: Configure Auto-Failover Groups
    • database object / Activity: Configure Auto-Failover Groups
  • alert rules
    • creating / Alert Rules
  • Application Cache
    • about / Horizontal Scaling
  • application user
    • about / Non-Administrative Users
  • appropriate Service tier
    • determining / Determining an Appropriate Service Tier
  • architecture, Azure SQL Database
    • about / Azure SQL Database Architecture
    • Client layer / Azure SQL Database Architecture
    • Service layer / Azure SQL Database Architecture
    • Platform layer / Azure SQL Database Architecture
    • Infrastructure layer / Azure SQL Database Architecture
  • architecture, elastic jobs
    • control database / Architecture
    • job service / Architecture
    • Azure Service Bus / Architecture
    • Azure Storage / Architecture
  • auditing
    • about / Auditing, Auditing
    • configuring, for Azure SQL Server / Configure Auditing for Azure SQL Server
  • Authentication
    • about / Authentication
    • SQL Server Authentication / Authentication
    • Azure Active Directory Authentication / Authentication
  • Authorization
    • about / Authorization
    • server level administrative roles / Server-Level Administrative Roles
    • non-administrative users / Non-Administrative Users
    • group users / Groups and Roles
    • roles / Groups and Roles
    • row-level security (RLS) / Row-Level Security
    • Dynamic Data Masking (DDM) / Dynamic Data Masking
  • Auto-Failover Groups
    • about / Auto-Failover Groups
    • terms / Auto-Failover Group Terms
    • databases, adding / Auto-Failover Group Terms
    • Read-Write Listener / Auto-Failover Group Terms
    • Read-Only Listener / Auto-Failover Group Terms
    • failover policy / Auto-Failover Group Terms
    • grace period with data loss hours / Auto-Failover Group Terms
    • friendly failover / Auto-Failover Group Terms
    • primary database service tier, upgrading / Auto-Failover Group Terms
    • configuring, for standalone Azure SQL Database / ConfiguringAuto-Failover Groupsconfiguring, for standalone Azure SQL Database the Auto-Failover Group
    • configuring, PowerShell used / Activity: Configure Auto-Failover Groups
    • PowerShell script, executing / Executing the PowerShell Script
  • automated backups, Azure SQL Database
    • about / Automatic Backups
    • backup storage / Backup Storage
    • retention period / Backup Retention Period
    • Recovery Service Vault, creating / Backup Retention Period
    • long-term backup retention, configuring / Configuring automated backups, Azure SQL Databaselong-term backup retention, configuringLong-Term Backup Retention for Azure SQL Database
  • automatic tuning, Azure SQL Database
    • about / Automatic Tuning
    • create index option / Create Index
    • drop indexes option / Drop Indexes
    • force last good plan / Force Last Good Plan
    • enabling / Force Last Good Plan
  • Azure Active Directory Authentication
    • about / Azure Active Directory Authentication
    • Azure Active Directory / Azure Active Directory
    • Active Directory - Password / Active Directory – Password
    • Azure Directory - Integrated method / Azure Directory – Integrated
    • Active Directory - Universal with MFA Support / Active Directory – Universal with MFA Support, Using Active Directory – Password to Authenticate to an Azure SQL Database
  • Azure Automation Account
    • creating / Activity: Creating Alerts
    • Runbook, adding / Activity: Creating Alerts
    • Runbook, configuring / Activity: Creating Alerts
  • Azure Fabric
    • about / Azure SQL Database Architecture
  • Azure profile details
    • saving, to file / Activity: Creating Shards
  • Azure SQL Database
    • architecture / Azure SQL Database Architecture
    • request flow / Azure SQL Database Request Flow
    • provisioning / Provisioning an Azure SQL Database
    • connecting, from Azure Portal / Connecting and Querying the SQL Database from the Azure Portal
    • querying, from Azure Portal / Connecting and Querying the SQL Database from the Azure Portal
    • connecting, from SQL Server Management Studio (SSMS) / Connecting and Querying the SQL Database from SQL Server Management Studio
    • querying, from SQL Server Management Studio (SSMS) / Connecting and Querying the SQL Database from SQL Server Management Studio
    • resources, deleting / Deleting Resources
    • versus, SQL Server / Differences between Azure SQL Database and SQL Server
    • features / Differences between Azure SQL Database and SQL Server
    • provisioning, with PowerShell / Provisioning Azure SQL Database
    • DTU Calculator workflow / Azure SQL Database DTU Calculator
    • restore types / Restore Types
    • deleted database, restoring / Restoring Deleted Databases
    • monitoring, Azure Web Portal used / Monitoring an Azure SQL Database using the Azure Portal
    • database metrics, monitoring with Azure Web Portal / Monitoring Database Metrics
    • monitoring, DMVs used / Monitoring an Azure SQL Database using DMVs
  • Azure SQL Database Authentication
    • structure / Azure SQL Database Authentication Structure
    • considerations / Azure SQL Database Authentication Considerations
  • Azure SQL Database monitoring, with DMVs
    • about / Monitoring an Azure SQL Database using DMVs
    • database metrics, monitoring / Monitoring Database Metrics
    • connections, monitoring / Monitoring Connections
    • query performance, monitoring / Monitoring Query Performance, sys.dm_exec_query_stats
    • blocking, monitoring / Monitoring Blocking
  • Azure SQL Database Service tiers
    • about / Azure SQL Database Service Tiers
    • Basic Service tier / Basic Service Tier
    • Standard Service tier / Standard Service Tier
    • Premium Service tier / Premium Service Tier
    • Premium RS Service tier / Premium RS Service Tier
    • scaling up, for better performance / Scaling upAzure SQL Database Service tiersscaling up, for better performance the Azure SQL Database Service Tier
    • Service tier, changing / Changing a Service Tier
  • Azure SQL Server
    • provisioning, with PowerShell / Activity: Provisioning Azure SQL Server and SQL Database using PowerShell

B

  • backup, Azure SQL Database
    • automated backups / Automatic Backups
    • manual backups / Manual Backups
  • backup and restore
    • about / Backup and Restore
  • BACPAC
    • about / DACPAC and BACPAC
    • reference link / DACPAC and BACPAC
  • Basic Service tier
    • about / Basic Service Tier
  • blocking
    • about / Monitoring Blocking
    • monitoring / Monitoring Blocking

C

  • Change Data Capture (CDC)
    • about / Change Data Capture
  • Client layer
    • about / Azure SQL Database Architecture
  • clustered column store indexes
    • about / Columnstore Indexes
  • Columnstore indexes
    • about / Columnstore Indexes
    • clustered columnstore indexes / Clustered Columnstore Index
    • non-clustered columnstore indexes / Non-Clustered Columnstore Index
  • compatibility issues
    • determining / Determining Compatibility Issues
  • components, Extended Events
    • session / Extended Events
    • events / Extended Events
    • event fields / Extended Events
    • Global Fields / Extended Events
    • target / Extended Events
  • connections
    • monitoring, with DMVs / Monitoring Connections
  • CreateSplitMergedatabase parameter
    • about / Activity: Split Data between Shard

D

  • DAC
    • about / DACPAC and BACPAC
  • DACPAC
    • about / DACPAC and BACPAC
    • reference link / DACPAC and BACPAC
  • database
    • importing / Importing a Database
  • Database-as-a-Service (DBaaS) / Azure SQL Database Architecture
  • Database Creators role
    • about / Database Creators
  • database level firewall rules
    • managing, from Transact SQL / Managing Database-Level Firewall Rules using Transact-SQL
  • database metrics
    • monitoring, with Azure Web Portal / Monitoring Database Metrics
    • alert rules, creating / Alert Rules
    • monitoring, with DMVs / Monitoring Database Metrics
  • database size
    • creating / Database Size
  • Database Transaction Unit
    • about / Azure SQL Database Service Tiers, Database Transaction Units
  • Data Dependent Routing
    • about / Data Dependent Routing
    • TKey / Data Dependent Routing
    • connectionString / Data Dependent Routing
    • ConnectionOptions / Data Dependent Routing
  • Data Migration Assistant (DMA)
    • about / Data Migration Assistant
  • deleted database
    • restoring / Restoring Deleted Databases
  • Deploy Database to Microsoft Azure SQL Database
    • about / SQL Server Management Studio
  • diagnostics settings
    • about / Diagnostic Settings
    • enabling / Diagnostic Settings
    • deleting / Diagnostic Settings
  • disaster recovery
    • about / Disaster Recovery
    • standard geo-replication / Standard Geo-Replication
    • active geo-replication / Active Geo-Replication
    • synchronous replication / Synchronous Replication
  • DMF (Dynamic Management Function) / Monitoring Connections
  • DTU (Database Throughput Unit) usage / Scale Up or Scale Down Service Tiers
  • DTU Calculator
    • URL / Azure SQL Database DTU Calculator
    • workflow / Azure SQL Database DTU Calculator, Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator
    • overall recommendation / Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator
    • recommendation based on CPU utilization / Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator
    • recommendation based on Iops utilization / Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator
    • recommendation based on log utilization / Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator
  • Dynamic Data Masking (DDM)
    • about / Dynamic Data Masking
    • implementing / Dynamic Data Masking, Activity: Implement Dynamic Data Masking
    • masks / Dynamic Data Masking
    • limitations / Dynamic Data Masking
  • Dynamic Management Views (DMVs)
    • sys.resource_stats / sys.resource_stats
    • sys.dm_db_resource_stats / sys.dm_db_resource_stats
    • used, for monitoring connections / Monitoring Connections
    • used, for monitoring query performance / Monitoring Query Performance, sys.dm_exec_query_stats

E

  • Elastic DB Tool scripts
    • about / Activity: Creating Shards
    • reference / Activity: Creating Shards
  • elastic jobs
    • about / Elastic Jobs
    • use cases / Use Cases
    • architecture / Architecture
    • workflow / Elastic Job Workflow
    • creating / Create an Elastic Job using the Azure Portal
  • elastic pools
    • about / Introducing Elastic Pools
    • considerations / When Should You Consider Elastic Pools?
    • sizing / Sizing an Elastic Pool
    • pricing, comparing / Comparing the Pricing
    • sizing best practices / Sizing Best Practices
    • creating / Createelastic poolscreating an Elastic Pool and Add Toystore Store Shards to the Elastic Pool
    • creating, PowerShell used / Activity: Exploring Elastic Pools
    • databases, adding with PowerShell / Activity: Exploring Elastic Pools
    • databases, deleting with PowerShell / Activity: Exploring Elastic Pools
  • elastic queries
    • used, for querying sharded tables / Activity: Using Elastic Queries
  • Export Data Tier Application
    • about / SQL Server Management Studio
  • Extended Event lists
    • about / Examining Queries
  • Extended Events
    • about / Extended Events
    • components / Extended Events
    • implementing / Examining Queries
  • Extended Events DMVs
    • about / Examining Queries

F

  • features, Azure SQL Database
    • backup and restore / Backup and Restore
    • recovery model / Recovery Model
    • SQL Server Agent / SQL Server Agent
    • Change Data Capture (CDC) / Change Data Capture
    • auditing / Auditing
    • mirroring / Mirroring
    • table partitioning / Table Partitioning
    • replication / Replication
    • multi-part names / Multi-Part Names
  • File Stream
    • about / File Stream

G

  • Geo-Restore
    • about / Geo-Restore Database
    • performing, PowerShell used / Activity: Perform Geo-Restore
  • Global Shard Maps (GSM)
    • about / Horizontal Scaling, Shard Map Manager
    • Shardmaps_global / Shard Map Manager
    • Shards_global / Shard Map Manager
    • Shard_mappings_global / Shard Map Manager
  • global temporary tables
    • about / Global Temporary Tables

H

  • hash indexes, memory-optimized table
    • about / Memory-Optimized Tables
  • high availability
    • about / High Availability
  • horizontal scaling
    • about / Horizontal Scaling

I

  • in-memory technologies
    • In-Memory OLTP / In-Memory OLTP
    • memory-optimized tables / Memory-Optimized Tables
    • natively compiled procedures / Natively Compiled Procedures
  • Infrastructure layer
    • about / Azure SQL Database Architecture
  • InterOP stored procedure / Natively Compiled Procedures

L

  • List Shard Map
    • about / Horizontal Scaling
  • Local Shard Maps (LSM)
    • about / Horizontal Scaling
  • local shard tables
    • reviewing / Activity: Using Elastic Queries
  • Login Manager role
    • about / Database Creators
  • log shipping
    • about / Log Shipping
  • long-term database restore
    • about / Long-Term Database Restore
    • performing, on Azure SQL Database / Long-Term Database Restore

M

  • Management Services
    • about / Azure SQL Database Architecture
  • manual backups, Azure SQL Database
    • about / Manual Backups
    • SSMS used / Backing up the manual backups, Azure SQL DatabaseSSMS usedAzure SQL Database using SSMS
    • DACPAC / DACPAC and BACPAC
    • BACPAC / DACPAC and BACPAC
    • versus, automated backups / Manual versus Automated Backups, Activity: Perform Back-ups
    • PowerShell used / Activity: Perform Back-ups
  • manual failover
    • performing / Configuring Active Geo-Replication and Performing a Manual Failover
  • masks, DDM
    • default / Dynamic Data Masking
    • email / Dynamic Data Masking
    • random / Dynamic Data Masking
    • custom string / Dynamic Data Masking
  • memory-optimized table
    • about / Memory-Optimized Tables
    • non-clustered indexes / Memory-Optimized Tables
    • hash indexes / Memory-Optimized Tables
    • versus, disk-based table / Activity: Explore the In-Memory OLTP Feature
  • migration method
    • determining / Determining the Migration Method
  • migration methodology
    • migration benefits, finding / Finding the Migration Benefits
    • blockers, finding / Finding the Blockers
    • service model, selecting / Selecting a Service Model
    • service tier, selecting / Selecting a Service Tier
    • main region and disaster recovery region, selecting / Selecting the Main and Disaster Recovery Region
    • migration tool, selecting / Selecting a Migration Tool
  • mirroring
    • about / Mirroring
  • monitoring options, Azure SQL Database
    • alert rules / Alert Rules
    • database size / Database Size
    • diagnostics settings / Diagnostic Settings
  • multi-part names
    • about / Multi-Part Names
  • multi-tenant data models
    • about / Multi-Tenant Data Models

N

  • New-AzureRMSqlDatabaseFailoverGroup cmdlet
    • ResourceGroupName parameter / Activity: Configure Auto-Failover Groups
    • ServerName parameter / Activity: Configure Auto-Failover Groups
    • PartnerServerName parameter / Activity: Configure Auto-Failover Groups
    • FailoverGroupName parameter / Activity: Configure Auto-Failover Groups
    • FailoverPolicy parameter / Activity: Configure Auto-Failover Groups
    • GracePeriodWithDataLossHours parameter / Activity: Configure Auto-Failover Groups
  • non-administrative users
    • about / Non-Administrative Users
    • application user / Non-Administrative Users
    • contained database users, creating / Creating Contained Database Users for Azure AD Authentication
  • non-clustered columnstore indexes
    • about / Non-Clustered Columnstore Index
  • non-clustered indexes, memory-optimized table
    • about / Memory-Optimized Tables

O

  • On-Premises SQL Server database
    • migrating, to Azure SQL Database / Migrating theOn-Premises SQL Server databasemigrating, to Azure SQL Database On-Premises SQL Server Database to Azure SQL Database
  • operating system (OS) / Azure SQL Database Architecture
  • OStress
    • using / Scaling upAzure SQL Database Service tiersscaling up, for better performance the Azure SQL Database Service Tier

P

  • performance tuning, Azure SQL Database
    • automatic tuning / Automatic Tuning
  • Platform-as-a-Service (PaaS) / Azure SQL Database Architecture
  • Platform layer
    • about / Azure SQL Database Architecture
  • Point-In-Time Restore (PITR)
    • about / Point-In-Time Restore
    • performing, on Azure SQL Database / Point-In-Time Restore
    • performing, PowerShell used / Activity: Perform PITR
  • PowerShell
    • used, for provisioning Azure SQL Server / Activity: Provisioning Azure SQL Server and SQL Database using PowerShell
    • used, for provisioning Azure SQL Database / Provisioning Azure SQL Database
    • used, for backing up Azure SQL Database / Activity: Perform Back-ups
  • PowerShell script
    • SqlServerName parameter / Activity: Creating Alerts
    • databaseName parameter / Activity: Creating Alerts
    • Edition parameter / Activity: Creating Alerts
    • PerfLevel parameterTopicnabout / Activity: Creating Alerts
    • Credential parameterTopicnabout / Activity: Creating Alerts
  • PowerShell Script
    • executing / Executing the PowerShell Script, Executing the PowerShell Script
  • Premium RS Service tier
    • about / Premium RS Service Tier
  • Premium Service tier
    • about / Premium Service Tier
  • proactive security
    • about / Proactive Security
    • auditing / Auditing
    • threat detection / Threat Detection

Q

  • query performance
    • monitoring / Monitoring Query Performance
  • Query Performance Insight
    • about / Query Performance Insight
    • using / Monitor Queries using the Query Performance Insight Blade

R

  • Recovery Point Objective (RPO) / Database Failover
  • Recovery Service Vault
    • about / Backup Retention Period
  • Reference Tables
    • about / Horizontal Scaling
  • Remove-AzureRmSqlDatabaseFailoverGroup
    • ResourceGroupName parameter / Activity: Configure Auto-Failover Groups
    • ServerName parameter / Activity: Configure Auto-Failover Groups
    • FailoverGroupName parameter / Activity: Configure Auto-Failover Groups
  • Remove-AzureRmSqlDatabaseSecondary cmdlet
    • using / Activity: Configure Active Geo-Replication
    • PartnerResourceGroupName parameter / Activity: Configure Active Geo-Replication
    • ServerName parameter / Activity: Configure Active Geo-Replication
    • PartnerServerName parameter / Activity: Configure Active Geo-Replication
  • replication
    • about / Replication
  • Resource Governor
    • about / Resource Governor
  • restore types, Azure SQL Database
    • Point-In-Time Restore (PITR) / Point-In-Time Restore
    • long-term database restore / Long-Term Database Restore
  • row-level security (RLS)
    • about / Row-Level Security
    • filter predicates / Row-Level Security
    • block predicates / Row-Level Security
    • implementing / Activity: Implement Row-Level Security
  • Runbook
    • about / Activity: Creating Alerts
    • creating / Activity: Creating Alerts
    • configuring / Activity: Creating Alerts
    • Webhook, creating / Activity: Creating Alerts

S

  • scaling, Azure SQL Database
    • vertical scaling / Vertical Scaling
    • horizontal scaling / Horizontal Scaling
  • security, Azure SQL Database
    • access control / Access Control
    • proactive security / Proactive Security
  • server level administrative roles
    • about / Server-Level Administrative Roles
    • Database Creators / Database Creators
    • Login Manager / Database Creators
  • server level firewall rules
    • managing, from Azure Web Portal / Managing the Server-Level Firewall Rules using the Azure Portal
    • managing, from Transact SQL / Managing the Server-Level Firewall Rules using Transact-SQL
  • Service layer
    • about / Azure SQL Database Architecture
  • service tier
    • changing, T-SQL used / UsingT-SQLused, for changing service tier T-SQL to Change the Service Tier
  • Set-AzureRmSqlDatabaseSecondary
    • using / Activity: Configure Active Geo-Replication
  • shard
    • about / Horizontal Scaling
  • shard-toystore.ps1 script
    • executing / Activity: Creating Shards
  • Shard2 parameter
    • about / Activity: Split Data between Shard
  • shard configuration
    • reviewing / Activity: Creating Shards
  • sharded tables
    • querying / Activity: Using Elastic Queries
  • sharding
    • about / Horizontal Scaling
  • sharding key
    • about / Horizontal Scaling
  • Shard Map Manager
    • about / Horizontal Scaling, Shard Map Manager
  • ShardMapManagerdatabaseName parameter
    • about / Activity: Split Data between Shard
  • ShardMapName parameter
    • about / Activity: Split Data between Shard
  • shard maps
    • about / Horizontal Scaling
    • List Shard Map / Horizontal Scaling
    • Range Shard Map / Horizontal Scaling
  • Shard Set
    • about / Horizontal Scaling
  • Shared database - Sharded model
    • about / Shared Database – Sharded
    • isolation / Shared Database – Sharded
    • maintenance / Shared Database – Sharded
    • cost / Shared Database – Sharded
    • DevOps / Shared Database – Sharded
    • business model / Shared Database – Sharded
  • single tenant model
    • about / Single Tenant (database-per-tenant)
  • sizing best practices, elastic pools
    • about / Sizing Best Practices
    • minimum number of databases / Sizing Best Practices
    • maximum number of concurrently peaking databases / Sizing Best Practices
    • DTU utilization per database / Sizing Best Practices
  • Split-Merge Cloud Service
    • deploying / Activity: Split Data between Shard
    • calling, PowerShell used / Activity: Split Data between Shard
    • PowerShell script, executing / Activity: Split Data between Shard
    • split operation, verifying / Activity: Split Data between Shard
  • split-merge tool
    • about / Activity: Split Data between Shard
  • SplitMergedatabase parameter
    • about / Activity: Split Data between Shard
  • SplitMergeServiceEndpoint parameter
    • about / Activity: Split Data between Shard
  • SplitRangeHigh parameter
    • about / Activity: Split Data between Shard
  • SplitRangeLow parameter
    • about / Activity: Split Data between Shard
  • SplitValue parameter
    • about / Activity: Split Data between Shard
  • SQL Azure Migration Wizard
    • about / SQL Azure Migration Wizard
  • SQL Browser Service
    • about / SQL Browser Service
  • SQL CLR
    • about / Common Language Runtime (SQL CLR)
  • SQLPackage.exe
    • about / SQLPackage.exe
  • SQL Server Agent
    • about / SQL Server Agent
  • SQL Server Authentication
    • about / SQL Authentication
  • SQL Server database
    • migrating, to Azure SQL Database / Migrating theOn-Premises SQL Server databasemigrating, to Azure SQL Database On-Premises SQL Server Database to Azure SQL Database
    • migrating, to Azure SQL Database with Data Migration Assistant / Activity: Using Data Migration Assistant
    • migrating, to Azure SQL Database with transactional replication / Activity: Performing Transactional Replication
  • SQL Server Data Tools (SSDT)
    • about / SQL Server Data Tools for Visual Studio
  • SQL Server Management Studio (SSMS)
    • about / SQL Server Management Studio
  • SQL Trace and Profiler
    • about / SQL Trace and Profiler
  • standard geo-replication
    • about / Standard Geo-Replication
    • database failover / Database Failover
  • Standard Service tier
    • about / Standard Service Tier
  • Switch-AzureRMSqlDatabaseFailoverGroup cmdlet
    • ResourceGroupName parameter / Activity: Configure Auto-Failover Groups
    • ServerName parameter / Activity: Configure Auto-Failover Groups
    • FailoverGroupName parameter / Activity: Configure Auto-Failover Groups
  • synchronous replication
    • about / Synchronous Replication
  • sys.dm_db_resource_stats
    • about / sys.dm_db_resource_stats
  • sys.dm_exec_query_stats / sys.dm_exec_query_stats
  • sys.resource_stats
    • about / sys.resource_stats
  • system stored procedures
    • about / System Stored Procedures

T

  • T-SQL
    • used, for changing service tier / UsingT-SQLused, for changing service tier T-SQL to Change the Service Tier
  • table partitioning
    • about / Table Partitioning
  • targets, Extended Events
    • Ring Buffer target / Extended Events
    • Event Counter / Extended Events
    • Event File Target / Extended Events
  • threat detection
    • about / Threat Detection
    • configuring, for Azure SQL Server / Configure Threat Detection for Azure SQL Server
  • tools, for detecting compatibility issues
    • about / Determining Compatibility Issues
    • Data Migration Assistant (DMA) / Data Migration Assistant
    • SSDT / SQL Server Data Tools for Visual Studio
    • SSMS / SQL Server Management Studio
    • SQLPackage.exe / SQLPackage.exe
  • toystore database
    • sharding / Activity: Creating Shards
    • shard-toystore.ps1 script, executing / Activity: Creating Shards
    • shard configuration, reviewing / Activity: Creating Shards
  • toystorejobs Automation account
    • creating / Activity: Creating Alerts
    • Runbook, adding / Activity: Creating Alerts
    • Credential asset, creating / Activity: Creating Alerts
    • alert, adding / Activity: Creating Alerts
  • Trace Flags
    • about / Trace Flags

U

  • unsupported features, Azure SQL Database
    • SQL Browser Service / SQL Browser Service
    • File Stream / File Stream
    • SQL CLR / Common Language Runtime (SQL CLR)
    • Resource Governor / Resource Governor
    • global temporary tables / Global Temporary Tables
    • log shipping / Log Shipping
    • SQL Trace and Profiler / SQL Trace and Profiler
    • Trace Flags / Trace Flags
    • system stored procedures / System Stored Procedures
    • USE statement / USE Statement
  • USE statement
    • about / USE Statement

V

  • vertical partitioning
    • about / Vertical Partitioning
    • benefits / Vertical Partitioning
  • vertical scaling
    • about / Vertical Scaling
    • service tier, scaling up / Scale Up or Scale Down Service Tiers
    • service tier, scaling down / Scale Up or Scale Down Service Tiers

W

  • Webhook
    • creating, for starting Runbook / Activity: Creating Alerts
lock icon The rest of the chapter is locked
arrow left Previous Section
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}