2026-02-25
11 reads
Artificial Intelligence (AI)
Can You Let Go of Determinism
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
2026-02-23
74 reads
Expensive CPUs
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
2026-02-04
84 reads
Database Development with AI in 2026
This seems like the appropriate first BrentOzar.com blog post in the year 2026, eh?
2026-02-02
Deep Learning and Craftsmanship Matter
GenAI technology is going to change coding, but there is still a lot of work available for humans.
2026-01-26
86 reads
Eight Minutes
When I was at the Small Data 2025 conference, one of the speakers was talking about their work with AI technologies. This person uses it a lot in their day job, often to complete tasks that they would have struggled to work on in the past, mostly because of time constraints, but also a lack […]
2026-01-16
147 reads
Semantic Search in SQL Server 2025
Learn how we can search text values in SQL Server 2025 using the new AI capabilities.
2026-01-12
3,154 reads
2026-01-07
80 reads
Loading a Database for USD$5
See how Claude Code helped load a lot of messy data into a database for less than $5.
2026-01-05
2,555 reads
Making AI Talk to Your Database: AI-Powered Database Queries Made Simple
Beneath the surface though, AI is just a tool that learns certain patterns and draws conclusions from information on the Web to answer questions, make decisions, or craft a code sample or two. Those that have used AI in the past will know that just as it’s capable of providing valuable information, AI tools can also generate inaccurate responses, and that’s why it’s important to use it wisely.
2025-12-29
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers