Voice of the DBA

Author: way0utwest

  • The End of Summer

    Growing up, this was the last week of summer for me every year. When I was a child in Virginia Beach, school started the day after Labor Day every year, which is next Monday in the US. This was our last chance to sleep in, enjoy the ocean, and stay out late without commitments. Starting next week we’d be back in school, up early, with homework to do every night.

    As an adult, the end of summer doesn’t really stand out anymore. Corporate changes are usually at the beginning of the year or in July, so it’s the end of June or December that are slower times. September is often the beginning of conference season for me, and I’ve usually been preparing for travel in September, as I am this year. I’ll be in San Diego in a little over a week for VS Live (if you want to join me, use the code Jones).

    I hope that most people have busy times and slow times at work. If you’re constantly busy and fighting fires, life is not good. That leads to stress, unhealthy living, and burnout. It’s not sustainable over time, at least not if you want to keep producing high quality work. I’ve lived in those situations and they’re neither enjoyable, nor the times when I’ve been at my most effective.

    When work is slower, I naturally slow down a little and appreciate that I can take more time to write, answer emails and messages with more detail, and think more carefully about situations. I also use the time to get ahead administrative tasks that I sometimes put off. For me, this is producing and scheduling things I’ll need later. This is often a time when I’ll write questions or editorials for the future.

    These are often the pieces I’m more pleased or proud of. I have time to work through details and spend more time reviewing my work. These are often the best questions I write.

    As a developer, this was the time I might refactor code I’m not pleased with, or tackle some niggling piece of work that I know is needed, but never has priority. As a DBA, this is when I refactor scripts and alerts, do more maintenance, maybe add some automation for tasks that I’ve just been doing manually because I don’t have time to do anything else. If I were  still a dev or DBA, this is when I’d be experimenting and practicing using AI as a lever to make myself more effective.

    When you have slower times, what tasks do you tackle? Documentation? Improvements? What else might not get done when the pace is a little more hectic? Let me know today.

    Steve Jones

    Listen to the podcast at Libsyn, Spotify, or iTunes.

    Note, podcasts are only available for a limited time online.

  • Advice I Like: Lots of Ideas

    “A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living

    Whenever we read about the success of someone or something, we often get the impression that someone had a great idea and executed on it. Especially in computing, it can seem like it’s the trajectory of many of the companies we know well.

    The reality is that a lot of companies have various bad ideas and then discover one working well. They pivot into the one good idea. Microsoft started writing programming languages and then pivoted to providing DOS. Netflix went from DVD rentals to streaming.

    The reality is that often we have lots of ideas and it can be hard to decide what a good idea is. That’s why we brainstorm, why we game, debate, and discuss options. We don’t have any hindsight when we are trying to move in a new direction, so we need to come up with various ideas to find a great one. Artists do this, musicians do this, plenty of creative people do this.

    I used to want to try and wait to have a great idea before discussing it with others. Andy Warren taught me to just throw things out there and then examine them with others.

    I’ve been posting New Words on Fridays from a book I was reading, however, a friend thought they were a little depressing. They should be as they are obscure sorrows. I like them because they make me think.

    To counter-balance those, I’m adding in thoughts on advice, mostly from Kevin Kelley’s book. You can read all these posts under the advice tag.

  • Measuring Productivity

    I’ve dealt with a lot of customers with who lately are concerned with the ROI of their teams. Certainly they want a good ROI if they purchase software from Redgate, as do we. Our goal has been to be partners with customers and continue to add value to the products they’ve purchased on a regular basis. We release every week or two, and our Redgate Monitor and Flyway updates reflect this. New functionality, fixes, and previews. I’m proud of the constant updates we deliver, and I know customers get increased value throughout our partnership.

    Does our software provide a good ROI? I get asked this question by execs regularly, and I often ask them if they feel they get a good ROI from their staff already. Answers are mixed, especially in the database world where it seems the costs and the value delivered from database dev or ops groups can be nebulous. Databases support application software, and if that software doesn’t work well because the database deployment scripts weren’t correct, weren’t tested, or have performance issues, who is at fault?

    It’s easy to blame the database, but who bears responsibility here? Is it the developers that didn’t model schema well or test queries at high volumes of data? DBAs who haven’t been adding or maintaining indexes? A lack of resources matching workload (an Ops issue)? Perhaps someone not taking time to review code (shared Dev/Ops or process issue) is at fault. Could it be the delays from a slow process to deploy changes end up delaing your digital transformation? Execs really care about that last one.

    There are metrics that DORA produces from their research around software delivery. These can be applied to database code, though I find often that companies adopting these don’t extend them to the database. At Redgate, we often have solutions engineers and architects spending time helping customers evaluate their existing database software lifecycle and try to decide if there is room for improvement. We love to sell you software, but only if you will use it and get value from the purchase.

    Today I’m wondering if any of you self-assess and maintain metrics or measures about how your databases perform. Lots of you use Redgate Monitor (or some other software) to watch databases, but do you keep metrics on how code gets to production? DORA would recommend you measure the time to make a deployment, the frequency, and other items, including when deployments fail. By the way, code compiling, but breaking the application because the logic is wrong is still a failed deployment.

    In 2026, even in the age of AI, I’m surprised how often I run into companies still doing manual work to deploy database code. Emailed scripts, file shares with random collections of code, even manual runs of SQL Compare to update production are the norm in many places. Even when C#/Java/etc. application code runs through an automated CI/CD process. I get that stateful databases are hard, but shouldn’t we be trying to make changes easy? An ordinary event, not an extraordinary one?

    Maybe more importantly, do you measure yourselves and evaluate your productivity as a DBA or database developer? Whether you do or don’t, what do you think are good measures of your productivity?

    Steve Jones

    Listen to the podcast at Libsyn, Spotify, or iTunes.

    Note, podcasts are only available for a limited time online.

  • Updating the Data API Builder

    I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I realized that the MCP capabilities were newer than my DAB version. I had v1.4

    2026-06_0232

    Wow, that’s old. The Overview page for the SQL Server MCP site says v1.7 is needed and 2.0+ has bug fixes. I need an update.

    I had this in my slide deck, but the dotnet tool is used to update the DAB. The command is

    dotnet tool update –-global Microsoft.DataApiBuilder

    This showed a download and then in a few minutes it was done. I could see I had an updated version.

    2026-06_0233

    And an MCP server!

    2026-06_0234

    A Further Update

    I checked a few weeks later and couldn’t remember the command, but I decided to try the install command. That worked as well, and I got an even newer, 2.0.12, version.

    2026-08_0374

    Still no timestamps from the logs, but I’m every hopeful.