Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

PostgreSQL 19 Is Late

"All software contains bugs."

That's a quote from Robert Haas's "Postgres 19 is late" post. He goes on to say that PostgreSQL has lots of bugs in it. It's the way it's been for a codebase that's over 40 years old. He goes on to note that it's easier to find bugs with LLMs, and easier to fix them. It's not, however, as easy to do the latter as the former.

The impact on PostgreSQL 19 is that they've had to revert a number of features much later in the process because the humans were reviewing and fixing bugs found by LLMs. This effort delayed other work and has affected the release.

As someone who primarily works with SQL Server, I'm not that worried about delays in PostgreSQL or other platforms. I think it's a fine choice, but I'm focused on SQL Server, which I think is more of a joy to work with.

However, there are a few interesting things in here. First, I think SQL Server has had a lot of bugs found lately (likely by AI LLMs). I recently wrote about the frequency of patches, which is higher in 2026. This is probably due to LLM code review, and that's good. It also means we likely will have more patches coming, not just in SQL Server or PostgreSQL but also in our other systems. What's the likelihood that someone will run an AI review and find bugs in other COTS software, internal apps, or even those no-code/lo-code systems people have been deployed? That's not even mentioning the vibe-coded prototypes that are suddenly important enough to put into production.

The other interesting thing was that Robert accepts that LLMs are likely to find more bugs in the future. How will they find time to work on them? After all, from the article, fixes "still need to be reviewed and committed by humans."

Maybe the best part of the last paragraph. He says LLMs are going to require every developer to raise their game. Every feature is going to be scrutinized by AI. That's a challenge and an opportunity, but the key is that developers need to get better. AI can help you and write code at amazing speeds, but it doesn't think.

We need sharp developers that think in order to cope with AI.

 

 

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

 
 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
AI/Machine Learning

How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents

From SQLServerCentral Blogs

Your AI is busy. But do you know what it's worth? ...

Day2:Get Started with Text Analysis in Azure

From Mainri

Text processing and analysis are possible through ...

How I Use Claude Code to Build Stuff

From Erik Darling Data

How I Use Claude Code to Build Stuff Chapters 00:00:00 – Introduction and Setup 00:02:30 – Opus and Fable Usage 00:06:00 – Agent Management and Token Usage 00:08:30 –...

Administration of SQL Server

SQL Server 2016 Has Reached End of Support. Now What?

From SQLServerCentral Blogs

SQL Server 2016 Has Reached End of Support. Now What? On July 14, 2026, SQL Server 2016 reached the end of extended support. That means regular... The post SQL Server 2016...

SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library

From SQLServerCentral Blogs

I built a free library of runnable SQL Server demos. Each reproduces a real production problem on purpose, measures the fixes, and checks its own predictions on SQL Server... The...

Speeding Up Patching – Beyond Patch Delivery

From SQLServerCentral Blogs

I wear many hats in technology, and one of those i...

Why do you have so many housekeeping jobs?

From SQLBlog.org

I talk about the pros and cons of consolidating lo...

SQL Server Deadlock, Slow-Cooked: A Recipe That Serves Two Sessions

From Journey to SQL Authority with Pinal Dave

A SQL Server deadlock, written up the way a recipe card is written. Ingredients, prep, method, and what to do when the sauce splits. It reproduces on SQL Server...

Analysis Services / BI on the MS Stack

Why Table Distribution Matters in Synapse SQL Pools

From Andy Broadsword

When designing tables in a Synapse Dedicated SQL P...

Community Interests

Meet Hugo Kornelis, Execution Plan Expert.

From Brent Ozar Unlimited

Hugo Kornelis is a database consultant in the Netherlands. Here are a few of his sites that you might recognize: SQLServerFast.com – his useful and insightful blog The Execution...

Game over

From SQL Server Fast

