Getting started with SQL server 2014 administration : optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL server 2014

Description

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014About This Book Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology Implement the new InMemory OLTP database engine feature to enhance the performance of your transaction databases This is a handson tutorial that explores the new features of SQL Server 2014 along with giving real world examples Who This Book Is For 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. What You Will Learn Design a SQL Server infrastructure combining on-premise servers and Windows Azure Storage Create a backup strategy that allows you to store your SQL Server backup in the Windows Azure cloud Improve database performance by using the In-Memory OLTP features Implement the delayed durability feature to improve transaction latency Use a cloud-based replica to build an AlwaysOn Availability Group Learn the other enhancements and new features that can help improve database performance In Detail The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such as SQL Server 2014 have evolved to allow DBAs to utilize both services to maintain their key service level agreements, ensuring that their important databases are always available. SQL Server 2014 has a strong focus on business intelligence, making it a vital tool if you are looking to improve the performance of your processes as a relational database professional. Getting Started with SQL Server 2014 Administration will guide you through your first steps of learning SQL Server 2014 by introducing you to its new features and helping you create a hybrid environment, which is both highly available and allows you to get the best performance from your databases. This book is for anyone who wants to boost their database application performance to the next level. Content: Cover Copyright Credits About the Author About the Reviewers www.PacktPub.com Table of Contents Preface Chapter 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 StorageMicrosoft Azure Virtual Machines Creating a Microsoft Azure Virtual Machine Summary Chapter 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 backupSummary Chapter 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 Chapter 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 ProceduresDelayed 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 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 GroupTroubleshooting Availability Groups Creating a cloud-based AlwaysOn Availability Group Creating an AlwaysOn Availability Group in Microsoft Azure Creating a Hybrid Availability Group Summary Chapter 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.