SQL Server 2022 and Azure

Cloud Power

ML and Better Data Protection

ML models can be used in the scope of analysis by Azure Synapse Analytics and SQL Server 2022. Real-time analysis of streaming data is also supported, for example, if the data has been integrated directly into a data warehouse. To this end, Azure Synapse Analytics integrates the Spark engine and can therefore collaborate with SQL Server 2022.

Microsoft has also integrated data protection functions into the system and made it possible to analyze individual columns and rows with different security settings and permissions. Dynamic data masking is possible, as is permanent encryption of all data. The system uses other Azure technologies to detect threats and can automatically protect the data being analyzed. Azure Synapse Analytics relies on Azure Active Directory for authentication.

In addition to data protection, data sharing naturally plays an important role. Azure Data Share [4] is one of the options available. The service works directly with Azure Synapse Analytics, enabling data sharing through the Azure user interface (e.g., in the scope of a subscription). In general, all software-as-a-service (SaaS) components that support the Open Data Initiative [5] can be connected.

Queries via SQL

The data in Azure Synapse Analytics can be queried by SQL. In this way, both relational and non-relational data (e.g., originating from local servers running SQL Server 2022) can be analyzed. According to Microsoft, petabytes of data can be processed in just seconds. In this context, Synapse Analytics supports Power BI and Azure Machine Learning. Power BI capabilities are integrated directly into Azure Synapse Analytics for this purpose, including the numerous data sources that can be connected by Power BI. The Power BI Common Data Service (CDS) and artificial intelligence (AI) capabilities are also available in Azure Synapse Analytics.

Azure Synapse Analytics supports other languages besides Transact SQL (T-SQL) for analysis or for connecting external systems, including Python, Scala, Spark, and, of course, .NET. The functions from Azure Data Factory are also available in Azure Synapse Analytics. Data sources can be connected to Mapping Data Flows, which is a graphical ETL tool available directly in the Synapse workspace.

Data Analytics and Blockchain Technologies

Azure Purview is another service related to SQL Server 2022. It supports the establishment of consistent governance functions for on-premises systems in the same way as in the cloud. The service captures the metadata on the on-premises SQL servers and classifies the data. Azure Purview helps organizations catalog and manage their data wherever the data resides. Access rights can be controlled specifically for local SQL servers.

SQL Server Ledger, on the other hand, is a data integrity technology. It can be used, for example, to store off-chain data from blockchains, such as for smart contracts or decentralized apps (dApps). However, SQL Ledger also ensures that certain data cannot be changed, ruling out manipulation. In this regard, SQL Server 2022 can demonstrate that data integrity has not been compromised whenever needed by a client.

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy ADMIN Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • The Azure Arc multicloud and on-premises management platform
    The Azure Arc cloud service supports centralized management of Windows and Linux servers, Kubernetes clusters, and SQL servers that are not themselves running in Azure, extending Azure management capabilities to servers in traditional data centers or any other cloud environment. We show you how to get Azure Arc up and running and look at its key features.
  • Migrating to Azure Monitor Agent
    The replacement for the Log Analytics Agent has improved security and cost efficiency, better manageability, and greater reliability – and you must migrate to this new solution by the end of 2024.
  • Azure AD and AD Domain Services for SMEs
    Azure Active Directory Domain Services is a Microsoft product, distinct from Active Directory and Azure Active Directory, that offers centralized directory services in the cloud in place of an often convoluted on-premises operation.
  • Server update with Azure Update Management
    Microsoft Azure Update Management automatically patches servers in on-premises data centers, virtual servers on Azure and other cloud services, and even Linux servers.
  • Private cloud with Microsoft Azure Stack
    Azure Stack is an Azure extension that implements an on-premises data center for consistent hybrid cloud deployments.
comments powered by Disqus
Subscribe to our ADMIN Newsletters
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs



Support Our Work

ADMIN content is made possible with support from readers like you. Please consider contributing when you've found an article to be beneficial.