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

The AI Budget Assistant

I saw this article about AI helping IT leaders plan their budgets, and I had visions of certain departments getting cut, especially data-related ones. My concern is that a lot of what a DBA does can be acting as insurance or supporting others and not necessarily doing things which are easily visible or that might show up in reports, praise in Slack/Teams, or in other places an AI might be prompted to look. If an IT leader has to decide what's important for the AI to look at, is data included?

Of course, it's entirely possible the AI would look at all the performance problems and want to spend more budget on the data side. Fingers crossed for that interpretation.

The idea of an AI looking at a large amount of current data in various spreadsheets, reports, goals, requirements, usage, and more to synthesize a budget makes sense. This is the type of thing many AI-type technologies do well, finding patterns and summarizing the data in a way that assists a human in producing a final report of where to spend money.

Just like any report produced by a human, I would hope that someone reviews the results and verifies the analysis makes sense. However, in reality, I suspect a lot of human reports are passed along as-is, with only a cursory glance. The world of AI might make this worse as we can produce larger and more detailed reports.

The funny thing might be that whoever has to approve the budget might let their GenAI model summarize the budget for accuracy. In that case, do we need humans involved? I can see some managers trying to reduce the staff that might have internal knowledge and replacing them with GenAIs. Will we just have AIs producing things other AIs read and summarize?

Most of us know that garbage in/garbage out is a constant problem in the world of data and reports. Judging data quality and ensuring the accurate (and complete) data is fed into any system is something that humans need to be a part of. An AI model might assist, but humans have context and knowledge that can be hard to craft into a prompt. After all, this might be the training data for your model, and I'm not sure general models will learn well without handholding from humans, especially in specialized areas like budgets.

I've had to build budgets, and while I don't think it's hard, it's time-consuming. There is a lot of drudgery, and I think an AI can help here. However, I'd want to audit and check the data and ensure that my helper is summarizing the data in a way that makes sense to me. Even then, what I'd most like to do is let the AI give me a few suggestions of future costs and let me fine-tune those before I present them to anyone else. After all, if we make large errors, I suspect I'll feel the pain of failure more than my AI assistant.

Steve Jones - SSC Editor

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

 
 
  Featured Contents
SQLServerCentral Article

Why Standards are Important

David.Poole from SQLServerCentral

There is something in the tech mindset that simultaneously loves and loathes a standard. Having standards is important, what those standards are is less so.

External Article

How to Install SSIS in Visual Studio 2019

Additional Articles from MSSQLTips.com

This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install SSIS in Visual Studio 2019.

Blog Post

From the SQL Server Central Blogs - Challenges Enterprises Face When Adopting AI

Joyful Craftsmen from Joyful Craftsmen Blog

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

Blog Post

From the SQL Server Central Blogs - PASS Summit 2024 – A new experience

Diligentdba 46159 from Mala's Data Blog

I attended the PASS Data Community Summit held in Seattle in person this year after a long gap of 4 years and after RedGate software took over running the...

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

The Definitive Guide to Azure Data Engineering: Modern ELT, DevOps, and Analytics on the Azure Cloud Platform

Site Owners from SQLServerCentral

Build efficient and scalable batch and real-time data ingestion pipelines, DevOps continuous integration and deployment pipelines, and advanced analytics solutions on the Azure Data Platform. This book teaches you to design and implement robust data engineering solutions using Data Factory, Databricks, Synapse Analytics, Snowflake, Azure SQL database, Stream Analytics, Cosmos database, and Data Lake Storage Gen2.

 

  Question of the Day

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

 

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

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)

Data API Builder Operations

What types of database operations does the Data API Builder support?

Answer: any CRUD operation

Explanation: The Data API Builder supports all CRUD operations (create, read, update, delete). Ref: What is the Data API Builder? - https://learn.microsoft.com/en-us/azure/data-api-builder/overview

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 - Development and T-SQL
Read data from json file - I am using the following code to read a json file. I can display the keys and coreentitykey info. However, I am unable to view the attributes (Enable and Name). Not sure how to display with the other fields. Any help is greatly appreciated. DECLARE @json NVARCHAR(MAX) = N'[ { "metadata": { "numNodes": "1329", "metadataKey": […]
SQL Server 2019 - Administration
Cannot restore new DB - I have made an empty DB called "HJEM_BB" I try to fill it from a backup (From device) When i select the backup, it opens nicely. Sets it to overwrite, some time goes, and i get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'hjem_bb' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: Microsoft.Data.SqlClient.SqlError: […]
SQL Server Data...is it encrypted? - Hi Suppose someone gained unauthorized access to the physical SS data stored on my machine.  Is the data encrypted?  Will the user need a password to access the data?  Here is how I login to SS: Thank you
SQL Server Setup - We don't have an IT department that can help us. We have our SQL server on a laptop that an employee owns and manages. He no longer wishes to support us with the SQL database on his laptop. The employee is disgruntled, so we need to make sure he does not have access to the […]
SQL Server 2019 - Development
standard deviation function doesnt seem to be behaving like an aggregate - hi i have 6 statistical populations in my overall data set.  They run across 21 data points.  No matter what i try with the standard dev function, i get back all 21 data points, each with a repeated std dev for the population that data point is in.  from the looks of the function it […]
Using ROW_NUMBER() to increment every time a value occurs - Hello folks, I have some rather unstructured data coming into a staging column from a file. I can guarantee the order of the data on load using a column I am calling RowNumber. I like to group the data using ROW_NUMBER() every time the value 'CreateDate' occurs. Here is current my effort. Thanks if you […]
SQL Azure - Administration
Transfer data from azure vm to blob storage - Hi Experts I want to move data/ some million rows from a Azure vm table to Azure blob storage. What all are the best ways to complete this task?   Thanks Manoj Bhadiyadra
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises - Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to the on-premises SQL Server, it consistently fails. Additional Details: I have an […]
Reporting Services
The user data source credentials do not meet the requirements to run this report - I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that allows me to click on a link to pull up another report (sub-report) passing it a server name as a parameter. The Data Source is setup to use Embedded connection with the following connection string: ="Data Source=" & Parameters!ServerName.Value & ";Initial […]
General
When trying to use a LocalDB, I get an error - I tried to find an appropriate forum to post the question. This one seems to be the closest. I'm sorry if I'm wrong. This is a long story, which I haven't time to go into now. I'm starting a new Blazor Web app using .NET 9 and include what's called Individual Accounts (or Individual Users, […]
Powershell
display bytea image - I moved a table from MsSql to Postgresql that had a field defined as Image in Mssql now in Postgres it's a Bytea field. How can I make sure data copied across with success? Is there some code I could run to make sure Image looks correct from PostgreSQL ? Thanks.
Analysis Services
MDX SSAS Calculated measure for last totals + turnovers - I have a measure with totals for specific dates with the LastNonEmpty aggregation, and a measure with turnovers with the Sum aggregation. Help create a measure with totals for each day that would take into account the last known totals + turnovers from the date of the last totals to the current date. I tried […]
SQL Server 2022 - Administration
How do I fix the, "Unable to process the existing user settings" error message? - I'm sure I've asked this question in either this forum, or another one, in the last 6 months, but I am still struggling with it. Over the Christmas break, desktop support reimaged my dev box, so I would have thought this problem would have disappeared. But I am sadly mistaken. When I open SSMS 20.2 […]
I need help accessing my local SQLExpress - My PC has been causing me problems for months. I've told my desktop support team. They reimaged my machine, but it hasn't helped. I cannot run SSMS against the LocalDB I get this error: and that's as far as that goes. If I try to connect to LocalDB I get this error: and that ends […]
SQL Server 2022 - Development
What approach should I take in getting two databases to work together? - At work I am rewriting an old application which no longer builds. It was poorly written to begin with. The original developers, who wrote it about 15 years ago, didn't follow any convention that was used at the time. They created a database to collect data and added one table to handled identity. All users […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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