Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

Getting More Time from AI

As I get older, I find that time is the most valuable commodity I have. It's the one thing that I need more of, but I can't get it. Even if I find more efficient ways of doing things, it seems there's an endless list of things at work and on the ranch that need to be done.

It seems to be the same for most of my friends in other jobs, whether in medicine, law, or any other position; they're often overloaded with more work than they can get done in a week. Arguably, it's not all important work, as sometimes we might tackle a task, only to have our boss throw the work away or delay the project. That's annoying, but I also understand priorities change.

Mostly, I understand people ask for a lot of things they don't really need, but because it's easy to ask. Over time, they may forget about their request or realize they don't need it anymore. So I tend to do the work I'm asked and then not worry about if it's really needed.

However, that's not what this piece is about. Let's say that you have a useful AI Assistant that can truly produce better code, faster than you can. You trust the coding agent (under your guidance), and it saves you time. Let's say that this agent reduces your coding load by 30%. Forget the issues with the agent stealing your joy.

A number of studies show that the average developer only codes around 2-3 hours a day. Some might say 4, but that's just 50% of your workday (I hope). If you save 30% of that time, then you're saving 1:20 a day, 6:40 a week. That's a nice chunk of change, but what will you do with the time? Or maybe more importantly, what will your boss expect you to do?

A lot of management might see 30% and expect you to get 30% more coding done (of 40 hours), asking for 12 hours more of work. I see that a lot as management somehow things that developers work 8 hours a day and should get 8 hours worth of code written. When that doesn't happen, and it never does, they often schedule more meetings to check on your progress. Hence to 2-3 hours worth of actual work.

The smarter group of managers might think that you could get 5 hours more work done (30% of 3/day), and the really smart group of managers might use that time to improve the coding skills of the staff. That's more than a 10% allocation of time and if focused, could help developers write more efficient code (especially SQL), improve their secure coding knowledge, and perhaps even tackle some technical debt with refactoring of existing problem areas.

I know that many people are skeptical of AI assistance in coding. I think it's a tricky thing, but even if the AI doesn't produce production code, but allows me to conduct a lot of quick experiments that can prove out a hypothesis, I think it can help developers become more productive.

If they learn to use it as a tool and management doesn't expect it will turn every developer into a 10x (or even 2x) engineer.

If you had more time, what would you do in your work day?

Steve Jones - SSC Editor

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

Ad for State of Database Landscape survey
 
 Featured Contents
SQLServerCentral Article

When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server

Chandan Shukla from SQLServerCentral

Learn how a trace flag affects SQL Server reading from disk and where this might be a useful thing for you to enable.

External Article

Side by Side Upgrade to SQL Server 2022

Additional Articles from MSSQLTips.com

As a SQL Server DBA, the migration of SQL Server from an existing version to the latest version is a usual activity. In today’s cloud-oriented world, many organizations still prefer an on-prem environment; my organization is one of them. There are multiple reasons to keep your data on-prem, like having more privacy and control of the environment. Currently, our major project is to migrate our existing Microsoft SQL Server 2019 to SQL Server 2022. Recently, we completed the POC. Today, let’s discuss the steps of the SQL Server 2022 installation and migration of our databases.

Blog Post

From the SQL Server Central Blogs - How to Install SQL Server 2025 RC0 on an Azure VM

Koen Verbeeck from Koen Verbeeck

I wanted to try out the new JSON index which is for the moment only available in the SQL Server 2025 preview version. I know, it’s not even available...

Blog Post

From the SQL Server Central Blogs - How to Avoid Knowledge Stagnation

MarlonRibunal from Marlon Ribunal - SQL, Code, Coffee, etc.

You want the short answer? Well, the only antidote to knowledge stagnation is probably embracing the habit of lifelong learning. For the long-winded answer, read on. Have you ever...

The Phoenix Project

The Phoenix Project

Additional Articles from SQLServerCentral

In this newly updated and expanded edition of the bestselling The Phoenix Project, co-author Gene Kim includes a new afterword and a deeper delve into the Three Ways as described in The DevOps Handbook.

 

 Question of the Day

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

 

Changing the Recovery Time

I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance 
 SET TARGET_RECOVERY_TIME = 12 xxx;

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)

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

Answer: Run this: /opt/mssql/bin/sqlservr -m"SQLCMD"

Explanation: To restart the server, you use the -m parameter. The recommendation from Microsoft is that you limit access to the SQLCMD program by adding that to the startup call. Ref: Restore the master database on Linux in single-user mode - https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-restore-master-database-in-single-user-mode?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
how to get notification that my database has corssed 8gb - i have sqlexpress on rds, is there any way i can get notifacation that my datatbas has crossed 8gb?
SQL Server 2019 - Administration
statistics callection intervel in query store ? - Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed in minutes. The default is 60 minutes. Consider using a lower value if you require finer granularity or less time to detect and mitigate issues. Keep in mind that the value directly affects the size of Query Store data. Use SQL […]
SQL Server Auditing: Track Changes by Specific Users on Specific Database Tables - Hello Everyone! My organization is looking to implement a solution in SQL Server (2019 , 2022) that allows us to monitor all data modifications — INSERT, UPDATE, and DELETE operations — made by human users (e.g., DBAs, analysts, or developers) while excluding changes made by system or application service accounts. Has anyone implemented a solution […]
Editorials
Remembering Phil Factor - Comments posted to this topic are about the item Remembering Phil Factor
Pushing the Limits of AGs - Comments posted to this topic are about the item Pushing the Limits of AGs
AI Steals Joy - Comments posted to this topic are about the item AI Steals Joy
Article Discussions by Author
The Tightly Linked View - Comments posted to this topic are about the item The Tightly Linked View
Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines - Comments posted to this topic are about the item Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines
SQL Server, Heaps and Fragmentation - Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained - Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Parameter Sensitive Plan Optimization in SQL Server 2022 - Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in SQL Server 2022
SQL Server 2022 - Administration
Bottlenecks on SQL Server performance - We have a BI-application that connects to input tables on a SQL Server 2022 Standard edition. This is installed on a Windows Server 2022 in Azure with the size Standard E32s v5, having 32 vCPUs, 256 GB RAM, 32 data disks and 51200 max IOPS. The SQL Server is used for reading, updating and writing […]
SQL Server 2022 - Development
Is there some good routines for updating SQL Server database objects with GitHub - At work we've been getting better at writing what's known as GitHub Actions (workflows, YAML). I've got it deploying applications to websites, etc. It is cool. One thing users would like to have is a means of deploying updates to SQL Server database objects using GitHub Actions. I've thought about this and have come up […]
Rounding Off issue in SQL Server - I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64)  Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Facing issue in rounding off where this query is retuning 0.0000170000 instead of 0.00001672. Actual datatype is numeric(28,8), tried increasing precision - changing data type (which i cannot do in production) to […]
taking the rcsi dive - Hi, we put together an extract that runs every 15 minutes against what i believe is a homegrown somewhat unstable shop floor control app that runs separately for a number of plants on separate sql and app servers.   The app and data were separated in recent years to make all of this more stable. We've […]
 

 

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

 

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