IFS Analysis Models - Azure Artifact setup - SQL Database (SQL DB)

General

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

Each customer has their own SQL Database hosted in the Azure SQL Server. This Database is created using the customer Service Principal

Create SQL DB

Note: Dependant on Azure SQL Server

Basics of setting up SQL DB

Network Settings

DB access from SQL Server Management Studio