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
  • creating / Creating a 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
  • URL / The container policy and Shared Access Signature
• 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
  • URL / Full Durability versus Delayed 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)
  • about / Integrating Microsoft Azure Storage

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
  • about / Memory-optimized tables and indexes
• High Availability (HA)
  • about / Integrating Microsoft Azure Storage
• 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
  • creating / The container policy and Shared Access Signature
• 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
  • about / Enhancements in AlwaysOn Availability Groups
• 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
  • creating / Creating a Microsoft Azure Storage account and container
• Windows Azure Storage container
  • creating / Creating a Microsoft Azure Storage account and 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
  • URL / Windows Server Failover Cluster
• Windows Server Failover Cluster (WSFC)
  • about / Windows Server Failover Cluster