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
 

The New Wave of Security Threats

We've had quite a few GDR patches for SQL Server released this year. If I glance at the Build Lists I maintain, I see Sept 2025, Nov 2025, Jan 2026, and Mar 2026 GDR patches. That seems rather frequent as the history of builds for recent versions has often seen them without any GDR, out-of-band patches. Just CU after CU every other month.

That pattern of rare security updates might be changing for lots of software, not just SQL Server. There was an article recently that noted AI tools might start exposing lots of bugs, including security holes, in software that has been around for years. Someone recently used AI found bugs in both PostgreSQL and MariaDB that have been around for years. They are patched, so if you run those platforms, make sure you patch things. The information is out there and someone is looking to take advantage of it.

Anthropic built a new model, Mythos, which has not been released publicly. It's been given to a few customers who have used it in testing, and it seems that it might be more capable than expected at finding bugs. Hopefully, we will find out how good it is soon and lots of companies can use it to examine software. It's certainly a danger as hackers and criminals might use it, but I believe that (responsible) information disclosure is better for everyone.

This is also a good reminder that you need to patch your systems. I certainly get wary about updating on day 1, but I do try to patch without too much of a lag. There are no shortage of zero-day attacks, but I also weigh the risk of instability from patches of questionable quality. Many vendors do a great job of patches and upgrades most of the time, but "many" and "most" aren't "all", so I prefer to let others test early. Someone has to apply the patches on day 1, but I don't want it to be me.

Security is getting harder, it's getting more burdensome, and it's becoming more important. At the same time, lots of people are building better security with new tools, including AI. Just make sure you apply those patches to take advantage of their work.

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/Cognitive Services

Thousands of AI ‘Vibe Coding’ Apps May Expose Sensitive Medical, Business Data

From Past News - RSS Feeds

Researchers warn that AI-built apps are exposing sensitive medical, financial, and business data, raising new security concerns around vibe coding. The post Thousands of AI ‘Vibe Coding’ Apps May Expose...

Why Claude?

From SQLServerCentral Blogs

Every major model out there can summarise documents, write code and answer multi step questions – then if you decide to go with a specific vendor based on costs... The...

Empty Pockets

From Daily WTF

If you've seen one developer recounting how their AI agent deleted production, you've seen them all. They're mostly not interesting stories. It's like watching someone speeding through traffic on...

Administration of SQL Server

Test SQL Server Backup Performance For Free

From Erik Darling Data

Test SQL Server Backup Performance For Free Chapters *00:00:00* – Introduction *00:00:30* – Free Stuff on GitHub *00:01:00* – Stored Procedure Overview *00:01:27* – Backup Performance Factors *00:01:57* –...

What are managed identities in SQL Server 2025? A complete guide

From Simple Talk

Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft Entra authentication for Azure resources.… The post What are managed identities in SQL...

Career, Employment, and Certifications

Who’s Hiring Database People? May 2026 Edition

From Brent Ozar Unlimited

Is your company hiring for a database position as of May 2026? Do you wanna work with the kinds of people who read this blog? Let’s make a love...

Cloud - AWS

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

From SQLServerCentral Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. St...

AWS RDS Aurora - our first approach

From SQLServerCentral Blogs

When starting with AWS RDS Aurora for managing relational databases in the cloud, many data engineers face the challenge of leveraging its cutting-edge features while maintaining performance and reliability.... The...

Computing in the Cloud (Azure, Google, AWS)

A Cloud Dependency Failure from Amazon

From SQLServerCentral Blogs

I went to sleep while reading a Kindle book on my ...

How to ensure successful deployment of a cloud migration

From Simple Talk

Practical cloud migration go-live tips: planning, team readiness, rollback strategy, testing, and post-migration checks for a smooth deployment.… The post How to ensure successful deployment of a cloud migration appeared...

Conferences, Classes, Events, and Webinars

Free SQL Server Spring Training on Performance Tuning

From Brent Ozar Unlimited

Times and tech are changing quickly. Let’s get you up to speed on the latest developments to do your work more quickly with a series of free live webcasts....

Advanced T-SQL Triage: I’m Coming to Zagreb

From Erik Darling Data

Advanced T-SQL Triage: I’m Coming to Zagreb On Friday, June 12th, I’ll be in Zagreb, Croatia, running my full-day workshop Advanced T-SQL Triage: The Art of Fixing Terrible Code...

DMO/SMO/Powershell

PowerShell: How to install the new Microsoft Entra ID Module

From Sid 500 PoSh

In this post, I’m going to walk you through installing the new Entra ID module so you can manage your Microsoft 365 cloud with PowerShell. It only takes a...

PowerShell Strikes Back: Know Your Quotes, Young Padawan

From SQLServerCentral Blogs

This is Week 1 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the... The...

ETL/SSIS/Azure Data Factory/Biml

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

From SQLServerCentral Blogs

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes? first appeared on Data Savvy. The post...

MDX/DAX

[DAX] Lib - From Zero to Community Hero (with Jake Duddy)

From Havens Consulting

 

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

Time Travel in Microsoft Fabric Warehouses

From Purple Frog Systems

Have you ever wished you could see what your data looked like last Tuesday? With time travel in Microsoft Fabric Warehouse, you can! Time travel in Microsoft Fabric Warehouse...

How to set up a SharePoint Folder Shortcut using Workspace Identity in Microsoft Fabric

From FourMoo

I really think it is ideal to use a workspace iden...

Understanding Fabric MCP

From SQLServerCentral Blogs

Model Context Protocol, or MCP, is one of those technical ideas that sounds more complicated than it really is. The easiest way to think about it is this: MCP... The...

Performance Tuning SQL Server

Learn T-SQL With Erik: Clustered Tables, Page Splits, and Readaheads

From Erik Darling Data

Learn T-SQL With Erik: Clustered Tables, Page Splits, and Readaheads Chapters *00:00:00* – Introduction to Clustered and Heaps *00:07:52* – Clustered Indexes and B-Trees *00:13:32* – Heap Tables Explained...

Learn T-SQL With Erik: Heap Table Problems with Updates and Deletes

From Erik Darling Data

Learn T-SQL With Erik: Heap Table Problems with Updates and Deletes Chapters *00:00:00* – Introduction *00:01:01* – SQL Server Specific Content *00:02:01* – Free Resources *00:03:11* – Upcoming SQL...

PostgreSQL

Mastering the Challenges of PostgreSQL High Availability and Disaster Recovery

From DCAC

In recent years, we’ve seen an upturn in adoption of the open-source database engine PostgreSQL. Commercial databases like Oracle and SQL Server can become quite expensive as applications grow...

Christophe Pettus: Eight Bytes Is the Easy Part

From Planet Postgres

PostgreSQL 19 expands MultiXactOffset to 64 bits, eliminating a real outage failure mode. So when do regular transaction IDs get the same treatment?

Christophe Pettus: Managed Postgres, Examined: Amazon Aurora PostgreSQL

From Planet Postgres

Aurora PostgreSQL separates compute and storage, replicating redo records across three Availability Zones.

Christophe Pettus: All Your GUCs in a Row: autovacuum_max_workers

From Planet Postgres

Raising autovacuum_max_workers above 3 won't speed up vacuum unless you also increase autovacuum_vacuum_cost_limit—the I/O budget is divided among workers, not…

Christoph Berg: CYBERTEC's contributions to PostgreSQL 19

From Planet Postgres

The window for new features in PostgreSQL 19 has closed with the Commitfest PG19-Final on April 9th. 182 patches were committed in this commitfest alone (plus more in the...

Christophe Pettus: MultiXact Members at 64 Bits: One Less Wraparound to Worry About

From Planet Postgres

PostgreSQL 19 eliminates the 32-bit MultiXactOffset ceiling that has crashed high-concurrency FK-heavy clusters at 3 a.m.

PowerPivot/PowerQuery/PowerBI

Clean Up Your Matrix Visual in Power BI

Many Power BI developers view tables and matrix visuals as the enemy. They dislike building them, and often think, “the user is just going to export this to Excel anyway.” But here’s the thing: tables and matrix visuals have an important business case, and sometimes a well-structured table communicates data far better than any chart would.

April release of Power BI is so so so good if you want a free design update ???? #PowerBI

From Guy in a Cube

 

Filtering measures through slicers

From Sqlbi

A slicer cannot filter a measure: let’s analyze this common request by explaining how to use a slicer to filter a measure, after discussing the real meaning of using...

Understand DAX Context in Power BI: CALCULATE, Filter Context & Row Context (Part 2)

From Havens Consulting

Video by: Reid HavensThe single biggest concept separating DAX beginners from confident report builders is context. This interactive guide breaks down how Power BI evaluates every formula you write:...

Filtering measures through slicers

From Sqlbi

A slicer cannot filter a measure. In this article, we analyze this common request by explaining how to use a slicer to filter a measure, after discussing the real...

Product Reviews and Articles

A Redgate Data Modeler Gotcha with Relationships

From SQLServerCentral Blogs

This happened to me recently after being busy with non-data modeling tasks for a few weeks. I went to add a relationship and was confused about the behavior. Read... The...

Product Upgrades and Releases

Test Data Manager: One-click deployment on AWS cloud

From Product learning – Redgate Software

Deploy Redgate Test Data Manager into your own AWS...

The AWS MCP Server is now generally available

From AWS News Blog

AWS announces the general availability of the AWS MCP Server, a managed remote Model Context Protocol (MCP) server that gives AI agents and coding assistants secure, authenticated access to...

SQL Server Diagnostic Information Queries for May 2026

From Glenn Berry

Introduction These are my SQL Server Diagnostic Information Queries for May 2026, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration...

R Language

Comparing R's {targets} and dbt for Data Engineering

I’m getting more and more into data engineering these days and having used R for a long time, I’m seeing a lot of problems that look nail-shaped to my R-shaped hammer. The available tools to solve those problems exist for (presumably) very good reasons, so I wanted to take some time to dig into how to use them and compare their workflows to what I would otherwise naively do in R.

Security News and Issues

You Can’t Fix What You Can’t Measure: Introducing the Access Risk Score

From Sherpa of Data

By this point, two things should be very clear: Your access model is not a clean hierarchy.It behaves like a graph of inherited, interconnected permissions. Which leads to a...

‘Patch Wave’ Warning: AI May Expose Decades of Hidden Software Bugs

From Past News - RSS Feeds

 

Software Development

The Organization Is the Bottleneck

From O'Reilly Radar - Insight

Everyone is adopting AI coding tools. Engineers are writing code faster than ever. But are organizations actually delivering value faster? That’s not obvious. I wrote Enabling Microservice Success with...

T-SQL and Query Languages

Why COALESCE might be the most useful SQL function you’re not using right

From Simple Talk

Learn how the SQL COALESCE function works, with practical examples for handling NULL values, setting defaults, and writing cleaner, more reliable queries.… The post Why COALESCE might be the most...

Three T-SQL Tricks You May Not Be Using Yet

From SQLFingers

Three T-SQL features that have shipped over the last few releases and quietly retired patterns many of us are still using out of habit. Each replaces a stale workaround...

Tech News

Google Chrome Reportedly Installs 4GB AI Model Without Clear Opt-In

From Past News - RSS Feeds

Security researcher Alexander Hanff says Chrome is quietly installing a 4GB AI model, raising concerns over consent, storage, and emissions. The post Google Chrome Reportedly Installs 4GB AI Model Without...

Pentagon Adds Nvidia, Microsoft, Amazon, and Reflection AI to Classified AI Push

From Past News - RSS Feeds

The Pentagon expanded classified AI deals to Nvidia, Microsoft, AWS, and Reflection AI, renewing scrutiny of military AI safeguards and vendor rules. The post Pentagon Adds Nvidia, Microsoft, Amazon, and...

Radar Trends to Watch: May 2026

From O'Reilly Radar - Insight

The most significant tension in this issue is between two companies making different decisions about how to handle AI with frontier security capabilities. Anthropic restricted Claude Mythos to a...

99% of US Enterprises Are AI-Ready. Their Lawyers Beg to Differ.

From SQLFingers

Two facts. The same week. 99% of US enterprises consider themselves AI-ready. 88% believe they are ahead of their competitors. 60% of those same organizations cite data management and governance...

Mark Cuban’s AI Warning: 5 Roles That Could See Fewer Openings

From Past News - RSS Feeds

 

The Lighter Side

The Fun of Aging

From Dr SQL

This is more or less a personal pep talk to myself as I navigate a few months of activity outside of the normal work week and I was feeling...

CodeSOD: Not for Nullthing

From Daily WTF

Today's anonymous submitter sends us some code that just makes your mind go… blank when you look at it. public static boolean isNull(String value) { return StringUtils.isBlank(value); } StringUtils.isBlank comes from the Apache...

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

Install and Configure SQL Server 2025 Enterprise Developer Edition

From AndyLeonard.blog()

This post is for people interested in setting up a...

 
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

 

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