Franklin

Getting Started with SQL Server 2014 Administration.

Author/Creator:
Ellis, Gethyn.
Publication:
Olton Birmingham : Packt Publishing, Limited, 2014.
Format/Description:
Book
1 online resource (124 pages)
Status/Location:
Loading...

Options
Location Notes Your Loan Policy

Details

Other records:
Subjects:
SQL (Computer program language) -- Programming.
Database management -- Computer programs.
Form/Genre:
Electronic books.
Summary:
This is an easytofollow 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.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.
Contents:
Intro
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.
Notes:
Description based on publisher supplied metadata and other sources.
Local notes:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2021. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Other format:
Print version: Ellis, Gethyn Getting Started with SQL Server 2014 Administration
ISBN:
9781782172420
9781782172413
OCLC:
879474271