Author: way0utwest

  • 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.

  • Contracting for Work

    Throughout my career, I’ve primarily been a full time employee for an organization. I have worked for myself, as well as for consulting companies. For the latter, I’ve been an employee as well as a contract worker. There’s a bit of difference between those, at least in the US, and it isn’t always easy to understand what that means for an individual.

    I thought about my various experiences while reading about Jon Shaulis’ T-SQL Tuesday post recently on changing his mind about contracting. He also has a section on T-SQL (bonus points for Jon), but the post is mostly about contracting and employment. Jon talks about some of the differences he’s seen between working for someone as a contractor and as an employee. His experiences are similar to mine, but I certainly wish I’d had a good list of these things when considering job offers in my 20s.

    There are lots of people in our #sqlfamily that have started consulting businesses, wanting to work for themselves and make more money. You can read various accounts of how well this works, but it certainly isn’t as smooth for everyone as it might seem. I like reading Brent Ozar’s yearly evaluations, and I’ve been following Eugene Meidinger’s journey as well. These aren’t about contracting too much, but they do give you an idea of what it’s  like to operate your own business, and as a contractor, you are your own business, though you have a little less of the “business” stuff to do since someone does the admin, selling, and marketing and just tells you what to do.

    I actually encourage everyone to consider themselves and contractor and don’t get too complacent with your job as an employee. You never know when you situation will change, and it’s good to be prepared. It might not even be you, as your spouse or partner might force you to make a change.

    Or your employer might.

    Just like a contractor might have one client for 10 years, I think it’s prudent to keep an eye on the environment and be prepared to find another client if some unforeseen event occurs. The days of single company employment for life are over for most of us. I have the best job, but I keep an eye on the market. One never knows when things might change for them.

    Deciding how to structure your employment is a decision each of us should make, but do so with an open mind and some understanding of the changes for work, benefits, savings, medical coverage, and more. While Jon has a good list, I’d love to see more people build and publish a structured checklist in terms of decisions and costs, even sample ones. This can help others get an idea of what the impact might be on their life when making a decision like this.

    No matter whether you choose to work for an organization or as a contractor, it’s not a final decision. You can change your mind anytime, though do so with some planning and consideration of the impact on you and your family. It’s not an easy decision, but you should be comfortable with your choice when you finally do make it.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.