Cargando…
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 /
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. T...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, UK :
Packt Publishing,
[2014]
|
| Colección: | Professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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 StorageMicrosoft 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 backupSummary; 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 ProceduresDelayed 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 GroupTroubleshooting 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; Index.