Sr. Content Developer at Microsoft, working remotely in PA, TechBash conference organizer, former Microsoft MVP, Husband, Dad and Geek.
165063 stories
·
33 followers

AI Ran the Query and Returned Wrong Numbers

1 Share

AI ran the query in two seconds and every number came back wrong. It ran beautifully, which is not the same thing at all.

Three panel cartoon. The red bird announces that the query ran beautifully. Sam asks whether the numbers are right and the bird says they are numbers. Sam says these go to the board on Monday and the bird calls them very important numbers.

Cardinal Rules. A Saturday cartoon about AI and databases.

It ran is the weakest test we have, and it is the one almost everybody uses.

The classic way a fast query lies is a join that quietly duplicates rows. One customer has two addresses on file, the join fans out, and now that customer appears twice in the revenue total. Nothing errors. Nothing warns. Revenue is simply eleven percent too high, which is close enough to look plausible and far enough to matter.

The other classic is a LEFT JOIN turned into an INNER JOIN by a WHERE clause on the right hand table. Customers with no orders vanish from a report about customers. The report does not mention that anybody is missing. Reports never do.

Cardinal writes both of these constantly, because both are perfectly ordinary SQL. Nothing about the text is wrong. The model has no way to know that your address table has two rows per customer, since it has never seen the data and, as we established in week one, has never seen your schema either.

So use the only test that works. Pick one customer you know by heart, and check that customer by hand. Then check the row count against something you already trust, last month’s report, the finance number, anything with a history. Two minutes, and the board meeting stops being a gamble.

Cardinal Rule

It ran is not the same as it is right.

Check one row you know by heart, then check the total against something older.

Cardinal insists the query was structurally magnificent. On the desk this season: AI: Nobody’s in There. But we’re still in here. (on Amazon) and 100 AI Interview Questions and Answers for Data Professionals (Kindle, also on Amazon.in, paperback and audiobook).

Next Saturday, Cardinal tests something on ten rows and calls it instant.

Finishing fast is not a result, it is a starting gun.

Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.

First appeared on AI Ran the Query and Returned Wrong Numbers

Read the whole story
alvinashcraft
just a second ago
reply
Pennsylvania, USA
Share this story
Delete

Why does our leadership team keep having the same strategy conversation?

1 Share
A revolving door party. Strategic decision-making as a revolving door, with people continuously going round and round.
Revolving Door Party by Scott Beale

If your executive team keeps returning to the same strategic debates, and strategic decision-making keeps stalling, the cause is rarely a lack of data or too many difficult people. More often, the team is arguing over uncertain choices as if it could prove one option right in advance. Treat each choice as a hypothesis with agreed evidence and a date to review it, make the strategy visible on one page, and, if you’re stuck, bring in an independent facilitator with no stake in which option wins.

Signs your leadership team is going round in circles

The same item appears on the agenda month after month. Each time people discuss it with energy, and each time it rolls over to the next meeting.

Or the team does make a decision, and then someone quietly reopens it a few weeks later. Sometimes it’s someone who missed the meeting. Sometimes it’s someone who was there and nodded along, but was never really convinced.

Another version is agreement in the room followed by different actions afterwards. Everyone leaves thinking they’ve aligned, and then each function does something slightly different with what it heard.

And when the team finally settles on a choice, it’s often because the loudest voice won, or the HiPPO (the highest-paid person’s opinion). Everyone else then goes along with it without really committing, and it rarely survives the first bad month.

None of this means the team is bad at strategic decision-making. In my experience, it usually means capable people are trying to solve an uncertain problem as if it had a knowable right answer.

Why does strategic decision-making get stuck?

Mostly, it’s because strategic choices are uncertain. Nobody can know in advance whether entering a new market, or restructuring around customer segments, will work. People with different experience will reasonably see different futures. So nobody wins a debate about which option is “right” by arguing harder, and more analysis tends to give each side more ammunition rather than settling anything.

It doesn’t help when there’s no shared picture of the strategy. It lives in a slide deck from the last offsite, in a few documents, and in each person’s head. Every conversation has to reconstruct the context before it can get anywhere, and each person reconstructs it slightly differently.

Then there’s the lack of any point at which the team reviews a decision. If a choice is effectively permanent, the stakes of getting it wrong feel very high. It’s rational to hold out, or to reopen it when new information appears, because there’s no other legitimate place for that information to go.

And finally there’s loyalty to individual functions. Each member of the executive team also represents a part of the organisation, and people judge options partly by what they mean for their part. I don’t see that as people being difficult. It’s what we ask of people when we put them in charge of a function.

