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

AI Steals Joy

Take a moment and think about how much work you do each day. If you write code, how much time do you actually spend writing code around meetings, admin work, and other tasks. If you manage systems and develop scripts, how often do you get to work on a script, change it, upgrade it, or add a new feature? I bet it's a minority of time for most of you. Studies show that many developers spend only an hour or two writing code each day. I would guess it's lower for sysadmins or DBAs who incorporate coding into their jobs.

Now think about how much you enjoy each thing you do. I assume meetings aren't the most exciting thing you work on, nor is updating a document for others to read. When I wrote code as the main part of my job, solving the problem, trying different algorithms, experimenting with enhancements, those were the fun times.

Now imagine having a competent AI assistant that works with you. What if the AI does the coding and leaves you with the meetings and writing of specifications? It could happen. While it might be fun to direct a team of agents, you still need to understand software architecture and development, but you might not want to get away from writing code.

As more developers start to use AI agents to get work done, there is rising dissatisfaction among developers because the AI can do quite a bit of the coding, which is the thing that most developers love. The AI doesn't help with any of the other busy work, though AI agents might do a better job of ensuring docs match committed code (or released code).

What I'd really like is an AI that would take my place at meetings. Maybe do a report for me or take a summary back, get some action items for me. An AI agent could handle things that wouldn't necessarily be fun for me. Not all tedious things, but it could free up more time for coding.

However, that's not what the GenAI agents are being positioned to do. They're stealing the joyous part of development. At least, if managers have their way, that's the place they'll use GenAI most.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Parameter Sensitive Plan Optimization in SQL Server 2022

Deepam Ghosh from SQLServerCentral

Learn about a new feature of SQL Server 2022 - Parameter Sensitive Plan Optimization(PSPO)

External Article

Configure SQL Server Alerts for Azure SQL Managed Instance

Additional Articles from MSSQLTips.com

How can we setup alerts in Azure SQL MI to notify us when there are issues?

Blog Post

From the SQL Server Central Blogs - How to Reset the SA Password When You Get Locked Out

Tim Radney from Tim Radney - Database Professional

Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved...

Blog Post

From the SQL Server Central Blogs - SQL Server Log Shipping: The Tried and True of DR

Kevin3NF from Dallas DBAs

It’s not glamorous, but it works In a world where shiny new HA/DR features get all the press, there’s one SQL Server technology that just keeps doing its job....

The Unicorn Project

Site Owners from SQLServerCentral

In The Unicorn Project, we follow Maxine, a senior lead developer and architect, as she is exiled to the Phoenix Project, to the horror of her friends and colleagues, as punishment for contributing to a payroll outage. She tries to survive in what feels like a heartless and uncaring bureaucracy and to work within a system where no one can get anything done without endless committees, paperwork, and approvals.

 

 Question of the Day

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

 

Minimum Change Tracking Retention

If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);
What is the minimum amount of time I can set?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by dbakevlar)

Tables with a SPARSE Column and Consumption

True or False:  Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.

Answer: True

Explanation: The answer is TRUE. SPARSE columns are space-saving only when the majority of values are NULL. If most values are NOT NULL, they can consume more space than standard columns due to additional overhead. Ref: Sparse Columns - https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns?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 2012 - General
SQL Server authentication vs. Trusted connection - I maintain an application written years ago, where the database is on a Windows 2012 R2 Server and the database is SQL Server 2012. The people who configured this application made it so that it used SQL Server Authentication. I've always taken it to be the case that SQL Authentication was the only way of […]
SQL Server 2019 - Development
is there a way to "detect" schema like changes on a server? - Hi, we have a few people who like to experiment on our prod sql server with new tables, schema changes, dependency chain breaks, maybe ssis, even ssrs  etc etc without telling anyone till its too late.  They hold high ranking positions so forget your first thought.   I often end up with technical debt or sheer […]
SQL Azure - Development
How to resolve issue of custom Audit log table containing incorrect data? - We have created a parent table, child table & Audit log table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that are associated with the parent record. […]
SSRS 2016
ssrs subscription file share - I am trying to create a subscription that posts to a one drive directory.  I reset my password through microsoft and then copied that password when setting up the file share subscription.  When the subscription executes I get 'a logon error occurred when attempting to access the file share.  the user account or password is […]
SSDT
Visual Studio SSIS Package Showing Up Blank - Hi all, this is my first time posting on this forum, thank you all very much in advance. I have a .dtsx package open in Visual Studio, and one of the Script Tasks are erroring with "The binary code for the script is not found. Please open the script in the designer by clicking Edit […]
Snowflake, DataBricks, Redshift, and other cloud warehouse platforms
just finished a deep dive into snowflake - Hi, i know this is a sql forum but snowflake purports to interface with everything so i was hoping to get an opinion from some of the pundits in this forum. Does anyone in this community have an opinion either way of the snowflake product? One of the biggest areas of confusion is that they […]
Editorials
Guidelines and Requirements - Comments posted to this topic are about the item Guidelines and Requirements
Concerns over AI Chat Privacy - Comments posted to this topic are about the item Concerns over AI Chat Privacy
MySQL
MySQL 5.6 not writing any logs - We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We have enabled the error, general & slow logging in the config file, but the logs are not being written even in case of errors. The below is a snippet from the ‘my.ini’ file:     # Commented lines aren’t included [mysqld] […]
Article Discussions by Author
Copying Production Schema - Comments posted to this topic are about the item Copying Production Schema
Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric - Comments posted to this topic are about the item Workspace Identity Authentication for your Power BI Semantic Models in Microsoft Fabric
Database File Growth Report Script - Comments posted to this topic are about the item Database File Growth Report Script
The Duplicate Cursor - Comments posted to this topic are about the item The Duplicate Cursor
Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1 - Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1
What is Delayed Durability in SQL Server — And Should You Turn It On? - Comments posted to this topic are about the item What is Delayed Durability in SQL Server — And Should You Turn It On?
 

 

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

 

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