E-book details

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. Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014

Gethyn Ellis

Ebook
  • Getting Started with SQL Server 2014 Administration
    • Table of Contents
    • Getting Started with SQL Server 2014 Administration
    • Credits
    • About the Author
    • About the Reviewers
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
        • Why Subscribe?
        • Free Access for Packt account holders
        • Instant Updates on New Packt Books
    • Preface
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the example code
        • Errata
        • Piracy
        • Questions
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • Index
  • Title: 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
  • Author: Gethyn Ellis
  • Original title: 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
  • ISBN: 9781782172420, 9781782172420
  • Date of issue: 2014-04-25
  • Format: Ebook
  • Item ID: e_3cpn
  • Publisher: Packt Publishing