Index
A
- access control, Azure SQL Database security
- active geo-replication
- Add-AzureRmSqlDatabaseToFailoverGroup cmdlet
- alert rules
- Application Cache
- application user
- appropriate Service tier
- architecture, Azure SQL Database
- architecture, elastic jobs
- auditing
- Authentication
- Authorization
- Auto-Failover Groups
- automated backups, Azure SQL Database
- automatic tuning, Azure SQL Database
- Azure Active Directory Authentication
- Azure Automation Account
- Azure Fabric
- Azure profile details
- 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
- Azure SQL Database monitoring, with DMVs
- Azure SQL Database Service tiers
- Azure SQL Server
B
- backup, Azure SQL Database
- backup and restore
- BACPAC
- Basic Service tier
- blocking
C
- Change Data Capture (CDC)
- Client layer
- clustered column store indexes
- Columnstore indexes
- compatibility issues
- components, Extended Events
- connections
- CreateSplitMergedatabase parameter
D
- DAC
- DACPAC
- database
- Database-as-a-Service (DBaaS) / Azure SQL Database Architecture
- Database Creators role
- database level firewall rules
- database metrics
- database size
- Database Transaction Unit
- Data Dependent Routing
- Data Migration Assistant (DMA)
- deleted database
- Deploy Database to Microsoft Azure SQL Database
- diagnostics settings
- disaster recovery
- DMF (Dynamic Management Function) / Monitoring Connections
- DTU (Database Throughput Unit) usage / Scale Up or Scale Down Service Tiers
- DTU Calculator
- Dynamic Data Masking (DDM)
- Dynamic Management Views (DMVs)
E
- Elastic DB Tool scripts
- elastic jobs
- elastic pools
- elastic queries
- Export Data Tier Application
- Extended Event lists
- Extended Events
- Extended Events DMVs
F
- features, Azure SQL Database
- File Stream
G
- Geo-Restore
- Global Shard Maps (GSM)
- global temporary tables
H
- hash indexes, memory-optimized table
- high availability
- horizontal scaling
I
L
- List Shard Map
- Local Shard Maps (LSM)
- local shard tables
- Login Manager role
- log shipping
- long-term database restore
M
- Management Services
- manual backups, Azure SQL Database
- manual failover
- masks, DDM
- memory-optimized table
- migration method
- migration methodology
- mirroring
- monitoring options, Azure SQL Database
- multi-part names
- multi-tenant data models
N
- New-AzureRMSqlDatabaseFailoverGroup cmdlet
- non-administrative users
- non-clustered columnstore indexes
- non-clustered indexes, memory-optimized table
O
P
- performance tuning, Azure SQL Database
- Platform-as-a-Service (PaaS) / Azure SQL Database Architecture
- Platform layer
- Point-In-Time Restore (PITR)
- PowerShell
- PowerShell script
- PowerShell Script
- Premium RS Service tier
- Premium Service tier
- proactive security
Q
- query performance
- Query Performance Insight
R
- Recovery Point Objective (RPO) / Database Failover
- Recovery Service Vault
- Reference Tables
- Remove-AzureRmSqlDatabaseFailoverGroup
- Remove-AzureRmSqlDatabaseSecondary cmdlet
- replication
- Resource Governor
- restore types, Azure SQL Database
- row-level security (RLS)
- Runbook
S
- scaling, Azure SQL Database
- security, Azure SQL Database
- server level administrative roles
- server level firewall rules
- Service layer
- service tier
- Set-AzureRmSqlDatabaseSecondary
- shard
- shard-toystore.ps1 script
- Shard2 parameter
- shard configuration
- sharded tables
- sharding
- sharding key
- Shard Map Manager
- ShardMapManagerdatabaseName parameter
- ShardMapName parameter
- shard maps
- Shard Set
- Shared database - Sharded model
- single tenant model
- sizing best practices, elastic pools
- Split-Merge Cloud Service
- split-merge tool
- SplitMergedatabase parameter
- SplitMergeServiceEndpoint parameter
- SplitRangeHigh parameter
- SplitRangeLow parameter
- SplitValue parameter
- SQL Azure Migration Wizard
- SQL Browser Service
- SQL CLR
- SQLPackage.exe
- SQL Server Agent
- SQL Server Authentication
- SQL Server database
- SQL Server Data Tools (SSDT)
- SQL Server Management Studio (SSMS)
- SQL Trace and Profiler
- standard geo-replication
- Standard Service tier
- Switch-AzureRMSqlDatabaseFailoverGroup cmdlet
- synchronous replication
- sys.dm_db_resource_stats
- sys.dm_exec_query_stats / sys.dm_exec_query_stats
- sys.resource_stats
- system stored procedures
T
- T-SQL
- table partitioning
- targets, Extended Events
- threat detection
- tools, for detecting compatibility issues
- toystore database
- toystorejobs Automation account
- Trace Flags
U
- unsupported features, Azure SQL Database
- USE statement
V
- vertical partitioning
- vertical scaling
W
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.