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

Building Your Own Software

Lots of AI usage has been spent inside companies on building new software. Sometimes people are trying to rebuild existing software. I've seen more than a few articles say that Slack is dead (it's changing), or Monday is dead, or some other SaaS isn't going to survive because people can vibe code their own replacement. I know a few people trying to do this, with very mixed success.

I saw this post from Jason Friend of Basecamp, where he noted that most products wouldn't exist if everyone were an entrepreneur. This is because the great products exist precisely because an entrepreneur had a great idea and followed it through. They made mistakes, they learned, and they spent a lot of time getting the product right. The coding was likely a part of this, but the mistakes, the changes of direction, the decisions on what to add or take away, those are time-consuming things not shortcut by AI. The coding isn't the big delay in lots of products. A great response to the post notes this: there are many decisions that go into a product. Many people don't think about all those decisions.

Certainly, some people will use AI and do a great job coding a replacement for some existing product. They'll make their own version of a product, likely learning a lot from existing software. They will shortcut some design and testing time since they know what they want. It's the software they already use, and they know how it works. They don't need to design it.

However, the software is just part of the process, especially in the SaaS world. Infrastructure and operations are big. While a replacement Slack might not need quite the level of hardware, networking, DR, disks, etc., it needs a lot more than an individual can build and manage. An LLM might help you determine where your bottlenecks are and help you build the systems needed to manage more resources, but it's going to take time. Especially if you don't know what sorts of hardware and bottlenecks will occur as more people use your software.

It's also going to make mistakes.

Imagine your LLM gives you a piece of bad code that doesn't perform. We can refactor and fix that. Now imagine your LLM doesn't configure DR correctly. Fixing that is a little harder, especially if you don't realize DR is lacking until an incident occurs.

Software is hard. One thing I've learned over the years in advocating for customers' requests in Flyway, SQL Prompt, or Redgate Monitor is that the coding takes time and effort, but much less than the decisions on what and how to build something. Those eat up time and focus. Once you solve these, AI definitely helps the rest go quicker, especially if you have AI building tests. However, until you solve the problems around coding, it's not necessarily faster or better.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server

Pablo Echeverria from SQLServerCentral

From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.

External Article

Time Series Data Mining Example with T-SQL when Adding New Data

Additional Articles from MSSQLTips.com

Please demonstrate the steps for updating an existing time series dataset used in a prior data mining project with a fresh batch of data. Then, repeat the mining performed for the original dataset with the freshly updated dataset.

Blog Post

From the SQL Server Central Blogs - AI Experiments: Claude Solved a DAB Issue

Steve Jones - SSC Editor from The Voice of the DBA

I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some sort of agent. I’m doing the same, but in this case, I had it tackle...

Blog Post

From the SQL Server Central Blogs - Restore SQL Server Database to an OrbStack Container

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

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack container in a Macbook. If you are like me who switched from a Windows laptop...

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration

Site Owners from SQLServerCentral

With built-in AI for application development and advanced analytics powered by Microsoft Fabric, SQL Server 2025 empowers you to innovate—securely and confidently. This book shows you how.

 

 Question of the Day

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

 

Symmetric Key Encryption

If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey
WITH ALGORITHM = AES_256,
KEY_SOURCE = 'My secret key source passphrase',
IDENTITY_VALUE = 'My secret identity value'
ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7';
GO

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)

DBCC CHECKDB Limits III

On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?

Answer: Yes, but only for disk-based memory-optimized tables

Explanation: DBCC CHECKDB can run on databases with memory-optimized filegroups, but only checks disk-based tables. Ref: DBCC CHECKDB - https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-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.


SQL Server 2019 - Development
whats that ssis analyzer product that documents lineage - hi, a few years ago was at a very large company that bought a software product that documents lineage i think in much the same way a dictionary would but automatically.   does anybody know what (if any) products on the market do that kind of thing and which is/are the best?
General
PowerBI Question - Data Sources - I don't see a PowerBI forum, so I'm posting here. I have a need to create a report using one query but multiple SQL Servers. I'm wondering if I could create a CMS registered group and somehow pass the query to all servers in the group at the same time and pull back the results […]
Editorials
What is CPU Usage? - Comments posted to this topic are about the item What is CPU Usage?
The SQL Server 2016 Plan - Comments posted to this topic are about the item The SQL Server 2016 Plan
The Mythical Bus Accident - Comments posted to this topic are about the item The Mythical Bus Accident
Article Discussions by Author
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened - Comments posted to this topic are about the item Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Limiting Checkpoints - Comments posted to this topic are about the item Limiting Checkpoints
SQL Server Certificates - Comments posted to this topic are about the item SQL Server Certificates
Connect an Azure Function to Azure SQL database Using a Managed Identity - Comments posted to this topic are about the item Connect an Azure Function to Azure SQL database Using a Managed Identity
Implicit Conversions Cripple SQL Server - Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III - Comments posted to this topic are about the item BIT_COUNT() III
SQL Server 2022 - Administration
Alamat Kantor BCA KCU Batam Telp:08218200203 - Hub Via Wa:628218200203 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi 36113
Alamat Kantor BCA KCU Kisaran Telp:08218200203 - Hub Via Wa:628218200203 Alamat: Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten Asahan, Sumatera Utara 21215
Alamat BCA KCU Pematang Siantar Tlp:08218200203 - Hub Via Wa:628218200203 Alamat: Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara 21117
SQL 2025 SSMS Nonsense - Yeah, I know this is a 2022 forum, but I don't see a 2025 forum at the moment. I downloaded 2025 Developer Standard edition and 2025 SSMS. I right click my database to import an excel sheet and "Import Data" is greyed out. Did my Google-Fu and found out that SSIS needs to be installed […]
 

 

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

 

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