AAD – Using Managed Service Identity (MSI) with Azure App Service and Azure SQL Database

Managed Identity Service is a useful feature to implement for the cloud applications you plan to develop in Azure. You can use this identity to authenticate to any service that supports Azure AD authentication without having any credentials in your code. The credentials never appear in the code or in the source control. It works by defining a service principal ID attributed to either a system-assigned (Azure Service instance) or a user-assigned (Azure stand-alone resource). The difference between both is that for the system-assigned identity, the service principal ID is available […]

Read More →

SQL/SSAS – Failover Cluster on Windows 2012 – Installation & Configuration

Confirm compatibility of your environnement before deploying a SQL failover cluster. https://docs.microsoft.com/en-us/windows-server/failover-clustering/clustering-requirements Disks configurations Disk 1 – Quorum: Is the quorum of the cluster. A cluster quorum disk is the storage medium on which the configuration database is stored for a cluster computing network. The cluster configuration database, also called the quorum, tells the cluster which physical server(s) should be active at any given time. Disk 2 – Data: This drive must be formatted using 64K. This is the one hosting the databases of the SQL instances Disk 3 – […]

Read More →

AAD – How to use Azure SQL Database with Azure Active Directory Authentification

In this post, i will go through the authentification with Azure Active Directory account and Azure SQL Database. Creation of the SQL Server and database In Azure, select the All Services button, search for SQL Server and click the star to add it in your favorites on the left bar. Click the SQL Servers blade and Add Fill the requested information to complete the creation of the SQL server. Proceed next to add a new database to the SQL server. Click New Database Fill the requested information to complete the database […]

Read More →