Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

by Gethyn Ellis
     
 

View All Available Formats & Editions

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 with this book and ebook.

Overview
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

See more details below

Overview

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 with this book and ebook.

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

What you will learn from this book

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
Approach

This is an easy-to-follow 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.

Read More

Product Details

ISBN-13:
9781782172413
Publisher:
Packt Publishing
Publication date:
04/25/2014
Pages:
106
Product dimensions:
7.50(w) x 9.25(h) x 0.22(d)
Age Range:
1 - 17 Years

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >