Voice of the DBA

Author: way0utwest

  • Some Numbers in 2019

    It’s the end of 2019, and I thought I’d look back at some data from this year. It’s been a busy, but wonderful year for me. I like numbers, so here are some stats from this year. They’re somewhat random, but interesting to me.

    Work

    • 181 podcasts
    • 61 flights on United
    • 139,000 miles flown
    • 12 International business class upgrades (makes a big difference going to work)
    • 5 countries visited (outside the US, 3 new ones for me)
    • 68 nights in Hilton hotels, 23 in AirBnBs, 3 in another hotel
    • 600+ pieces of content (articles, editorials, questions of the day, and blogs) published on SSC
    • 12 webinars
    • 8 SQL Saturdays attended (Memphis, Melbourne, Brisbane, Christchurch, Slovenia new ones for me)
    • 9 SQL in the City Summits (a high and none missed), along with 2 Streamed events

    Personal

    • 2 days snowboarding (a low in the last decade)
    • 1 Horse shelter built, 1 generator shed built
    • 1 year head coaching volleyball
    • Final 8 tournaments attended for my daughter’s club volleyball career.
    • 2 camping trips with horses (rode on one)
    • Read 125 books (all time high)
    • 4 comedy shows attended (finally, no kids!)
    • 230 workout days this year, a little low

    There are probably lots more things I could track, but these are the big ones for me, and certainly these help me think about next year. I want to ski more, build more things, and workout more. Not sure I’ll read more, but I spent the year re-reading some series and some of those went quickly.

    All in all, 2019 was great for me. Looking forward to seeing where 2020 takes me.

  • Looking Back at the Year

    Just two days left in 2019, and I thought this would be a good day to look back at the year. It’s been a busy and long year, but a great one for me. I hope many of you feel the same, but if it’s been a hard year, I hope next year is better.

    I started the year doing more learning for myself and some coaching 13 year old kids at volleyball. Those tasks kept my busy for the first third of the year, and I managed to get through a few books, learn a few skills, and enjoy some time with SQL Server. It was still busy, as I didn’t get a weekend off between Jan and April with either my daughter’s team or mine playing in a tournament.

    After April, I picked up the pace with events. I’ll close out the year with 9 SQL in the City Summits and 7 SQL Saturdays. That was most of my year traveling, apart from the pre-con days at the PASS Summit. I normally go to a few more conferences, but decided not to this year. This was not as much speaking, but a lot of travel. This was my biggest year, where I flew over 140,000 miles and spent nearly 90 nights away from home. Fortunately, about 40 of those were with my wife, which makes it much more enjoyable.

    This year saw a new release of SQL Server, one that I think is a milestone and will change the way we look at the platform. It will take a decade before most of our instances are at the 2019+ level, but this is the start of new ways to look at the platform with containers and scale out clusters. I’m excited by the possibilities and I look forward to how people will build systems in the future.

    It seems that security was less of a news item this year, though there were still plenty of incidents. I was amazed that after all the press about security issues that so many Elasticsearch servers are still out there with no password. There really is not good reason for this. I’d like to think that this is the line in the sand, and if you install a server with no password after today, you’re just terminated. Or arrested. That happened this year.

    Redgate turned 20 this year, which was amazing for me. I’ve known the company for 18 years and watched it grow and change in that time. I’ve worked there for 12 years, and hope to see 20. Next up is 20 years for SQLServerCentral, which will be just over a year away.

    I had a great year overall, and I’ll write more on my blog if you’re interested. I am looking forward to 2020, and I hope you are as well.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • The Best DBA Gifts

    It’s a few days after Christmas, which many of us celebrate, though there are certainly other holidays that people enjoy. Whatever your beliefs or tradition, this is a time of year when many of you likely received some gifts for the holiday season. Maybe you got something exciting, maybe something highly desired. Maybe you got a big joint gift for you and your partner. My wife and I used to give ourselves something nice that we’d both enjoy. In the past, we’d gotten new furniture for our bedroom or a big TV.

    The last few years, as my children have become adults, we’ve gone to a family Secret Santa. We have a limit ($40 this year), so I wasn’t expecting anything special, but I am always interested in seeing how creative others are. In the past I got a kid playing guitar and singing a song for me. I’ve also had some creative art projects in the last few years.

    There’s more to the season than gifts, but since many of us are in a slow time over the holidays, I thought I might ask what you wish you would get from work. Today, is there something that would make your job more enjoyable, interesting, exciting, or maybe just bearable in the future.

    You might want equipment, different hours, flex time, more considerate co-workers, better code written or something else. Let us know today, and then maybe think about a plan to convince someone else to help implement it at work. You might find you can get what you want if you ask for it the right way.

    I’ve got a great job, lots of benefits, and I can’t complain about anything. Perhaps the only thing that might make life a little easier next year is a few more article submissions. Maybe one of you out there wants to help me with that gift? I hope so, and I’m happy to help you in any way I can.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Installing PowerShell for SQL Server – #SQLNewBlogger

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

    PowerShell is the hot new scripting language for working with processes outside of an application. It’s cross platform, and it has a lot of capabilities for working with SQL Server. The way that this gets installed has changed, so this is a quick post to ensure others know how to do this.

    Running a Command

    I know there is an Invoke-SqlCmd cmdlet in PowerShell. On a new laptop, I tried to run it and had issues.

    2019-12-17 15_57_22-cmd - powershell

    SQLPS is the old module, and SqlServer is the new one. The error message says to try importing the module, so let’s do that.

    2019-12-17 15_59_40-cmd - powershell

    That doesn’t work either. Hmmm. I think I need to install this. To do that, I need an elevated command prompt. I’m using ConEmu, and I can restart this session as an admin. Or you can use the start menu to find cmd and start this as an admin:

    2019-12-17 16_02_41-Installing PowerShell for SQL Server - #SQLNewBlogger - Open Live Writer

    Once you have an elevated prompt, start PowerShell and then run this:

    Install-Module SqlServer

    This will install the module if you answer the prompts correctly. I had to use the -AllowClobber parameter as I had some conflicting things installed from dbatools. I’ll likely update those after this with their own AllowClobber.

    2019-12-17 16_05_24-cmd - powershell (Admin)

    Once this is done, you should be able to use the cmdlets. First you import the module with this:

    Import-Module SqlServer

    Then you can run code:

    2019-12-17 16_08_05-cmd - powershell (Admin)

    SQLNewBlogger

    After getting a new laptop, I needed to set a few things up. PowerShell was one of those. As I started to do this, I grabbed screenshots to document the process for my blog. I then built this post in about 10 minutes.

    You could do this as well, to round out the knowledge you gain as you do something similar, and show you’re familiar with these concepts.