Lead Image © Dmitriy Shpilko, 123RF.com

Lead Image © Dmitriy Shpilko, 123RF.com

SQL Server 2022 and Azure

Cloud Power

Article from ADMIN 71/2022
SQL Server 2022 focuses on even closer collaboration between on-premises SQL servers and SQL functions in Azure, including availability and data analysis. We highlight the innovations of the database server and the interaction with versatile and powerful Azure services.

Microsoft is heading in the direction of the cloud. SQL Server 2022 is no exception, with the new database server offering enhanced functions for a closer tie-in to Azure, creating new opportunities for companies. However, I'll first look at SQL server licensing because, starting in version 2022 and following the abolition of the Open License program, SQL server will exclusively be available as a Cloud Solution Provider (CSP) purchase license or in the Open Value volume license program. You need to take this into account when planning licensing. Incidentally, as of this year, Windows Server is no longer available for commercial customers in the Open program for volume licensing, which also plays a role for the database server.

Azure Hybrid Advantage for SQL Server [1] lets you use licenses for locally operated SQL servers in Azure. Microsoft offers price reductions for this purpose, which is an important consideration in high-availability scenarios with SQL Server 2022 and Azure SQL Managed Instance. Therefore, it makes sense to look into server licensing in good time. A limited version of SQL Server 2022 will also be released for Linux. Microsoft continues to recommend the use of Linux containers for container installation. SQL Server 2022 cannot be operated in Windows containers.

SQL Server Used Locally

The connection between local SQL servers and Azure SQL instances will still be optional in the future, which means SQL servers can be operated locally without relying on functions from Azure. However, the cloud offers many advantages in terms of availability, replication, and data analysis. As the volume of data in the enterprise continues to increase, role owners need to deal with large quantities of structured and unstructured data. Additionally, you have the choice of centralized and decentralized storage approaches, numerous

Use Express-Checkout link below to read the full article (PDF).

Buy this article as PDF

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

Buy ADMIN Magazine

Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • 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.
  • Connecting Windows Server 2016 with Azure
    Microsoft continues to integrate Windows Server with the Azure cloud. With Cloud Witness and the RDS Connection Broker, you can operate distributed environments more reliably and efficiently, and SQL databases migrate sensibly into the cloud.
  • Security features in Windows Server 2022
    The release of Windows Server 2022 adds some new security features to its server operating system that might not be earth-shattering; however, you will find Secured-core, DNS over HTTPs, TLS 1.3, and Azure Stack HCI genuinely useful in your constant fight to harden server operations.
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.