SQL Server 2017 Administration Inside Out

Nonfiction, Computers, Database Management
Cover of the book SQL Server 2017 Administration Inside Out by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt ISBN: 9780135185391
Publisher: Pearson Education Publication: February 26, 2018
Imprint: Microsoft Press Language: English
Author: William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
ISBN: 9780135185391
Publisher: Pearson Education
Publication: February 26, 2018
Imprint: Microsoft Press
Language: English

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

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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

More books from Pearson Education

Cover of the book Weird Wild Animal Facts by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Run Your Business as if You Are the Owner by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Photographing Indoor Sports by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Logistics & Supply Chain Management by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Build Windows 8 Apps with Microsoft Visual C# and Visual Basic Step by Step by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Tricks of the Podcasting Masters by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Moving to Microsoft Windows Vista by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Inside Microsoft SharePoint 2010 by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Mastering Project Management Strategy and Processes by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book The Apache Modules Book by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book The New Heart of Darkness by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Apple Pro Training Series by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Millimeter Wave Wireless Communications by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book NCLEX-RN Practice Questions Exam Cram by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
Cover of the book Essential Facebook Development by William Assaf, Randolph West, Sven Aelterman, Mindy Curnutt
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy