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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Otros Autores: Ellis, Gethyn (Compilador)
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

MARC

LEADER 00000cam a2200000 i 4500
001 EBOOKCENTRAL_ocn879474271
003 OCoLC
005 20240329122006.0
006 m o d
007 cr cnu---unuuu
008 140509s2014 enk o 000 0 eng d
040 |a N$T  |b eng  |e rda  |e pn  |c N$T  |d E7B  |d UMI  |d DEBBG  |d DEBSZ  |d COO  |d YDXCP  |d EBLCP  |d MHW  |d IDEBK  |d OCLCQ  |d OCLCO  |d OCLCF  |d OCLCA  |d D6H  |d AGLDB  |d OCLCQ  |d ICA  |d OCLCQ  |d MOR  |d CCO  |d PIFAG  |d ZCU  |d MERUC  |d OCLCQ  |d U3W  |d REB  |d STF  |d OCLCQ  |d VTS  |d CEF  |d ICG  |d NLE  |d INT  |d VT2  |d OCLCQ  |d UKMGB  |d WYU  |d G3B  |d TKN  |d OCLCQ  |d UAB  |d DKC  |d AU@  |d OCLCQ  |d M8D  |d UKAHL  |d OCLCQ  |d OCLCO  |d QGK  |d OCLCQ  |d OCLCO 
016 7 |a 018005559  |2 Uk 
019 |a 879551205  |a 880640763  |a 907244196  |a 1259127755 
020 |a 9781782172420  |q (electronic bk.) 
020 |a 1782172424  |q (electronic bk.) 
020 |a 1782172416 
020 |a 9781782172413 
020 |z 9781782172413 
029 1 |a AU@  |b 000062544993 
029 1 |a AU@  |b 000066758759 
029 1 |a CHNEW  |b 000697309 
029 1 |a CHNEW  |b 000887535 
029 1 |a CHVBK  |b 374464529 
029 1 |a DEBBG  |b BV042032838 
029 1 |a DEBBG  |b BV043609177 
029 1 |a DEBSZ  |b 407733817 
029 1 |a DEBSZ  |b 414183126 
029 1 |a DEBSZ  |b 484722751 
029 1 |a GBVCP  |b 882839950 
029 1 |a UKMGB  |b 018005559 
035 |a (OCoLC)879474271  |z (OCoLC)879551205  |z (OCoLC)880640763  |z (OCoLC)907244196  |z (OCoLC)1259127755 
037 |a CL0500000436  |b Safari Books Online 
050 4 |a QA76.73.S67 
072 7 |a COM  |x 051170  |2 bisacsh 
082 0 4 |a 005.75/6  |2 23 
049 |a UAMI 
245 0 0 |a Getting started with SQL server 2014 administration :  |b optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL server 2014 /  |c [compiled by] Gethyn Ellis. 
264 1 |a Birmingham, UK :  |b Packt Publishing,  |c [2014] 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Professional expertise distilled 
588 0 |a PDF title page (viewed May 9, 2014). 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
520 |a 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. 
546 |a English. 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
650 0 |a SQL (Computer program language) 
650 6 |a SQL (Langage de programmation) 
650 7 |a COMPUTERS  |x Programming Languages  |x SQL.  |2 bisacsh 
650 7 |a SQL (Computer program language)  |2 fast 
700 1 |a Ellis, Gethyn,  |e compiler. 
776 0 8 |i Print version:  |a Ellis, Gethyn.  |t 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.  |d Birmingham, England : Packt Publishing, ©2014  |h iii, 92 pages  |z 9781782172413 
830 0 |a Professional expertise distilled. 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1685898  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH26849707 
938 |a EBL - Ebook Library  |b EBLB  |n EBL1685898 
938 |a ebrary  |b EBRY  |n ebr10868165 
938 |a EBSCOhost  |b EBSC  |n 771463 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis28366007 
938 |a YBP Library Services  |b YANK  |n 11802703 
994 |a 92  |b IZTAP