Mattias De Smet

Jul 20 2023

PowerBI: Change PowerBI Desktop language

by mattias

No Comments

Ever woken up to a PowerBI Desktop that suddenly spoke a different language then before? For some reason in Belgium the application likes to revert to French, while I prefer...

Jul 20 2023

Uncategorized

SQL : Locking down disperse SQL databases – part 6 – Unlock Request form

by mattias

No Comments

As the cherry on this multi-layered cake that has a base of SQL logins, KeyVault, a sauce of Azure Functions with a coating of Elastic Jobs all glazed with PowerAutomate,...

Jul 08 2023

Uncategorized

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

by mattias

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

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

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...