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
 

Dancing Robot Goes Rogue

This is a headline out of a Hollywood thriller: Dancing robot busts a move, and dishes, after going rogue at California hot pot restaurant. It's an actual story about a robot that gets too close to a table and sends dishes and cutlery flying. In the news report, there is a ticker that says "employees restrain dancing robot in restaurwant.

The robot didn't go crazy or try to hurt anyone. It's really a dancing robot. In reports, it does say that the robot performs a expected, but the humans set it a little too close to the table at the request of the diners. In the video you can also see employee struggling to turn the robot off, which is disconcerting as mechanical systems can be far stronger than flesh and bones. Having kill switches or known ways to disable these systems is important.

Most of us won't likely deal with databases and physical robots anytime soon, but we certainly are being asked to evaluate, use, and perhaps trust automated agents and other AI technologies that may operate on our code and our live systems. More and more organizations are looking at AI to not only examine data and provide code, recommendations , or analysis, but with agentic systems, they may take actions.

What happens when a "digital robot" goes haywire in a software system? What if a monitoring system starts killing off sessions because it "thinks" (really predicts) that they are causing slowness. What happens if a DevOps robot thinks your code is ready and starts deploying changes? Or maybe worse, what if it detects issues and starts issuing undo commands for the last few changes made to the system? I know we've been concerned about these sorts of actions, AI-based or not, and tried to be careful what capabilities we build into Redgate Monitor. Adding too much autonomy could easily cause more issues than it solves.

There is tremendous opportunity with robots and agents, but we need guardrails, strong controls, circuit breakers, and easily accessed kill switches. While many of us would love AI to do our laundry, what happens when one of those robots goes wild? Stained clothes might be the least of our problems.

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

Get AI-Ready With Erik: Retrieval Augmented Generation

From Erik Darling Data

Get AI-Ready With Erik: Retrieval Augmented Genera...

Why most enterprise AI projects fail – and how to fix them

From Simple Talk

Discover why many enterprise AI projects fail and ...

It’s Here: AI Query Tuning

From Forrest Shares Stuff

Early in Covid, even before the mass awareness set...

Administration of SQL Server

Flashing Neon Sign for the Transaction Log

From Deb the DBA

Lately, I’ve been feeling like we’re not paying as much attention to transaction logs as we should. In fact, I’ve been saying there needs to be a flashing neon...

Non-Yielding Scheduler During Backups?

When you take a backup, the allocated extents are read from disk and written to wherever you asked, this could be local disk, a network location, some place in the cloud across the world. Seems pretty straight forward, taking away all the compression and encryption stuff for now. However, the database probably has things changing it while the backup is going

Everything you should know about the SQL Server Resource database

From Simple Talk

Learn what the SQL Server Resource database is, why it exists, how it affects patching/ upgrades, and what to do if it’s missing/corrupted.… The post Everything you should know about...

SQL MCP Server: From Setup to Live Data

From SQLFingers

In a previous post, I covered what SQL MCP Server is, why it matters, and why getting the security model right is non-negotiable. If you haven't read that one,...

SQL Server 2016: 111 Days. The Last Patch Just Dropped.

From SQLFingers

On March 10, Microsoft dropped a security patch for SQL Server 2016. It fixed a publicly disclosed, actively scrutinized elevation-of-privilege vulnerability — one that lets any authenticated user escalate...

Azure SQL Managed Instance

Double Your Core Count With Azure SQL Managed Instance

I’m going to open with a perhaps controversial statement: “when you buy 4 vCores on the Azure SQL Managed Instance platform, what you’re actually buying is 2 physical cores presented as 4 hyperthreaded cores to SQL Server”.

Career, Employment, and Certifications

The Opposite of Mental Rest

From Dr SQL

So, I wrote a blog about getting Mental Rest on Si...

To be where I need to be

From SQL Server Fast

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

Only Focus on A, B, and Z

From Callihan Data

I was listening to the “excellence, actually” podcast recently, and one of the co-hosts mentioned an idea that I recognized but had not heard termed in such a way...

8 Claude Prompts Professionals Use to Eliminate Repetitive Tasks

From Past News - RSS Feeds

 

Computing in the Cloud (Azure, Google, AWS)

The Lift-and-Shift Migration Trap (and Its Hidden Costs)

From Sherpa of Data

Part 3 in a series on evolving SQL Server environments into AI-ready architectures. Once organizations recognize the architecture gap we discussed in a previous post, the natural instinct is...

Conferences, Classes, Events, and Webinars

The 2026 Redgate Summit in New York City

From SQLServerCentral Blogs

We’re coming back to New York, which is exciting for me. I love NYC. The Redgate Summit 2026 – New York City comes back on May 5, 2026. You... The...

SQL Server Performance Office Hours Episode 53

From Erik Darling Data

 

Mastering DAX video course, 3rd edition

From Sqlbi

The third edition of the Mastering DAX video course is available! The third edition of the Mastering DAX video course is now available! The world has changed a lot since the release...

Excel

SUMIFS for Budget Reporting: Build A Summary Dashboard Without Pivot Tables

There are countless project managers and finance assistants all over the UK building summary dashboards, all doing the same thing.

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

Building the Well-Architected Framework for Fabric–My FabCon 2026 Talk

Yesterday, I gave a presentation at Microsoft Fabcon in Atlanta titled “Building the Well-Architected Framework for Fabric”. I’ve been a public speaker for nearly 20 years, and I don’t usually get nervous before a talk. Not that I was shaking yesterday, but given this was a new topic for me, and a big crowd

