LEADER 05352nam 2200649 450 001 9910464411903321 005 20200520144314.0 010 $a1-78217-242-4 035 $a(CKB)3710000000107503 035 $a(EBL)1685898 035 $a(SSID)ssj0001215651 035 $a(PQKBManifestationID)11783467 035 $a(PQKBTitleCode)TC0001215651 035 $a(PQKBWorkID)11178178 035 $a(PQKB)11508736 035 $a(MiAaPQ)EBC1685898 035 $a(PPN)228029236 035 $a(Au-PeEL)EBL1685898 035 $a(CaPaEBR)ebr10868165 035 $a(CaONFJC)MIL610905 035 $a(OCoLC)879474271 035 $a(EXLCZ)993710000000107503 100 $a20140519h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aGetting started with SQL server 2014 administration $eoptimize your database server to be fast, efficient, and highly secure using the brand new features of SQL server 2014 /$fGethyn Ellis ; cover image by Karl Moore 210 1$aBirmingham, England :$cPackt Publishing,$d2014. 210 4$dİ2014 215 $a1 online resource (106 p.) 225 1 $aProfessional expertise distilled 300 $aIncludes index. 300 $a"Professional Expertise Distilled." 311 $a1-78217-241-6 327 $aCover; 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 327 $aCreating 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 327 $aCreating 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 327 $aDelayed 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 327 $aCreating 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 330 $aThis 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. 606 $aSQL (Computer program language)$xProgramming 606 $aDatabase management$xComputer programs 608 $aElectronic books. 615 0$aSQL (Computer program language)$xProgramming. 615 0$aDatabase management$xComputer programs. 676 $a005.756 700 $aEllis$b Gethyn$0944096 702 $aMoore$b Karl$f1955- 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910464411903321 996 $aGetting started with SQL server 2014 administration$92131101 997 $aUNINA