Voice of the DBA

Tag: syndicated

  • Daily 21 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 give thanks, list the kind things others have done for you.

    I am very thankful for my life, especially with where I am today. I tend to do many things for myself, but here are a few things people have done for me in the last week:

    • cooked for me
    • brought me something I forgot
    • bought me a drink
    • thanked me for doing my job
    • sent a kind note after I finished something
    • praised a piece of work
    • did a favor I asked
    • thanked me for cooking

    There are more, but I am finding myself taking note more often when someone does something kind, rather than dismissing or accepting it as something I’d do.

    Instead, I’m learning to feel gratitude for little things.

  • Saving PowerShell Results to the Clipboard–#SQLNewBlogger

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

    Working with results and manipulating them is always something I struggle with a bit in PowerShell. I’ve slowly been learning how to limit results to what I want and then save those out.

    Recently, I was reading Learn dbatools in a Month of Lunches, and I learned something new. I can save results to the clipboard easily. Here’s an example:

    Let’s say I want to get backups status. I’d run something like this, using the Get-DbaDbBackupHistory cmdlet:

    2021-12-07 09_44_04-C__Users_Steve

    I see results, but I might want to put this into a report or email that I send to others. I can certainly highlight this in the cmdline and copy it, but there’s an easier way.

    I can pipe this to clip, and then I don’t see the results.

    2021-12-07 09_44_08-C__Users_Steve

    Then I can CTRL+V and paste this into notepad (or anywhere).

    2021-12-07 09_44_12-_Untitled - Notepad

    Super handy way to take information from the PoSh cmdline and ensure I get everything. Miss-highlighting when not paying attention has caused me problems before, especially when the results scroll off the screen. Highlighting a lot of information is hard, so using clip is a good trick.

    SQLNewBlogger

    This was a quick trick I learned while doing something else, so I decided to write a quick post. This took me about 5 minutes to put together.

    You could do the same thing, showing how you’d use this in your job.

  • Daily Coping 20 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 look for something positive to say to everyone you speak to.

    In general, I’m a fairly positive person and I think most others are as well. I smile at people, wave, greet them, and get positive responses overall.

    I’m writing this a few days in advance, and while I didn’t see a lot, I did interact with a few people.

    • I stopped for coffee in the morning and made it a point to greet the person, ask how they were, smile, and wish them well.
    • I went to coach and greeted parents, thanking them for coming and supporting their kids. You’d think they’d all be there, but often I have only 1 of 2, or sometimes none there.
    • I did have to be hard on kids, but I did make a point of cheering things they did well and telling them where I liked their action or effort before asking for changes.
    • I made it a point to thank the staff at the venue, as well as ensure my team cleaned up their space.
    • Stopping for dinner, positive comments before and after the meal to staff, thanking them for their work and wishing them happy holidays.
    • Letting my son and wife know it was good to spend some time with them in the evening.

    Often I find myself thanking others for things they would do, or are responsible for, regardless of what I do. I know I’ve worked in the service industry, and it is nice to have some recognize you, even when it’s your job.

  • Daily Coping 16 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 see how many different people you can smile at today.

    I’m writing this a bit before, but I saw this item, so I started to track the list:

    • Guy at the ATV shop
    • Two people at the tire shop, as I walked by and stopped to say hi.
    • Repairman that came to the house
    • Receptionist at the gmy
    • Three random people I saw while working out.
    • Gas station attendant (no gas, just a soda Winking smile )
    • parent and receptionist at the volleyball gym
    • Team and coaches practicing before us (13)
    • My team (10).
    • My son

    Not a bad list for one day.