How to break the strategic decision-making loop

I don’t think there’s a single trick. The aim is for each conversation to build on the last one, rather than starting from scratch.

Make the strategy visible on one page

I use the TASTE X-Matrix for this. It captures True North, Aspirations, Strategies, Tactics, and Evidence on a single page, along with how they relate to each other. When the strategy is visible, the next conversation can pick up where the last one left off.

It also makes disagreements more specific. Instead of a general argument about direction, the question becomes something like “do we believe this tactic really contributes to that aspiration?” Those relationships are judgements, not calculations, but at least they’re judgements everyone can see and discuss.

Frame options as hypotheses

You can write a strategic choice as a hypothesis. We believe that this strategy, implemented through these tactics, will move us towards these aspirations. We’ll know we’re on track if we see this evidence by this date.

This shifts the conversation from who is right to what would tell us. In my experience, it’s much easier for a leadership team to agree on what evidence would matter than to agree on what the future holds. And once the team agrees on that, strategic decision-making gets much easier, because a decision no longer feels permanent and risky. It becomes a bet the team has chosen to place, with a clear point at which to look again.

Separate strategic decision-making from reviewing

This is where a regular rhythm matters. With Continuous Strategy, everyone takes part in reviewing and refreshing the strategy continuously, on an agreed cadence. Between reviews, decisions stand, and tactics get on with implementing them. At the review, the team looks at the evidence and adjusts.

That rhythm is part of what I’d call the organisation’s operating model, meaning its capability to run its strategy. It’s the cadences, interactions and artefacts around the X-Matrix, along with the decision rights, governance and structure that support them. When the operating model gives new information somewhere to go, strategic decision-making stops spilling over into corridor conversations.

Check understanding after the meeting

Agreement in the room isn’t the same as aligned action. Backbriefing closes that gap. After a decision, each leader plays back what they understood, what they intend to do, and what they need from others. Misunderstandings surface in days rather than months.

Catchball extends the same idea through the organisation, passing the strategy back and forth between levels until people can see how their work connects to it, which builds decision-making capacity further down the organisation. It’s also one of the best ways I know to notice when strategy and work start drifting apart.

Why does an independent facilitator help?

The most obvious reason is that an independent facilitator has no stake in which option wins. They’re not protecting a budget or a team, so they can hold the process without anyone suspecting them of steering the outcome.

They can also name the pattern. It’s hard for a member of the executive team to say “this is the third time we’ve had this conversation” without it sounding like a complaint about colleagues. From the outside, it’s simply an observation.

And it frees the CEO to take part. When a CEO chairs their own strategy discussion, they tend either to steer it or to hold back so as not to steer it. Neither helps. With someone else holding the process, the CEO can contribute as a full member of the team.

If you’re wary of consultants, that’s reasonable. A good facilitator shouldn’t arrive with the answer, or take over your strategic decision-making. The strategy has to be yours, or nobody will own it when it gets difficult.

What does this look like in practice?

I worked with an internal coaching team and its leadership in a large pharmaceutical organisation. They kept debating what the coaching team should focus on and what success would look like. It kept coming back, and never quite landed.

Putting the strategy onto an X-Matrix helped show why. People were using the same words to mean different things, and there was confusion about the difference between the TASTE elements. Flow metrics were a good example. Were they evidence, telling us whether the strategy was working? Or were they a tactic, something the team would do? Until that was clear, people were effectively having two different conversations.

And if flow metrics were evidence, the next question followed naturally. Which tactics did we expect to contribute to them? That turned out to be a far more useful conversation than a general one about focus.

The review helped realign everyone and refocus on what to do next.

There is a different example in the Rally case study.

Who can help a UK leadership team with this?

This is the work I do. I’m based in Brighton, and most of it is with UK leadership teams, helping them make their strategy visible, treat their choices as hypotheses, and review them on a regular rhythm. The TASTE X-Matrix and Continuous Strategy grew out of that work, building on the Strategy Deployment I first learned at Rally Software.

You can find out more about how I help, or about Strategy Deployment more generally.

If your leadership team keeps having the same strategy conversation, I’d be happy to talk through your strategy.

The post Why does our leadership team keep having the same strategy conversation? first appeared on AvailAgility - Karl Scotland.
Read the whole story
alvinashcraft
24 seconds ago
reply
Pennsylvania, USA
Share this story
Delete

Turn your Raspberry Pi into a classic games machine

1 Share

Following the launch of The Raspberry Pi Guide to Retro Gaming and the recent special retro gaming issue of Raspberry Pi Official Magazine, we thought this Maker Monday was an ideal time to revisit the topic, which seems to be having a bit of a moment.

