Skip to content

Azure Data Factory Deep Dives in 2019

I’m very happy and honored to announce that I will be presenting three Azure Data Factory Deep Dives in 2019! Join me at SQLSaturday Oslo on August 29th, Data Saturday Holland on October 4th, or dataMinds Connect on October 7th :)

Improved and New Content

At SQLBits 2019, I co-presented the Azure Data Factory Deep Dive with Jason Horner (@jasonhorner). We received great and actionable feedback from our attendees (thank you!) and have been working on improving the session since then. That includes everything from moving sections around for a better flow, to adding newly released features like Wrangling Data Flows.

Since I will be presenting these deep dives alone, I have also made some additional changes. Without an experienced trainer like Jason by my side, I’m not entirely confident running hands-on labs during the day. Instead, I will be focusing on delivering the best and most updated content I can, and let attendees work through labs on their own :)

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.

Important Updates in June 2019

I passed exam DP-200 in May 2019, and published this post based on that version of the exam. In June 2019, the exam was updated:

List of updates to Exam DP-200 in June 2019

While most of the content in this post should still be relevant, there will be some differences between my skills measured checklist and the skills measured in this updated version of the exam.

Preparing for Microsoft Exam DP-200: Implementing an Azure Data Solution

When I started preparing for the DP-200 exam in February 2019, it had just been released. There were no courses, practice exams, or books available at that time. Instead, I relied heavily on Microsoft Learn and a lot of hands-on experience.

In short, this is how I prepared:

On April 3rd, 2019, the official classroom course was released. There is also a self-paced course available on Microsoft Open edX, and all the course labs are available on GitHub. I did not take either of these courses or work through the labs because I wanted to try the new learning paths from Microsoft, but you may find the more traditional courses useful.

So! In addition to the things I did to prepare, you may also want to:

Below, you can find more details about how I prepared with links to all the resources I used.

Continue reading →

Speaking at DataGrillen 2019

DataGrillen 2019 logo showing a bratwurst on a database-shaped grill

On June 20-21, I will be enjoying bratwurst and beer in Lingen, Germany – while speaking at DataGrillen 2019!

I’m so happy and thankful to be a part of this event again. Last year, when it was called SQLGrillen, there were a total of 35 sessions. This year, the event has grown to 50 sessions over 2 days! More time to learn and network, yay :)

DataGrillen 2019 Schedule

I will be presenting my session Uhms and Bunny Hands: Tips for Improving Your Presentation Skills on Friday, June 21st. This is a fun session to present, because I will show you all the presentation mistakes I’ve made over the years so you can learn what NOT to do :) I will also share tips on how to craft your session to help your attendees remember your key messages, how to prepare for demo failures and worst-case scenarios, and how to build confidence as a new speaker.

If you are looking for more technical sessions, check out the full schedule and speaker list. All I can say is: wow. That is one impressive line-up!

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 →