Exporting query data is quite simple as one-two-three: One: define your file format CREATE EXTERNAL FILE FORMAT parquetfile1 WITH ( FORMAT_TYPE = PARQUET, DATA_COMPRESSION = ‘org.apache.hadoop.io.compress.SnappyCodec’ ); Two: define your file location (note: you should have read/write/list permission the path) CREATE EXTERNAL DATA SOURCE ADLS_DS WITH( LOCATION = ‘abfss://synapse@deltapoc0storage0dest.dfs.core.windows.net’)Czytaj dalej / Read more
Azure Active Directory – inviting users when you are not an AAD admin
By default, all users, including guests, can invite guest users. Isn’t it beautiful? No, it’s not! Definitely not if you are an AAD admin. So treat this post as a warning. Your users, including !!guest users!! can invite other users to your AAD by default. If you are ok withCzytaj dalej / Read more
Worth watching! EightKB – SQL Server Internals Conference 17.06.2020
Most of the lectures at conferences focus on general topics, often at a basic level to introduce the listener to a certain area, just to interest him. And there are only a few that I come out with a head full of detailed technical knowledge, very useful in understanding theCzytaj dalej / Read more
Are you looking for a Client ID but actually you don’t have permission to access Azure Active Directory?
That was my case. And to be honest it wasn’t easy to find the solution, although the solution is pretty easy 😉 All pages that I visited are describing on how to do it but using only Active Directory within the portal… The truth is, that even if you can’tCzytaj dalej / Read more
Azure Bastion – creating proper NSG rules
Just in case someone came across a problem defining proper nsg rules for Azure Bastion… Well, here they are: Works like a charm 😀 And below the ARM for it: { “$schema”: “https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#”, “contentVersion”: “1.0.0.0”, “parameters”: { “projectPrefix”: { “type”: “string”, “metadata”: { “description”: “Prefix for the name of resources.”Czytaj dalej / Read more
Azure Databricks deployment and error: SubnetMissingRequiredDelegation – VNet injection problem
The problem Are you surprised by the following error messages? Resource Microsoft.Databricks/workspaces [workspacename] failed with message : ResourceDeploymentFailure SubnetMissingRequiredDelegation Failed to prepare subnet. Please try again later? Sure, I was too 🙂 So, what the heck is going on? May I ask if you have used the benefits of theCzytaj dalej / Read more
SSAS database info (db size, partition size, processing status etc.)
Source: http://www.ssas-info.com/analysis-services-scripts/1197-powershell-script-to-list-info-about-ssas-databases slightly modified param($ServerName = “localhost”, $dbname = “db_name”) ## Add the AMO namespace $loadInfo = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”) $server = New-Object Microsoft.AnalysisServices.Server $server.connect($ServerName) if ($server.name -eq $null) { Write-Output (“Server ‘{0}’ not found” -f $ServerName) break } foreach ($d in $server.Databases ) { if ($d.Name -ne $dbname) { continue;Czytaj dalej / Read more
Maximum length of ADLS Gen2 path (and directory/file name)
Yeap 😐 If anyone was interested in this topic and did not find the answer in the official documentation (at least not explicitly), the answer is just above. I was wondering how far you could go in creating the directory path. I only found the limit given for anCzytaj dalej / Read more
“Internal error: An unexpected exception occurred.” when trying to filter simple dimension that has ragged parent-child hierarchy in multidimensional model.
Platform: SQL Server Analysis Services 2016 RTM and later (Multidimensional) In one of our projects, we encountered an interesting problem related to parameter filtering on one of our reports (SSRS). However, we would like to make sure that no mistake has been made before it hits as a bugCzytaj dalej / Read more
Uploading files to Azure Data Lake Storage Gen2 from PowerShell using REST API, OAuth 2.0 bearer token and Access Control List (ACL) privileges
Introduction In my previous article “Connecting to Azure Data Lake Storage Gen2 from PowerShell using REST API – a step-by-step guide“, I showed and explained the connection using access keys. As you probably know, access key grants a lot of privileges. In fact, your storage account key is similarCzytaj dalej / Read more