Windows Azure SQL Database
Integrating Microsoft Azure Storage
Microsoft Azure Virtual Machines
Summary
Chapter 2: Backup and Restore Improvements
Database backups to a URL and Microsoft Azure Storage
Restoring a backup stored on Windows Azure Storage
SQL Server Managed Backup to Microsoft Azure
Encryption
Summary
Chapter 3: In-Memory Optimized Tables
Requirements
Virtualized environments
Memory-optimized tables
Summary
Chapter 4: Delayed Durability
Understanding the full transaction durability
Understanding the delayed transaction durability
Full Durability versus Delayed Durability
Using delayed transaction durability
Delayed Durability and transaction log flush
Delayed Durability and potential data loss
Delayed Durability and other SQL Server components
Summary
Chapter 5: AlwaysOn Availability Groups
Introducing AlwaysOn Availability Groups
Enhancements in AlwaysOn Availability Groups
Using Microsoft Azure Virtual Machines as replicas
Building AlwaysOn Availability Groups
Creating Availability Group
Troubleshooting Availability Groups
Creating a cloud-based AlwaysOn Availability Group
Summary
Chapter 6: Performance Improvements
Partition switching and indexing
Columnstore indexes
Buffer pool extensions
Cardinality estimator and query plans
Statistics
Resource Governor
Summary
Index