Moving On After a Technology Fail
After his watch broke, Steve had to get a new tool and isn't sure it was a good move.
2025-02-21
90 reads
Technology
Where's the Printer Friendly Option?
Steve reminisces about the older technology of putting words on paper, often from the web.
2024-10-04
76 reads
2024-09-27
680 reads
AI Is Great and Tech is Failing
Steve is a little disappointed in technology that didn't work well after a security incident.
2024-09-25
202 reads
2024-09-21
162 reads
It's Time to Play
Writing editorials every few weeks for a technical mailing list has been one of the more challenging responsibilities in my (nearly) two years with Redgate as an advocate working with Steve, Grant, and Louis. Each week, it’s interesting for me to see the mix of technical insights and everyday life stuff that each of us […]
2024-08-31
443 reads
Continuity Across Restarts
A cloud version of Aurora MySQL has added support for the buffer pool to survive restarts of the database engine. Steve thinks that's an interesting technology, which could be helpful.
2024-01-12
146 reads
2023-11-24
178 reads
Using Technology for Health
I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
2022-03-05
129 reads
Digitizing Construction
One of the more analog industries is embracing digital change faster and faster./
2021-08-11
301 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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...
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