Author: way0utwest

  • The Evolving DBA

    The world is changing. Plenty of people have written about the changes in the job of the DBA (DBAKevlar, Brent Ozar), including myself. While lots of vendors might postulate their database removes the need for a DBA, and some might believe that, I think that’s disingenuous. Microsoft doesn’t hire DBAs, but they hide that job under other titles. We still need DBAs, though the job changes a little in the future.

    Recently I saw a post from new PASS Board director, Melody Zacharias, where she notes that DBAs are more important than ever. She gives us five reasons, and I tend to agree with most of them.  There is a need to somehow keep track of and manage data, much of which will continue to live in relational stores. As much as there is grown for key-value, graph, streaming, document, and other styles of data stores, we still use relational databases for many tasks. I don’t see that going away anytime soon, especially for legacy software that will continue to live for some time.

    There is also the aspect of a DBA that involves the cleaning, checking, and verifying that data is in the form and format we expect, not to mention the need to ensure the data is intact and protected, and not changed inappropriately (or corrupt). Every system needs people that can dig through data and help decode its meaning as well as ensuring that business users can get it in to a report of some sort. Those tasks don’t go away. While end users might have more self-service query tools, that doesn’t ensure that they will actually know where the data is or how to reformat it. No end user tool is going to fix mm/dd/yyyy for a user expecting dd/mm/yyyy.

    There is also the need to just manage large amounts of data. I know data scientists have struggled to work with large scales of data in the past, and not just because of hardware limitations. They spend an inordinate amount of time gathering and organizing data that is used for analysis or AI/ML operations. Future organizations won’t want to waste their time on those tasks and turn to some sort of DBA to help manage the large data needs of those people performing high level analysis.

    The DBA isn’t going away, though the job is changing. Checking logs and backups is likely something you’ll do less of in the future if you work in Operations. Instead, you’ll manage more data, and you’ll certainly need some coding skills to ensure you can perform in GitOps environments, where we don’t click on things, but rather use code to define our systems and the configuration that we expect.

    The evolution can be daunting, but it can also be exciting. You have time to learn and change and build new skills. Embrace the opportunity to grow and change in your career as a DBA.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • A Smooth Laptop Setup

    A little over a week ago, I got a new laptop. This was late on a Sunday afternoon, and I went home to spend time with me wife. After dinner, we relaxed with a little TV time. While trying to decide what to watch, I opened the laptop and started the Windows setup process. This post talked about how smoother and simple things were for me, though certainly not seemless as I’ve had on OSX machines. Still, it went well.

    Windows

    The first part of getting a new Windows machine going is usually the account. I have a Microsoft account I use for a few things. It’s actually an old Hotmail account, but it’s worked well for me.I entered this, and it linked to a few things I already had set up, including my OneDrive. This bootstrapped quite a bit of the process.

    I then checked Windows Update (nothing to apply) and upgraded to Windows 10 Pro. Once this was done, I opened the Windows Store and applied a few updates from there. While this was running, I did two things.

    Chrome

    I prefer Chrome as a browser, and I keep some settings linked to this browser, like bookmarks, some throwaway user/pwds, and settings. I usually start by opening Edge on a new install and going to Chrome and installing it. I could to this separately, but it’s usually my first step.

    Chocolatey

    This is my go-to install system. It’s yum or apt-get for Windows and I’ve used it for close to a decade now. I go to the website, and grab the script. Since I usually don’t have DropBox yet, and that’s where I have lots of stuff, I start here. Run this in an admin command prompt that’s got PowerShell running:

    Set-ExecutionPolicy AllSigned or Set-ExecutionPolicy Bypass -Scope Process
    Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

    Those two things get the package manager running. Once this is done, I usually start grabbing stuff I know I need. I used to have a long list of things to install, but since my needs change over time, I usually go with this:

    choco install dropbox -y
    choco install evernote -y
    choco install greenshot –y
    choco install spotify –y

    These are the main things I want, and really need. While these are running, I usually go get the o365 portal from work and start that install, because it’s long.

    With every laptop, I somewhat change the things I install. I posted I was doing this and Aaron Nelson dropped me a link to his gist of database pro software: https://gist.github.com/SQLvariant/d29ffd1e9905992318b4585c83399328.

    This is a great list, and I immediately added some of these items. I don’t use all of these, but I use many.

    • SSMS
    • ADS
    • Git
    • VSCode
    • PowerBi
    • VS
    • Python
    • Sublime Text
    • Slack
    • Teams
    • Docker Desktop

    I do need SQL Server, but I held off since I wasn’t sure if I want to install it or just run containers. I’m debating this as I write this. I’m really tempted to skip an install and set up folders for holding db/log files at specific versions.

    Once these tools were installed, I added the Redgate Toolbelt, missing that in Aaron’s list. I saw Kendra tried this and it worked, but I was half paying attention and just running choco commands while watching a movie.

    Just in glancing at the machine on a dresser a few times and typing a few commands had most of the machine set up in the space of a 2 hour movie. It was Holiday in the Wild, if you’re wondering. An enjoyable movie.

    More to do, but really typing a few commands, I had most software installed that I need.

    Now I just need to decide what to do about SQL Server.

  • Prompt in ADS

    Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of the value, given how UI dependent Prompt is for users.

    Things have changed.

    sql-prompt_early-access_social-graphic_1200x630

    There’s an EAP program, with an early look at the formatting part of Prompt in ADS.

    I’ve been using this for a few weeks, and it’s different, but it works well. All my styles from SSMS are ported and linked, and it’s a quick set of keystrokes, albeit different ones, to format code.

    I’m curious to see what others think, so join the program if you want formatting in ADS and are willing to give some feedback.

  • Finding Your Own Career

    Building a career is hard work. It takes time and focus to move along a path that you choose for yourself. What I have seen across a few decades of work is that most people don’t bother to find a path, and are happy to wander from job to job, finding new positions or projects when they are forced to do so. As much as I advocate for others to continually learn, there’s nothing wrong with wandering randomly through a career, sticking with a job or employer as long as you can.

    The one thought that I’d like to see everyone adopt is a conscious decision to do so. Make the choice to have the career you want, and the life you want, whatever that is for you.

    Recently on Twitter, there has been a lot of career advice that I’ve seen posted. One very interesting item was that a developer shouldn’t compare themselves to anyone else. They should be proud of what they’ve done and work towards the goals and achievements that mean the most to them. Good advice, but often hard to follow.

    Most of us only see a fraction of the world, and a limited view of potential opportunities for languages, projects, positions, and skills. We often do look at others’ accomplishments and then try to model ourselves in some way to be like others. Not completely but we may choose to learn a skill another has, or pass a test that someone else completed, or maybe go work for the company that a colleague has enjoyed. There’s nothing wrong with that.

    Think about what others do and decide what aspects of that you’d like to adopt. As much as I’ve coached others to think for themselves, make their own decisions, and be proud of the things they accomplish, I also want them striving forward. That often requires a goal and an ideal, which we often find in others we admire. Compare yourself to others, but don’t judge yourself by their standards. Decide on your own if you’re living up to the measurements that make sense to you.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.