SQL Server 2017 Administration Inside Out EPUB

by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt

Part of the Inside Out series

EPUB

Download - Immediately Available

Please note: eBooks can only be purchased with a UK issued credit card and all our eBooks (ePub and PDF) are DRM protected.

Description

Conquer SQL Server 2017 administration-from the inside out

Dive into SQL Server 2017 administration-and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds-all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today's essential tasks-and challenge yourself to new levels of mastery.

* Install, customize, and use SQL Server 2017's key administration and development tools

* Manage memory, storage, clustering, virtualization, and other components

* Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations

* Provision SQL Server and Azure SQL databases

* Secure SQL Server via encryption, row-level security, and data masking

* Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing

* Establish SQL Server IaaS network security groups and user-defined routes

* Administer SQL Server user security and permissions

* Efficiently design tables using keys, data types, columns, partitioning, and views

* Utilize BLOBs and external, temporal, and memory-optimized tables

* Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans

* Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments

For Experienced SQL Server Administrators and Other Database Professionals

* Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert

* Prerequisites: Basic understanding of database administration procedures

Information

Download - Immediately Available
Format:EPUB
Pages:704 pages
Publisher:Pearson Education
Publication Date:26/02/2018
Category:
- Databases
- SQL Server / MS SQL
ISBN:9780135185391

Other Formats

PDF from £25.59
- PDF | Published 23/02/2018 | £25.59 | View now
Paperback / softback from £27.69
- Paperback / softback | Published 19/02/2018 | £27.69 | View now