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 /: optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL server 2014. ([2014])

• Record Type: Book
• Further Information: Note: [compiled by] Gethyn Ellis.
• Other Names: Ellis, Gethyn compiler.
• Contents: 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.
• Publisher Details: Birmingham, UK : Packt Publishing
• Publication Date: 2014
• Extent: 1 online resource
• Subjects: 005.75/6; COMPUTERS -- Enterprise Applications -- Business Intelligence Tools; SQL (Computer program language); COMPUTERS -- Programming Languages -- SQL; SQL (Computer program language); COMPUTERS -- Databases -- Servers; Electronic books
• Languages: English
• ISBNs: 9781782172420; 1782172424; 1782172416; 9781782172413
• Related ISBNs: 9781782172413
• Notes: Note: PDF title page (viewed May 9, 2014).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.