Increasing the Accuracy of Data We Rely On
GPS data is used by many applications. Steve notes that managing data like this might be hard inside organizations.
2020-12-01
77 reads
Editorials
Delivering Patches Quickly
Tesla updates their cars over the air while many other companies require you to move slow and visit a dealer. Steve thinks we can be more like Tesla as developers if we move to DevOps.
2020-11-30
88 reads
Bad career advice from a 14 year old
I was having a conversation with my 14-year-old grandson Thomas the other day. He was telling me that is signed up to take a programming class in school next term and sees a future career in technology. He loves playing video games, so maybe developing them would be a good choice. He also was thinking […]
2020-11-28
196 reads
Black Friday Wishes
Today Steve asks if there are things you might wish your employer would do for you this holiday season.
2020-11-27
108 reads
2020-11-26
66 reads
2020-11-25
72 reads
Privacy Problems in Apps
Lots of contact tracing apps are out there. Do you know which ones collect which types of data and what they do with it?
2020-11-24
169 reads
2020-11-23
121 reads
The Wide Impact of PASS
An organization, or an event, is more than just the name and structure. It's mostly the people.
2020-11-21
181 reads
2020-11-20
135 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