Mattias De Smet

Jul 08 2023

SQL : Locking down disperse SQL databases – part 5 – Approval flow with PowerAutomate

by Mattias De Smet

No Comments

We’ll design the approval flow in PowerAutomate, which will send out the emails to notify the requestor, trigger the unlock process for the requested database, and give the opportunity for...

Jul 06 2023

Uncategorized

SQL : Locking down disperse SQL databases – part 4 – Automatic locking with Elastic Jobs

by Mattias De Smet

No Comments

Now that we setup the logins, the key vault and the function that will do the unlocking, it’s time to make sure any unlocked logins are also automatically locked again,...

Jun 29 2023

Uncategorized

SQL : Locking down disperse SQL databases – part 3 – Unlocking with Azure Function

by Mattias De Smet

No Comments

In order to unlock one of the deploy logins, you need a mechanism that does this without providing access to someone to the database to actually unlock that login. The...

Jun 26 2023

Azure

SQL : Locking down disperse SQL databases – part 2 – Logins & Keyvault

by Mattias De Smet

No Comments

In the previous article I explain the full setup of a mechanism to automate the access management of databases across various servers. In this article, I’ll start with the basics:...

Jun 23 2023

Azure, Uncategorized

SQL : Locking down disperse SQL databases – part 1

by Mattias De Smet

No Comments

In this series, I’ll detail a process to automate giving and removing access to databases. Not just a single one, but different databases over different servers. Introduction The use case...