Distributed Monoliths
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
2024-12-06
170 reads
Editorials
Reducing the Cycle Time
Building software can be hard and lots of people have tried various methodologies to improve the way their teams work. Steve notes a lot of the process is the same, but he has a preference.
2024-12-04
102 reads
Doing a Little Research
I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell […]
2024-12-02
179 reads
Lies You Should Believe - Anything is possible
We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]
2024-11-30
143 reads
Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
2024-11-29 (first published: 2009-07-15)
303 reads
2024-11-27
116 reads
2024-11-25
191 reads
Giving Thanks
My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]
2024-11-24 (first published: 2024-11-23)
77 reads
New SQL Server 2022 Functions
There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.
2024-11-22
1,163 reads
Boring or Scripting
There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.
2024-11-20 (first published: 2015-05-18)
461 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers