This is an easytofollow handson tutorial that includes real world examples of SQL Server 2014's new features. Each chapter is explained in a stepbystep manner which guides you to implement the new technology.If you want to create an highly efficient database server then this book is for you. This book is for database professionals and system administrators who want to use the added features of SQL Server 2014 to create a hybrid environment, which is both highly available and allows you to get the best performance from your databases.
Intro 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.
Description based on publisher supplied metadata and other sources.
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Print version: Ellis, Gethyn Getting Started with SQL Server 2014 Administration