Voice of the DBA

Category: Blog

  • Project Euler

    I like having problems to practice solving in computer science. It can be a fun hobby, and it exercises your mind. I have enjoyed the Advent of Code, though some of those are complex and hard to focus on in my busy life.

    My middle son asked about Project Euler as he finished his first year of college and suggested we try some together. He’s been busy, though I have called him down as I’ve solved one or two. He’s asked I send him my code, which I’m doing in Python as practice. He’s using C++, which is something he’s studying, but he knows some Python.

    These are all math based problems, and most are short in the archives. I’ve been trying to take 5-10 minutes and solve 1 a day. I’ll ping my kid when I’m working, and we might pair program a bit to get a solution.

    Not terribly challenging, but it is a different type of thinking from most data work, and it can be fun. If you want to take a break from other work, maybe experiment with a new language, give Project Euler a try.

  • No @@ServerName on Linux

    I setup a new instance of SQL Server on Linux some time ago. At the time, the Linux machine didn’t have any Samba running, and no real “name” on the network. As a result, after installing SQL Server I got a NULL when running SELECT @@SERVERNAME.

    The fix is easy. It’s what you’d do if you had the wrong name. You run:

    sp_addserver ‘Ubuntu’, Local

    In this case, Ubuntu was the name I gave my machine under the Samba server, since that’s the OS. I don’t plan on adding more for now, so this is fine.

    After the chance, I couldn’t restart the instance from SSMS, so on the host itself, I ran a

    sudo systemctl stop mssql-server
sudo systemctl start mssql-server

    That completed, and my @@servername is now working.

  • The June 2018 SQL in the City is coming

    We’ve got the schedule up and you can register today. Once again I’m heading to the UK, along with Grant, to broadcast a series of sessions that we hope will help you learn a bit more about building better database software and protecting data.  Kathi’s recording her session as she’ll be in Hawaii that week (she declined to trade with me).

    The theme this time is Compliant Database DevOps. Lots of people are struggling and coming to terms with the GDPR changes. I’d argue, as would others, that really most of the world ought to have better data handling, so we’ll give you some thoughts and ideas here of how to do this. We’ll use some Redgate products, but we’re hoping you get the overall concepts and ideas as well.

    Join me on June 20 and get a one day conference from the comfort of your own office.

  • Prepping for Mastering Index Tuning with Brent Ozar Unlimited

    I got the chance to sign up for a few courses from the Brent Ozar Unlimited team and took it. I struggle to find time for training, between work commitments, travel, and family time, it’s hard to fit in a day or two. I’ve almost given up on going to in-person classes mostly because of the time involved.

    I’m trying this online, both to learn something and see how the experience is. I’ve watched Brent present many times, and I think he does a good job of explaining concepts. While I suspect there’s a good amount of things in this course that I’ll already know, my experience is that it’s both good to get reminded of concepts from a different point of view as well as get some tips/tricks that I might not know. I’m always amazed how I might learn one small thing in a beginner session that I never knew.

    Signup

    The signup is simple. Go to the class page and add this to your cart and pay for it. The process is simple, and you get a good agenda as well as a schedule. I really appreciate the schedule, including the breakdown into what’s covered during different blocks.

    There are multiple dates/times to choose from, but this is online during the workday, Eastern US time, so plan accordingly. For me, this means a slightly early morning, but since I can turn up the speakers and walk to the coffee machine, this works out well.

    There are other classes on their home page, including Database DevOps, PowerShell, SSIS, and Data Science. There are plenty of more mainstream DBA/developer type SQL Server classes as well.

    Prep

    A couple weeks before the class, I got one of those automated emails from GoToWebinar. I’m used to receiving 3-4 of these before an event, so I promptly ignored it.

    Then I got a second one a few days later, and I decided to look at this one. I managed to actually read this section:

    “To get ready, go here:
    https://BrentOzar.com/xxxxxx
    And read the “0.1 Before the Class” module. There’s a ton of prep work and instructions in there for you, including a few videos to watch to prep, and you can download the slides to follow along. ” 

    I removed the URL, since I’m not sure this is public, but in any case, I clicked the link to find a description of the class, in usual well-written Brent style. There was also a series of links on the side, for various slides and labs.

    The Before the Class is a page with 4 videos from Brent that are supposed to prep you and give you some background. It’s 69 minutes, so I set aside some time and got moving.

    And I ran out of time. I watched 3 of the videos, but ended up not getting the fourth one done before the class because of family and travel commitments. I should have tried to watch more in short periods, but I kept putting things off. I know a lot of this stuff, but if you’re new to the class and want to learn this, spend the time to get some basics down.

    Testing Equipment

    I didn’t bother, mostly because I use GoToWebinar every few weeks, between my work or watching other things. As a result, I know my PC works. If you don’t do that, make sure you set things up.

    Contact and Notifications

    I went back and looked. I got these notifications:

    • A confirmation of the purchase
    • A 2 week notices that asked me to go to the class page, and also get started on Slack.
    • A 2 week (minus 1 day) email that asked me to read the “0.1 Before the Class” module.
    • Two 4 day notices, a day apart (one was a 3 day notice). Not sure if this was correct, but these were roughly the same.
    • An email the day before the class with a VM URL and credentials
    • A “start in 1 hour” notice

    That might seem like a lot, but I think this is pretty good. I might miss one of the advance notices in a busy world, so it’s nice to get the second one. I could glance at it and delete it if I had read the previous one.

    There’s a good amount of prep stuff out there, and Brent has each module of his class recorded, so I could have gotten ahead and watched some of the class ahead of time. I could have also played with labs a bit, though he warns you IN CAPS to be careful about not breaking some things.

    Overall

    The process before the class was well done. There is a good amount to help me prepare, but I won’t know until I get to the class if the prep was good enough.

    Looking forward to starting. Actually, but the time this publishes, I might have started, so we’ll see.