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

Collecting Data Is Hard

Data is the lifeblood of much of the world today. Not necessarily big data, and certainly not perfect data, and definitely not just digital data. Organizations, individuals, governments, really everyone out there are making decisions based on data. You might think it's going to rain, so you cut the grass today, or maybe defer adding fertilizer. Your organization sees demand for a product increase, so it orders more and produces more. Government is always using data to make decisions about resource allocation. We might not think governments make great decisions, but they do use data and data matters.

Recently I was reading a science fiction book (I, Starship) about the future, where a person's brain (Henry) becomes uploaded to manage a starship. This ship will travel light years away for 80 years and they need the human crew asleep in hibernation to survive the journey. The interesting thing, to me, was a part in the book where there is a discussion of why Henry was uploaded and why AIs aren't advanced enough to run the starship. There's this quote: "The first generations (of LLMs) performed well, but as time went on, we entered a situation where more and more of the data available to train them on was itself machine-generated. So, instead of mimicking high-quality human output, the outputs got more garbled."

I worry about this as the current models are sucking up so much data to learn, but so little of the new data is being generated by humans. We already see plenty of AI-slop on the Internet, with fewer and fewer articles, blogs, etc. being human generated. I'm sad because people don't share as much of their own thoughts, knowledge, etc. This is especially true in light of the AI companies taking individuals' work for training without compensation. Indeed, I worry that many places will go the route of Stack Overflow, where they essentially fail.

I'm worried about that here at SQL Server Central, as I see less questions being asked by humans and less discussion about the nuances of database challenges.

However, there are AIs out there also polluting the world. This was a piece from last year that more AIs are taking surveys and polls. Reddit is seeing questions being asked, and I'm sure there are AIs answering them. How long before the amount of AI generated traffic dwarfs human generated traffic? I mean new data, not consumption. I expect plenty of humans are going the way of the people in WALL-E and just consuming data. They'll continue to watch untold numbers of reels, shorts, Tik-Toks, etc.

Are we going to see less "real" data and more generated data? I already have seen no shortage of issues from customers trying to use synthetic data for testing. It doesn't match the real world well, but if they stop getting real data from customers and more from other bots, maybe it won't matter. Of course, I'm not sure how well their systems will perform in the real world.

GIGO is a real issue, and I expect a lot of companies will learn this as the volume of AI-generated data increases.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

Understanding Temp Tables and Table Variables in SQL Server

sabyda from SQLServerCentral

Introduction When building application backends or processing complex data sets in a SQL Server, we frequently need a temporary storage to hold the intermediate query results. For example: Store filtered rows before joining them to another table Hold calculation results inside a stored procedure Break a complex query into smaller readable steps Process a small […]

Technical Article

How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot

Additional Articles from SQLServerCentral

Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.

Blog Post

From the SQL Server Central Blogs - When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

James Serra from James Serra's Blog

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform. Power BI, data engineering, warehousing, data science, real-time analytics, Copilot, and other experiences can all...

Blog Post

From the SQL Server Central Blogs - Accessing the Data API Builder MCP Server from VS Code

Steve Jones - SSC Editor from The Voice of the DBA

I recently started playing with the MCP Server for SQL Server, which is a part of the Data API Builder (DAB). I’m not sure why there wasn’t a separate...

The Unicorn Project

Site Owners from SQLServerCentral

In The Unicorn Project, we follow Maxine, a senior lead developer and architect, as she is exiled to the Phoenix Project, to the horror of her friends and colleagues, as punishment for contributing to a payroll outage. She tries to survive in what feels like a heartless and uncaring bureaucracy and to work within a system where no one can get anything done without endless committees, paperwork, and approvals.

 

 Question of the Day

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

 

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

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)

RegEx Functions I

Which of these RegEx functions need compatibility level 170 in SQL Server 2025?

Answer: REGEXP_LIKE() and REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE()

Explanation: Of the functions that perform Regular Expression work, the REGEXP_LIKE() and REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE() functions require compatibility 170. The others work on SQL Server 2025 with other compatibility levels. Ref: Regular Expressions - https://learn.microsoft.com/en-us/sql/t-sql/functions/regular-expressions-functions-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 2016 - Administration
Two queries work until compared with EXCEPT statement - I've got multiple databases on 2 SQL 2019 CU32 servers , all using the same schema and code base. The only difference in patch levels is Test has the July Security Update and Prod has the March one. There's a Table Valued function that fails on one database only and only on prod. Of the […]
SQL Server 2016 - Development and T-SQL
Execute as failure - Security has long been a problem for me. Every time I think I understand something, along comes another issue to show me that I don't. I want to have an application on start-up query some information from a sort of status table, to see what it is allowed to do. I have a schema called […]
SQL Server 2019 - Administration
In-place OS upgrade or migration to new OS? - Putting this here as we're currently on SQL Server 2019 installed on Windows Server 2019, all hosted as VMs in Azure.  We've recently been handed down a directive to upgrade to Windows Server 2025 by the end of Sept (which, needless to say, is NOT going to happen by that time.) My preference would be […]
SQL Server 2019 - Development
Logic question in a WHERE clause using IIF? - Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the code has me stumped. I'm trying to add a filter in my WHERE clause that basically says "omit records if [BillingReason] in (1, 2, 3) AND ([NewInsID] IS NOT NULL AND [OldInsID] IS NOT NULL)". For example: [BillingReason] = 1, [NewInsID] […]
Editorials
A Challenge of Our Knowledge - Comments posted to this topic are about the item A Challenge of Our Knowledge
The New World Of AI Robots - Comments posted to this topic are about the item The New World Of AI Robots
An Eventual Consistency Scam - Comments posted to this topic are about the item An Eventual Consistency Scam
Never is Not the Policy - Comments posted to this topic are about the item Never is Not the Policy
Article Discussions by Author
The memory toll of VARCHAR(MAX) in SQL Server - Comments posted to this topic are about the item The memory toll of VARCHAR(MAX) in SQL Server
Transaction Log Truncation - Comments posted to this topic are about the item Transaction Log Truncation
BIT_COUNT() V - Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager - Comments posted to this topic are about the item How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Automating SSAS Multidimensional Security Audits with PowerShell - Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits with PowerShell
SQL Server 2022 - Administration
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts? - Hello We recently encountered an issue where a SQL table unexpectedly grew in size due to an application error. The table increased from a few gigabytes to around 11 TB within one week, which completely filled the PRIMARY filegroup. To prevent this from happening again, I would like to set up an alerting system that […]
SQL Server 2022 - Development
STRING_AGG DISTINCT - Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval of distinct values only? If yes, I'd be interested to see it, thanks.
 

 

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

 

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