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

The DBA is Dead; Long Live the DBA

I remember getting a job at a startup in the Denver Tech Center. This was shortly after SQL Server 7 was released, with a marketing campaign that the platform was auto-tuning and wouldn't require a DBA. My colleague asked me if I wanted to learn Cold Fusion and have a longer career. I declined and stuck with this SQL Server thing, which has seemed to work out pretty well over the years.

I was reminded of this when I saw a "Death of the DBA Again" post, this time from an Oracle DBA. There are plenty of links in there from Larry Ellison and Oracle about how some version of Oracle won't require a DBA. I've seen questions on Reddit (and elsewhere ) about this topic where people seem to think DBAs can be replaced.

Or maybe they want them replaced.

There are no shortage of posts on why this isn't the case (Grant, Kellyn, Brent, William, Boris). These all look slightly different, but the main thrust is that there is still data management-type work and people are needed to do it. Or maybe to direct the AIs to do it.

An interesting post from Kendra last year that we will see less DBA jobs because good DBAs can leverage AI to replace a few less-good DBAs. I like her approach, and the key reason why AI agent usage will grow is that they can potentially just make less mistakes than a human.

If that human is you, then you might not have a job.

I do think that the DBA as a gatekeeper or a single point of managing systems and ensuring backups/security/patches are made is dwindling. However, there are still lots of places for database-related work. High Availability setups are needed; someone has to work with InfoSec and auditors and implement their requirements. That might be especially important as those requirements might not be clear and clean enough for all your systems. While ETL might be a thing of the past with the various "links", without a doubt, people will link too many tables to analytics systems, leading to overloaded systems, too many resources being used, and costs being too high.

That might be a reason we will still need some type of DBA. They need to field the complaints from budget holders and work on a resolution to reduce costs.

The DBA will continue to exist in many organizations, but the job will change, and you need to evolve. There might be other organizations that don't want a "DBA" as a title, but they will need a data engineer, a full-stack developer spending more of their time on the database stack, an InfoSec person that mostly works on database security, or some other job that absorbs all the data-related chores.

There is a lot of opportunity still out there, but the bar is being raised, and one end of that bar rests on AI. Improve your skills, show your value, and become someone who delivers results and doesn't just say "No."

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

GPX distance and time analysis in SQL Server

Cláudio Tereso from SQLServerCentral

In this article we do a comparative analysis of the distance covered by two athletes during a race using the data of their GPX files.

External Article

Common Misconceptions About Microsoft Certification Exams

Additional Articles from SimpleTalk

An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.

Blog Post

From the SQL Server Central Blogs - Three Ways to Use Snowflake Data in Microsoft Fabric

James Serra from James Serra's Blog

Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now...

Blog Post

From the SQL Server Central Blogs - Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

SQLPals from Mission: SQL Homeostasis

Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022

If you’ve spent any time tuning SQL Server, you’ve probably heard “Turn...

Deciphering Data Architectures

Deciphering Data Architectures

Additional Articles from SQLServerCentral

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

 

 Question of the Day

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

 

Changing the AG Listener

In SQL Server 2025, if I want to remove an IP from a listener, what do I do?

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 String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')

Assume preview features are enabled.

Answer: 1

Explanation: This function calculates the number of inserts, updates, and deletes needed to transform one string into another. In this case, only one letter needs to be changed. Ref: EDIT_DISTANCE - https://learn.microsoft.com/en-us/sql/t-sql/functions/edit-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.


Integration Services
SSIS 2019 or 2022 - Microsoft Connector for Oracle - Hello all, I am having one heck of a time installing Microsoft Connector for Oracle on a VS2019 instance with Integration Services 3.15 and also on VS2022 with integration services installed. For the life of me, I cannot get the Oracle connection manager to show up when I right click on the connection managers and […]
Create txt file in SSIS without NON UTF-8 characters - Hello SSC Community, I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version.  […]
Create txt file in SSIS without NON UTF-8 characters - Hello SSC Community, I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version.  […]
Create txt file in SSIS without NON UTF-8 characters - Hello SSC Community, I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version.  […]
Editorials
25 Years of SQL Server Central - Comments posted to this topic are about the item 25 Years of SQL Server Central
You Have Homework - Comments posted to this topic are about the item You Have Homework
There Are a Lot of Databases - Comments posted to this topic are about the item There Are a Lot of Databases
Article Discussions by Author
The Decoded Value - Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS - Comments posted to this topic are about the item Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Automating Database Cleanup for PostgreSQL Using Python - Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL Using Python
The Query Optimizer and Page Density - Comments posted to this topic are about the item The Query Optimizer and Page Density
Adding and Dropping Columns II - Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform - Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
SQL Server 2022 - Development
bringing a .bak across the wire without rdp'ing or mapping into the sql server - hi,  a peer of mine would like to be self sufficient in bringing small .bak's over to her local without rdp'ing to the sql server or mapping a drive to that server or asking our dba for help. I dont even think she would mind if sql sent the .bak straight across the wire to […]
Create filegroups in partition - I have a table with partition on create_timestamp field. Though we're storing all data in one file group, the boundary values are defined for each quarter. I would like to add few filegroups for the next quarters: 2025-04-01, 2025-07-01 and 2025-10-01 I attached file for the partition, filegroup and rows info. With huge number of […]
 

 

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

 

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