2025-03-26
1,185 reads
2025-03-26
1,185 reads
Steve has a few thoughts after the end of mainstream support for SQL Server 2019.
2025-03-26
19 reads
Often we find out about a problem reported by a customer after the incident has passed. This might be from a trouble ticket or even an email that we...
2025-03-24
4 reads
Should we build modern software as monoliths or microservices? Or something else? Steve has a few thoughts today.
2025-03-24
81 reads
2025-03-24
436 reads
The main thing is to keep the main thing the main thing. – from Excellent Advice for Living We can summarize this advice as focus on what’s important. I...
2025-03-21
4 reads
2025-03-21
351 reads
I was asked about state-based deployments in Flyway Teams, so I decided to show how this can work with a quick demo. This post walks through the process. I’ve...
2025-03-21
13 reads
Code is vulnerable to supply chain attacks, which aren't something many of us think about.
2025-03-21
69 reads
We published an article recently at SQL Server Central on Tally Tables in Fabric from John Miner. In it he showed how this can be efficient. A day after...
2025-03-21 (first published: 2025-03-12)
6,897 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
We've got upwards of 40 SSIS solutions all stored in one GIT repository in...
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Comments posted to this topic are about the item Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers