Code Supply Chain Security
Building software is becoming harder as new attacks try to inject malicious code into products.
2022-10-12
129 reads
Editorials
Things I've Learned About the Cloud
Steve shares a few things he's learned from customers trying to migrate their systems to cloud computing platforms.
2022-10-10
246 reads
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
2022-10-08
241 reads
Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
2022-10-07
275 reads
The Value of Seniority
Some people might seem like they are from the future, but their experience is just shining through.
2022-10-05
177 reads
The Growth of IQP
Steve talks about some of the Intelligent Query Processing improvements in SQL Server 2022.
2022-10-03
289 reads
How Important is Software?
The user experience from our software is important. Maybe more than many developers realize.
2022-10-01
72 reads
Cloud Databases
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
2022-09-30
562 reads
The Right Connection
Making a connection to the wrong database had disastrous results for Travis-CI.
2022-09-28 (first published: 2018-04-19)
238 reads
2022-09-26 (first published: 2018-03-16)
410 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
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers