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

Is GenAI Coming Faster Than You Think?

If you're a fan, no. You're chomping at the bit, waiting to get everyone using GenAI models in their work. If you're skeptical, then you might think it's never coming to take your job, be a personal assistant, help you with coding, etc. Pick the task it won't help you with.

A more nuanced view, which is similar to mine, is from Kendra Little, in which she says AI will eliminate DBA Jobs  Faster Than You Think, I'm not quite as pro-AI as Kendra, mostly because I see so many companies that are slow to change, slow to adopt new tech, slow to adjust their thinking. They just soldier on and keep running their business, as they've been doing for decades. Even when you might make a case for change, or prove it's worthwhile, they just don't spend the time to change.

Make no mistake, change takes time. And time is a valuable and limited resource. Even if you don't appreciate time's value, many of you still don't want to spend time on new things.

In the piece, Kendra notes that she has been using an AI Agent to help get work done. She sees that agent getting better at tasks and helping her get work done quicker. At some point, she knows the GenAI agent will be able to help her do the work of multiple people. Not eliminating DBA jobs, but reducing the need. Can we have 3 DBAs instead of 5 or 10? Can we get down to 2, or even 1 with a part-time DBA service?

I do think that GenAI models and agents will help people get more work done, which might reduce the number of people an organization needs. However, I see no shortage of work in most organizations. In fact, I know of a few friends who can't seem to hire a talented DBA. Perhaps a GenAI agent can support them and help them get work done without the need for a DBA. Not now, of course, but maybe in a year or two.

However, humans still need to be in the process, and I suspect, even with an AI agent for every human, there's still a lot of work to get done. I'm not convinced this will reduce employment. I think it could increase employment, though the bar for employees will rise.

At least in some places. In some, they'll keep doing the same thing they've been doing since 2001, or 1994, or 1983.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

DeepSeek: What is new with this AI technology?

Daniel Calbimonte from SQLServerCentral

Learn how the DeepSeek GenAI LLM works and see how it produces SQL code.

External Article

Finding Out What Changed in a Cumulative Update

Additional Articles from Brent Ozar Blog

Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks that look like they’re going to lead to more information – but they simply lead back to themselves.

Blog Post

From the SQL Server Central Blogs - Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

Koen Verbeeck from Koen Verbeeck

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....

Blog Post

From the SQL Server Central Blogs - Save Azure PostgreSQL Backup to Storage

hellosqlkitty from SQLKitty

This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated...

Big Data Analytics cover

Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis

Site Owners from SQLServerCentral

Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.

 

  Question of the Day

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

 

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?

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)

The Backup Space Needed

How do I calculate the amount of space needed for I/O buffers during a backup operation?

Answer: This is the buffercount * the MaxTransferSize parameter values

Explanation: This is the buffercount * the MaxTransferSize parameter values. Ref: BACKUP - https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver16

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
Log Shipping Not Able to Restore Log Files in Secondary - I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I have restored the database in the follow storage layout on the SQL Server 2017 machine: D:\Data\.mdf L:\Logs\.ldf When I execute the restore job and it skips all log backups. I ran restore verifyonly for the log backups […]
SQL Server 2016 - Development and T-SQL
SSIS - ADO Source Datetime Issue - I'm using an ADO Net Source to extract data and running into an issue with timestamps changing before reaching the destination. I can log directly into the source system and see a value should be 2025-03-01 00:03:14 but SSIS is brining it back as 2025-03-01 01:03:14. I put a data viewer on it so this […]
Where to see how a Partition schema and function is defined - Please see the below. The dependencies of a table(the table depends on) shows Partition function and partition scheme. However I cant seem to find how and where this function is defined? I can see only user defined functions? Please guide on this
SQL 2012 - General
DbaTools With Powershell - Omit The Id Column on CSV Export? - I am learning DbaTools in Powershell, and my current project is exporting a CSV file. I've managed to get the code to work; however, there are situations in which I will need to omit the Identity column when exporting.  Is there a way to do this programmatically in DbaTools, so that the CSV file won't […]
SQL Server 2019 - Administration
ExecutionLog3 table in Reportserver Database - I have a SSRS report for which users are complaining to be slow, but from querystore, I can see that the SP (Report only has this SP execution) is taking less than 15sec. In ExecutionLog3 table, timedataretrieval for the same report is showing up to be for more than 20 mins. Could anyone tell me […]
SQL Server 2019 - Development
String or Binary Truncation Error Strange Behavior (SQL 2019) - Forgot I posted a similar issue back in 2020, String or Binary Truncation Error Strange Behavior, but here we are again, 5 years later with a somewhat similar issue. Here is the message from SQL Server: String or binary data would be truncated in table 'dbo.BAT_Test', column 'NewCode'. Truncated value: ''. Basically, a stored procedure […]
Cummulative Total - Hi I have below query and i want Cummulative Total . Total should be reset on change of Account SELECT ROW_NUMBER() OVER (PARTITION BY Account ORDER BY A."Account") AS "Row No", A."Account" AS "Account",(A."Debit") AS "Debit", (A."Credit") AS "Credit" From Master A Thanks
SQL Azure - Administration
Migrating mission critical database from SQL on Prem to Azure SQL - We are migrating our environments to Azure, it will be a mix of SQL managed instances and Azure SQL instances depending on the different system requirements. We offer realtime service to out clients and need to have minimal downtime hen we make the shift. The first database will be migrated to AzureSQL. Our on prem […]
Transactional Replication from Read replica - If I have Read replica (in Azure SQL MI), can it be used as a Publisher in transactional replication setup. I understand that Replication creates objects some objects in Publisher db, can we use listener name with applicationintent setting anywhere for it use Secondary instead of Primary. AWS DMS works similar to how transactional replication […]
Azure Data Factory
Is there a way to determine an Azure Data Factory Trigger's "next run time"? - Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a scheduled trigger will run next. Is similar functionality available in ADF?
Anything that is NOT about SQL!
Fantasy Football 2025 - The thread for the league in 2025. Players from last year have priority.
SQLServerCentral.com Website Issues
Everyone is a Newbie? - Everyone seems to be a Newbie with zero points today! Browser = Chrome
SQL Server 2022 - Administration
SQL availability group and file server role answering from the same name - Hello, I'm tasked with setting up a 2 node server cluster that will host a MS SQL availability group. I have the servers setup and the AG looks to be working well. However, there is also a requirement to hang a share off of one of the drives. I'm not crazy about this requirement, but […]
Installing SQL FCI Instance certificates - SQL FCI Instance certificates I have a client who has a requirement for certificates bound to the instance in a FCI environment. I have create the certificate and installed on both nodes, but I get a cluster error when failing over. The environment setup Node1 Node2 FCI Instance name\SQLInstance   Have set the FCI and […]
SQL Server 2022 - Development
SSIS how to manage source control with multiple packages / projects - We've got upwards of 40 SSIS solutions all stored in one GIT repository in teams.  I thought this was the proper way to go.  The problem is managing this when I am in the middle of developing one of those solutions.  What I usually do is just make a copy of the folder the solution […]
 

 

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

 

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