SQL Server 2019 Administration Inside Out



Bookstore > Books > SQL Server 2019 Administration Inside Out

Price$53.99 - $67.16
Rating
AuthorsRandolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni
PublisherMicrosoft Press
Published2020
Pages992
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-100135561086
ISBN-139780135561089
EBook Hardcover Paperback

Dive into SQL Server 2019 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 2019 in any production environment: on-premises, cloud, or hybrid. Six experts thoroughly tour DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You'll find extensive new coverage of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today's essential tasks - and challenge yourself to new levels of mastery.

Explore SQL Server 2019's toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager; Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures; Install and configure SQL Server on Windows and Linux; Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API; Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more; Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication; Use availability groups for high availability and disaster recovery; Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances; Optimize databases with SQL Server 2019's advanced performance and indexing features; Provision and operate Azure SQL Database and its managed instances; Move SQL Server workloads to Azure: planning, testing, migration, and post-migration.


  1. (2 books)
  2. (2 books)
  3. (2 books)
  4. (4 books)
  5. (2 books)



Similar Books


SQL Server 2017 Administration Inside Out

SQL Server 2017 Administration Inside Out

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

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

Price:  $34.23  |  Publisher:  Microsoft Press  |  Release:  2018

Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

by Gethyn Ellis

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...

Price:  $16.99  |  Publisher:  Packt Publishing  |  Release:  2014

Pro SQL Server 2012 Administration, 2nd Edition

Pro SQL Server 2012 Administration, 2nd Edition

by Ken Simmons, Sylvester Carstarphen

Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex field requiring an unusually broad and well-rounded skill set. A good database administrator must be part system administrator, part database ...

Price:  $59.99  |  Publisher:  Apress  |  Release:  2012

Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

by Satya Shyam K Jayanty

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2011

Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.SQ...

Price:  $24.23  |  Publisher:  Apress  |  Release:  2018

Refactoring Legacy T-SQL for Improved Performance

Refactoring Legacy T-SQL for Improved Performance

by Lisa Bohm

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQ...

Price:  $23.99  |  Publisher:  Apress  |  Release:  2020

Pro T-SQL 2019

Pro T-SQL 2019

by Elizabeth Noble

Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-...

Price:  $24.62  |  Publisher:  Apress  |  Release:  2020

Learning SQL Server Reporting Services 2012

Learning SQL Server Reporting Services 2012

by Jayaram Krishnaswamy

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2013