| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| 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. |
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... |
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... |
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... |
(Warning: This blog post is non-technical but pure... |
| HA/DR/Always On/Clustering |
Backup can restore data but still leave identity s... |
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 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... |
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. |
shape profile reads a table and writes a .shape file: a small file that describes how the data behaves, not the rows themselves. |
A suspected developer laptop breach triggering the largest-ever crypto theft has put engineering access controls under intense industry scrutiny. |
My great friend Joe Webb had this post a while bac... |
| T-SQL and Query Languages |
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... |
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 provides signals for enterprise AI. OpenAI slashes model prices, again. |
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. |
Discover the hidden AI adoption costs—token spra... |
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... |
  | 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. |
|
|