2020-05-09
152 reads
Editorials
2020-05-08
219 reads
2020-05-07
123 reads
Remote Data Challenges
While working remotely, we still need good security practices and strong data protection.
2020-05-06
223 reads
2020-05-04
124 reads
Representing uncertainty in difficult times
The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?
2020-05-02
188 reads
Are You Ready To Change Your Work Environment?
With many of us working from home, Steve wonders if you want to change anything.
2020-05-01
120 reads
A Security Regression
Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.
2020-04-30
116 reads
Where AI Shines
Artificial Intelligence hasn't always worked well, but there is one place that is seems to have lots of potential.
2020-04-29
169 reads
Keeping Unique Aliases
Steve prefers having standards, and today notes that aliases should be included in your standards document.
2020-04-28
147 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