Keep. It. Simple.
How simple should software development be? Steve notes it can be simple, but not too simple.
2024-10-09
198 reads
software development
Storing and Retrieving the Initialization and Configuration Data for Applications
All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.
2024-10-04
Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
2024-09-20
472 reads
Event Streams for Persistent and Asynchronous Microservice Communication
This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.
2024-09-11
A Lack of Architecture and Planning
Today Steve talks about how we end up with software systems that don't appear to be well engineered.
2024-08-19
218 reads
A Programmer's Attitude
The way we approach development can have a big impact on quality, as well as how smoothly our team works together.
2024-07-19
181 reads
The Cost of Rework
Steve notes that we're always better doing things better the first time. That takes some effort.
2024-07-01
183 reads
Common Algorithm Concerns
Steve doesn't have a lot of concerns about AI models writing code and reusing algorithms, but others might not feel the same way.
2024-05-29
218 reads
There's No Free Lunch with Open-source Software
As a member of the PostgreSQL open-source community, I have been following the recent license change by Redis Labes on March 20, 2024. Redis introduced a dual license model, specifically adding the Redis Source Available License (RSAL), which prevents other vendors from providing Redis as a service without a paid subscription from Redis Labs. The […]
2024-04-13
223 reads
The Code Freeze
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
2024-04-10
234 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers