mailwal

PostgreSQL 19 Is Late (2026-10-31)

SQLServerCentral
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

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

Text processing and analysis are possible through ...

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? On July 14, 2026, SQL Server 2016 reached the end of extended support. That means regular... The post SQL Server 2016...

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...

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

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

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

Community Interests

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

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

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

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...

(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...

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

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

Currently in the Microsoft documentation it talks ...

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 To ...

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

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....

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

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.

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

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

Product Upgrades and Releases

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

Python

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

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...

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

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

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 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 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 foundation for a Windows SQL Server lab...

RSS FeedTwitter
This email has been sent to [subscriber]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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.
[email protected]