Exploring Fabric Ontology

I have been spending a little time with the Microsoft Fabric data agent documentation lately, and one pattern keeps showing up, and it is not just in the official guidance but in community posts from people who have actually tried to deploy these things: the demo runs beautifully.

Monitoring Fabric Mirroring for SQL 2025

From SQLServerCentral Blogs

I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is... The...

Fabric SSIS Public Preview: What It Changes – and What It Doesn’t

From AndyLeonard.blog()

 

Microsoft News

Microsoft Fabric FabCon 2026 announcements that will transform your data stack

From Purple Frog Systems

What Microsoft just revealed about the future of enterprise analytics… Microsoft’s FabCon 2026 conference unveiled a transformative vision for enterprise data and AI integration. Rather than incremental improvements to...

Performance Tuning SQL Server

Y’all Are Getting Good Free AI Advice from PasteThePlan.

From Brent Ozar Unlimited

PasteThePlan has a new AI Suggestions tab, and it’s been really fun to watch the query plans come in and the advice go out. Here are some examples: Date...

SQL101: Top Ten SQL Server Performance Tuning Best Practices

From In Recovery...

There are a huge number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially when you consider the...

SQL Server 2025 OPPO: Better Plans. Less Duct Tape.

From SQLFingers

 

PostgreSQL

How User-Defined Types work in PostgreSQL: a complete guide

From Simple Talk

Learn PostgreSQL User-Defined Types (UDTs) with clear examples of DOMAIN, COMPOSITE, ENUM, and RANGE types, plus practical SQL code for real-world use.… The post How User-Defined Types work in PostgreSQL:...

Vibhor Kumar: PostgreSQL HA Without SSH: Why Open Source efm_extension Matters in a Zero-Trust World

From Planet Postgres

Introduction: The End of “Just SSH Into the Box?...

Shaun Thomas: Using Patroni to Build a Highly Available Postgres Cluster—Part 3: HAProxy

From Planet Postgres

Welcome to Part three of our series for building a...

Deepak Mahto: PostgreSQL Sequence Reset: START WITH vs RESTART WITH vs SETVAL Explained

From Planet Postgres

Recently during one of the Oracle to PostgreSQL mi...

Richard Yen: EXPLAIN's Other Superpowers

From Planet Postgres

Introduction Most people who work with Postgre...

Umair Shahid: PostgreSQL High Availability on OCI: Why Your Failover Passes Every Test But Breaks in Production

From Planet Postgres

Your PostgreSQL HA cluster promotes a new primary....

PowerPivot/PowerQuery/PowerBI

Prevent Future Date Spillage in Power BI Visuals

For Power BI developers, one very common (and frustrating) issue is when measures spill into future dates on charts especially when working with some time intelligence DAX calculations (e.g. MTD, YTD, etc.), date dimensions that extend beyond current date, and forecast-enabled tables.

Power BI Report-Scoped Measures: 6 Patterns for Better Reports

From Havens Consulting

Video by: Reid HavensReport-scoped measures (aka r...

Perform Matrix Magic in Power BI! ?? #powerbi

From Guy in a Cube

 

Product Reviews and Articles

Monday Monitor Tips: Intelligent Alert Thresholds

From SQLServerCentral Blogs

 

Python

How to Build a General-Purpose AI Agent in 131 Lines of Python

Implement a coding agent in 131 lines of Python code, and a search agent in 61 lines

SQL Server 2025

The Burrito Bot: AI-Powered Search in SQL Server 2025

From SQLServerCentral Blogs

A while back I posted about a couple of side projects that I’ve been working on when I get the chance. One of those was the Burrito Bot…a bot... The...

Resource Governor in SQL Server 2025. A Good Change.

From SQLFingers

Someone runs a massive SELECT INTO #temp, tempdb f...

SQL Server News

My Wish List for SQL Server Performance Features

From Brent Ozar Unlimited

There are a lot of shopping days left before Christmas, and even more before the next version of SQL Server ships, so might as well get my wish list...

SQL Server Security and Auditing

They Hid Malware in a SQL Table. A weak password and BCP Did the Rest.

From SQLFingers

BCP. I love it. It's a workhorse — bulk copy data in, bulk copy data out, no drama. I've used it more times than I can count. Which is...

Security News and Issues

Google Moves Up Post-Quantum Cryptography Timeline

From SQLServerCentral Blogs

In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography are susceptible to Shor's Algorithm in quantum cryptography. Cracking those algorithms with classical computing is... The...

Software Development

Resolve Merge Conflicts the Easy Way

From You've Been HAACKED

Merge conflicts don't have to ruin your day. I use mergiraf for structural merging and a Claude Code skill for everything else. Here's how to set it up.

T-SQL and Query Languages

DATE_BUCKET performance versus conventional methods

From Dr SQL

A month and a half ago, I wrote a blog on using DATE_BUCKET. It is a cool feature thta makes doing some grouping really quite easy. It is here:...

Blazing Fast (and Accurate) Searches Without an Index

From Andy Broadsword

 

Tech News

ChatGPT’s Free Ride Is Over — Here’s the Bill

From Past News - RSS Feeds

 

The Lighter Side

CodeSOD: The Barren Fields

From Daily WTF

 

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

SSMS Updating and a new Grid Export Feature

From Dr SQL

During the Erin Stellato and Makena Barickman sess...

SSMS v22.4.1: Copilot is GA. So What’s It Do Right Now?

From Brent Ozar Unlimited

Copilot in SSMS has two parts. Usually people focu...

 
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

 

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