SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability

Book Description

Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable. You’ll learn about built-in Query Intelligence capabilities to help you to upgrade with confidence that your applications will perform at least as fast after the upgrade than before. In fact, you’ll probably see an increase in performance from the upgrade, with no code changes needed. Also covered are innovations such as contained availability groups and data virtualization with S3 object storage.

New cloud integrations covered in this book include Microsoft Azure Purview and the use of Azure SQL for high availability and disaster recovery. The book covers Azure Synapse Link with its built-in capabilities to t博兰斯勒ake changes and put them into Synapse automatically.

Anyone building their career ar庞巴迪ound SQL Server will want this book for the valuable information it provides on building SQL skills from edge to the cloud.

​What You Will Learn

• Know how to use all of the new capabilities and cloud integrations in SQL Server 2022
• Connect to Azure for disaster recovery, near real-time analytics, and security
• Leverage the Ledger to create a tamper-evident record of data changes over time
• Upgrade from prior releasesand a法拉利chieve faster and more consistent performance with no code changes
• Access data and storage in different and new formats, such as Parquet and S3, without moving the data and using your existing T-SQL skills
• Explore new application scenarios using innovations with T-SQL in areas such as JSON and time series

Who This Book Is For

SQL Server professionals who want to upgrade their skills to the latest edition of SQL Server; those wishing to take advantage of new integrations with Microsoft Azure Purview (governance), Azure Synapse (analytics), and Azure SQL (H宇舶表A and DR); and those in need of the increased performance and security offered by Query Intelligence and the new Ledger

中文：

书名：SQL Server 2022揭示: 由安全性、性能和可用性提供支持的混合数据平台

了解如何在SQL Server 2022中使用新功能和云集成。本书涵盖了与Azure云的许多创新集成，使SQL Server 2022有史以来最与云连接的版本。这本书涵盖了前沿功能，例如基于区块链的分类账，用于创建随时间变化的数据篡改记录，您可以依靠这些记录来保持正确和可靠。您将了解内置的查询智能功能，以帮助您放心升级，确保您的应用程序在升级后的运行速度至少与之前一样快。实际上，您可能会看到升级带来的性能提高，而无需更改代码。还涵盖了诸如包含可用性组和具有S3对象存储的数据虚拟化之类的创新。

本书涵盖的新云集成包括Microsoft Azure Purview和使用Azure SQL实现高可用性和灾难恢复。这本书涵盖了Azure Synapse Link及其内置功能，可以自动进行更改并将其放入Synapse。

任何围绕SQL Server建立职业生涯的人都希望这本书提供有关从边缘到云构建SQL技能的宝贵信息。

你将学到什么

• 知道如何使用所有新功能和云集成SQL Server 2022
• 连接Azure灾难恢复、近实时分析和安全
• 利用账本创建数据随时间变化的篡改记录
• 从以前的版本升级，实现更快、更一致的性能，无需更改代码
• 访问不同格式的数据和存储，如Par碧欧泉quet和S3，无需移动数奢侈腕表据和使用您现有的t-sql技能
• 利用t-sql在JSON、时序等领域的创新探索新的应用场景

这本书是给谁的

希望将技能升级到最新版本的SQL Server专业人员; 希望利用与Microsoft Azure Purview (治理)，Azure Synapse (分析) 和Azure SQL (HA和DR) 的新集成的人员；以及那些需要查询智能和新分类账提供的提高性能和安全性的人