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

Getting Started with SQL Server 2014 Administration

Starting
Gethyn Ellis

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014
$10.00
$26.99
RRP $16.99
RRP $26.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781782172413
Paperback106 pages

About 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.

Table of Contents

Chapter 1: SQL Server 2014 and Cloud
Windows Azure SQL Database
Integrating Microsoft Azure Storage
Microsoft Azure Virtual Machines
Summary
Chapter 2: 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
Chapter 3: In-Memory Optimized Tables
Requirements
Virtualized environments
Memory-optimized tables
Summary
Chapter 4: 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
Chapter 5: 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
Chapter 6: Performance Improvements
Partition switching and indexing
Columnstore indexes
Buffer pool extensions
Cardinality estimator and query plans
Statistics
Resource Governor
Summary

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.

Authors

Table of Contents

Chapter 1: SQL Server 2014 and Cloud
Windows Azure SQL Database
Integrating Microsoft Azure Storage
Microsoft Azure Virtual Machines
Summary
Chapter 2: 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
Chapter 3: In-Memory Optimized Tables
Requirements
Virtualized environments
Memory-optimized tables
Summary
Chapter 4: 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
Chapter 5: 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
Chapter 6: Performance Improvements
Partition switching and indexing
Columnstore indexes
Buffer pool extensions
Cardinality estimator and query plans
Statistics
Resource Governor
Summary

Book Details

ISBN 139781782172413
Paperback106 pages
Read More