Refactoring SQL Code
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
2025-12-12
174 reads
software development
Done is Better than Good
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
2025-11-26
95 reads
PRs Are Like Trouble Tickets
Adopting a modern development approach brings with it the need to manage PRs, which Steve thinks can be like trouble tickets.
2025-10-01
114 reads
Requiring Technical Debt Payments
Steve found someone using an interesting approach to get developers to address some technical debt.
2025-09-08
147 reads
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
2025-06-25
164 reads
Patching the Patch
If you have had to fix the thing you just fixed with a fix, you might enjoy today's editorial.
2025-06-16
104 reads
Reflecting on the Mythical Man Month
Steve looks back at the Mythical Man Month, a book every software engineer and manager should read.
2025-06-06
105 reads
Database First or Application First
Today Steve is wondering how you approach coordinating application and database changes. Share which one you deploy first.
2025-04-16
175 reads
Using Feature Flags
Feature flags are being used in modern software development. Steve thinks these should also be a staple of database changes.
2025-04-07
372 reads
Monoliths and Microservices
Should we build modern software as monoliths or microservices? Or something else? Steve has a few thoughts today.
2025-03-24
135 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers