This reference includes timesaving solutions, tips, and workarounds to help plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine authors including Randolph West tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio and PowerShell.
<ASIN: 0137899882 >
This edition has new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022.
Author: Randolph West et al Publisher: Microsoft Press Date: September 2023 Pages: 992 ISBN: 978-0137899883 Print: 0137899882 Kindle: B0C4VKVP27 Audience: SQL Server administrators Level: Intermediate Category: Database
- Identify low-hanging fruit and practical, easy wins for improving SQL Server administration
- Get started with modern SQL Server tools, including SQL Server Management Studio, and Azure Data Studio
- Upgrade your SQL Server administration skillset to new features of SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Linux
- Design and implement modern on-premises database infrastructure, including Kubernetes
- Use data virtualization of third-party or non-relational data sources
- Monitor SQL instances for corruption, index activity, fragmentation, and extended events
- Automate maintenance plans, database mail, jobs, alerts, proxies, and event forwarding
- Protect data through encryption, privacy, and auditing
- Provision, manage, scale and secure, and bidirectionally synchronize Microsoft's powerful Azure SQL Managed Instance
- Understand and enable new Intelligent Query Processing features to increase query concurrency
- Prepare a best-practice runbook for disaster recovery
- Use SQL Server 2022 features to span infrastructure across hybrid environments
Related Reviews
SQL Server 2022 Administration Inside Out
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.
Oracle PL/SQL By Example, 6th Ed
Author: Elena Rakhimov Publisher: Oracle Press Pages: 480 ISBN: 978-0138062835 Print: 0138062838 Audience: Developers interested in Oracle PL/SQL Rating: 4 Reviewer: Kay Ewbank
This is the sixth edition of a well established title that has been updated for the latest version of PL/SQL (21c).
|
Learn dbatools in a Month of Lunches
Author: Chrissy LeMaire et al Publisher: Manning Pages: 400 ISBN: 978-1617296703 Print: 1617296708 Kindle: B0B39PCHL8 Audience: SQL Server DBAs Rating: 5 Reviewer: Ian Stirk
This book aims to make it easier to manage your SQL Server estate, how does it fare?
| More Reviews |
|