Getting Started with SQL Server 2014 Administration


Getting Started with SQL Server 2014 Administration
eBook: $16.99
Formats: PDF, PacktLib, ePub and Mobi formats
$14.44
save 15%!
Print + free eBook + free PacktLib access to the book: $43.98    Print cover: $26.99
$26.99
save 39%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 106 pages [ 235mm x 191mm ]
Release Date : April 2014
ISBN : 1782172416
ISBN 13 : 9781782172413
Author(s) : Gethyn Ellis
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise, Microsoft SQL Server


Table of Contents

Preface
Chapter 1: SQL Server 2014 and Cloud
Chapter 2: Backup and Restore Improvements
Chapter 3: In-Memory Optimized Tables
Chapter 4: Delayed Durability
Chapter 5: AlwaysOn Availability Groups
Chapter 6: Performance Improvements
Index
  • 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 Storage
    • Microsoft 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 backup
    • Summary
  • 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 Procedures
    • 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
      • 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
  • 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

Gethyn Ellis

Gethyn Ellis is a SQL Server consultant and trainer with clients in Europe and North America. His client base includes both public and private sector clients that range from large financial firms to departments of the UK government. Specialized in database administration, virtualization, and performance, he has been involved in several large projects that involve migration of large SQL Server estates to the latest version of SQL Server and also migrated that infrastructure to a virtualized platform. He is also an instructor with Learning Tree and teaches several courses on the Learning Tree SQL Server curriculum. You can follow Gethyn's blog at www.gethynellis.com.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

Getting Started with SQL Server 2014 Administration +    Unity 4.x Game Development by Example: Beginner's Guide =
50% Off
the second eBook
Price for both: €23.00

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

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

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.

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.

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.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software