Daily Coping 2 Mar 2022

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. All my coping tips are under this tag.

Today’s tip is to give sincere complements to people you talk to today.

This was easy for me, mostly because I try to find positives in life. Just a few days ago I was at a larger volleyball tournament, and I went to see some kids that I have coached in the past. I got the chance to talk to some of them afterwards, and I complemented them on things that they did well, reminding them to be proud of the good things.

They had plenty of negatives to say about themselves, and I don’t coach kids who are on other teams, so I only had complements.

It was good to see the parents as well, and I thanked them for continuing to support their kids in volleyball, even though they aren’t on my team.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 2 Mar 2022

Goal Progress for Feb 2022

I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022.

February became more of a work month for me, and a somewhat busy month outside of work with life. I didn’t do enough on my career, and am more stalled than I’d like. I let distractions take over more than I should, and I felt a bit bad at the end of the month, rushing through some things the last week of Feb to make a little progress.

I’m slowing down, but at least I did something. I’m lowering the grade because I just didn’t do enough.

Grade: C+

Here are the goals:

Work

  • DP-900 – Passed
  • DP-300
    – Stated studying, practice tests around 60% correct
  • Demo with SQL Server – 5%
  • Demo with PostgreSQL – 0%
  • Demo with MySQL – 0%
  • Feedback book – 72%
  • Good Strategy/Bad Strategy – 0%

Personal

I made a slight alteration here. I didn’t try to hook up to Google Sheets, but instead pasted in some data and started to try and get this moving.

  • Link Google Sheets to Power BI – 0%
  • Create Report – 0%
  • Create Dashboard – 0%
  • Get people using it – 0%

Community

  • Support the Colorado groups by speaking twice and helping get one event set up
    – 33%

    • CO Springs event set up
  • Speak at 3 other user groups outside of Colorado – 33%
    • Spoke at DBA Fundamentals group
  • Support SQL Saturdays – Help get 10 events run in 2022
    • 3 scheduled, 2 more close
  • Volunteer 4 days with Habitat – 0 days
Posted in Blog | Tagged , , | Comments Off on Goal Progress for Feb 2022

Daily Coping 1 Mar 2022

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. All my coping tips are under this tag.

Today’s tip is to make a plan to change your daily routine for a day and see how you feel.

I tend to follow the same routines often, usually work, gym, cook, maybe some fix or chore. Changing up a routine is good, but it can be hard.

For me, I don’t sit still well. I usually have plenty of things to do, and I try to tackle something when I have free time. This might sound strange, but I don’t do well with taking days off. I’m either doing chores, fixing something, or coaching. Even my breaks for something like watching a football game are while I’m cooking or looking at the condensed game while playing guitar.

I wasn’t sure what to do with this tip, but last weekend we didn’t have plans. Or I didn’t. My wife had to work, but we had a weekend off from coaching, no plans, weather wasn’t great, so I decided to relax. I read in bed, watched some Netflix, played some guitar, but didn’t work on anything new.

I had a relaxed day, went to the gym later and sat on a bike for an hour, pedaling relatively slowly. Just taking it easy and doing a little work. I went to the store for groceries and had a relaxing time cooking dinner.

It was an odd, low stress, no hurry day for me. Unlike most of my life. I enjoyed the leisure, but felt the next day like I hadn’t done enough. I’d wasted time.

I accepted that, didn’t chastise myself, and moved on. Not likely to take many of those days, but I will take a few.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 1 Mar 2022

A New Command Palette in SQL Prompt

I’ve gotten used to using the Command Palette in VS Code/ADS/Sublime Text regularly to find some setting or change something. What felt strange at first has become a habit for me. I actually like having this one place to search and get things done.

It’s now in SQL Prompt.

If I press ALT+S, I see this in SSMS. A large command prompt with lots of entries.

2022-02-22 12_33_20-SQLQuery1.sql - ARISTOTLE_SQL2017.sandbox (ARISTOTLE_Steve (54))_ - Microsoft SQ

This popup lets me do a few things. If I start typing, I can get to most any object or SQL Prompt command from here. It’s like a global search for all things Prompt.

As an example, I can highlight an object and then ALT+S, type “object ex” and I’ll see this:

2022-02-22 12_35_27-SQL Prompt_ Command Palette

If I select the “Select in Object Explorer” (or click), the OE will navigate to that item.

2022-02-22 12_36_57-

Simple, and I could get there in other ways, but having all this in one searchable place, rather than right clicking and looking through a menu, or looking at the top menu bar, is easy. I even see the shortcut in the command palette (CTRL+F12) if I want to memorize it.

I can also use this for commands like insert semicolons, which I can never remember the shortcut for.

2022-02-22 12_38_50-SQL Prompt_ Command Palette

I can look for objects, commands, or options, filtering my results with the selection at the top. Or I can look in all areas. I can even look at the see the status of options in the palette, as shown here.

2022-02-22 12_41_38-SQL Prompt_ Command Palette

I have some things memorized, and the ALT+S isn’t quite in my muscle memory, but I am finding that I use it when I don’t know where something is located, or can’t remember a shortcut.

It’s a new feature, and the team is looking for feedback, so give it a try and let them know what you think.

If you don’t have SQL Prompt for SSMS and SQL Server, download an eval today and give it a try.

Posted in Blog | Tagged , , | Comments Off on A New Command Palette in SQL Prompt