One of the most popular uses for a Raspberry Pi computer, retro gaming makes use of the hardware’s power and ability to run emulation software to replicate a wide range of classic consoles and computers: from NES to PlayStation 2, and ZX Spectrum to Amiga. It’s easy to get started by installing a specialist emulation OS such as Recalbox, RetroPie, Lakka, or Batocera.

While you can enjoy Raspberry Pi retro gaming with a standard keyboard and monitor setup, there are many ways to achieve a more authentic experience so you can pretend you’re living in the past! Here, we take a look at a wireless gamepad, a classic console-style case, a couple of ways to output analogue video (including one for Raspberry Pi Pico), and a mini arcade cabinet kit for two players. Insert coins to continue play…

Picade MAX

Pimoroni | £495 / $549

These bartop arcade cabinet kits seem to be getting ever larger. First there was the original Picade with an 8-inch screen, then a 10-inch version, and now we have this super-size 19-inch MAX model — back in stock in the Pimoroni store — which adds controls for a second player.

The IPS display has a retro-friendly 5:4 aspect ratio and 1280 × 1024 resolution, with vibrant colour and wide viewing angles. The robust arcade joysticks and buttons are connected to an RP2040-powered USB controller board, resulting in very low latency for the inputs. A separate audio board (also powered by RP2040) outputs stereo sound to the cabinet speakers and, at last, there’s a physical rotary volume control.

If you want to go further, you can add NVMe SSD storage, swap out the standard buttons for RGB LED-illuminated ones, and even add a Galactic Unicorn for marquee lighting. The controller and audio boards are also available separately, so you could use them (or the original Picade X HAT) as the basis for a custom-built cabinet.

Verdict

A bigger bartop arcade cabinet with plenty of upgrades.

Warning! Legal ROMs

When finding ROMs for your retro setup, please be cautious that you are not downloading from a site hosting software illegally. There are lots of legal ROMs available, including many modern ‘homebrew’ titles developed for classic hardware.

The Raspberry Pi Guide to Retro Gaming

Raspberry Pi | £19.99 / $24.99

The easiest way to get started with retro gaming on your Raspberry Pi is by bagging a copy of this book. As well as a step-by-step guide to quickly create your own Raspberry Pi-based home console setup, it features advanced tips and tricks to help you perfect the emulation experience with hardware upscalers, dedicated video converters, and even vintage CRT displays for ultimate authenticity. The book also explains where to find legal ROMs, how to play your old floppies and CDs, and how to get games running from online stores. 

In-depth tutorials cover building the arcade machines of your dreams, including a pocket handheld for gaming on the go, and emulating 8-, 16- and 32-bit classic computers such as the Apple II, Atari 400/800, BBC Micro, ZX Spectrum, C64, Amiga, Atari ST, and IBM PC.

For those readers who don’t just want to play, there’s a chapter on classic 8-bit BASIC programming, including creating a full ZX Spectrum game — now that takes me back!

Verdict

A comprehensive guide to retro gaming on Raspberry Pi.

RGB Dual 2 

Recalbox | From €72 / £62 / $83

As well as providing a free and open source emulation system for Raspberry Pi, the Recalbox project has an online store in which it sells various bits of retro-related hardware. One of these is the RGB Dual 2, a Raspberry Pi 5-compatible board with analogue video outputs to connect it up to an old TV or monitor.

Fitting on Raspberry Pi 5’s GPIO header, and matching the SBC’s dimensions, it features four outputs: SCART, composite RCA, VGA, and a 3.5mm audio/composite jack. So your connection options are well covered, and it supports 4:3 and 16:9 TVs. Four DIP switches enable you to alter settings, such as forcing 50Hz mode and enabling 31kHz/Multisync. It also has a built-in I2S digital-to-analogue converter (DAC) for high-quality analogue audio.

You can buy the RGB Dual 2 board on its own or in a kit with various extras, such as a RecalTower stacking case. Either way, an Active Cooler is recommended to keep Raspberry Pi chilled as you enjoy pixel-perfect video.

Verdict

The easiest way to output analogue video to a TV or monitor.

Raspberry Pi Compatible Wireless Gamepad / Controller

The Pi Hut | £14 / $19

For console gaming, you’ll want a suitable controller, whether it be a gamepad or arcade-style joystick. There are countless options available, in a wide variety of designs, typically based on classic console controllers.

Most of them can be plugged directly into a standard USB-A port. This one, however, is wireless (powered by three AAA batteries). Instead of using Bluetooth like some other gamepads, it has a USB receiver dongle with which it communicates via 2.4GHz wireless — no extra setup required. As with any other controller, you may need to map the buttons in your chosen emulation software.

