Tag: security

Jun 26 2023

Azure

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

by mattias

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

keyvault, security, sql

Jun 23 2023

Azure, Uncategorized

SQL : Locking down disperse SQL databases – part 1

by mattias

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

azure, azure sql db, elastic job, function, keyvault, powerautomate, security, sql

Jun 18 2023

Business Intelligence

PowerBI : Implementing BYOK

by mattias

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

azure, byok, encryption, PowerBI, security

Jan 30 2023

Business Intelligence

PowerBI : Manage dataset access requests

by mattias

No Comments

When a PowerBI report gets more and more popular, all kind of users start requesting access to a report. Your PowerBI developers made the dataset, setup Row Level Security, and...

bi, dataset, PowerBI, security

Aug 18 2022

Azure

Hiding secrets from Azure Functions

by mattias

No Comments

When creating Azure Functions in support of database related logic, or with any need to use a sensitive value, you probable already make sure you don’t store it in the...

azure, function, keyvault, security