Author: way0utwest

  • The Costumed DBA

    It’s Halloween today, which is a day when children typically dress up and go looking for candy. It’s supposed to be trick or treat, but I’ve seen relatively few tricks and lots of treats with my kids. No Halloween for me, and likely a quiet day as I get ready for travel to Seattle and try to relax at home for a few days. My kids are grown and no others come to my house out in the country.

    More than a few adults will dress up in costume today. Some will come to work in an outfit, which is something I’ve done in the past. In my 20s, I’d wear a gorilla mask and hands, frightening more than a few people who weren’t expecting a hairy hand to fall on their shoulder or hand them a report. I haven’t done that in years, and I think those days are behind me.

    Some people will dress up at night, going out to have fun at a party. Surrounded by others that are enjoying themselves, or competing to see how creative you can be is fun. Perhaps you dress up to take your kids out and enjoy the night with them.

    Many of us do need to work today, as Halloween isn’t a holiday in most organizations. We’ll have various experiences at work, maybe a horrific day when we break something with the wrong click or poorly structured code. Maybe we’ll do something heroic that saves the day, or at least helps someone else.

    With today a costume day, I want to ask you which character, hero, icon you’d like to emulate in your daily work. Is it a computer scientist like Alan Turing? Maybe Iron Man that flies in to rescue a disaster? Maybe you’re the fireman that shuts down a problem. Let us know what costume you’d like your work to wear.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Removing SSMS Completion Time–#SQLNewBlogger

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

    If you’ve upgraded your SSMS lately, you might have seen this. Queries now have a completion time on the Messages window.

    2019-10-17 17_15_23-SQLQuery1.sql - Plato_SQL2017.sandbox (PLATO_Steve (52))_ - Microsoft SQL Server

    On one hand, I think this is great, because I can tell that I’ve run this recently. On the other hand, I might have multiple batches, so I can get confused or mis-informed. I also just don’t like this.

    Microsoft didn’t agree, because at first, I couldn’t remove this. That was really annoying. However, with  SSMS v18.3.1, I can.

    If I go to the SSMS Options, and then go to Query Execution | SQL Server | Advanced, I see this:

    2019-10-17 17_18_34-Options

    At the bottom of the first column is the Show completion time checkbox. Uncheck this, and suddenly, I’m happy.

    2019-10-17 17_19_52-SQLQuery2.sql - Plato_SQL2017.sandbox (PLATO_Steve (59))_ - Microsoft SQL Server

    One caveat, I do need to open a new window. That old window, even if I change the connection, still shows the time. Fortunately, CTRL+A, CTRL+C, CTRL+V help me move on.

    SQLNewBlogger

    This was one of those annoying things I needed to fix because it impacted my productivity. It’s a perfect post of my finding a way to be more productive and learning on my own.

  • Republish: Rogue Software Changes

    On site with a customer today, so busy all day. You get to read Rogue Software Changes while I’m working.

  • OK, Microsoft Teams is cool

    I’ve had a lot of video collaboration tools come across my desk over the last decade. I’ve depended on many of these to communicate with Redgate in the UK as well as Microsoft for feedback, coordination, etc. I’m regularly on calls with people where we need to present or share a screen.

    Probably a few I’ve forgotten, but I’ve used:

    • Oovoo
    • Broadcast.net
    • GotoMeeting/webinar
    • Webex
    • join.me
    • Skype
    • Skype 4 Business
    • Slack
    • Teams
    • On/24
    • Zoom

    For awhile, we settled on Skype for Business at Redgate, where most meetings (scheduled or impromptu) were on this platform. It worked well for my on both my Windows 10 machines, and I got used to it. However, it was an issue for the OSX people. At Redgate, we’ve somewhat settled on Zoom as the current in house platform, but I still get Skype and Slack calls.

    Recently I got a note about an MVP call with Microsoft. It was on Teams, which is their standard. I didn’t think I’d make it, so I deleted the invite from my computer. Then, plans changed, and I was scrambling.

    I did see the meeting invite on my phone calendar, so I clicked that and started Teams on my Android phone. I could hear, but I struggled to see. Even a 5.5” screen isn’t great for 50+ year old eyes. I opened Teams on the PC, thinking that maybe the invite was there, but to my surprise, the meeting opened, with a “join” link. I could see in the timeline that “Steve Jones” had already joined. I clicked the link and got the screen share on a PC where I could see.

    That was cool. Skype will track a call I’ve had and scheduled meetings, but it doesn’t seem to always sync between my phone and PC. Very cool.