O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Getting Started with SQL Server 2014 Administration

Book Description

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

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

  • 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

Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Table of Contents

  1. Getting Started with SQL Server 2014 Administration
    1. Table of Contents
    2. Getting Started with SQL Server 2014 Administration
    3. Credits
    4. About the Author
    5. About the Reviewers
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
        3. Instant Updates on New Packt Books
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    8. 1. SQL Server 2014 and Cloud
      1. Windows Azure SQL Database
        1. Creating a Windows Azure SQL database
        2. Connecting to a Windows Azure SQL database with Management Studio
        3. Migrating an existing database to Microsoft Azure
      2. Integrating Microsoft Azure Storage
        1. Creating a database that uses the Microsoft Azure Storage integration
          1. Creating a Microsoft Azure Storage account and container
          2. The container policy and Shared Access Signature
          3. Creating a credential
          4. Creating a database using Microsoft Azure Storage
      3. Microsoft Azure Virtual Machines
        1. Creating a Microsoft Azure Virtual Machine
      4. Summary
    9. 2. Backup and Restore Improvements
      1. Database backups to a URL and Microsoft Azure Storage
        1. Backing up a SQL Server database to a URL
      2. Restoring a backup stored on Windows Azure Storage
      3. SQL Server Managed Backup to Microsoft Azure
        1. Configuring SQL Server-managed backups to Microsoft Azure
      4. Encryption
        1. Creating an encrypted backup
          1. Creating a database master key for the master database
          2. Creating a certificate or asymmetric key
          3. Creating an encrypted database backup
      5. Summary
    10. 3. In-Memory Optimized Tables
      1. Requirements
      2. Virtualized environments
      3. Memory-optimized tables
        1. Memory-optimized tables and indexes
        2. Transact-SQL and natively compiled stored procedures
        3. Concurrency
          1. Some concurrency terminologies
      4. Summary
    11. 4. Delayed Durability
      1. Understanding the full transaction durability
      2. Understanding the delayed transaction durability
      3. Full Durability versus Delayed Durability
      4. Using delayed transaction durability
        1. Transaction level Delayed Durability – Transact-SQL
        2. Delayed Durability and Natively Compiled Stored Procedures
      5. Delayed Durability and transaction log flush
      6. Delayed Durability and potential data loss
      7. Delayed Durability and other SQL Server components
      8. Summary
    12. 5. AlwaysOn Availability Groups
      1. Introducing AlwaysOn Availability Groups
      2. Enhancements in AlwaysOn Availability Groups
      3. Using Microsoft Azure Virtual Machines as replicas
        1. The commit mode
        2. Reporting and administrating on secondary replicas
      4. Building AlwaysOn Availability Groups
        1. Windows Server Failover Cluster
        2. Configuring the instance service
        3. The Availability Group listener
      5. Creating Availability Group
      6. Troubleshooting Availability Groups
      7. Creating a cloud-based AlwaysOn Availability Group
        1. Creating an AlwaysOn Availability Group in Microsoft Azure
        2. Creating a Hybrid Availability Group
      8. Summary
    13. 6. Performance Improvements
      1. Partition switching and indexing
      2. Columnstore indexes
        1. Creating a clustered columnstore index
        2. Updating a table with a clustered columnstore index
      3. Buffer pool extensions
      4. Cardinality estimator and query plans
      5. Statistics
      6. Resource Governor
      7. Summary
    14. Index