Data skew is one of the most important considerations when working with Azure Synapse Analytics. Data skew is the uneven distribution of data across data storage distributions in SQL Dedicated Pools. In this post, you’ll learn how to monitor the data skew in your Azure Synapse Analytics SQL Pool. About Data Skew To begin, data skew is when your data is not distributed correctly across different… READ MORE
In this post we’ll walk through the steps you can take to give a Service Principal a role with “Least Privilege” in Azure. After reading this article you will have a very practical method that you can use over and over again. You will be able to create roles for your Service Principals that will… READ MORE
There’s a newer feature in Log Analytics that you may have missed. This feature makes it much, much easier to share your fantastic KQL query creations with the world and puts the real work on the folks at Microsoft. In the Logs blade in any Log Analytics workspace, under the Share option, there’s a new Share to community option.… READ MORE
Conditional Access is great. However, when it comes to managed devices it only allows to check for Hybrid Azure AD join and Intune compliance. With Microsoft Cloud App Security (MCAS), we can also require a certificate to be present on the client to get access. In this post I’ll show you how to do that.… READ MORE
Join Pascal Strassl, Miba AG, Austria for this short ‘How To Set up Infrastructure with Azure Pipeline + Terraform’ video.
Terraform-based deployment of almost all Azure Data Services (default deployment settings are in the parenthesis): Azure Service Bus (Standard, namespace,topic,subscription, auth. rules) Azure Data Lake Storage (ZRS, Hot, Secured, StandardV2) Azure Data Factory (w/Git or without) Azure Data Factory linked with Data Lake Storage Azure Data Factory Pipeline Azure DataBricks WorkSpace (Standard) Azure EventHub (Standard, namespace) Azure Functions (Dynamic, LRS storage, Python, w/App.Insights or without) Azure Data Explorer (Kusto, Standard_D11_v2, 2 nodes) Azure Analysis Server (backup-enabled, S0, LRS, Standard) Azure Event Grid (domain, EventGridSchema) Azure SQL Server (version 12.0) Azure SQL Database (ElasticPool SKU name, 5 GB max data size) Azure SQL Elastic Pool (StandardPool, LicenseIncluded, 50 eDTU/50GB) Properties and content… READ MORE
Accessing data in different data sources is one of the main tasks in machine learning model development life cycle. Let’s discuss one of the most common data accessing scenarios. Scenario : We have to set of relational data points stored in a Azure SQL server to develop a machine learning model using Azure Machine Learning.… READ MORE
Monitoring the ‘Elevate Access Activity’ by Global Admin is a bit tricky operation and so far I have only found it possible with the Microsoft Cloud App Security (MCAS). Last year, I wrote about how you can do it with MCAS. The ultimate solution would be to monitor the activity in Azure Sentinel and, in this blog… READ MORE
In this blog post, you will learn how to use the Rust programming language to interact with Redis using the redis-rs client. We will walk through commonly used Redis data structures such as String, Hash, List etc. The Redis client used in the sample code exposes both high and low-level APIs and you will see both these styles in action. Code… READ MORE
Many organizations use Azure AD Connect Sync to synchronize hybrid identities from Windows AD to Azure AD DS. Microsoft recently announces a new service, Azure AD Connect Cloud Sync, that also synchronizes Windows AD identities to Azure AD. In this video, we go over how they are similar, features that are different, and when to… READ MORE
