Voice of the DBA

Tag: AI

Changing the Paradigm of Work

I saw an article on AI usage that is based on an upcoming book that suggests redesigning the world around new tech, not adding it to existing things. The first example is how electricity was introduced to existing factories, but it only provided some incremental gains until new factories were redesigned around electric motors. There’s also an example given about reworking hotels to remove the front desk since that feature isn’t needed. Instead, people could walk in, and an employee with a tablet could find them to check them in.

I’m all for rethinking and redesigning processes. I do think we have a huge glut of software in many organizations that exists because processes have evolved across time, but not everything and we keep our old software. When we have a new need or want a new capability, we add new software (or add features), but we don’t necessarily throw out all the old software, processes, or habits. That wouldn’t be practical, often because when we implement something new, it might not meet all our needs. Or at least we don’t know it meets our needs at first.

I don’t love the examples, especially as I see organizations where Teams/Slack are heavily in use (not just in tech companies), and these tools have changed how people work. Not everyone has moved, and there is a lot of document sharing and legacy systems, but that’s also because not everyone wants to or can change at the same pace. However, lots of people have changed how they create, share, collaborate, communicate, and more because of these tools.

I also think the hotel example is silly (read the article to see more). I don’t need a desk, and often I check in and get my key without ever visiting a desk. However, I do like the desk because when I need something, I want to be able to find someone, not wander around looking for an employee or waiting for them to respond to some page. When there’s a desk I can see someone is there. I certainly don’t want a kiosk with an AI there to queue at to request a person help me.

GenAI LLMs are going to change work for a lot of people, especially those in tech. I don’t know that we can redesign the way we work now, as the technology is still advancing, and I’m not sure how we will want to integrate agents with GenAI to do work. We have to experiment and find ways to use this tech before we build too much. We also have to see it mature.

When we do, I bet many more people will start to use AI to generate code, change settings, deploy things, and more. I’m also sure that they will make many mistakes, at scale, and we’ll be using a GenAI agent to undo things, or perhaps we’ll have humans scrambling to fix systems. I wouldn’t be surprised to see the humans commonly fixing things as we might not trust the AI Agent (or our prompting) to fix our mistake.

If you could redesign work, what would you want out of an AI? Assume that it is at least as competent as someone you work with. Is there a way that a GenAI system would make your work smoother?

Steve Jones

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

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

May 28, 2025
Using AI to Test a SQL Query
Someone sent me this code.
```
WITH p AS
 ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN
 FROM wp_posts
 WHERE post_parent = 94341; )
 UPDATE p SET menu_order = RN
```
That’s not great code. In fact, it won’t run. I know that, but does an AI? Let’s see how Copilot does.

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

The First Test

I entered this prompt, but accidentally hit Enter. When I then pasted in the code and hit enter, I got this:

That is just about what I would have sent the author to let them know this code doesn’t work. It’s good to see a GenAI LLM can recognize this.

I then pasted in the entire prompt which was: “give me a table with the schema to match this code: WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN FROM wp_posts WHERE post_parent = 94341; ) UPDATE p SET menu_order = RN”

The Gen AI response was polite, with this answer:

Certainly! Based on your SQL code, it looks like you need a table schema that matches the structure of wp_posts, particularly including ID, post_parent, and menu_order. Here’s a possible schema:

I then had this code, with a copy button that I could copy/paste into SSMS.
```
CREATE TABLE wp_posts (
     ID INT PRIMARY KEY,      -- Unique identifier for each post
     post_parent INT,         -- Parent post ID (for hierarchical structures)
     menu_order INT           -- Order value for arranging posts
);
```
That’s what I would have done to mock this up for testing. You might guess the next step: data.

Here’s my prompt: create some test data for the table with Ids that increment but are not necessarily sequential and post_parent values that match the ID values

That got my this response.

That’s not bad, but it’s a limited set of data. Let’s ask for more.

Below this the GenAI LLM gave me a summary that explains what it did.

Next, I wanted a test. I used this prompt: write a tsqlt test to verify that the update statement works to reset the menu_order to sequential values for a particular post_parent

I got a nice response and the code I’m showing below the image.

Here is the code:
```
-- Step 1: Create a test class
EXEC tSQLt.NewTestClass 'TestMenuOrderUpdate';
```
GO

— Step 2: Define the test
CREATE PROCEDURE TestMenuOrderUpdate.[test_UpdateMenuOrder_Sequential]
AS
BEGIN
— Arrange: Fake the wp_posts table
EXEC tSQLt.FakeTable ‘dbo.wp_posts’;

INSERT INTO wp_posts (ID, post_parent, menu_order)
VALUES
(101, 94341, 5), (102, 94341, 3), (103, 94341, 8),
(104, 94341, 1), (105, 94341, 7);

