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

Less Junior Staff

As I've been working with some AI (Artificial Intelligence) technologies, what I've often found is that they produce junior-level code. The code I'd expect from someone early in their career or inexperienced in a particular area. That is code that likely works, but isn't efficient or clean or perhaps incomplete in some way.

I'm sure AI technologies will improve, and we'll be able to train them better for our environment. Just like we train junior developers to be better. However, what does that mean for junior people across the next decade? I ran across an interesting post on the death of the junior developer, which speculates we might have a problem as an industry.

The post references an article from Gene Kim, where a law firm sees a similar problem with their junior people, who are associates. That position might be equivalent to the junior developer in software. Someone with more experience and knowledge often reviews work and helps shape it, even though the junior person does the work. With AI, however, we might not need the junior person. Instead, the AI produces work the senior person has to review. Finding issues with associate work is a lot like finding hallucination problems in AI responses.

The same could be said of coding. There is plenty of poorly written code, but if senior people become good at writing prompts and getting the same code back that a junior developer would write, then how many junior people do we need? Arguably less, though you might still need a few. Or you might think that you need all the junior people and you'll get 10x more work done, clearing your backlog. Certainly, I know most developers, DBAs, and other IT people have a large backlog of problems.

However, the problem with junior people using LLM (large language model) AIs and getting more done is that they might generate a lot more bad code, so much that your senior people can't find the time to review the code and you end up with systems that contain even more technical debt than you have today. Perhaps we even find systems that don't perform well enough for regular use or create constant issues that your developers try to fix with AI, which might not work. I can certainly see things deteriorating rapidly.

There's a great quote in the Gene Kim piece: "I believe this furthers the case that AI helps the experienced people far more than inexperienced people — the seniors more than the juniors."

I'm starting to think that might be the case. Senior people are going to become very productive, and very valuable. Junior people are going to struggle, and while they'll get work done, the quality will vary. Maybe that's good, or maybe we will start to see a rapid divergence of not only productivity but salaries. If you can hire a senior person to produce better code at the same rate as your 5 junior people, maybe you'll want to pay that senior person $200k a year and reduce junior rates to $45k a year.

I don't know that we'll see rapid changes, as many organizations are slow to alter the way they hire, code, or structure their staff. However, as there is success by others, especially when it's touted in places like the ETLS, I can see other managers being influenced. That will filter over time to those who hire to pick the productive, senior-level people who can showcase some code skills in an interview. Craft a prompt to solve a problem, get some code back, refine it, explain where and why you'd change your prompt or use parts of the code, and we might see the AI-capable people getting hired quickly, and for fantastic compensation.

I don't know that I think this reduces a lot of junior staff, mostly because of organizational inertia, but I do think that learning to be better at your craft and learning to use AI is likely to increase your future earnings.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Big Northwind with AI

Steve Jones - SSC Editor from SQLServerCentral

As part of my work with Redgate, I wanted to do some testing on our subsetting and masking tools. Subsetting needs a big data set, and while Stack Overflow is big, it's kind of simple. I wanted something a little different. Since our engineers use Northwind to do a lot of demos, I decided to […]

External Article

Days of the Week, Bitwise Edition

Additional Articles from SimpleTalk

I recently had to help support synchronization and distribution of workloads between multiple servers.

Technical Article

Level up your learning in 2024 with PASS Data Community Summit

Additional Articles from PASS

Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.

Blog Post

From the SQL Server Central Blogs - Backup SQL Server to AWS S3 Bucket (2022 Update)

david.fowler 42596 from SQL Undercover

Way back in the mists of time I wrote a post on how to backup SQL server to an S3 bucket using TNTDrive, https://sqlundercover.com/2018/06/18/backup-your-on-premise-sql-server-directly-to-an-aws-s3-bucket/. Back then, if we wanted...

Blog Post

From the SQL Server Central Blogs - Boost Your SQL Skills: A Fun, Hands-on Challenge Awaits!

Tracy McKibben from RealSQLGuy - Helping You To Become A SQL Hero

Are you ready to take your SQL skills for a spin? The August 2024 SQL Practice is here to offer you a fun, hands-on learning experience. Designed with real-world...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

 Question of the Day

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

 

The SQL Server 2022 32 Bit Upgrade

I have a SQL Server 2014 SP4 instance that is a 32 bit version of SQL Server. Can I upgrade this to SQL Server 2022 with the setup program?

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)

Finding Data Types

What is the value of system_type_name returned in the result set from this code?

DECLARE @query nvarchar(max) = 'select ''1'' + ''2'' + 4';
EXEC sp_describe_first_result_set @query, null;

Answer: int

Explanation: This returns an int type, according to our implicit conversion rules and defaults. Ref:

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
64KB and 32KB cluster size for log drives and tempdb - Hi, I was told that sometimes log and tempdb drives benefit from 32KB cluster size as opposed the traditional 64KB.  How can I check this theory for a specific system?  I guess different database servers have different write patterns. How do I find out what write sizes a particular server uses the most and if […]
Timeout while trying to add database to availability group - Hello experts, I'm trying to learn what network access is being blocked when I get the timeout error below. It happens after I click Connect in the Add Database to Availability Group wizard. I have sometimes gotten around this by using T-SQL to add the db, but I want to finally understand how to fix […]
Using the Database Migration Assistant - Getting questionable results. - Hello, Firstly, apologies if I have posted in the wrong spot, I could not find a 'Migration' forum here. Happy to move it elsewhere if need be. I am using the Database Migration Assistant to recommend an Azure SQL Managed Instance SKU for an on-premises SQL Server 2017 instance. I ran the assessment over 3-4 […]
Windows 11 & sudden SSMS sorting nuisance - When I was still in Windows 10, I'd open up SSMS (version 18) and go to Object Explorer Details, where I would see the folders System Databases and Database Snapshots up at top and all the individual database names listed in alphabetically order (unless I sorted otherwise). Now that I've upgraded to Windows 11, something […]
SQL Server 2019 - Development
Why am I getting a "Incorrect syntax near '@tblName' error message? - I'm working on a SQL script to delete all old tables starting with the name of "Old_". I'm testing in my test database, but it raises errors. However, if I use the PRINT statement, everything is fine. I don't get what's wrong. I'm following Microsoft's Learn page on sp_executesql, and as far as I know, […]
How to calculate potential IO benefits of changes - I work on a multi terabyte warehouse database application which typically ingests between 130 and 180 million rows of data per day and processes into a data mart for them for consumption into a Tableau report. This is an on prem database using a virtual machine with 18 cores and 300 GB allocated to SQL […]
Lag function on an update not working - I have a table with odds from sportsbook, and I need to populate a gamedate value that is null . The gamedate in question coincides with the even numbered rotation rows of the data, below are samples of what i'm working with Create [dbo].gameresults ( gamedate date null, team varchar(50) null, rotation int null, odds […]
Reporting Services
What do I do about OBJ files, when I try to commit to a Git repository? - Today I was trying to store an SSRS project into a Git repository. (The SSRS project was written by a vendor.) I wanted to put it into Git so that if I needed to revert to an older version, I could do that more easily. I was going to use GitHub to store the repo […]
Powershell
Checking flag sometimes false\positive result - I have this script checking a SQL table looking for a result of True in a table. 99% of the times it works as designed, but on certain occasions it does not. I check this with a scheduler every 5 minutes. It sometimes produces a result of true in which hasn't been set to that […]
extract data from all servers and dump it into a table - I have 5 servers in the servers table . The code is not looping through all servers. Its only going to the ABC server 5 times and capturing data from ABC server 5 times. $Servers = Invoke-Sqlcmd -Query "SELECT ServerName FROM dbo.Servers" -ServerInstance "ABC" -Database "DB" foreach ($Server in $Servers) { $ServerName = $Server.ServerName If […]
Testing
Test1 - test
SSDT
SSIS MSOLEDBSQL: ConnectRetryCount, ConnectRetryInterval - Using SSISDB on server A, we have a parent package that loops through a configuration table and executes several hundred stored procedures on server B. Occasionally one of the processes fails with Failed to acquire connection "". Connection may not be configured correctly, or you may not have the right permissions on this connection. This […]
Analysis Services
How to create a Visual Studio project from an SSAS Multidimentional cube? - I was hoping there would be some sort of "import" feature but can't find it...
Job Postings
Hiring 15 skilled SQL devs for part-time freelance work. Jobs start @ $40 / hour - Are you a skilled SQL developer? Are you looking to supplement your income with high-paying, fully-remote freelance work? Are you interested in learning more about AI and its impact on the future? Join our talented community of SQL experts supporting the world's leading AI companies, and be competitively compensated for your hard-earned skills and insights. […]
SQL Server 2022 - Development
Index Update Reports - Scans/Seeks - SELECT DB_Name() As CurrentDatabase, objects.name AS Table_name, indexes.name AS Index_name, SUM(dm_db_index_usage_stats.user_seeks) as UserSeeks, SUM(dm_db_index_usage_stats.user_scans) as UserScans, SUM(dm_db_index_usage_stats.user_updates) as UserUpdates, GETDATE() as Createdttm FROM sys.dm_db_index_usage_stats INNER JOIN sys.objects ON dm_db_index_usage_stats.OBJECT_ID = objects.OBJECT_ID INNER JOIN sys.indexes ON indexes.index_id = dm_db_index_usage_stats.index_id AND dm_db_index_usage_stats.OBJECT_ID = indexes.OBJECT_ID WHERE dm_db_index_usage_stats.user_lookups = 0 ANDdm_db_index_usage_stats.user_seeks < 1 ANDdm_db_index_usage_stats.user_scans < 1 AND indexes.name IS […]
 

 

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

 

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