Blog de Sauget Charles-Henri MVP Data Platform
If you are using Azure SQL DB Premium tier or Azure SQL Managed Instance (Business Critical Tier), you will benefit from using the read-only replicate provided to lighten the workload on your read-write database and avoid unwanted locks. This article will provide guidance to explain how to do this on Power BI and Azure Analysis Services (for Power Query type…
Since version 1.17 of Azure Storage Explorer it is possible to propagate the permissions of an Azure DataLake Gen2 on the child folders! Finally, because the operation was quickly tedious. So after adding container level rights, it is possible to add specific rights to an existing folder: To add a default permission to it, applied when creating new objects. Until…
If you are using Synapse Analytics with SQL Pool Serverless (former SQL Pool On demand) and you want to manage a notion of “principle of least privilege”, there are a few things to take into account. The creation of a USER using for example an AD group: With [MyAdGroup], a group in the Active Directory to which we want to…
The first difficulty in discussing an AAS / PowerBI functionality is to create a test environment that is interesting enough. StackOverflow proposed by Brent Ozar looks like a good fit. The Extra-Large version has the merit of making more than 300 GB of data and of providing several areas of interesting analysis. The tabular model used for this example is…
**************March 2021 Update************ It’s now possible to generate the Shared Access Signature using the online portal : Storage accounts with Hierarchical Namespace activated (also called Azure Data Lake Storage Gen 2) have the main advantage of managing access via Azure AD authentication and therefore being able to give rights to a UPN (POSIX rights). However, for compatibility purposes, a large…
