How to get all column names for a table in a sql query 21 April, 2020

I always forget how to do this, so I decided I'd write it down.

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Table_Name'

And that's it! Now I can call this query and get all the columns names for a given table without having to dig through some GUI.


Mx Master 3 Customize Gesture Button to use Task View 20 April, 2020

So a little background. I recently purchased a Logitech MX Master 3 (and an MX Keys, but we'll save that for later) and I really love it. To be fair though, I have had the original MX Master for like 3 years now. They are incredible products and I will probably keep purchasing them as they are released.

Back to what I started this post for! I have the MX Master and something special about the mouse is that it has a sort of tray for your thumb and that tray contains a button. This button, once you get used to its odd positioning, is great because you can click it for macros or you can click and hold and move the mouse for gestures. Pretty sweet!

Logitech Options showing MX Master 3
Logitech Options showing MX Master 3

I believe to do any of the above, you'll need to install the Logitech Options app. I've used it on macOS and windows 10 and have no complaints. This setup is all related to my work setup in windows, though I imagine you can do something similar in macOS.

Logitech Options showing gesture button highlighted
Logitech Options showing gesture button highlighted

Once you've installed this you can customize your gesture button. There are some presets, but I wanted to use only the virtual desktop switcher and the windows 10 task switcher. Adding the virtual desktop switching gestures was easy enough because there are items in the menu specifically for this. As far as I can tell, this is not the case for the Task View. You can see it set for clicking the gesture button in the preset, but I couldn't find it in the menu.

The preset I wanted to base this on, with Task View in the bottom left
The preset I wanted to base this on, with Task View in the bottom left
The custom preset I made and that I've been using for several years
The custom preset I made and that I've been using for several years

After about an hour of messing around with it, I noticed a Keyboard Modifier menu option. Salvation!

Salvation!
Salvation!

I could just trigger the Task View with win + tab. How wonderful! Now I can switch left or right to a different desktop and click the button to quickly move windows to other desktops.

Setting the keyboard shortcut I want!
Setting the keyboard shortcut I want!

My Custom Preset With Task View
My Custom Preset With Task View

Maybe this won't help anyone else, but hopefully it will.


Who Am I? 16 January, 2019

Hi, I'm Nick Kaczmarek. I'm a software engineer working in Cleveland, Ohio for a company called Hyland Software.