Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Limit the Blast Radius

You still need DBAs (that know how to back up systems and test restores). If you think you don't, or if you manager does, then perhaps they ought to read this piece on how an AI agent deleted a production database. This wasn't the case of an agent just running around with sysadmin access to all resources, or a lack of tests that allowed bad code to flow through a CI/CD process.

This was a system design that had a hole in it. An API call to change infrastructure that could change both staging and production. Not something an AI set up, but humans did. A hole from both PocketOS and the API vendor that allowed the AI agent to make the same type of mistake we've seen humans make. A mistake of not double checking, not verifying, not following the rules of getting a second set of eyes, even a second set of virtual eyes, on the code.

Reading this, I can imagine this is how some of the AWS and Azure outages occurred over the last decade. Not the 2025/2026 AI inspired ones, but the 2010-2015 human mistakes that didn't expect a change to have such a far reaching blast radius,

You still need guardrails, for both humans and AIs. Don't get slack and assume either truly knows what they are doing and deserves rights everywhere. Don't assume that your guardrails were setup correctly. AI agents make great helpers. Use some read only ones to examine your setup and look for holes. If/When we get the next Claude Mythos model (or the equivalents from Google/OpenAI/etc.) have it look for precisely the types of holes that come from bad code that looks to reset, redeploy, or re-anything in your environment.

We separate out roles for different people to limit the blast radius of the mistakes we inevitably make. AIs aren't necessarily smarter or better than humans. Just faster. We need separate roles, separate rights, and governance for AI agents, precisely because they can make decisions faster than humans.

There's tremendous potential, but and tremendous danger in allowing anyone, or anything, too many rights in any organizations. RBAC, audits, and all the other things we implement to try and reduce the number of silly mistakes are still needed. At some point we're going to see amazing social engineered emails, messages, XSS, and other items that are designed to fool the AIs that look to help us.

We need to ensure we set good guardrails and limits when that starts to happen. Or we're going to lose control much quicker than expected.

PS If you want a fun and slightly scary read on how AI could go sideways, I enjoyed The Final System recently, which made me not want to deploy any sort of AI agent beyond tightly scoped ones with very, very limited rights.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

PASS Europe comes to Frankfurt

Steve Jones - SSC Editor from SQLServerCentral

PASS Europe comes to Frankfurt, Germany on June 10-11, 2026.

Stairway icons Database Deployments

Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments

Massimo Preitano from SQLServerCentral

After defining the deployment contract in the previous level, this article focuses on validating a changeset before it reaches production. Rehearsal across environments ensures that execution order, rollback behavior, and baseline alignment all behave exactly as expected.

External Article

You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.

Additional Articles from Brent Ozar Blog

When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen to execute one particular time.

Blog Post

From the SQL Server Central Blogs - Understanding Fabric MCP

James Serra from James Serra's Blog

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

Blog Post

From the SQL Server Central Blogs - PowerShell Strikes Back: Know Your Quotes, Young Padawan

gbargsley from GarryBargsley

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

Technical Article

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

Site Owners from SQLServerCentral

This book is your comprehensive guide to building robust Generative AI solutions using the Databricks Data Intelligence Platform. Databricks is the fastest-growing data platform offering unified analytics and AI capabilities within a single governance framework, enabling organizations to streamline their data processing workflows, from ingestion to visualization. Additionally, Databricks provides features to train a high-quality large language model (LLM), whether you are looking for Retrieval-Augmented Generation (RAG) or fine-tuning.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Distance Metric Algorithms

What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?

Answer: cosine distance, Euclidean distance, and dot product

Explanation: The three distance metrics are: cosine distance, Euclidean distance, and dot product Ref: VECTOR_DISTANCE() - https://learn.microsoft.com/en-us/sql/t-sql/functions/vector-distance-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2017 - Administration
How do I explain that SQL Server should not be used as a code repository? - This week my BI Developer colleague proudly showed me a new Power BI report that he'd vibe-coded. Here's how it works: Write a SQL query that selects the data needed for the report, concatinates it into one massive row, then format that row as a JavaScript array. Write your custom report as a html web-page, […]
SQL Server 2019 - Administration
SQL Password enforcing - Hi to all We have situation at a client where someone is illegally changing passwords, reactivating sa user etc with a 3rd part tool. Does anyone know of any way to stop password updates. Note we this guy is stopping sql agent services and auditing while he does whatever he does, so he causing some […]
SQL Password enforcing - Hi to all We have situation at a client where someone is illegally changing passwords, reactivating sa user etc with a 3rd part tool. Does anyone know of any way to stop password updates. Note we this guy is stopping sql agent services and auditing while he does whatever he does, so he causing some […]
Data Transformation Services (DTS)
How are you handling sensitive data when using AI for queries or transformations - Hi everyone, I’ve been looking into using AI for helping with data-related tasks (writing queries, transforming data, explaining datasets, etc.), and something that’s been on my mind is how to deal with sensitive data. In a lot of real-world cases, the data isn’t exactly something you can just paste into a tool — things like […]
Editorials
The Dangers of Dependencies - Comments posted to this topic are about the item The Dangers of Dependencies
Who is Using CAGs? - Comments posted to this topic are about the item Who is Using CAGs?
What Are You Waiting For? - Comments posted to this topic are about the item What Are You Waiting For?
SQLServerCentral.com Website Issues
SPAM Issues May 2026 - We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off for lots of IT staff, including a Monday holiday. We declared an incident early on 6 May and started working on the problems. We have taken the following actions, which may disrupt some legitimate users, but hopefully few: We've invalidated all […]
Article Discussions by Author
Creating a JSON Document III - Comments posted to this topic are about the item Creating a JSON Document III
Stairway to Reliable Database Deployments Level 2 - Defining the Deployment Contract - Comments posted to this topic are about the item Stairway to Reliable Database Deployments Level 2 - Defining the Deployment Contract
PASS Europe comes to Frankfurt - Comments posted to this topic are about the item PASS Europe comes to Frankfurt
SSC Spam - Comments posted to this topic are about the item SSC Spam
What is New in SQL Server 2025 - Comments posted to this topic are about the item What is New in SQL Server 2025
May the Fourth Be With You Fun - Comments posted to this topic are about the item May the Fourth Be With You Fun
Increase Deadlock Detection - Comments posted to this topic are about the item Increase Deadlock Detection
 

 

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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