Skip to content

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 →

Azure Data Factory Training Day at SQLBits 2020

On March 31st, I will be presenting my A Day Full of Azure Data Factory training day at SQLBits 2020. Yay! 🤓

Cathrine Wilhelmsen presenting her A Day Full of Azure Data Factory Training Day at SQLBits 2020

SQLBits is one of my absolute favorite events. I was literally jumping up and down when I got the news that I was selected as a speaker! 🥳 In addition to presenting a training day session, I will present a general session, and volunteer again on the other days. Woohoo!

If you are considering registering for SQLBits 2020, I highly recommend that you make a decision and register as soon as possible. Why? Because the prices go up on January 11th! Early bird pricing is only £999 for two full-day training days and three conference days. That’s a bargain! From January 11th, the price goes up to £1199. From February 15th, the price goes up to £1499.

You can also register for individual days. Check out the SQLBits pricing page for all the details, then go register!

Continue reading →

Personal Highlights from 2019

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.)

This is a total brag fest that I’m writing solely for myself. It’s my 2019 highlight reel that I can look back on when days get rough and I need a reminder that life is actually pretty awesome and I’m insanely lucky and privileged to be here. And when we get to 2025, future Cathrine can re-read everything and go “oh yeah, I remember that, we were so young and inexperienced back then, awww!” …like I do now with my old posts. It’s fun. You should try it! 😁

Lessons Learned in 2019

I also started writing about some of the more difficult parts of my year and what I learned from it… And in the middle of it, I realized that I’m not quite ready to share those thoughts yet. I still have lots of processing to do before I can turn my struggles into any kind of useful advice for others. I’m hoping to be able to do that in 2020.

But for now, I’ll share the short version:

Mark Manson taught me The Subtle Art of Not Giving a F*ck and it changed my life.

After reading that book in 2018 and reflecting on it for all of 2019, I’ve started learning to take responsibility for my own feelings, to set healthy boundaries for myself, and to choose my f*cks wisely.

So should you 💙

Continue reading →

Azure Data Factory Resources

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

For the past 25 days, I have written one blog post per day about Azure Data Factory. My goal was to start completely from scratch and cover the fundamentals in casual, bite-sized blog posts. This became the Beginner’s Guide to Azure Data Factory. Today, I will share a bunch of resources to help you continue your own learning journey.

I’ve already seen from your questions and comments that you are ready to jump way ahead and dive into way more advanced topics than I ever intended this series to cover 😉 And as much as I love Azure Data Factory, I can’t cover everything. So a little further down, I will share where and how and from who you can continue learning about Azure Data Factory.

But first…

That’s a wrap! Woohoo 🥳

Continue reading →