Voice of the DBA

Tag: AI

  • A Quick Second Opinion

    I saw this article and thought, surely there’s nothing I could use in here: 10 Best AI Prompts for Everyday Tasks. Quite often, when these articles appear, they are very high-level and contrived examples of things that I rarely find myself doing.

    So I clicked the link.

    For most of the prompts, I didn’t think these were the types of things that I do often, nor were the prompts useful. I’m rarely looking for AI to draft emails or perform some of the simple creative things. I’m not sure these are big burdens on time for others, but perhaps I’m wrong. I know many people struggle to build plans or rewrite things, but I do those often and have gotten good at them. I tried using an LLM, but it wasn’t helpful. I do sometime ask Claude to turn things into checklists because I’m being lazy, but getting the things organized is usually the hard part. Pasting them into Word/Powerpoint and changing the bullet format is easy.

    If anyone finds value in these items, and you should try them, that’s great. I find an LLM to be a great quick assistant that can do something for me while I move on to another task. If you struggle to get drafts started, or you need a second opinion and don’t want to call/slack/message/text/etc. a friend, use an LLM. I don’t know using an LLM like this provides an ROI, but it definitely prevents your blocker from interrupting others and forcing them to context-switch to respond to you.

    I found another article on prompts for professionals, which has other prompts that might help you get that second opinion. Perhaps you can use these in technical ways, asking for an evaluation of your algorithmic approach or your message to co-workers. If you find them valuable, or you try them in a situation, let me know. Leave a comment. This AI stuff is new, and we can help each other learn.

    If nothing else, experimenting with an LLM will teach you about communication and how clear and direct you are being with your assistant. Do a poor job and the LLM often won’t quite give you the results you want. Get something back that you can use? Examine how well you communicated to the assistant. Many of us can improve here, and learning to be clear and concise with an LLM will also aid you in those communications you send to other humans.

    Steve Jones

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

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

  • Cognitive Coverage

    Satya Nadella talked about cognitive coverage in the age of AI, about being able to understand and manage AI agents to get work done as a software developer. The interview from Hard Fork Live covers the future of work and comfort in this new age. This reminds me of a book that the CEO of Redgate recommended, Reshuffle. I love the book, but it’s slow reading as I constantly stop and think.

    Work is changing; it’s becoming unbundled and re-bundled in different ways, and many of us will have to learn to work in new ways. Not all of us, but many of us. Some might see their day-to-day efforts change little; some will not recognize their job a year from now. As with anything, lots of us will be in the middle with some changes, some status quo. That’s certainly where I am with AI assistance.
    The short version of what Satya says is that there is new glue work coming to software engineers. To me, this is where we re-bundle the work that needs to be done: there is work completed by us, results from AI LLMs, and the glue that puts that stuff together. The glue is managing, organizing, deciding, and probably a few other xxx’ings in there. It’s also about understanding what’s happening across all the work you are responsible for completing.

    That understanding is the cognitive coverage. I like that term as it implies that I need to know the sum total of what’s happening from my team, both humans and AI agents. I can grok the way the river of work is flowing.

    And it’s flowing. It’s not stopping. It might be getting wider. I can lightly influence it, but if I don’t keep an eye on things, it might go in directions I don’t expect and even overflow its banks.

    The hosts noted that most people want to know their jobs won’t change or how they will change. That’s one of the big things with AI that’s disruptive and scary. With a machine able to learn and adjust in ways that are more flexible than ever in the past, we have to be adaptable as well. We have to learn to work with this flexible, non-deterministic, eerily human-like technology. It’s a scary and unnerving thing for many of us.

    AI is definitely changing the world. It’s not magic; it’s not going to automatically get rid of all, or maybe not many, humans, but it is going to change the demands placed upon them. Getting a grasp of your cognitive coverage of what AI does is going to be important.

    Steve Jones

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

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

  • AI Helps Me with My Sloppiness

    I type fairly well. Well, I type fast, but I do wear out a backspace key relatively quickly on most keyboards. That and a space bar.

    AI helps me deal with my issues in a way that I really like. This post looks at a small thing that I appreciate, and it’s why I wish I had a small local model running for more software.

    This is part of a series of experiments with AI systems.

    Searching for Posts

    Today I was searching for some posts. I typed in something and found nothing.

    2026-06_0178

    Clearly, I mistyped something, but before I fixed this, I alt-tab’d over to Claude and tried a similar query. It worked much, much better.

    2026-06_0180

    Not perfect, as the search (corrected) on my site shows more posts.

    2026-06_0179

    In this case, what I really wish was that this search box (and lots of other software), were running a small model, not an LLM, but a SLM, that would interpret my poor typing and do what I want. Or ask me and remember what dumb mistakes I make all the time.

    If an AI were powering the search, it would guess I mean “Monday” not “moday” and just run the appropriate search, get me all the results, and help me smooth out my day. Instead, I burned a few seconds looking at this, getting my brain to decode what search thing I’d mis-typed, and broke my concentration. I was thinking of a subject and had to change context to figuring out a search typo.

    Not a big interruption, but an interruption nevertheless.

    I typo things all the time. Git constantly asks me if “git stauts” is really “git status”, but it doesn’t just run that. I should re-enable autocorrect, but who has the time. Maybe I’ll ask Copilot to do that.

    In any case, the sloppy mistakes, the implied context, these are things humans deal with well. We can overlook typos and even understand things that don’t look like words. I bet many of you know what this says.

    “According to a researche [sic] at Cambridge University, it doesn’t matter in what order the letters in a word are, the only importent [sic] thing is that the first and last letter be at the right place.” – science alert

    For most of my life, computers required being more exact, which was a struggle for many people. Search, led by Google, has helped, but it isn’t as good as an LLM, nor does this help in many pieces of software.

    To me, this is one place a local LLM, watching what you type and doing a much better job than phone autocorrect, in all the place I type. That’s what Copilot should do. Fix my typing in software, in the CLI, and other places. Learn what I do and help me.

    Right now, Copilot is not something I like, but I see AI potential for the future if they try to make it work well, and not just stuff it in there.

    FYI, #@$#$#@$ Copilot didn’t do the work for me.

    2026-06_0190

  • I Want to Use My Brain

    I had a very interesting conversation recently with a longtime DBA who was worried about using AI in their database work. The Redgate State of the Database Landscape 2026 report showed that the vast majority of you (99%) are getting value from AI, so clearly it’s being used. However, this individual was concerned that using AI for tasks would not engage their brain, and they might lose some of their SQL skills.

    And they want to use their brain at work.

    I would hope most of you want to use your brains and accomplish things. That’s a lot of the reason I continue to work and enjoy what I do. It engages me, and I find the challenge of solving problems to be interesting work. Whether that’s simple T-SQL queries, architecture for an application, or the culture challenges of changing teams. It’s exciting to move anything forward.

    I would hope most people want to use their brains at work and not just get through the day without straining their mental faculties. It’s fun to solve a problem, puzzle, or challenge. The thing I’ve learned is that AI doesn’t preclude that.

    I use AI to tackle tedious things. Small things. Minute-saving things. The number of times I use an AI to do something that saves me minutes is surprising. Those minutes add up across the week and let me avoid some of the tedious work and focus on the things I enjoy: deciding if something works and if it is the appropriate solution.

    I might ask an LLM to generate some code, summarize some text, or give me a first draft. I might use a lot of what I get, or just a little. I might throw everything away and do it myself, but often that little kickstart gets me moving quicker than I might otherwise get started, and it’s lower stress for me when I’m on a deadline.

    I enjoy PowerShell, but sometimes the tedium of getting the syntax right and formatting things is annoying. Scaffolding around an algorithm can be a pain. An AI can do a lot of that stuff and I can evaluate the result. I never type > instead of -gt anymore because the LLM does it. I decide if I like the approach or not, or if I want to write a little code inside the scaffolding.

    I still use my brain. AI hasn’t changed that. It’s just that I avoid some of the tedious things. And if I need a break, I can go for a walk or cook or play guitar rather than slogging through a chore that isn’t interesting.

    Steve Jones

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

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