Resembling a classic PlayStation DualShock gamepad, it features an Analog button to press to enable full analogue thumbstick control (otherwise they just acts as buttons). There’s also a Turbo button for rapid fire — great for shoot-’em-ups. There’s no noticeable wireless lag, either.

Verdict

A good value-for-money wireless controller.

Game 5Pi Retro Gaming Case for Raspberry Pi 5 

52Pi / The Pi Hut | £17 / $23

When playing emulated games, you might want to add a vintage-style case to enhance the illusion that you’re back in the eighties, nineties, or whenever. There are many cases resembling classic consoles available, such as the PlayStation, Dreamcast, SNES / Super Nintendo, N64, and Game Boy. This one harks even further back with its boxy NES-like design, albeit a lot smaller than the real thing.

To help prevent your Raspberry Pi 5 overheating, it features excellent cooling with two fans: one mounted on Raspberry Pi with thermal pads, and a second ‘exhaust fan’ blowing air through the vents in the case.

The two-part case is easy to assemble, and there are cutouts for micro HDMI and USB-C power ports, plus a microSD card slot. A hinged flap can be lifted to reveal the USB and Ethernet ports. Unlike some cases we’ve seen, the two buttons on the front are non-functional, but there is a tiny one at the rear to press Raspberry Pi 5’s own power button.

Verdict

As well as looking cool, this classic case has excellent cooling.

Pico VGA Demo Base

Pimoroni | £20 / $22

While not as powerful as a full-size Raspberry Pi computer, a Raspberry Pi Pico can emulate many classic 8-bit consoles and computers. The biggest issue is outputting video and audio. You could opt for Pimoroni’s PicoVision, which outputs hi-res video via an HDMI port. The downside is that it won’t run standard Pico-based emulators unless you adapt them to use its hardware.

The Pico VGA Demo Base is a simpler option for Pico-powered emulation on a VGA monitor. Compatible with Raspberry Pi Pico and Pico 2 models, it has its own micro USB power port (freeing up Pico’s own for USB devices), a microSD card slot for storage, and two 3.5mm audio jacks (for DAC and PWM).

You can flash the RP2040 version of the classic Doom, created by Raspberry Pi’s own Graham Sanderson, or use one of the Pico-based system emulators available. Some, like pico-zxspectrum, even have precompiled UF2 files for the VGA Demo Base; others can be compiled with an option to use the board’s pin mapping, etc.

Verdict

An easy way to output VGA video from Raspberry Pi Pico for retro gaming.

8BitDo Retro Mechanical Keyboard

8BitDo / The Pi Hut | £90 / $121

When emulating classic computers, it’s worth connecting a mechanical keyboard with old-fashioned clicky-clack keys. This one features an 87-key layout with Kailh Box White switches V2 for tactile typing. It comes in four retro colour schemes: C64, N, Fami, and M. 

Get your copy of The Raspberry Pi Guide to Retro Gaming for £9.99

This book shows you all the tips and tricks you need to start playing all your favourites from yesteryear. Retro gaming enthusiasts love Raspberry Pi for how easy it is to use for their retro games, especially when they can do it all on one device and not need a roomful of consoles and computers like in the 80s and 90s.

Inside you’ll find information on how to create a simple, quick setup to relive the glory days of gaming, along with more advanced tips on achieving the perfect emulation machine thanks to advanced techniques, hardware upscalers, and dedicated video converters. There’s a lot of devices and extra tips that you’ll find in here, from finding or making the right controller to connecting older peripherals to your Raspberry Pi.

Our step-by-step guides also include how to create a nifty pocket handheld for retro gaming on the go, and a full-size arcade machine to maximise your nostalgia. All this, and we’ll also show you where to find legal ROMs, play your old floppies and CDs, and get games running from online stores.

The post Turn your Raspberry Pi into a classic games machine appeared first on Raspberry Pi.

Read the whole story
alvinashcraft
3 hours ago
reply
Pennsylvania, USA
Share this story
Delete

James Shore: Assessing the Impact of AI - Episode 428

1 Share

https://clearmeasure.com/developers/forums/

Today's guest is James Shore, author of The Art of Agile Development and a consultant who transforms software development organizations when repeated fixes have failed. James is a recipient of the Gordon Pask Award for Contributions to Agile Practice, an early adopter of Extreme Programming, and previously served three years as VP of Engineering at OpenSesame. James last joined me in 2021 to talk about the second edition of The Art of Agile Development, and I'm glad to have him back to learn about his most recent project.

