The Life List
Today Steve notes that having a list of things to do before you die can be a driving force for you.
2020-05-22
107 reads
Editorials
Investing in Speed
Much of what we do to improve ourselves is an investment in our work. The same thing could be said about businesses. Today a little advice about making an investment.
2020-05-20
180 reads
2020-05-19
94 reads
2020-05-18
148 reads
Bad Managers
I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]
2020-05-16
207 reads
Taking Quarantine Holiday
What will you do about vacation during the pandemic? Steve gives his thoughts.
2020-05-15
130 reads
Remote Sharing and Learning
Steve notes we all need to learn to communicate and share information better, especially while we are remote.
2020-05-14
122 reads
Smarter Design
Many of us have used PowerPoint, which has grown smarter through the use of Machine Learning.
2020-05-13
237 reads
Defending Against Ransomware
Many more companies that you have heard about have been attacked by ransomware. Steve suggests you get prepared before this happens to you.
2020-05-12
217 reads
2020-05-11
228 reads
Blogs
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...
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...
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