Skip to content

Overview of Azure Data Factory User Interface

This post is part 3 of 26 in the series Beginner's Guide to Azure Data Factory

In the previous post, we started by creating an Azure Data Factory, then we navigated to it. In this post, we will navigate inside the Azure Data Factory. Let’s look at the Azure Data Factory user interface and the four Azure Data Factory pages.

Azure Data Factory Pages

On the left side of the screen, you will see the main navigation menu. Click on the arrows to expand and collapse the menu:

Animation of expanding and collapsing the pages menu in the Azure Data Factory user interface

Once we expand the navigation menu, we see that Azure Data Factory consists of four main pages: Data Factory, Author, Monitor, and Manage:

Screenshot of the Azure Data Factory user interface showing the four main pages: Data Factory, Author, Monitor, and Manage
Continue reading →

Renaming the default branch in Azure Data Factory Git repositories from “master” to “main”

In Azure Data Factory, you can connect to a Git repository using either GitHub or Azure DevOps. When connecting, you have to specify which collaboration branch to use. In most cases, the default branch is used. Historically, the default branch name in git repositories has been “master“. This is problematic because it is not inclusive and is very offensive to many people.

The Git project, GitHub, and Azure DevOps are making changes to allow users to specify a different default branch name. GitHub and Azure DevOps will be changing their default branch names to “main” in 2020. I fully support this change and will be doing the same in my projects.

In this post, we will go through how to rename the default branch from “master” to “main” in Azure Data Factory Git repositories hosted in GitHub and Azure DevOps. Then we will reconnect Azure Data Factory and configure it to use the new “main” branch as the collaboration branch.

For these examples, I’m using my personal demo projects. I’m not taking into consideration any branch policies, other users, third-party tools, or external dependencies. As always, keep in mind that this is most likely a larger change, both technically and organizationally, in production and enterprise projects. 😊

The Short Version

  1. Create a new “main” branch in your Git repository
  2. Set the new “main” branch as the default branch in your Git repository
  3. Delete the old “master” branch in your Git repository
  4. Disconnect from your Git repository in Azure Data Factory
  5. Reconnect to your Git repository in Azure Data Factory using the new “main” branch as the collaboration branch
Continue reading →

Sneaking back in… (2020 edition)

Oh, hi there! Just… you know… sneaking back in…

Some of you may have noticed that I have been offline for a while. I shut down my blog, stayed off social media, and took a break from everything this summer.

The short version of this blog post is: I have reopened my blog and I’m looking forward to catching up with you on social media 💙 But like the title says, I will be sneaking back in. Slowly. The world is a very weird place, and I don’t expect things to go back to normal any time soon. Adjusting is going to take time.

It’s going to take time for me to update myself on recent technical changes, and even more time updating my content. I know a lot of my content is already outdated. It bothers me, and I want to update it. But it’s not going to happen immediately or all at once. And that’s ok. Because I’m not ok, you might not be ok, the world is certainly not ok, and it’s ok to not be ok for a while.

It will get better, eventually. Right now, I’m prioritizing my family, my health, my friends, my job, trying to do better. This stuff? *gestures at blog* This can wait. But all my posts are available again, because hey, even though some of it might be slightly outdated, I still hope it can be useful for some 😊

…now what?

Today is the last day of my vacation, and I have big plans. I’m going to sit outside and read, then I’m going to go back inside to watch TV, then I’m going to get a good night’s sleep. A proper, lazy, relaxing Sunday 🌞

Summer in Norway
Sneaking back in... like this butterfly

Tomorrow, I will start working again. And that’s a natural way of getting back into things, reading up on the latest technical releases, tweak some posts, update some slide decks… And then I’ll take it from there. One day at the time. Like we all have to.

It’s good to be back. I’ve missed you all 🤗

Keyboard shortcuts for moving text lines and windows (T-SQL Tuesday #123)

Keyboard shortcuts for moving text lines and windows (T-SQL Tuesday #123)

This month’s T-SQL Tuesday is hosted by Jess Pomfret (@jpomfret). She wants to hear about life hacks to make your life easier! In this post, I share two of my most-used keyboard shortcuts. One for moving text lines up and down without copying and pasting, and one for moving windows around without dragging and dropping. I use these all the time :)

Moving text lines up and down

Previously, I was moving text lines up and down in a couple of different ways. Have you ever marked all the text on a line, copied it, then pasted it again? Yeah, I did that all the time. And then I discovered there’s an easier way! Yay :)

There are a couple of different flavors to this keyboard shortcut.

In Office applications like PowerPoint and OneNote, you use Shift+Alt+Up and Shift+Alt+Down:

Recording of my two monitors. The left monitor shows the keystrokes.

In other applications like SQL Server Management Studio, Azure Data Studio, and Visual Studio Code, you simply use Alt+Up and Alt+Down.

Moving windows around or between screens

Similarly, I was previously dragging windows around multiple monitors using my mouse. Then I discovered you can use Win+Arrows to move windows around. And then I discovered that you can use Win+Shift+Arrows to immediately move windows to the same position on other monitors. Are you showing a full-screen application while presenting? Just win-shift-arrow it to the extended screen and you look like a total pro. Whaaat! :D

Recording of my two monitors. The left monitor shows the keystrokes.

Keyboard all the things!

There you go. Two of my favorite, useful, and timesaving keyboard shortcuts! I use these so much that I don’t think about them anymore – until someone goes “whoa whoa whoa wait what magic did you just do!?” :D

What are your favorite keyboard shortcuts?

Speaking at NIC 2020

NIC 2020

On February 6-7, I will be presenting Understanding Azure Data Factory: The What, When, and Why at NIC 2020 in Oslo 🥳

NIC 2020 is a brand new event for me, both as an attendee and speaker. It takes place in Oslo Spektrum, one of Norway’s largest indoor arenas. When I hear Oslo Spektrum, I think of concerts, so I’m very excited to see what it’s like to attend a conference there! I really have no idea what to expect at this event, and that’s fun 🤓

NIC 2020 Schedule

NIC is short for Nordic Infrastructure Conference, so it’s not my typical data conference. However, I will do my best to make my session even more relevant to this audience. I want to add a few more slides about where Azure Data Factory fits into architectures and solutions, for example. I’ll do some brainstorming. Hmm. Challenge accepted!

Continue reading →