Website - https://www.jamesshore.com/
Biography - https://www.jamesshore.com/v2/services/biography
Blog - https://www.jamesshore.com/v2/blog
The Art of Agile Development - https://www.jamesshore.com/v2/books/aoad2
Are You Getting Your Money's Worth - https://www.jamesshore.com/v2/blog/2026/are-you-getting-your-moneys-worth-from-ai
Assessing AI Impact Notes For Your CFO https://www.jamesshore.com/v2/blog/2026/assessing-ai-impact-notes-for-your-cfo LinkedIn - https://www.linkedin.com/in/james-shore-7475b6/ Mastodon - https://mastodon.online/@jamesshore Github - https://github.com/jamesshore

Previous episodes with James Shore:
Episode 167 - https://azuredevopspodcast.clear-measure.com/james-shore-on-the-art-of-agile-development-episode-167

Want to Learn More?
Visit AzureDevOps.Show for show notes and additional episodes.





Download audio: https://traffic.libsyn.com/clean/secure/azuredevops/Episode_428.mp3?dest-id=768873
Read the whole story
alvinashcraft
3 hours ago
reply
Pennsylvania, USA
Share this story
Delete

541: .NET 11 Launch: Performance Gains, Union Types, and Runtime Changes

1 Share

James and Frank dive into .NET 11's biggest announcements from .NET Conf 2026, exploring the performance optimizations that matter most to developers—from native AOT CLI tools shaving milliseconds off startup times to runtime async improvements that make your code faster without changes. They break down union types, MAUI's runtime consolidation, and why the team is obsessed with squeezing every millisecond for modern development workflows.

Chapters

  • 00:00 Welcome and Studio Setup Chat
  • 01:13 .NET 11 Launch and .NET Conf
  • 02:52 Building the .NET Conf Q&A Platform
  • 09:17 Performance Optimizations and Native AOT
  • 13:54 Runtime Async Preview Feature
  • 18:33 Union Types and Type Safety
  • 23:25 MCP Servers and AI Integration
  • 25:40 MAUI Runtime Consolidation and Mobile
  • 31:12 Feature Roundup and Community Engagement

Links

Follow Us

⭐⭐ Review Us ⭐⭐

Machine transcription available on http://mergeconflict.fm

Support Merge Conflict

Links:





Download audio: https://aphid.fireside.fm/d/1437767933/02d84890-e58d-43eb-ab4c-26bcc8524289/27c755a7-9dae-4c3b-9dfb-d73027e46c28.mp3
Read the whole story
alvinashcraft
3 hours ago
reply
Pennsylvania, USA
Share this story
Delete

Setting a spending limit on a Claude Code session

1 Share

An agent that runs on its own stops when the task is done, not when your budget is. That’s fine for a quick question, but it’s a different story for a refactoring job in CI or a scheduled run overnight.

So the question becomes: how do you put a ceiling on a Claude Code session?

Remark: Strictly speaking you can’t set a token limit. Claude Code caps on spend (tokens × price), so that’s what we’ll use.

The naive approach

Just run it and see what happens:

claude -p "Run the test suite, fix the failing tests in src/ and commit the fix"

There is no limit by default. Claude keeps going until it thinks it’s finished, and you find out the cost afterwards.

Two flags can help

Claude Code has two flags that act as a safety net in print mode (-p):

claude -p "Run the test suite, fix the failing tests in src/ and commit the fix" \
  --max-budget-usd 3.00 \
  --max-turns 30
  • --max-budget-usd stops the run once the estimated spend on API calls reaches the amount.
  • --max-turns limits the number of agentic turns. When the limit is reached, the run exits with an error, so your script can branch on the exit code.

I typically use both. A runaway loop that keeps retrying a failing fix hits the turn limit long before it gets expensive, and the budget flag covers the case where every turn is just very large.

Remark: The budget is a soft cap. It’s checked against a client-side estimate that can differ from your actual bill, and spend can pass the cap. Best to leave some headroom.

What about interactive sessions?

As far as I know, there is no equivalent hard cap for an interactive session. What you can do:

  • Check the running cost with /cost.
  • Look at what is filling your context window with /context.
  • Use /compact to summarize a long session, or /clear when you switch tasks.
  • When you’re billed through the API, set a spend limit on the workspace in the Anthropic Console as the backstop.

That’s it! Set both flags on every unattended run and treat the result as a safety net, not an exact meter.

More information

Read the whole story
alvinashcraft
3 hours ago
reply
Pennsylvania, USA
Share this story
Delete
Next Page of Stories