(Warning: This blog post is non-technical but pure...

 
HA/DR/Always On/Clustering

Why identity recovery must be part of your backup strategy

From IT Pro - Microsoft Windows Information, Solutions, Tools

Backup can restore data but still leave identity s...

MDX/DAX

DAX LLM Benchmark v2

From SQLBI

The DAX LLM Benchmark v2 shows that the latest fro...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault

From Simple Talk

Learn how to pass API secrets into Microsoft Fabric Gen2 dataflows using Azure Key Vault, pipelines, and public parameters (no keys in code.)… The post How to secure API keys...

The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering

From SQLServerCentral Blogs

(This post starts a three-part series on how AI is changing the way we build solutions in Microsoft Fabric. First, we’ll explore how the new unified Copilot in Fabric... The...

Simple Report Bursting With Fabric Dataflows Gen2

From Chris Webb's BI Blog

When the new Send Email action was announced for F...

Can You Trust Your Fabric Data Agent? Programmatically Testing Accuracy and Determinism

From Data – Marc

Over the past year, I’ve written quite a bit abo...

How to Use Direct Lake Across Public and Private Link Workspaces in Microsoft Fabric

From FourMoo

Currently in the Microsoft documentation it talks ...

Advanced Text Handling with T-SQL AI Functions in the Fabric Warehouse

From MSSQL Tips

Explore how Microsoft Fabric SQL AI functions can enhance your data processing and analysis for your warehouse data. The post Advanced Text Handling with T-SQL AI Functions in the Fabric...

Performance Tuning SQL Server

The Joys of Early Exits

From Erik Darling Data

The Joys of Early Exits Chapters 00:00:00 – Introduction 00:01:31 – Early Exits in Code 00:04:13 – Practical Examples 00:06:00 – Early Exits in Triggers 00:08:06 – Benefits of...

SQL Server Performance Office Hours Episode 92

From Erik Darling Data

SQL Server Performance Office Hours Episode 92 To ...

Why You Don’t Get Parallelism When You Ask for The Whole Table

From Brent Ozar Unlimited

Let’s say you’re working with a big copy of the Stack Overflow database, and you wanna get all the users, like for a data export. SQL Server doesn’t parallelize...

PostgreSQL

Robert Haas: Postgres 19 is late, and it's AI's fault

From Planet Postgres

Over the past decade, the timing of PostgreSQL major releases has become very predictable: no earlier than the middle of September, and no later than the middle of October....

Igor Suhorukov: Which language should an AI agent use to search its memory: SQL or SPARQL?

From Planet Postgres

Agent memory has been in fashion ever since agents appeared: it fights hallucinations and lets an LLM base its answers and decisions on your own information. Whether it is...

Power BI/PowerPivot/PowerQuery

Power BI Administration at Scale:

PPCC26 has wrapped up and I am still buzzing. A huge thank you to everyone who came along to Power BI Administration at Scale: Governance Patterns for Enterprise Deployments with Shabnam Watson and me. I promised I would share the demo code, so here it is.

Building Claude Dashboards on Power BI Semantic Models: Step-by-Step Setup, RLS, Sharing and Limitations

From BI Insight

Have you ever wanted to build an interactive dashboard directly on top of your existing Power BI semantic models, without opening Power BI Desktop or writing a single line...

Product Reviews and Articles

Monday Monitor Tips: Query Recommendations

From SQLServerCentral Blogs

We keep adding stuff to Redgate Monitor, and it’...

Product Upgrades and Releases

Updates for all sp_Check tools

We’ve been busy updating our suite of sp_Check tools, but…we forgot to tell you about that.

Python

What’s Actually in a Shape Profile?

shape profile reads a table and writes a .shape file: a small file that describes how the data behaves, not the rows themselves.

Security News and Issues

Binance pledges to cover $6.3B theft as investigators trace breach

From IT Pro - Microsoft Windows Information, Solutions, Tools

A suspected developer laptop breach triggering the largest-ever crypto theft has put engineering access controls under intense industry scrutiny.

Software Development

The magical (temporary) power of duct tape

From Dr SQL

My great friend Joe Webb had this post a while bac...

T-SQL and Query Languages

T-SQL Mistakes: Careless and Careful Write the Same Six Queries

From Journey to SQL Authority with Pinal Dave

T-SQL mistakes, in the two-panel format the childr...

How SQL Server Solves the Halloween Problem

From DualCoreDBA

It’s that time of year again when ghouls and spo...

Talmud Game Theory in SQL Server

From MSSQL Tips

Uncover principles of Talmud game theory and its a...

Experimenting with CHOOSE: #SQLNewBlogger

From SQLServerCentral Blogs

I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included.... The...

Tech News

Why CTOs shouldn’t overlook AWS savings plans

From IT Pro - Microsoft Windows Information, Solutions, Tools

Interested in cutting AWS cloud costs? AWS Savings Plans can help. Find out how they work and which one is right for your organization with this tip.  

Samsung Warns AI Memory Shortage Could Worsen in 2027

From Past News - RSS Feeds

Samsung says AI memory demand will outstrip supply in 2027. See what the shortage means for South Korea, APAC manufacturers, and enterprise buyers.

Anthropic IPO filing offers clues for enterprise AI, model price wars

From IT Pro - Microsoft Windows Information, Solutions, Tools

Anthropic IPO filing provides signals for enterprise AI. OpenAI slashes model prices, again.

The new data center resilience playbook

From IT Pro - Microsoft Windows Information, Solutions, Tools

Explore strategies for enhancing data center resilience, ensuring business continuity and managing risks against disruptions in today's tech landscape.

Amazon Warns Against 'Tokenmaxxing' in Updated Engineering Guidance

From Past News - RSS Feeds

Amazon warns engineers against tokenmaxxing in new AI coding guidance. AWS tests reveal how coding agents can drive up token costs without improving results.

IT leaders reveal the hidden costs of AI adoptions budgets miss

From IT Pro - Microsoft Windows Information, Solutions, Tools

Discover the hidden AI adoption costs—token spra...

The Lighter Side

Car Update October 2026

From SQLServerCentral Blogs

This month I want to look at a few of the things I’ve seen posted about cars during the last month. These are a few headlines, as well as... The...

Tools for Dev (SSMS, ADS, VS, etc.)

Building a SQL Server 2025 Lab On Linux Part 1

From Lee Markum

Building a foundation for a Windows SQL Server lab...

 
RSS FeedTwitter
This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -