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

Prompt Requests

One of the challenges of AI-assisted coding agents is that they tend to produce A LOT of code. Even in refactoring or migration changes, the AIs can work quickly and generate such a volume of code that the process starts to become overwhelming. For pull requests, for CI/CD build systems, and certainly for human reviewers, they can be overwhelmed. This can become a real problem with OSS projects, where submissions can grow exponentially to the point that maintainers stop looking at pull requests. I suspect the same thing might happen in corporate repositories when lots of developers can refactor or submit huge amounts of code produced by AI agents in a fraction of the time it took a year ago.

I was listening to an interview with an experienced software developer and OSS project maintainer who said that he preferred getting a "prompt request" that contained a description of a problem and the specification for a solution that he could submit to his own LLM to get the code. Rather than use an AI to review a code in a PR written by a human or AI agent, a great prompt that can communicates the problem and solution is preferred.

That's a fascinating idea to me. Specify what you want and let the code owners send it to an AI and get a code response whose quality and focus they can decide to implement, based on their own context provided to an LLM (standards, style, patterns, etc.)

Of course, for open source projects, perhaps the maintainer doesn't want to spend time managing AI agents or working through quality, but this does allow them to focus on the idea being suggested rather than attempting to review code, test it, judge the quality, and perhaps request changes from the submitter. They can take your idea and implement it. If it's a simple fix, even better, as the maintainer might get quick help from an AI, using the style of code they are used to (their own).

Software engineering is changing a lot in the age of AI, and this seems to be one of the more interesting things I've seen suggested. Not YOLO or vibe-coding, but rather a prompt that suggests the idea and turns contributors into a specification written for the robot coder.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

T-SQL in SQL Server 2025: JSON_OBJECTAGG

Steve Jones - SSC Editor from SQLServerCentral

Learn about the new JSON_OBJECTAGG function in SQL Server 2025.

External Article

SQL Server Data Warehouse Concepts, Schema Design, and Implementation

Additional Articles from MSSQLTips.com

Companies generate a huge amount of data on a daily basis from such things as sales transactions, inventory changes, and customer interactions. This data originates from different data sources and is stored in operational databases called OLTP (Online Transaction Processing) systems that primary focuses on transactions like data inserts, updates or deletes. Maintaining the transactional data in an OLTP database is important. However, if you need to analyze or report on the data, storing the data in a centralized repository in well-structured schema is necessary.

Blog Post

From the SQL Server Central Blogs - From Planning to Practice: Setting Up Your FinOps Framework

HamishWatson from The Hybrid DBA's Blog

As someone who works in DevOps, I’m always focused on creating systems that are efficient, scalable, and reliable. But when it comes to the cloud, one critical piece often...

Blog Post

From the SQL Server Central Blogs - “We love to debate minutiae”

K. Brian Kelley from Databases – Infrastructure – Security

I am guilty as charged. The quote was in reference to how people argue about details in fitness or finances that are more detailed than is useful to them....

Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices

Steve Jones - SSC Editor from SQLServerCentral

In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.

 

 Question of the Day

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

 

An Unusual Identity

What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
     id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
     somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
    somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
 id
 FROM dbo.IdentityTest2

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)

Identities and Sequences II

In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?

Answer: Only the identity property

Explanation: Only the identity property does this. Since a sequence can be linked to multiple tables, or called independently, the consecutive numbers cannot be guaranteed. 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 - Development
String_agg not working as needed - I'm trying to get this string_agg to put all the 'comments' into one result field like instead of: 433    2018-11-06 11:08:12.793     Customer called 433     2018-11-06 11:08:12.793     Customer left message This is needed: 433    2018-11-06 11:08:12.793     Customer called, Customer left message Any ideas?: WITH MaxCommentCTE AS ( SELECT DISTINCT client_id […]
query to track time spent on individual tasks in SSIS - Hi everyone I am looking at building a query to determine how much time is being spent on each task in SSIS.  My SSIS package has a few containers and within each container there are tasks.  Once one container finishes processing then the next container gets processed.  I have never done this before so I […]
Editorials
Doing the Little Things - Comments posted to this topic are about the item Doing the Little Things
Everything is the right question away - Comments posted to this topic are about the item Everything is the right question away
Hidden Heroes - Comments posted to this topic are about the item Hidden Heroes
Changing Data Types - Comments posted to this topic are about the item Changing Data Types
Article Discussions by Author
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform - Comments posted to this topic are about the item Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform - Comments posted to this topic are about the item Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Historical Data Tracking - Comments posted to this topic are about the item Historical Data Tracking
Vectors in SQL Server 2025 - Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences - Comments posted to this topic are about the item Odd Sequences
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database - Comments posted to this topic are about the item SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Identities and Sequences I - Comments posted to this topic are about the item Identities and Sequences I
Fun with JSON II - Comments posted to this topic are about the item Fun with JSON II
SQL Server 2022 - Development
VS Code, Unresolved References. - Hi all, I just started using VS Code to work with DB projects.  I have a work-in-progress DB, meaning some of the objects are broken.  But, for those that are not broken, when I run dotnet build I get many unresolved reference errors that have no problem existing on the server or in SSMS.  The […]
 

 

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

 

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