security Archives - Mattias De Smet

Dec 27 2024

Get notified when Azure secrets are about to expire

by Mattias De Smet

No Comments

Using Azure EntraID App Registrations is almost essential for any type of application security or person-independant access to APIs and other autorization flows. Always follow the best practices when setting...

Jul 24 2024

Azure, Business Intelligence, Technology

Fabric : Warehouse security – custom DB roles

by Mattias De Smet

No Comments

Fabric is a platform that is taking everyone in the Microsoft data stack with speed. Data for the masses, warehouses at your fingertips, everyone a lakehouse whenever they want. Sounds...

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

Jun 18 2023

Business Intelligence

PowerBI : Implementing BYOK

by Mattias De Smet

No Comments

What is BYOK BYOK is the acronym for Bring Your Own Key. It gives you the ability to use your own encryption key on your data in rest, so you...

Tag: security

Get notified when Azure secrets are about to expire

Fabric : Warehouse security – custom DB roles

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

SQL : Locking down disperse SQL databases – part 1

PowerBI : Implementing BYOK