Pro SQL Server 2019 Administration, 2nd Ed (Apress)
Friday, 22 November 2019

This comprehensive guide for SQL Server DBAs has been updated for SQL Server 2019. Author Peter Carter includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL.

<ASIN:1484250885>

.

Author: Peter Carter
Publisher: Apress
Date: October 2019
Pages: 940
ISBN: 978-1484250884
Print: 1484250885
Kindle: B07ZC1XC9Z
Audience: SQL Server DBAs
Level: Intermediate
Category: Database

Topics covered include:

 

  • Install and configure SQL Server on Windows through the GUI and with PowerShell 
  • Install and configure SQL Server on Linux and in Containers
  • Optimize tables through in-memory OLTP, table partitioning, and the creation of indexes
  • Secure and encrypt data to protect against embarrassing data breaches
  • Ensure 24x7x365 access through high-availability and disaster recovery features
  • Back up your data to ensure against loss, and recover data when needed
  • Perform routine maintenance tasks such as database consistency checks  
  • Troubleshoot and solve performance problems in SQL queries and in the database engine 

 

Related Reviews

Pro SQL Server Administration

 

For recommendations of SQL Server books see Pick Of The Shelf - SQL Server in our Programmer's Bookshelf section.

 

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.

 

 

Banner
 


Essential C# 8.0, 7th Ed (Addison-Wesley)

Author: Mark Michaelis
Publisher: Addison-Wesley
Date: October 2020
Pages: 1088
ISBN: 978-0135972267
Print: 0135972264
Kindle: B08Q84TH84
Audience: C# developers
Rating: 4.5
Reviewer: Mike James
The latest edition of a highly recommended book that combines reference and tutorial material.



Domain Storytelling (Pearson)

Author: Stefan Hofer
Publisher: Pearson
Pages: 288
ISBN:978-0137458912
Print:0137458916
Kindle:B099ZNXCJT
Audience: software architects
Rating: 4.5
Reviewer: Kay Ewbank

This book sets out to be a practical guide to database domains, bringing together domain experts, software developers, designers and bus [ ... ]


More Reviews