— Act: Run the update logic
WITH p AS (
SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) AS RN
FROM wp_posts
WHERE post_parent = 94341
)
UPDATE wp_posts
SET menu_order = p.RN
FROM p
WHERE wp_posts.ID = p.ID;

— Assert: Check if menu_order is sequential
EXEC tSQLt.AssertEqualsTable ‘ExpectedResults’, ‘wp_posts’;

END;
GO

— Step 3: Create expected results table for assertion
CREATE TABLE ExpectedResults (
ID INT PRIMARY KEY,
post_parent INT,
menu_order INT
);

INSERT INTO ExpectedResults (ID, post_parent, menu_order)
VALUES
(101, 94341, 1), (102, 94341, 2), (103, 94341, 3),
(104, 94341, 4), (105, 94341, 5);

— Run the test
EXEC tSQLt.Run ‘TestMenuOrderUpdate’;
This is where I stopped. This code runs, though it’s brittle in that the Expected Results table is a real table and not a temp inside the test. I can easily edit that and likely quicker than the GenAI can. It’s copy/pasting some code for me from one spot to another. I also need to add a CREATE OR ALTER to the proc.

Summary

A quick use of an AI that easily saved me 5-10 minutes to mock of a scenario and show someone what they were doing wrong and also testing their code. I mock up things regularly to test them, and often do something like this to answer questions. This is a good place where AI can save some time, and might be worth using. I’m also glad to see it recognize and write some decent SQL code for me, especially the insert statement for test data.
May 28, 2025
Checking Myself with GenAI

I had a suggestion from somone on a place where AI helps them and I decided to try it. The person had an AI summarize their work and if the result wasn’t the intention of the author, then they know know their writing wasn’t clear.

This post looks at how that worked for me.

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

Checking an Editorial

I wrote an editorial on database Devops that was published recently. I decided to have a few AIs summarize this and see if the result was what I intended. First up, Claude, with a simple prompt: summarize this text (insert here). See the top of the prompt here:

The result is shown below and seems to be an accurate summary of the text. This is basically what I was trying to say in the piece. Of course, this isn’t much shorter than the text, but this gives me confidence here in the ability to recognize what I’ve written.

In Perplexity, I got this result. This result is similar, but doesn’t mention the author. Instead, this is a summary of the text, not trying to give a voice to the author, which is interesting. Very close to the text above, but this seems slightly drier, taking the text as fact rather than opinion.

Perplexity also had some related items at the bottom, which injected a prompt back into the LLM for more info.

Last, Copilot. I have a dedicated key on my laptop for this and I pressed it and entered my prompt in the app. This result is shorter and to the point. There are some additional links to click that the bottom.

Clicking on one of the items at the bottom injects the text and gets a new result.

I tried this with a couple other piece of work, some of which aren’t published. In each case (3 attempts), the summary made sense. I don’t know if that means I am writing anything clearly, but it does help me get a sense of what I’ve written.

May 21, 2025
The AI View From Above

It likely isn’t a surprise to many of you that executives like AI. A survey shows that 74% of executives surveyed have greater confidence in AI-generated insights than advice from colleagues or friends. At the board level, even more (85%) favor AI-driven advice.

That’s amazing to me, and while I might think this is a bit too much trust being placed in these GenAI LLMs, perhaps it’s also partially because they work with too many people who aren’t great at their jobs. Plenty of people skim through data or focus on certain things and might miss the details. While an AI can read and summarize a lot, it might not have the context we expect. I tend to be a bit skeptical of AI summaries, often because they don’t necessarily weigh the different parts of an article the same way that I do. However, they can be helpful.

Even more interesting, 44% of executives say they would trust a GenAI to override their decisions based on insights, and 38% would trust AI to make decisions on their behalf. Business decisions based on data, or conclusions from a lot of inputs are different than producing working code, so I don’t know how accurate these models might be in this context. I do know that I want experienced people reviewing and judging GenAI outputs, and I would not allow an AI to override me without my input.

However, I wouldn’t just discount a GenAI recommendation. I tend to have strong opinions, but loosely held. I’ll change if there is evidence or a good argument to do so. It’s possible a GenAI might see things I miss and produce an insight that gets me to change a decision.

What’s a bit scary about the stats from this survey is that many executives see a skills gap in their staff, and their trust in GenAI might lead them to replace or augment existing staff with more GenAI tools. They might expect hiring can be delayed or slowed (or eliminated) with GenAI filling gaps. This might be especially true as many tech companies talk about how GenAI tools are making them more efficient.

That means that tech professionals should consider a few things. First, learn to work with GenAI tools and use them to prove your value to an organization. This includes learning when not to use them. Second, continue to improve your skills to ensure you can judge Gen AI results and emphasize that you are still the expert. Lastly, as the technology improves, consider adding some skills in how to train an AI to be a better assistant for you. The more efficient you are, especially with a GenAI helper, the more likely you are to impress executives and managers that are choosing which staff to keep.

Steve Jones

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

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

May 19, 2025