Voice of the DBA

Category: Blog

  • Cleaning Up Registered Servers

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

    I was working with Get-DbaRegServer from dbatools and got some errors. When I dug through the errors, I noticed some interesting items listed in my server list. This is what I saw:

    2020-03-30 10_18_14-cmd - powershell (Admin)

    While all the servernames are valid, the names are a little silly. I initially thought some of these were the reason for my errors with the cmdlet, but they weren’t. Still, I want to remove a few of these.

    I can likely find these in the registry or elsewhere, but there’s an way way to see this: SSMS. Under the View menu, there is a Registered Servers item.

    2020-03-30 10_22_23-

    Clicking this will get me a new pane, where the Object Explorer lives.

    2020-03-30 10_22_35-Solution1 - Microsoft SQL Server Management Studio

    If I expand this, I see a few categories, including my Azure Data Studio (ADS) connections and groups. It’s a nice way to see what’s registered.

    2020-03-30 10_22_44-Solution1 - Microsoft SQL Server Management Studio

    For the Local Server Groups for SSMS, I can highlight an instance and click “delete” to remove it. You get a confirmation dialog, but it’s removed. I can this in PoSh. Instance001 and 002 are gone.

    2020-03-30 10_29_47-cmd - powershell (Admin)

    I can’t, however, remove the ADS ones. I get this with a right click (nothing with Delete).

    2020-03-30 10_27_29-Solution1 - Microsoft SQL Server Management Studio

    The integrations between SSMS and ADS do not extend to altering the connections.

    Simple stuff, but handy to have around, especially over time as you add lots of registrations over time.

    SQLNewBlogger

    This took about 3-4 minutes to figure out as a part of other things I was doing, but I made a few notes and then spent 10 minutes writing this up and taking screenshots.

    This is a good place to start blogging if you want to get going.

  • The Car Game

    I started this on Facebook, privately with friends. I heard about it from one of them and liked it. I didn’t get many guesses, so I took a chance and posted on Twitter.

    Some good guesses, but I decided to drop it here as well. Leave a comment with your guess. Play along if you like and give me a trackback and I’ll take my guess.

    The Game

    The game is to list some cars you’ve owned in your life (or your family has) and add a fake one. List however many you want, include years if you’d like/

    Here’s my list. Use the number when guessing. I added more and included some years, where I knew them.

    1. 1988 Porsche 911
    2. 1991 Acura Integra
    3. 1977 Pontiac Bonneville
    4. 1980 Chevy Suburban
    5. 2004 Honda Odessey
    6. 1974 Porsche 914
    7. 1977 VW Scirocco
    8. 1990 Isuzu Trooper
    9. 1982 Saab 900
    10. 2007 Dodge Durango
    11. 2010 Chevy Silverado
    12. 2011 2500 Dodge Ram 3500
    13. 1991 Mercedes 240D
    14. 2007 Toyota Prius
    15. 2010 Toyota Prius
    16. Pontiac Station wagon
    17. Ford F250
    18. 1997 Isuzu Trooper
    19. 1984 Chrysler Town and Country
    20. Jeep Grand Cherokee
    21. 1980 Pontiac Bonneville
    22. Yukon XL
    23. 2001 Chevy Suburban
    24. 2004 Dodge Grand Caravan

  • Daily Coping 10 Apr 2020

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

    Coping today is to make time for self-care. Do something kind for yourself.

    Hmmm, what can I do here. I already do a lot for myself, but I’m going to do some baking on Friday afternoon. I find cooking and baking relaxing, especially after work and working out, and with an adult drink. Since there’s no going out, I’ll spend some time in the evening making something.

    My daughter is gluten sensitive, so a lot of the traditional way I’ve cooked things for most of my life doesn’t apply. This is especially true for baking. I did get a cookbook from Nicole Hunn for small bites that I’ve made a few things from.

    This week, I think I’ll tackle a cheesecake made gluten free. That would be a nice treat.

  • Daily Coping 9 Apr 2020

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

    Today the tip was to make some progress on a project that matters to you.

    Fortunately, I had a timely delivery today. This has been my desk and chair.

    20200409_121155

    I heard a truck this morning and then got this:

    20200409_114145

    I’d been meaning to upgrade my situation for some time, ever since I visited Glenn Berry and sat in his chair.

    I opened the box to a nice greeting.

    20200409_114425

    Took a break to assemble things.

    20200409_115423

    And voila

    20200409_121315

    Way more comfortable and I can physically see a difference. Next up, I need to spend some time putting up a better charging station to organize my desk. This is the current one:

    I’d like something more like this, with more room to organize part of my desk

    2020-04-09 12_38_06-(281) Pinterest