azure

Today, I’m excited to announce the general availability of database designer in Azure Synapse Analytics. The database designer allows users to visually create databases within Synapse Studio without writing a single line of code. The designer also enables users to explore database templates, customiz

Do you work as part of a data science team that spends a lot of time re-creating features? A Feature store is a centralised repository that allows data scientists, machine learning engineers, and data engineers to collaborate, share and discover features. This article will walk you through the proce

Reference architectures are great but how do you secure your new Data Lakehouse platform enough to make InfoSec happy? Let’s dive into design patterns for securing Databricks

Building upon Azure Databricks, I'll move from the compute engine to data storage. Things are a little simpler to secure but the plethora of options available can have significant impacts on usability and cost

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It’s so much more than SQL Server! Adam and Patrick look at why you should care about it! What is Azure Synapse Analytics? https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

Azure Bastion is a fully managed jumpbox-as-a-service that provides secure and seamless Remote Desktop Protocol (RDP) and Secure Shell Protocol (SSH) access to your VMs in local or peered virtual networks. With native client support available on the Standard SKU for Azure Bastion, you now unlo...

Today, I’m excited to announce the general availability of database designer in Azure Synapse Analytics. The database designer allows users to visually create databases within Synapse Studio without writing a single line of code. The designer also enables users to explore database templates, customiz

A new Power BI Custom Connector for the Power BI REST API. Just download the file and start using it! Is that easy!

A guide to making your Power BI custom connector for Power Apps and Power Automate

Two ways to build and deploy static websites with Azure

Hello, for the last 10 years, I have been writing on and of about my experiences on a personal site (like this one) and in that time, I have moved from platform …

I love WordPress, yet I wanted to see if I could generate a static site by using WordPress as a content management system.

Install Hugo on macOS, Windows, Linux, OpenBSD, FreeBSD, and on any machine where the Go compiler tool chain can run.

Contribute to rukmani-msft/adlsguidancedoc development by creating an account on GitHub.

I’m assuming You have figured out how to google a few skills and create a few PBI reports that refresh on their own without five people on…

Solve your SQL Server SQL Azure issues with these valuable tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

In this article we look at how to call Logic App synchronously from Azure Data Factory.

Sometimes in life you have to do things you really don't like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData source component for this task, as described in one of my most popular articles ever: Reading SharePoint Lists with Integration Services 2017 (I'm not

Learn how Azure Functions can help build robust serverless apps.

I was ready for a nice relaxing evening today, when an email appeared in my inbox “Azure Purview is now Microsoft Purview!” Initially I thought… yeah.. “just another Microso…

Azure Data Factory V2 allows developers to branch and chain activities together in a pipeline. We define dependencies between activities as well as their their dependency conditions. Dependency con…

Best practice for structuring your Azure Data Factory? Hello friends, this post and my next few posts have been born out of a community talk I’ve delivered a couple of times now at various co…

A live demo failed, so here's a recorded video on how to handle schema drift in Azure Data Factory, using the Mapping Data Flows feature :)

Which feature should you use to transform data in Azure Data Factory? Find your answer by comparing Mapping and Wrangling Data Flows.

Learn the supported connectors in Azure Data Factory and Azure Synapse Analytics pipelines.

Below is a method to use in ADF’s Mapping Data Flows to reduce the data stream in your data flows to only include distinct rows. This sample is available as a pipeline template here. Choose y…

Here is a quick walk-through on how to use Azure Data Factory’s new Data Flow feature (limited preview) to build Slowly Changing Dimension (SCD) ETL patterns. The Data Flow feature in ADF is …

I have been putting together a series of posts and videos around building SCD Type 1 and Type 2 using Mapping Data Flows with Azure Data Factory. In this latest post, I’m going to walk throug…