On Saturday, January 30th, 2021, I will be speaking at the first Data Toboggan event! This is a free event focusing on Azure Synapse Analytics. There are 14 sessions scheduled in 12 hours, covering topics such as data integration, machine learning, data warehousing, data governance, and more. Join us 🤓
I will be presenting a session called Pipelines and Data Flows: Introduction to Data Integration in Azure Synapse Analytics.
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.
On the left side of the screen, you will see the main navigation menu. Click on the arrows to expand and collapse the menu:
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. 😊
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 :)
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:
In other applications like SQL Server Management Studio, Azure Data Studio, and Visual Studio Code, you simply use Alt+Up and Alt+Down.
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! 🤯😁
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!?” 😎
It’s December 31st, 2019. WHAAAAAT? 🤯 I have no idea how we’re almost in 2020, but here we are! Just a few hours left of the year. (Hi to my friends around the world who are already in 2020! 👋🏻) Like many others, I enjoy reflecting on the year that’s almost over. This year, I’ve decided to collect some of my highlights from 2019.
(Warning! There will be lots of tweets and pictures.)