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!
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.
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.
After about an hour of messing around with it, I noticed a Keyboard Modifier menu option. 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.
Maybe this won't help anyone else, but hopefully it will.