Getting Started with SQL Server 2014 Administration电子书

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