SQL Server 2017 Administration Inside Out

SQL Server 2017 Administration Inside Out
Author :
Publisher : Microsoft Press
Total Pages : 1125
Release :
ISBN-10 : 9780135185391
ISBN-13 : 0135185394
Rating : 4/5 (394 Downloads)

Book Synopsis SQL Server 2017 Administration Inside Out by : William Assaf

Download or read book SQL Server 2017 Administration Inside Out written by William Assaf and published by Microsoft Press. This book was released on 2018-02-26 with total page 1125 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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


SQL Server 2017 Administration Inside Out Related Books

SQL Server 2017 Administration Inside Out
Language: en
Pages: 1125
Authors: William Assaf
Categories: Computers
Type: BOOK - Published: 2018-02-26 - Publisher: Microsoft Press

DOWNLOAD EBOOK

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. Th
Microsoft SQL Server 2005 Management and Administration (Adobe Reader)
Language: en
Pages: 904
Authors: Ross Mistry
Categories: Computers
Type: BOOK - Published: 2007-10-03 - Publisher: Pearson Education

DOWNLOAD EBOOK

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Se
MCITP Administrator Microsoft SQL Server 2005 Optimization and Maintenance Study Guide
Language: en
Pages: 699
Authors: Victor Isakov
Categories: Computers
Type: BOOK - Published: 2007-07-10 - Publisher: John Wiley & Sons

DOWNLOAD EBOOK

Covering Microsoft’s brand-new SQL 2005 administrator exam, this study guide walks you through setting up, maintaining, and troubleshooting database solutions
Learn SQL Server Administration in a Month of Lunches
Language: en
Pages: 390
Authors: Don Jones
Categories: Computers
Type: BOOK - Published: 2014-04-30 - Publisher: Simon and Schuster

DOWNLOAD EBOOK

Summary Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and re
Learning SQL on SQL Server 2005
Language: en
Pages: 344
Authors: Sikha Saha Bagui
Categories: Computers
Type: BOOK - Published: 2006-04-26 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrie