Bad Stored Procedures
Stored procedures can be poorly written, but Steve prefers them over embedded code.
2024-09-20
414 reads
software development
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
200 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
163 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
150 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
193 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
154 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
207 reads
Database Feature Toggles
In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code.
2024-03-22
Re-platforming
Sometimes you need to completely change your software, perhaps on a new platform. Steve has a few thoughts on this drastic action.
2024-03-20
165 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
Putting the Player with the Number
Comments posted to this topic are about the item Putting the Player with the...
Your Security Checkup
Comments posted to this topic are about the item Your Security Checkup, which is...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers