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
 

Don't Panic

And bring a towel.

If you don't know what I'm talking about, you have homework.

You know with that lead in I'm going to talk about AI. Sorry, can't help it. It's on my mind quite a lot. It's in the news, oh, a whole lot. The majority of those stories can be summed up in a single word:

PANIC!

While I know I'm just some rando on the internet and my opinion is worth every single penny you're paying for it (for those confused, it's zero, zero pennies), I have a few words to share beyond "Don't panic."

First up, yeah, if you haven't been working with the LLMs and Agentic AI, you might not be aware of it, but, yes, these things are going to be disruptive. Potentially, massively disruptive. Every new technology that's truly ground breaking, and this very much qualifies, eliminates jobs and changes career paths. Every new technology also creates new jobs and different career paths. I know these two facts because a) I'm old and I've seen similar shows before, b) I read a lot of history, including the history of technology. We're still in the early days of this disruption. Anyone who says they know for certain how things are going to turn out is selling you something (and how much did you pay for this?). I'm not going to tell you that I know exactly how things are going to turn out here, but I know, for certain, there's going to be good with the bad. What? Where? Haven't a clue. If I did, I'd be charging you.

Next, if you haven't been working with the LLMs and Agentic AI, dude, come on, it's time to start. One thing I can say about these things is that they mainly constitute yet another tool. This tool may be powerful. It may serve a whole slew of functions. However, it's just a tool. Like any tool, the likelihood of picking it up and putting it to work without any practice or knowledge of it is going to end in pain. Quick story about a hammer. I grew up around craftsmen. My uncles on my mom's side of the family all put tools in my hands at an early age. So, I learned how to use a hammer. I was helping a friend build some stuff. Another friend of his was also helping. Other friend was a big, buff, weight lifter dude. Huge. Me, I'm pretty weak in the upper body frankly. Yet, I was pounding in nails in 2-4 sharp hits of the hammer. Giant muscled guy was hitting them 15-20 times, hard as he could, bending a lot of them. Why? I knew how a hammer worked and he just didn't. AI = Hammer. It's inevitable. You're going to use them at some point. Learn how to use them well. It's just a tool.

Finally, seriously, don't panic. Spit out the black pill. Yeah, there's a lot happening around technology right now and it's scary. Your job, as a technologist, is not to freak out. It's to learn, understand, and then appropriately apply. Further, sticking your head in the sand and hoping this all blows over 'cause it's a fad and a bubble, HALLUCINATIONS, ain't going to work well for you. Yes, there are simply metric tonnes of hype. Yes, it is a bubble (tulip or canal, we don't yet know). Yeah, they do make up the darndest things. However, it's a new tool that's going to be used for a long time. Best to learn how to use it.

Grant Fritchey

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.
Vendors/3rd Party Products

Test Data Management and SOC 2 Compliance

Using live data outside production is one of the fastest ways to create compliance risk, because it quickly becomes harder to control who can access it, how it is handled, and how long it is kept. A Test Data Management (TDM) approach provides exactly the kind of controls SOC 2 auditors look for in this situation: an automated, traceable end-to-end process for protecting, provisioning, and removing customer data so it can be used safely in non-production environments.

AI/Machine Learning/Cognitive Services

What’s holding back AI impact in banking?

From AllAnalytics

If AI ambition inside your bank is starting to col...

OpenAI Warns AI Could Hit Jobs, Taxes, and Society All at Once

From Past News - RSS Feeds

OpenAI says AI could disrupt jobs, taxes, and soci...

Posthuman: We All Built Agents. Nobody Built HR.

From O'Reilly Radar - Insight

Farewell, Anthropocene, we hardly knew ye. ?? AI i...

Mustafa Suleyman: AI development won’t hit a wall anytime soon—here’s why

From Technology Review Feed - Tech Review Top Stories

We evolved for a linear world. If you walk for an ...

AI-Infused Development Needs More Than Prompts

From O'Reilly Radar - Insight

The current conversation about AI in software deve...

Meta Debuts ‘Muse Spark’ AI, Challenging Rival Models From OpenAI, Google

From Past News - RSS Feeds

Meta launches Muse Spark, a new multimodal AI mode...

Architecture as Code to Teach Humans and Agents About Architecture

From O'Reilly Radar - Insight

A funny thing happened on the way to writing our b...

The Download: AstroTurf wars and exponential AI growth

From Technology Review Feed - Tech Review Top Stories

This is today’s edition of The Download, our weekday newsletter that provides a daily dose of what’s going on in the world of technology. Is fake grass a bad idea? The AstroTurf wars are far from over.  In 2001, Americans installed just...

Meta Pumps Another $21B Into AI Cloud Powerhouse CoreWeave

From Past News - RSS Feeds

Meta commits an additional $21 billion to CoreWeav...

Claude Cheat Sheet: A Complete Guide to Anthropic’s AI

From Past News - RSS Feeds

 

6 Google Gemini Features Most People Haven’t Discovered Yet

From Past News - RSS Feeds

 

Administration of SQL Server

First Normal Form (1NF): Breaking the ‘unbreakable rule’ in database design

First Normal Form (1NF) is the most widely known rule in database normalization. It requires that tables contain no repeating groups and that each column holds atomic values. But, in real-world database systems, developers often intentionally break this rule when modeling complex data. Let’s find out why.

SQL Server Diagnostic Information Queries for April 2026

From Glenn Berry

Introduction These are my SQL Server Diagnostic In...

Did You Really Name That Default?

From SQLServerCentral Blogs

Ten years (and a couple jobs) ago, I wrote about n...

From Legacy to AI -Ready: A Practical Modernization Roadmap

From Sherpa of Data

Part 5 in a series on evolving SQL Server environm...

How Multi-Column Statistics Work

From Brent Ozar Unlimited

The short answer: in the real world, only the firs...

Why TOP (1) Can Return Multiple Rows (and Why That Matters)

From Andy Broadsword

Having TOP (1) return multiple rows feels wrong?...

Deeper Diagnostics and Actionable Dashboards

From Journey to SQL Authority with Pinal Dave

That is a harder problem than it looks, and most m...

ADR Comes to TempDB in SQL Server 2025. Read This Before Enabling.

From SQLFingers

Two weeks ago I covered the Resource Governor chan...

SUBSTRING Optional Length In SQL SERVER 2025

From Dr SQL

Sometimes along comes a feature that seems so obvi...

Free SQL Server Performance Monitoring Blocking and Deadlocking

From Erik Darling Data

Free SQL Server Performance Monitoring Blocking and Deadlocking Summary In this video, I delve into the blocking and deadlock monitoring capabilities of FreeSQL Server Performance Monitoring, a tool I’ve...

Every Few Years, Someone Kills SQL Server, Here We Are Again

LinkedIn is doing that thing again. 'Is SQL Server...

Free SQL Server Performance Monitoring System Health Extended Event

From Erik Darling Data

Free SQL Server Performance Monitoring System Heal...

CONVERT_IMPLICIT: Why SQL Server Is Ignoring Your Index

From SQLFingers

 

Career, Employment, and Certifications

How to pass Microsoft certification exams: tips and guidance

In my previous article, I discussed how to prepare for Microsoft certification exams. In this article, I’m covering what you should do when actually taking the exams.

The World Needs More Software Engineers

From O'Reilly Radar - Insight

I sat down with Aaron Levie at the O’Reilly AI C...

Cloud - AWS

Launching S3 Files, making S3 buckets accessible as file systems

From AWS News Blog

Amazon S3 Files makes S3 buckets accessible as hig...

Community Interests

Making stuff go faster, from databases to the race track (with Matt Gordon)

Steve visits Microsoft Data Platform MVP and data consultant Matt Gordon near his home in Lexington, KY. They discuss his love of making databases go faster, AI, the pros and cons of MS Fabric, data quality, community involvement, and much more. Plus, learn all about Matt’s passion for motorsport and what he currently races on the track.

T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

From Data on Wheels (Steve Hughes)

I am delighted to host this month’s T-SQL Tuesda...

Computing in the Cloud (Azure, Google, AWS)

How to minimize downtime in a cloud migration

Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, and critical questions to avoid data loss and system failure.

DMO/SMO/Powershell

2026: Check Secure Boot Certificates of all Domain-Computers with PowerShell

From Sid 500 PoSh

The Microsoft Secure Boot certificate expires in 2...

Data Mining / Data Analysis

Why your data still can’t answer a simple question 

From Joyful Craftsmen – The Business Intelligence Agency

Every organization I talk to has the same problem ...

Traditional ALM is no longer enough – here’s why

From AllAnalytics

Asset and liability management (ALM) is still a co...

One-pass formulas for mean and variance

From AllAnalytics

 

Database Design, Theory and Development

A Practical Guide to Refactoring Production Databases with Redgate Data Modeler

From Product learning – Redgate Software

Refactoring a production database is rarely just a...

DevOps and Continuous Delivery (CI/CD)

Case Studies: Real-World Success Stories of FinOps Implementation

From SQLServerCentral Blogs

Learning any kind of theory is easy, but adapting ...

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

From SQLServerCentral Blogs

Working in DevOps, I’ve seen FinOps do amazing t...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Everything you need to know about MongoBleed (CVE-2025-14847)

From Simple Talk

Learn what MongoBleed (CVE-2025-14847) is, how the vulnerability leaks MongoDB server memory, which versions are affected, and how to protect your database.… The post Everything you need to know about...

ETL/SSIS/Azure Data Factory/Biml

The Day Our SSIS Catalogs Didn’t Match

From AndyLeonard.blog()

I knew what I was doing. I wrote the lifecycle man...

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

Role-Playing Dimensions In Fabric Direct Lake Semantic Models Revisited

From Chris Webb's BI Blog

Back in September 2024 I wrote a blog post on how ...

Writeback with Fabric Planning: What It Is, Why It Matters, and How to Get Started (with Gopal)

From Havens Consulting

LIVESTREAM DATE/TIME ??April 17th, 2026 (9:30 AM -...

PostgreSQL

Lætitia AVROT: PAX: The Storage Engine Strikes Back

From Planet Postgres

Thanks to Boris Novikov, who pointed me in the PAX...

Richard Yen: WAL as a Data Distribution Layer

From Planet Postgres

Introduction Every so often, I talk to someone...

David Wheeler: pg_clickhouse 0.1.10

From Planet Postgres

Hi, it’s me, back again with another update to p...

Lætitia AVROT: pg_column_size(): What you see is not what you get

From Planet Postgres

Thanks to my colleague Ozair, who sent me a JIRA t...

Vibhor Kumar: AI at the Edge, Truth in Postgres

From Planet Postgres

A practical blueprint for secure, private, high-performance AI systems Edge AI is having its inevitable moment. Not because the cloud is going away, but because reality keeps interrupting...

Jim Mlodgenski: pgcollection 2.0: Integer Keys, Range Deletes, and Oracle Parity

From Planet Postgres

In my first post about pgcollection, I introduced the collection type to address the challenge of migrating Oracle associative arrays keyed by strings to PostgreSQL. For integer-keyed associative arrays,...

warda bibi: The 1 GB Limit That Breaks pg_prewarm at Scale

From Planet Postgres

Recently, we encountered a production incident where PostgreSQL 16.8 became unstable, preventing the application from establishing database connections. The same behavior was independently reproduced in a separate test environment,...

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – new pg_get_*_ddl() functions

From Planet Postgres

On 5th of April 2026, Andrew Dunstan committed patch: Add pg_get_database_ddl() function   Add a new SQL-callable function that returns the DDL statements needed to recreate a database. It...

Ahsan Hadi: Using the pgEdge MCP Server with a Distributed PostgreSQL Cluster

From Planet Postgres

 

Laurenz Albe: Schemas in PostgreSQL and Oracle: what is the difference?

From Planet Postgres

 

PowerPivot/PowerQuery/PowerBI

Your Core Model Isn't Supposed to Do Everything | Power BI Extensibility Layer Objects

From Havens Consulting

Video by: Reid HavensHere's something that trips u...

Using visual calculation to highlight an entire row

From Sqlbi

How to highlight a row based solely on the maximum...

How to navigate the lattice of visual calculations

From Sqlbi

 

Professional Development

Two often forgotten, yet important tracks at a tech conference

From Dr SQL

I recently got back from several conferences DataT...

Python

Syntax and data structures in esProc SPL – a complete guide

In this article, you’ll learn about SPL’s core syntax elements, its primary data structure (the table), and how to perform common data operations. By the end, you’ll understand how to write effective SPL code and how it compares to equivalent operations in Python.

Python Supply-Chain Compromise

From Schneier on Security

This is news: A malicious supply chain compromise ...

Data analysis in Python and esProc SPL compared – what are the differences, and which is best?

From Simple Talk

Compare esProc SPL and Python for data analysis. Discover how esProc simplifies grouping, filtering, and data processing compared to Pandas.… The post Data analysis in Python and esProc SPL compared...

Security News and Issues

Amazon Bedrock Guardrails supports cross-account safeguards with centralized control and management

From AWS News Blog

Organizational safeguards are now generally availa...

Google Wants to Transition to Post-Quantum Cryptography by 2029

From Schneier on Security

Google says that it will fully transition to post-...

Hong Kong Police Can Force You to Reveal Your Encryption Keys

From Schneier on Security

According to a new law, the Hong Kong police can d...

Cybersecurity in the Age of Instant Software

From Schneier on Security

AI is rapidly changing how software is written, de...

On Microsoft’s Lousy Cloud Security

From Schneier on Security

ProPublica has a scoop: In late 2024, the federal government’s cybersecurity evaluators rendered a troubling verdict on one of Microsoft’s biggest cloud computing offerings. The tech giant’s “lack of proper detailed...

Google Addresses Privacy Concerns Around Gemini in Gmail

From Past News - RSS Feeds

Google says Gemini does not train on Gmail data, o...

Tech News

Scientists Train Rat Neurons for Real-Time Computing

From Past News - RSS Feeds

Scientists trained rat neurons for real-time compu...

Samsung Galaxy Watch Finally Brings Blood Pressure Tracking to the US

From Past News - RSS Feeds

Samsung is rolling out blood pressure monitoring t...

Ukrainian War Robots, Drones Hit Front Lines, Testing Russia’s Firepower

From Past News - RSS Feeds

Ukraine is using ground robots and drones to cut c...

European Startup Develops Flying Robots for High-Risk Infrastructure Repair

From Past News - RSS Feeds

Flying robots from AITHON Robotics are transformin...

China Opens ‘Robot Schools’ to Prepare Humanoids for Work, Home Tasks

From Past News - RSS Feeds

China is training humanoid robots in dedicated “...

Intel to Help Build Elon Musk’s Terafab AI Chip Plant for Robotics

From Past News - RSS Feeds

Intel has joined Elon Musk’s Terafab chip projec...

Meet ‘Alex’: A Disaster-Response Humanoid Challenging China’s Robotics Rise

From Past News - RSS Feeds

IHMC unveils Alex, a disaster-ready humanoid robot...

Netflix Unveils AI Video Editing Tool That Removes Objects, Recreates Scenes

From Past News - RSS Feeds

 

 
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

 

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