Author: way0utwest

  • Daily Coping 23 Dec 2021

    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 contact someone who may be alone or feeling isolated.

    I’ve done this a few times, but this is another good excuse to do so. I know a couple people that live alone, and I’ve worried about them a bit. I reached out and chatted a bit, just asking how they were and engaging in a bit of a conversation.

    It was good to touch base and I actually reached out to a second friend to check on them.

    It’s easy to forget how different someone else’s live might be and how lonely it can be to not be with others this time of year.

  • Searching dbatools–#SQLNewBlogger

    Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

    I learned something new about dbatools. That’s using the Find-DbaCommand cmdlet, which is handier than Get-Command. I’ll show you why in this post.

    Searching PowerShell

    You can search for commands with Get-Command. If I search for “key” in the dbatools module, I’d run this:

    Get-Command *key* -Module dbatools

    This returns me a number of items. In fact, it returns 11 items.

    2021-11-20 11_56_58-C__Users_Steve (Admin)

    That’s not bad, and this is how I’ve often been looking for command when I’m coding. This is faster than going to the index page on the site.

    Find-DbaCommand

    I was reading the upcoming dbatools in a Month of Lunches, and saw the Find-DbaCommand listed. If I use this, and include “key”, I get different results.

    2021-11-20 11_59_14-C__Users_Steve (Admin)

    This might be more than I want, but I thought this was a neat addition to the dbatools module to help someone find commands quickly.

    It is definitely easier than going to dbatools.io and trying to search for a command in the command list.

    SQLNewBlogger

    I learned something, and I sketched out how to explain it to someone. I took 5 minutes to knock this post together. You could do the same thing, but expand on a way that you actually use this to find a command.

    Might teach someone how a skill. Might even teach someone that wants to interview you.

  • Wellness Week

    I work for a great company, one that I feel cares about me as more than a “resource”, gives me opportunities (with responsibility and accountability, and has some nice benefits. I actually used one of those last week. I get a volunteer day every year, where I can spend time with a charity and get the day off. I used mine to volunteer for Habitat for Humanity in Denver.

    During the last two years, Redgate has approached the pandemic and remote work with the idea that we need to be reasonable with each other. We need to understand that some employees might have more people in their homes during work hours and may need to provide care for others. They might have other challenges, or just be struggling to cope. We were asked to work with people, rather than against them, and try to support each other as best we could. I think it worked out well, and it showed us that company cares about us.

    I know some other companies have done this, though not many. When a friend talks about how their employer supported them or others in difficult times, it’s always a surprise, and I am often impressed with how the organizations behave. I thought about that last month when I saw Spotify take a “wellness week” where they closed all their offices for a week. It won’t necessarily cure stress and overwork, but it is a bonus chance to let some people unwind.

    A few organizations have closed between Christmas and New Year’s, or around the holidays, often when they don’t have much business taking place. Often this is a chance for them to avoid some costs, and a fair number of them have done this without paying people for that time. It doesn’t affect white-collar workers, but it does affect blue-collar ones, and I think that’s a very poor message to send to your staff. Giving people an option of more time off is nice, but don’t prevent them from working if they need the paycheck.

    Lots of organizations slow down around this time of year, and they accept a lower amount of work getting done. I think that’s a better strategy, especially if you give people more flexibility to spend time with family or take care of business. Personally, I’d like to see more companies close down for the week and pay employees. If you’re not accomplishing much, maybe you should accept that and gain some goodwill by giving people a break.

    I know there are lots of roles where this isn’t easy. Knowledge workers have it easy compared to those that need to interact with people or things in the real world. We do know, however, the engaged and happy workers will do a better job. They’ll get more done, and they’ll produce more quality work. I like the idea of “wellness time” where possible to give employees a break. Even if you had to split your employees into two groups and give each half a break during different days, it might be a good investment to make in your staff.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

  • Planning 2022

    It is already looking like a more normal year for me in 2022. I was just accepted for DataGrillen 2022, which posted the schedule this week. As I added that to my list of events, I noticed that I already have a few things up there:

    • March 2-4 – Visual Studio Live, Las Vegas
    • March 9-12 – SQL Bits, London
    • May 14 – SQL Saturday Jacksonville, Jacksonville, USA
    • May 23-25 – Technorama, Antwerp
    • Jun 2-3 – DataGrillen, Germany somewhere

    I’ve also got trips planned to these places for volleyball as a coach, so it will be a busy H1 for me:

    • Las Vegas
    • Chicago
    • Reno

    I know more things will come, and I’m looking to submit to a few new events. There are also a few people planning SQL Saturdays, so I’m hoping that there will be more live events in 2022.

    I know the world feels shaky, but I’m confident. I get my booster tomorrow, and many people feel as like as I do. The goal of vaccination is to get back to doing the things we love, and I’m looking forward to doing so.