Daily Coping 30 Sep 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

Today’s tip is to ask a trusted friend to tell you what they like about you.

Not an easy thing. Asking someone what they like about you. Easier to ask family, or a partner, but that’s not part of this coping. I don’t have a lot of really close friends, so I had to think about who I’d ask and haven’t necessarily had a lot of contact with lately.

I got this back: I like that you are calm, wise, thoughtful, efficient, friendly, and fun.

Kind words that make me smile.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 30 Sep 2020

I Want PASS to Survive

I want PASS to survive.

I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many of my fondest memories, my widest smiles, and my deepest thoughts have been connected in some way to the PASS organization.

I want them to survive.

I’m also angry at them. The board, C&C, past directors, the whole last decade because of the way I think things have been run. I have my own demons here, with how I feel I’ve been poorly treated by the organization in the past. I am trying to set that aside, and focus on what’s important.

We need PASS to survive this year, which means we pull together and push forward. Let’s make this the best Summit we can.

There are plenty of people complaining about PASS, and the way the Summit is run. I do not think I could have done things better than anyone else has. Perhaps I could have, but I certainly could have managed things worse. I don’t know what data is inside this organization, or why decisions are made. Maybe there should be more transparency and accountability, but those are issues to examine after another 60 days. This year is a black swan event, one of a few that PASS has survived. Whether this organization should have been better prepared is also a discussion for late November.

I truly don’t think that anyone is trying to make bad decisions or upset others. Making decisions is hard, and I know there is a lot of pressure on everyone. I also think that it’s up to each of us to hold everyone accountable regularly, something that hasn’t been done often enough, or widely enough. Again, we can discuss and debate that later in the year, and certainly these are things anyone running for the board needs to address, but remember that a lot of things have gone wrong this year for everyone. At home, and in business. Certainly at PASS.

This Summit is a great opportunity to learn something, and get access to the content for a full year. There are some great pre-cons at a competitive price. Booking two of these and adding the Summit is a price that many of us would pay for two days of training. You can learn a lot in two days, and then access the rest of the content for a full year.

You also support PASS. I want them to survive.

I don’t want PASS to continue to operate in the same manner next year. I don’t want the same levels of accountability, transparency, financial disclosure or protocol. I want all that to be better. I think everyone involved wants that, and they want change.

For now, I want PASS to survive, and I hope you do, too.

If you’ve enjoyed a past Summit or a SQL Saturday or a virtual group, think about attending the Summit this year. Get some training, reconnect with those of us in the same industry, and get inspired by all the possibilities of what you can do with data in your job.

Posted in Blog | Tagged , | 7 Comments

Daily Coping 29 Sep 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

Today’s tip is to look at photos from a time with happy memories.

I try to take a lot of photos, and I love the various services that often show images from previous years. A few I’ve enjoyed lately from last September.

Last August, we dropped my daughter off at college, which was a little sad, but also very exciting.

IMG_20190815_135738_01

I went to London last year for work and my wife joined me. We took a side trip to Stonehenge.

20190908_141933

Then at the end of the month, just about a year ago, I flew to Sydney for a couple days to run a SQL in the City event there. I managed an afternoon of tourism.

20190926_133911

Posted in Blog | Tagged , , | 2 Comments

Fixing the PoSh Hotkey in ADS

I installed the PowerShell (PoSh) extension in ADS recently. This is available in the extension pane, and once installed, you get the 4th icon on the right added to your sidebar, for PoSh.

2020-09-10 15_07_51-poshtest.ps1 - Data Analysis - Azure Data Studio

I have the SSMS Keymap extension installed as well, since that was the first one I grabbed. This gives me keymapping to allow CTRL+E to execute queries. I have literally a decade of muscle memory here, and really wanted this to work.

However, when I highlight code in ADS and press F8, which is what I do in VS Code, I get this:

2020-09-11 14_42_34-poshtest.ps1 - Data Analysis - Azure Data Studio

Not only is my PoSh code in the editor tab not executed in the Terminal, but the Server Connection pane pops open.

This is because that’s what keymap does for F8. I can use the command palette to debug this.

2020-09-11 14_44_14-Keyboard Shortcuts - Data Analysis - Azure Data Studio

If I open up the keyboard shortcuts and search for F8, I find that a number of things use this.

2020-09-11 14_44_21-Keyboard Shortcuts - Data Analysis - Azure Data Studio

The last binding is the one that’s in effect, and you can see that the Show Connections overrides the PowerShell item.

Fortunately, I can edit this by clicking on the left of this line.

2020-09-11 14_45_41-Keyboard Shortcuts - Data Analysis - Azure Data Studio

Once the dialog pops up, it is there to capture any keystrokes, so it’s hard to get a picture of this. However, with a little experimenting, I remapped this to CTRL+L, which has some bindings, but these aren’t ones I use.

Now I see PowerShell as the last item, and if I close this tab, and go back to my code, I can press F8, and I’ll see the line executed in the terminal.

2020-09-11 14_47_45-poshtest.ps1 - Data Analysis - Azure Data Studio

Posted in Blog | Tagged , , | Comments Off on Fixing the PoSh Hotkey in ADS