Getting Started with SQL Server 2014 Administration -- Table of Contents -- Getting Started with SQL Server 2014 Administration -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. SQL Server 2014 and Cloud -- Windows Azure SQL Database -- Creating a Windows Azure SQL database -- Connecting to a Windows Azure SQL database with Management Studio -- Migrating an existing database to Microsoft Azure -- Integrating Microsoft Azure Storage -- Creating a database that uses the Microsoft Azure Storage integration -- Creating a Microsoft Azure Storage account and container -- The container policy and Shared Access Signature -- Creating a credential -- Creating a database using Microsoft Azure Storage -- Microsoft Azure Virtual Machines -- Creating a Microsoft Azure Virtual Machine -- Summary -- 2. Backup and Restore Improvements -- Database backups to a URL and Microsoft Azure Storage -- Backing up a SQL Server database to a URL -- Restoring a backup stored on Windows Azure Storage -- SQL Server Managed Backup to Microsoft Azure -- Configuring SQL Server-managed backups to Microsoft Azure -- Encryption -- Creating an encrypted backup -- Creating a database master key for the master database -- Creating a certificate or asymmetric key -- Creating an encrypted database backup -- Summary -- 3. In-Memory Optimized Tables -- Requirements -- Virtualized environments -- Memory-optimized tables -- Memory-optimized tables and indexes.

Transact-SQL and natively compiled stored procedures -- Concurrency -- Some concurrency terminologies -- Summary -- 4. Delayed Durability -- Understanding the full transaction durability -- Understanding the delayed transaction durability -- Full Durability versus Delayed Durability -- Using delayed transaction durability -- Transaction level Delayed Durability - Transact-SQL -- Delayed Durability and Natively Compiled Stored Procedures -- Delayed Durability and transaction log flush -- Delayed Durability and potential data loss -- Delayed Durability and other SQL Server components -- Summary -- 5. AlwaysOn Availability Groups -- Introducing AlwaysOn Availability Groups -- Enhancements in AlwaysOn Availability Groups -- Using Microsoft Azure Virtual Machines as replicas -- The commit mode -- Reporting and administrating on secondary replicas -- Building AlwaysOn Availability Groups -- Windows Server Failover Cluster -- Configuring the instance service -- The Availability Group listener -- Creating Availability Group -- Troubleshooting Availability Groups -- Creating a cloud-based AlwaysOn Availability Group -- Creating an AlwaysOn Availability Group in Microsoft Azure -- Creating a Hybrid Availability Group -- Summary -- 6. Performance Improvements -- Partition switching and indexing -- Columnstore indexes -- Creating a clustered columnstore index -- Updating a table with a clustered columnstore index -- Buffer pool extensions -- Cardinality estimator and query plans -- Statistics -- Resource Governor -- Summary -- Index.