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

Gethyn Ellis

1 customer reviews
Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014
Mapt Subscription
FREE
$29.99/m after trial
eBook
$11.90
RRP $16.99
Save 29%
Print + eBook
$26.99
RRP $26.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$11.90
$26.99
$29.99p/m after trial
RRP $16.99
RRP $26.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781782172413
Paperback106 pages

Book Description

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.

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

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
From 1 reviews

Read More Reviews

Recommended for You

SQL Server 2012 with PowerShell V3 Cookbook Book Cover
SQL Server 2012 with PowerShell V3 Cookbook
$ 35.99
$ 25.20
Microsoft SQL Server 2012 Performance Tuning Cookbook Book Cover
Microsoft SQL Server 2012 Performance Tuning Cookbook
$ 35.99
$ 25.20
Instant MDX Queries for SQL Server 2012 Book Cover
Instant MDX Queries for SQL Server 2012
$ 19.99
$ 14.00
Mastering Web Application Development with AngularJS Book Cover
Mastering Web Application Development with AngularJS
$ 26.99
$ 5.40
Windows Server 2012 Automation with PowerShell Cookbook Book Cover
Windows Server 2012 Automation with PowerShell Cookbook
$ 32.99
$ 23.10
Hadoop Beginner's Guide Book Cover
Hadoop Beginner's Guide
$ 29.99
$ 21.00