SQL Server 2022 and Azure

Cloud Power

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

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.
  • Replication between SQL Server and Azure SQL
    Wherever Microsoft SQL Server runs on local networks, individual or all databases can be migrated to Azure SQL by transactional replication. Various opportunities unfold, including analytics in the Azure cloud and global access routes for mobile users and home and branch offices.
  • 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.
  • Keeping Azure VMs up to date
    The operating system of an Azure virtual machine can be kept up to date by a number of methods; we provide an overview and look in detail at Azure Automation Update Management, the Azure Update Management Center, automation options, and other related topics.
  • 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.
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.

Learn More”>
	</a>

<hr>		    
			</div>
		    		</div>

		<div class=