SQL Server 2022 is the basic element of Microsoft Intelligent Data Platform. The platform easily integrates the operating databases, analytics and data management. Integration with Azure allows you to create a controlled emergency recovery for SQL Azure, and also allows you to get analytics in almost real time, which allows you to manage databases imperceptibly for the final user.

New functions SQL Server 2022 IoT:

Connection to the cloud

• Azure SQL Managed Instance - provides uninterrupted operation of the SQL Server 2022 IoT using the PAAS environment for emergency recovery, which reduces the settings and control time (compared to IAAS)
• Azure Synapse Link
• Azure Synapse Link provides SQL Server 2022 Automatic web channels for registering changes to SQL Server and transferring them to Azure Synapse Analytics.

Integration with Microsoft Purview
Microsoft Purview is a unified data management service. Integration SQL Server 2022 with Microsoft PurView provides data search and allows:

• Automatically scan SQL Server 2022 to collect metadata
• Support for data classification using Microsoft Information Protection tuned tags.
• Support for setting and monitoring access rights to SQL Server.

Functions SQL Server 2022 associated with Azure

• A single performance of all SQL servers, deployed locally, in Azure and other clouds.
• Support for local data protection using Microsoft Defender for a cloud.

• Security and safety. Identify people, activities and potential threats, using Artificial Intelligence (AI)-enabled cameras, to increase facility security with edge-based Video Management Systems for storage and deeper analysis.
• Manufacturing. Monitor equipment sensors to calculate performance metrics, solve production problems, and predict required maintenance, improving field-service efficiency.
• Smart buildings. Protect with intelligent enterprise fire and life safety monitoring solutions.
• Healthcare. Support medical imaging technology such as picture archiving and communication systems (PACS) for patient images.
• Smart cities. Monitor complex and rapidly changing environmental conditions like air and water.
• Retail. Monitor shelf inventory and quality (object detection).

Microsoft SQL Server has been available for embedded use for many years. Combined with Windows Server IoT 2022 and a specific purpose application, Microsoft SQL Server IoT 2022 provides a comprehensive database platform for mission-critical data analytics and offers industry-leading performance, availability, and security. For clarity, Microsoft SQL Server IoT 2022 has the same features and functionality as Microsoft SQL Server 2022, but different licensing and distribution. Microsoft SQL Server IoT 2022 is only licensed through the OEM channel under special dedicated use rights. It must be installed on the device with an integrated (embedded) software application (or suite of applications) dedicated and designed for a specific use.