Cognitive Coverage

Posted on July 1, 2026 by way0utwest

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.

Posted in Editorial | Tagged | Leave a comment

AI Helps Me with My Sloppiness

Posted on July 1, 2026 by way0utwest

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

Posted in Blog | Tagged , , | Leave a comment

SQL Server Still Wins

Posted on June 29, 2026 by way0utwest

Is it worth continuing to run SQL Server when PostgreSQL licensing is zero? Rebecca Lewis has a well written post on why that looks at some of the pros and cons of paying for SQL Server instead of moving to PostgreSQL. She starts with some of the things PostgreSQL does well, of which I think the Extensibility is really cool. SQL Server has some of this in CLR and the non-SQL language support, but those seem kludgy and complex to me. They aren’t really integrated into the SQL Server platform.

They’re good, but I do wish vendors or the community could add some extensions in a way PostgreSQL does. Of course, I also worry about stability, so maybe this is a wish that isn’t really a great idea.

The pros list for SQL Server is quite a good list, at least for existing users. Tooling isn’t close, both for DBAs and developers, and inside the platform. At Redgate, we support both SQL Server and PostgreSQL with Redgate Monitor, and there is so much more information that we can gather from SQL Server on what’s happening. It’s truly amazing when I compare them. We constantly are looking to add to our PostgreSQL monitoring solution and ensure admins see as close a view in PostgreSQL as SQL Server, but the reality is so much information is available.

On the dev tool side, while SSMS can be slow, it’s still way better than any other database development tools I’ve seen.

The innovation argument for SQL Server over PostgreSQL isn’t a great one, as PostgreSQL continues to evolve, but I’m glad Microsoft continues to work on the engine. I wasn’t enamored with SQL Server 2022, but I do like 2025 and look forward to what comes in 2028 (my guess). What I really wish, however, is that Microsoft marketed SQL Server more, with a little less Fabric in the way.

That being said, I am continually grateful for the SQL Server marketing team’s support of SQL Saturday/Day of Data events.

It is interesting to think that the Microsoft-stack gravity is Rebecca’s third argument. It certainly makes a lot of work convenient if you use Microsoft tools, and I completely agree that ripping this out is a major reason why people stick with SQL Server. Across the last 5-6 years, I’ve had many customers tell me they’re moving to PostgreSQL and abandoning SQL Server. They constantly ask Redgate for more PostgreSQL tools (and we’ve built some), but the reality is that a year, or two, or three later, they still have those ambitious plans. They haven’t moved.

It’s really, really hard to change database platforms.

That might not seem like a pro, but it is a reason why SQL Server still wins in many organizations. It’s comfortable, effective, performs well under a variety of situations, and quite frankly, there are millions of people who are more comfortable with it than many other platforms.

I like other platforms, but I love SQL Server. It’s been good for my career and I look forward to spending the next 10-15 years continuing to help others get the most out of their installations.

Steve Jones

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

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

Posted in Editorial | Tagged | Leave a comment

Monday Monitor Tips: Virtual Machine Usage and Cost

Posted on June 29, 2026 by way0utwest

One of the things I’ve been requesting for a number of years is cost information. I could see this coming in 2015 with the move to the cloud and need to justify the resources provisioned along with sizes. Doing that effectively needs cost information.

Redgate Monitor has added a bit of cost information, and the virtual machine section in the Estate tab contains this. This post looks at what is available (as of June 2026).

This is part of a series of posts on Redgate Monitor. Click to see the other posts.

Virtual Machines

When I first started managing VMs and moving database loads to them, one of the things that I was concerned about was the CPU and RAM usage. CFOs and lots of admins wanted these are 100% to get the most out of their investments.

I wanted something less to prevent my phone from ringing constantly.

When you pick select the Estate tab, you see a number of items, but since v143.0.2906, there is a Virtual Machines item.

2026-06_0181

If you select that, then you see all your virtual machines, along with the resource name, group, and various metrics. This is a quick overview of what’s running.

2026-06_0182

If you look at the list, some are local and some are in the cloud. In addition, to the right, I see the metrics that help me understand average usage in a few ways: CPU, memory, storage allocated and used, and costs.

2026-06_0183

There aren’t any costs above as we filter that on the demo site, but if you provide cloud credentials, we use this to get some cost information. Here’s a shot from the doc site, which shows the costs in local currency (pounds Sterling for RG) and USD, which helps normalize the costs. You can read more about this on the doc page.

2026-06_0186

If you select a machine, a blade slides out with more details on usage. Here you can see the primary SSC server. This helps me decide if this is over or under provisioned based on data. I see CPU usage across a month, along with memory and storage (not shown).

2026-06_0184

If I click the “compare with” toggle, I see the last two months overlaid, which is useful info. This helps me decide if last month was normal or an outlier. It does seem like June was a busier month than May, which is good. My boss likes busier.

2026-06_0185

As far as data, I have choices for the period, going from the last day to 6 months.

2026-06_0187 

It’s up to me to keep this data, and I have an entry as well in the Data Retention settings for this data.

2026-06_0188

There’s more coming, and I know there are plans to add PaaS data as well, but if there are things you’re interested in, please contact your account rep and let them know what needs you have and why. I think this is an important aspect of monitoring that will grow over time.

Summary

This post showed the first slice of work on costing information, with an emphasis on virtual machines. There is performance as well as cost data, so you can evaluate whether you are appropriately sized for your systems.

I’m looking forward to more information, including custom costs being added for on-premises machines, as well as PaaS services.

Redgate Monitor is a world-class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.

Posted in Blog | Tagged , , | 2 Comments