This blog will walk you through the steps of setting up a point-to-site VPN connection from a Windows server running StealthAUDIT so that you can discover and monitor all your Azure SQL databases. In the case of site-to-site, the access to the Azure SQL database is restricted to a specific server or desktop initiating the VPN connection to Azure. In the case of site-to-site VPN, one or more applications running within the external network can seamlessly access the Azure SQL databases. A point-to-site VPN connection is specific to a server or desktop that is external to Azure while a site-to-site VPN connection is for an entire network to Azure. The VPN connection can be either point-to-site or site-to-site. This option does not require defining a public end-point for the Azure SQL database.
This option also offers full administrative control over the SQL Server instance and the underlying operating system. Azure SQL Virtual Machine falls into the category of IaaS (Infrastructure-as-a-Service). Azure SQL Virtual Machines – This is similar to deploying an on-premise SQL Server in a virtual machine or in a physical server running Microsoft Windows or Linux (SQL Server 2017 supports Linux OS) operating systems.It comes with full SQL Server access and feature compatibility when there is a need to migrate on-premise SQL Server to Azure SQL. The main advantage of the managed instance is that there is no underlying operating system to worry about. The managed instance is co-hosted meaning there could be multiple instances of managed instances running on the same underlying hardware. Azure SQL Managed Instances – This is a full-fledged SQL instance similar to a SQL instance running on a Windows server but without access to the underlying operating system.The database server option allows the management of groups of single databases and elastic pools. Elastic Pool is a collection of databases that allows the flexibility of managing the performance characteristics of each database within the pool. A single database is similar to a database that can be created in a SQL Server instance.
It is essentially a DBaaS (Database-as-a-Service) and can be deployed as a single database, elastic pool or database server. Azure SQL Databases – This is a fully managed SQL database engine created using the latest version of Enterprise Edition of SQL Server.Microsoft Azure offers different variations of the SQLĭatabases that can be deployed based on the workload and complexity