Index
A
- ACID (Atomic Consistent Independent and Durable)
- about / Memory-optimized tables
- AlwaysOn Availability Group
- creating, in Windows Azure / Creating an AlwaysOn Availability Group in Microsoft Azure
- AlwaysOn Availability Groups
- about / Introducing AlwaysOn Availability Groups
- enhancements / Enhancements in AlwaysOn Availability Groups
- creating / Building AlwaysOn Availability Groups
- prerequisites / Building AlwaysOn Availability Groups
- asynchronous commit mode / The commit mode
- Availability Group
- creating / Creating Availability Group
- troubleshooting / Troubleshooting Availability Groups
- Availability Group listener
- about / The Availability Group listener
B
- buffer pool extensions
- about / Buffer pool extensions
- using / Buffer pool extensions
C
- cardinality estimator
- about / Cardinality estimator and query plans
- used, for improving query plans / Cardinality estimator and query plans
- certificate/asymmetric key
- creating / Creating a certificate or asymmetric key
- cloud-based AlwaysOn Availability Group
- clustered columnstore index
- creating / Creating a clustered columnstore index
- table, updating / Updating a table with a clustered columnstore index
- CodePlex
- columnstore index
- about / Columnstore indexes
- benefits / Columnstore indexes
- clustered columnstore index / Creating a clustered columnstore index, Updating a table with a clustered columnstore index
- commit mode
- about / The commit mode
- asynchronous commit mode / The commit mode
- synchronous commit mode / The commit mode
- concurrency control
- about / Concurrency
- Pessimistic concurrency control / Concurrency
- Optimistic concurrency control / Concurrency
- concurrency terminologies
- Dirty reads / Some concurrency terminologies
- Non-repeatable reads / Some concurrency terminologies
- Phantom reads / Some concurrency terminologies
- Control Transaction Durability
- credential, Windows Azure Storage
- creating / Creating a credential
D
- database
- migrating, to Windows Azure SQL Database / Migrating an existing database to Microsoft Azure
- creating, for Windows Azure Storage / Creating a database that uses the Microsoft Azure Storage integration
- creating, Windows Azure Storage used / Creating a database using Microsoft Azure Storage
- backing up, to URL / Database backups to a URL and Microsoft Azure Storage
- database backup
- restoring, on Windows Azure Storage / Restoring a backup stored on Windows Azure Storage
- database backup, URL
- limitations / Database backups to a URL and Microsoft Azure Storage
- database master key
- creating, for master database / Creating a database master key for the master database
- Delayed Durability
- about / Understanding the delayed transaction durability
- versus Full Durability / Full Durability versus Delayed Durability
- using / Using delayed transaction durability
- transaction level (Transact-SQL) / Transaction level Delayed Durability – Transact-SQL
- natively compiled stored procedures / Delayed Durability and Natively Compiled Stored Procedures
- transaction log flush / Delayed Durability and transaction log flush
- potential data loss / Delayed Durability and potential data loss
- and other SQL Server components / Delayed Durability and other SQL Server components
- Disaster Recovery (DR)
E
- encrypted backup
- creating / Creating an encrypted backup
- database master key, creating / Creating a database master key for the master database
- certificate/asymmetric key, creating / Creating a certificate or asymmetric key
- encrypted database backup, creating / Creating an encrypted database backup
- encrypted database backup
- creating / Creating an encrypted database backup
- encryption
- about / Encryption
- enhancements, AlwaysOn Availability Groups
- Windows Azure Replica / Enhancements in AlwaysOn Availability Groups
F
- full transaction durability
- about / Understanding the full transaction durability
- versus Delayed Durability / Full Durability versus Delayed Durability
G
- geo-replication / Creating a Microsoft Azure Storage account and container
H
- hash indexes
- about / Memory-optimized tables and indexes
- hash bucket / Memory-optimized tables and indexes
- heap
- High Availability (HA)
- Hybrid Availability Group
- creating / Creating a Hybrid Availability Group
I
- In-Memory Optimized tables
- using, requirements / Requirements
- virtualized environments / Virtualized environments
- Infrastructure as a Service (IaaS) / Creating an AlwaysOn Availability Group in Microsoft Azure
- instance service
- configuring / Configuring the instance service
M
- Managed Backup
- about / SQL Server Managed Backup to Microsoft Azure
- configuring, in SQL Server 2014 / Configuring SQL Server-managed backups to Microsoft Azure
- Managed Backup, SQL Server
- setting up, to Windows Azure / SQL Server Managed Backup to Microsoft Azure, Configuring SQL Server-managed backups to Microsoft Azure
- Management Studio
- used, for conneting Windows Azure SQL Database / Connecting to a Windows Azure SQL database with Management Studio
- about / Connecting to a Windows Azure SQL database with Management Studio
- memory-optimized tables
- about / Memory-optimized tables
- data types, supported in / Memory-optimized tables
- limitations / Memory-optimized tables
- indexes, supported in / Memory-optimized tables and indexes
- hash indexes / Memory-optimized tables and indexes
- natively compiled stored procedures / Transact-SQL and natively compiled stored procedures
- concurrency / Concurrency, Some concurrency terminologies
N
- natively compiled stored procedures
- about / Transact-SQL and natively compiled stored procedures
- using / Transact-SQL and natively compiled stored procedures
- and Delayed Durability / Delayed Durability and Natively Compiled Stored Procedures
- Node Majority quorum model / Creating a Hybrid Availability Group
- non-clustered hash indexes / Memory-optimized tables and indexes
- non-clustered indexes / Memory-optimized tables and indexes
O
- Object Explorer / Creating Availability Group, Troubleshooting Availability Groups
- OLTP
- about / Memory-optimized tables
P
- potential data loss
- and Delayed Durability / Delayed Durability and potential data loss
- prerequisites, AlwaysOn Availability Groups
- Windows Server Failover Cluster / Windows Server Failover Cluster
- instance service, configuring / Configuring the instance service
- Availability Group listener / The Availability Group listener
Q
- query plans
- improving, cardinality estimator used / Cardinality estimator and query plans
R
- replicas
- Windows Azure Virtual Machines, using as / Using Microsoft Azure Virtual Machines as replicas
- requirements
- for using, In-Memory Optimized tables / Requirements
- Resource Governor
- about / Resource Governor
S
- secondary replicas
- administering on / Reporting and administrating on secondary replicas
- reporting on / Reporting and administrating on secondary replicas
- Shared Access Signature (SAS) / Creating a database that uses the Microsoft Azure Storage integration
- SQL Server 2014
- Managed Backup, configuring in / Configuring SQL Server-managed backups to Microsoft Azure
- SQL Server components
- Delayed Durability, integrating with / Delayed Durability and other SQL Server components
- SQL Server database
- backing up, to URL / Backing up a SQL Server database to a URL
- SSD
- about / Buffer pool extensions
- statistics
- about / Statistics
- synchronous commit mode / The commit mode
- sys.fn_hadr_is_primary_replica function / Enhancements in AlwaysOn Availability Groups, Troubleshooting Availability Groups
T
- Transact-SQL
- Delayed Durability / Transaction level Delayed Durability – Transact-SQL
- transaction isolation levels
- read uncommitted / Some concurrency terminologies
- read committed / Some concurrency terminologies
- repeatable read / Some concurrency terminologies
- snapshot / Some concurrency terminologies
- serializable / Some concurrency terminologies
- transaction log flush
- and Delayed Durability / Delayed Durability and transaction log flush
- troubleshooting
- Availability Groups / Troubleshooting Availability Groups
U
- Uniform Resource Identifer (URI)
- about / Creating a credential
- Uniform Resource Identifier (URI) / Database backups to a URL and Microsoft Azure Storage
- URL
- database backup, creating to / Database backups to a URL and Microsoft Azure Storage
- SQL Server database, backing up to / Backing up a SQL Server database to a URL
W
- Windows Azure
- URL / Creating a Windows Azure SQL database
- SQL Server Managed Backups, configuring to / Configuring SQL Server-managed backups to Microsoft Azure, Encryption
- AlwaysOn Availability Group, creating in / Creating an AlwaysOn Availability Group in Microsoft Azure
- Windows Azure Replica
- Windows Azure SQL Database
- about / Windows Azure SQL Database
- creating / Creating a Windows Azure SQL database
- conneting, with Management Studio / Connecting to a Windows Azure SQL database with Management Studio
- existing database, migrating to / Migrating an existing database to Microsoft Azure
- Windows Azure Storage
- about / Integrating Microsoft Azure Storage
- benefits / Integrating Microsoft Azure Storage
- database, creating / Creating a database that uses the Microsoft Azure Storage integration
- container policy / The container policy and Shared Access Signature
- Shared Access Signature (SAS), creating / The container policy and Shared Access Signature
- credential, creating / Creating a credential
- used, for creating database / Creating a database using Microsoft Azure Storage
- database backup, creating to / Database backups to a URL and Microsoft Azure Storage
- backup, restoring on / Restoring a backup stored on Windows Azure Storage
- Windows Azure Storage account
- Windows Azure Storage container
- Windows Azure virtual machine
- about / Microsoft Azure Virtual Machines
- creating / Creating a Microsoft Azure Virtual Machine
- Windows Azure Virtual Machines
- using, as replicas / Using Microsoft Azure Virtual Machines as replicas
- Windows Server Failover Cluster
- Windows Server Failover Cluster (WSFC)
- about / Windows Server Failover Cluster