Voice of the DBA

Author: way0utwest

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

  • A Dearth of Data

    Most of us feel that our data volumes are constantly growing. A lack of data isn’t something we worry about, at least not in production. In development, far too many people use sensitive data for developers, which certainly ensures there is enough data, but at a potential increase in liability if the data is mishandled.

    If we require developers to create their own data, often there is a problem with them not having enough, or certainly not a representative set that helps ensure the software meets enough of the specifications. This is a challenge, and while random data helps, it doesn’t always work well. This problem might be hard to solve with OLTP systems, but what about an AI or ML scenario, where we might need lots of data to train a system?

    Microsoft Research is working on ways to solve this problem. They presented a paper on Icebreaker, a technique that uses minimal data to train a model. I’m not sure I completely understand how this works, but the idea is to be able to work with very little training data and somehow still train the model. I’m guessing there is some ML inside of the process itself.

    There are all sorts of downsides with using existing data to train models. Sometimes we have inherent bias, or otherwise skewed data. Allowing a model to work with less data, and perhaps then working to change, or even skew, the data to meet our goals might help. Certainly this likely requires input and feedback from a data scientist of some sort, but that might be where we take advantage of the skills and knowledge of that staff.

    There will be more use of the AI/ML technologies in the future, if for no other reason than people are very interested in how this can improve the way that systems can help analyze data. Of course, techniques like this might help us deal with the challenges of doing so when we don’t have all the data we would like to have while building the model.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.