Skip to content

Category: SQL Server and Azure

These posts are about the Microsoft Data Platform, including SQL Server and Azure products and services. Topics include T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server Management Studio (SSMS), Azure Data Studio (ADS), Azure Data Factory (ADF), Azure Databricks, Azure SQL Databases, Azure SQL Data Warehouse and Azure Data Lake Storage.

Presenting Three Sessions at Microsoft Ignite 2019

From November 4-8, I will be at Microsoft Ignite 2019, yay :) This year, I’m presenting three sessions! One breakout session and one theater session on Azure Data Factory (ADF), as well as one Diversity and Inclusion breakout session on personal branding.

Microsoft Ignite 2019 Sessions

Cathrine Wilhelmsen is speaking at Microsoft Ignite 2019
Continue reading →

Preparing for and Taking Microsoft Exam DP-201 (Designing an Azure Data Solution)

On January 31st, 2019, Microsoft released two new Azure Data exams: Implementing an Azure Data Solution (DP-200) and Designing an Azure Data Solution (DP-201). If you pass both of these exams, you become a Microsoft Certified Azure Data Engineer Associate. On June 17th, 2019, I passed DP-201: Designing an Azure Data Solution! Since I had previously passed the DP-200 exam, I also became a Microsoft Certified Azure Data Engineer Associate, yay :)

In this post, I share how I prepared for the exam and what my experience was like on the day of the exam.

Continue reading →

Preparing for and Taking Microsoft Exam DP-200 (Implementing an Azure Data Solution)

On January 31st, 2019, Microsoft released two new Azure Data exams: Implementing an Azure Data Solution (DP-200) and Designing an Azure Data Solution (DP-201). If you pass both of these exams, you become a Microsoft Certified Azure Data Engineer Associate. On May 24th, 2019, I passed DP-200: Implementing an Azure Data Solution! I am now halfway to my first Azure certification, yay :)

In this post, I share how I prepared for the exam and what my experience was like on the day of the exam.

Continue reading →

Comparing Mapping and Wrangling Data Flows in Azure Data Factory

In 2019, the Azure Data Factory team announced two exciting features. The first was Mapping Data Flows (currently in Public Preview), and the second was Wrangling Data Flows (currently in Limited Private Preview). Since then, I have heard many questions. One of the more common questions is “which should I use?” In this blog post, we will be comparing Mapping and Wrangling Data Flows to hopefully make it a little easier for you to answer that question.

Illustration of Person Comparing Mapping and Wrangling Data Flows in Azure Data Factory

Should you use Mapping or Wrangling Data Flows?

Now, we all know that the consultant answer to “which should I use?” is It Depends ™ :) But what does it depend on?

To me, it boils down to a few key questions you need to ask:

  • What is the task or problem you are trying to solve?
  • Where and how will you use the output?
  • Which tool are you most comfortable using?

Before we dig further into these questions, let’s start with comparing Mapping and Wrangling Data Flows.

Continue reading →