SQL Server 2019 Administration Inside Out



Bookstore > Books > SQL Server 2019 Administration Inside Out

Price$48.15 - $55.19
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

Beginning Microsoft SQL Server 2008 Administration

Beginning Microsoft SQL Server 2008 Administration

by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation a...

Price:  $5.17  |  Publisher:  Wrox  |  Release:  2009

Microsoft SharePoint 2013 Administration Inside Out

Microsoft SharePoint 2013 Administration Inside Out

by Randy Williams, CA Callahan, Chris Givens, John Milan Gross, Brian Alderman

Dive into SharePoint 2013 administration - and really put your systems expertise to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. Discover how the experts deploy, configure, and manage SharePoint - and challenge yourself to new levels of mastery....

Price:  $24.79  |  Publisher:  Microsoft Press  |  Release:  2014

Windows Server 2012 R2 Inside Out Volume 1

Windows Server 2012 R2 Inside Out Volume 1

by William Stanek

This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds for Windows Server 2012 R2 - with a focus on configuration, storage, and essential administrative tasks....

Price:  $39.21  |  Publisher:  Microsoft Press  |  Release:  2014

SQL Server 2019 AlwaysOn, 3rd Edition

SQL Server 2019 AlwaysOn, 3rd Edition

by Peter A. Carter

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems. The book provide...

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

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

by Andy Leonard

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2021

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

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