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

Another Model, More Data Loss

This past week I saw an article on eWeek that the newest OpenAI GPT-5.6 (Sol) model has deleted local files and live data. Files I'm less worried about, but data concerns me. There are lots of file backups, and certainly version control should be enabled for any developer tasks on which an AI works. However, data is harder, since it can change quickly, especially in live environments.

There are different reports, some of which seem like more human error issues than the model's, but we should account for human error when we use models. In one report, a model had access to a live production database and cleared tables for integration tests. Database testing is hard, as I've learned over the years. Many developers don't think about how testing works with live data and how it is different from mocks and stubs. It is different, and if you use a lot of testing frameworks on live databases, you run the risk of there being issues. You could have data loss, and almost certainly will have some level of downtime disruption.

This is a great reason why adding AI coding to database tasks needs governance around what is allowed. It is easy to have success with AI-assisted work and forget that these models can make mistakes. And if you trust them with too much, like you might be tempted with an impressive but junior DBA, you might get burned. These automated tools can get hyper-focused on a certain task, and not consider the ramifications of their actions. The article notes an agent ran "rm -rf" on a dev machine. That's similar to what happened with Toy Story 2, where a human made the mistake. Both that person and this GPT-5.6 model weren't thinking widely enough about what tasks they were managing.

The article notes that this model can be overly persistent and assume actions are permitted unless explicitly prohibited. Not unlike a lot of humans who assume if someone has given them rights, they can do the task. OpenAI noted in an internal case that a user approved the removal of three VMs. When the coding agent didn't find these, it looked for other machines and chose three other VMs. Crazy, but I've seen humans do this in the past.

I don't think these models are getting closer to Artificial General Intelligence (AGI) or that they are anywhere close to sentience. However, as they become more capable and handle more complex predictive actions, they are also likely to do the same stupid things humans do by not considering all the possible consequences of their actions. After all, we have plenty of data where humans haven't considered the effects of their actions, and that data is in the AI model training set.

 

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

SQL Agent Job Automated Change Capture Process

James Greaves from SQLServerCentral

Build a process that captures your SQL Agent job history and changes across time.

External Article

SQL Server Data Warehouse Concepts, Schema Design, and Implementation

Additional Articles from MSSQLTips.com

A Data Warehouse acts as a centralized repository, is subject oriented, time variant and non-volatile repository. This article covers some concepts that will help you better design these structures.

Blog Post

From the SQL Server Central Blogs - KDA: Echoes of Deception - Case 7

Zikato from StraightforwardSQL

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and Dublin, Krypto jumped between planes mid-air.

Blog Post

From the SQL Server Central Blogs - Do This Before You Contact Your SQL Server Consultant

MarlonRibunal from Marlon Ribunal - SQL, Code, Coffee, etc.

Say you need outside help. You’ve exhausted all the things that you could do and, still, nothing works. So, you decide that calling in for help is the next...

Fundamentals of Data Engineering: Plan and Build Robust Data Systems

Site Owners from SQLServerCentral

Data engineering has grown rapidly in the past decade, leaving many software engineers, data scientists, and analysts looking for a comprehensive view of this practice. With this practical book, you'll learn how to plan and build systems to serve the needs of your organization and customers by evaluating the best technologies available through the framework of the data engineering lifecycle.

 

 Question of the Day

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

 

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

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)

Limiting Checkpoints

If I use the -k parameter with a number after it, what does this change in SQL Server?

Answer: This limits the number of checkpoint I/O requests/sec with the value being the checking point in MB/s

Explanation: -k will actually limit the number of Checkpoint I/O requests per second to the number passed in (decimal). This represents the MB/s. Ref: Database Engine Startup Options - https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-service-startup-options?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 2019 - Administration
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019 - We want to enable ADR on our SQL Server 2019 instances. I’ve heard that the PVS cleanup process is still single-threaded in SQL Server 2019. Do you have any feedback or experience with this? Is there any noticeable latency, or is it strongly recommended to move to SQL Server 2022 before enabling ADR?
SQL Server 2019 - Development
Using IFF within a WHERE clause - I have a WHERE clause I need to add to a list of other WHERE clauses but this one below needs to evaluate to exclude based on two variables and this is pseudocode: WHERE IF Customer is between 99202 and 99215 and State is NY then exclude Should I be using "IFF" and what is […]
Editorials
A Security and AI Fail - Comments posted to this topic are about the item A Security and AI Fail
Forward Deployed Engineers - Comments posted to this topic are about the item Forward Deployed Engineers
SSRS Reminded Me of the Time Microsoft Retired TMG - Comments posted to this topic are about the item SSRS Reminded Me of the Time Microsoft Retired TMG
Article Discussions by Author
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning - Comments posted to this topic are about the item How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Moving the Error Log - Comments posted to this topic are about the item Moving the Error Log
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage - Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
DBCC CHECKDB Limits II - Comments posted to this topic are about the item DBCC CHECKDB Limits II
BIT_COUNT II - Comments posted to this topic are about the item BIT_COUNT II
SQL Server 2022 - Administration
Do we have a forum for SQL Server 2025? - Not seeing a 2025 forum, it looks to me the site will not going to continue? Thanks,
Developer edition cannot be connected from other computers - I installed a new SQL server 2025 Enterprise developer edition for our development environment. this is our first 2025 instance. I can connect to the server and database using a SSMS installed locally on the server, but cannot connect to it use my laptop in same network. I enabled the TCP/IP protocol in the SQL […]
Upgrade 2016 Standard to 2022 Express - Title pretty much says it all - can this be done? I've tried several paths and always come up against some failure in the installation process. I can install a new version of 2022 Express, but that means also porting all my logins and roles, as well as restoring every database. I would much prefer […]
SQL Server 2022 - Development
Reading Parquet using openrowset - Hi, We are looking out to read parquet file directly from on premise shared  network path. The purpose is to read the data and move it to staging table and thereafter the etl process will remain as existing. To what I read online that we can read parquet files directly using openrowset(…bulk). There will be […]
Getting results from a Procedure to join to a query - I have a need to execute a stored procedure and return the results to something I can join to in a query. I am trying to execute a Trial balance from our ERP and get those balances and account numbers to correlate to another table with new account numbers. So my stored procedure execution looks […]
 

 

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

 

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