PacktLib: Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

SQL Server 2014 and Cloud

Windows Azure SQL Database

Integrating Microsoft Azure Storage

Microsoft Azure Virtual Machines

Summary

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

In-Memory Optimized Tables

Requirements

Virtualized environments

Memory-optimized tables

Summary

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

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

Performance Improvements

Partition switching and indexing

Columnstore indexes

Buffer pool extensions

Cardinality estimator and query plans

Statistics

Resource Governor

Summary

Index