Open In App

Microsoft Azure – PaaS vs. IaaS in Azure SQL

Last Updated : 30 Mar, 2023
Improve
Improve
Like Article
Like
Save
Share
Report

SQL Server on an Azure Virtual Machine is known as IaaS or Infrastructure as a Service. As we move towards Azure SQL Database and Azure SQL Managed Instance, we moved towards the territory of Platform as a Service or PaaS type of offerings. 

In this article, we will break down the differences between IaaS and PaaS. The one big difference before we get started is that in IaaS or in this case, SQL Server on Azure Virtual Machine, there are a lot of things that you can configure yourself, just like in SQL Server, but with PaaS, there’s a lot of automation and help that Azure provides.

1. Automation:

 Now if we look at some examples, when we talk about business continuity and high availability, we can set up an availability group, but that takes some time. You could also do things like setting up some sort of long-term backup retention policy or system. But again, that’s going to take some configuration on your end. 

With Azure SQL PaaS services, Azure can help you set up these things pretty much automatically. 

2. Geo-replication:

With geo-replication, with a few clicks of a button in Azure SQL Database, you can set up geo-replication so you can have read replicas in your region, or across other regions. With automated backups, Azure can give you three replicas that are geo-distributed without you even having to say that, Azure just takes care of that for you. 

3. Automated Backups:

With Azure SQL Managed Instance and SQL Database, you can also set up auto fill-over groups so that in the time of a disaster, Azure can automatically fill you over to another region without you having to change any connection settings.

4. Scale:

In addition, while you can scale Azure Virtual Machine, even sometimes with a point and click in the portal, Azure SQL Database and Managed Instance offer different scaling options that make things easier. For example, Azure SQL Database offers serverless, where Azure does autoscaling of your applications, as your CPU demands increase from your application.

5. Versionless:

Azure SQL Database and Managed Instance on a PaaS service, offers a version-less SQL Server. It’s hard to put your mind around a version less SQL Server, but no longer do you worry about any updates to SQL Server or anything in the backend for the operating system. Azure completely manages all updates and changes to SQL and enhancements. Azure constantly feeds in fixes and enhancements to the service on the backend.

6. Built-in Intelligence: 

Paas provides built-in intelligence. For instance, you might go out on yourself and try to set up systems to do things like automatic indexing. But imagine if the Azure servers in the backend could look at your application, recognize patterns of performance enhancements, and automatically recommend or even apply indexes to your environment. Those are just some of the other examples that PaaS provides. 

7. Built-in Monitoring:

The fact that you can set up a virtual machine, get some advantages of the Azure infrastructure, but all the different things you need to do yourself in the VM to make it available, and performant, and secure, whereas Platform as a Service, manages all that. Azure will manage things, give you recommendations and provide automation. 

Difference Between IaaS vs PaaS:

Services Infrastructure as a Service(IaaS) Platform as a Service(PaaS)
Business Continuity Manual & time-consuming Automated and managed by Azure
High availability Manual & time-consuming Automated and available as per needs
Automated Backups Manual configuration needed Automated configuration
Backup Retention(Long-term) Manual configuration needed Automated configuration
Geo-replication Not Available Automatically creates 3 copies
Scale Depends on the Users machine Highly scalable automated system
Advanced Security Depends upon the user’s infrastructure Highly Secure.
Versions Needs update when available It is version less, so, one less thing to worry about.
Monitoring Need to be done manually Azure does it for you and notifies user of relevant changes or triggers.users
Built-in Intelligence Not available Available

Previous Article
Next Article

Similar Reads

Microsoft Azure - Azure Application Service Environments v2 Private PaaS Environments in the Cloud
Pre-requisite: Azure Microsoft Azure is a Cloud Computing Platform and Infrastructure created by Microsoft for building, deploying, and managing applications and services through a global network of Microsoft-managed data centers. Azure Application Service Environments (ASE) v2 is a private Platform as a Service (PaaS) environment in the cloud that
5 min read
Microsoft Azure - Getting Started With Azure Backup For Protecting an IaaS VM
Azure Backup is a cloud-based backup and recovery solution provided by Microsoft Azure that allows you to protect your data and applications running on-premises and in the cloud. When it comes to protecting IaaS VMs, Azure Backup offers a seamless and reliable backup and recovery solution. To protect an IaaS VM using Azure Backup, you need to creat
4 min read
Hosting a Web Application on Microsoft Azure in IAAS
Azure provides a lot of services to host a web application whether it be static or dynamic in a number of ways. In this article, we will host a simple static web application taking Infrastructure as a Service on Microsoft Azure, by using a free and open-source cross-platform web server software named Apache HTTP Server on a virtual machine. A stati
9 min read
Microsoft Azure - Configure Azure SQL with Azure CLI
In this article, we're going to take a closer look at how you can configure something like connectivity using the Azure CLI. What we have here is we are in Azure Data Studio and similar to the SQL notebook we are actually using a PowerShell notebook. That just means all our code cells are going to run PowerShell and we are just connecting to localh
4 min read
Microsoft Azure - Get Azure VM Properties using Azure PowerShell
The purpose of using the Azure PowerShell Commands is to quickly analyze the overall properties of VM/VMs at once the filtering the with select and where conditions. To find the properties of an Azure VM, you can perform the following commands in Azure Cloud Shell to get the details. Command: Get-AzVM Output: 1. Get all properties of an Azure Virtu
2 min read
Microsoft Azure - RDP to Azure Virtual Machines using Azure Bastion
In this article, we will learn how to do RDP(Remote Desktop Protocol) / SSH(Secure Shell) Connection to an Azure VM using Azure Bastion. First, let's discuss Azure Bastion. The Azure Bastion service is a fully platform-managed PaaS service that you provision inside your virtual network. It provides secure and seamless RDP/SSH connectivity to your v
3 min read
Microsoft Azure - Get CPU Utilization Data of a Azure VM in Azure Portal
Azure Virtual Machines (VM) is one of several types of on-demand, scalable computing resources that Azure offers. In this article, we will look into the process of getting the CPU Utilization data of an Azure VM in Azure Portal. Implementation: Follow the steps to get the CPU Utilization of an Azure VM in Azure Portal: Step 1: Log in to your Azure
2 min read
Microsoft Azure - Archive Azure VM to Azure Storage Account
In this article, we will be implementing a solution to archive a select azure VM snapshot to a select storage account for archiving using azure cloud shell. For implementation, we will be using Azure CLI commands. Prerequisite:VM SnapshotA storage account is neededUser needs "Storage Blob Contributor Data" IAM Role Access on Archiving Storage Accou
2 min read
Microsoft Azure - Check Status of Azure VM using Azure PowerShell
The following Azure PowerShell command helps you to find the Azure VM Config and properties details of Os Name, Os Version, Hyper V Generation, Disks properties, Extensions properties of Type Handler Version, Status and Message, VM Agents properties of Type Handler Version, Status and Message and also VM Power Status Codes, Messages, Plugins, Time
3 min read
Microsoft Azure - Azure VM Disk Space in Percentage using Azure KQL
Here we'll be using the Azure Insights Metric Query to find the free disk space in percentage using KQL. The purpose of this query is to find disk drive free space of all the Azure VMs without logging into every server. You can Run the following KQL log Queries in Azure Monitor or Azure VM Logs or Log Analytics Workspace. Note: VM Insights Agent sh
1 min read