An Age of AI?
The age of artificial intelligence seems to be here, but it's a little different to what we were promised.
2019-07-22 (first published: 2016-02-15)
450 reads
DaveConvery
2016-10-17
110 reads
2016-04-18
93 reads
SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
2015-11-02
298 reads
Who Cares About Your Data?
The observation that people hear what they want to hear is not a new one, and yet the extent to which people will go out of their way to ignore or misinterpret evidence can still surprise.
2015-06-01
122 reads
Email In The Bathroom: Not A Universal Good
Here are some fine, affordable products to completely destroy your work-life balance.
2015-04-27
177 reads
2015-02-16
90 reads
Fine Products for the Modern Drudge
As working hours in tech trend upwards, we look at some ways to make life easier.
2014-10-13
148 reads
The Broad View
An ingenuous use of existing data leads to the thought - when are we so deep in our work that we can't see how to improve?
2014-08-18
67 reads
Running With The Red Queen
Trying to take the time to fix sub-par processes has some surprising parallels in nature.
2014-04-28
186 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
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