2020-08-01
131 reads
Editorials
Research on the Changing Workplace
The workplace is certainly changing with the COVID-19 pandemic. Steve shares a few learnings from Microsoft's work from home experiment.
2020-07-31
128 reads
2020-07-30
81 reads
The Old Way or the New Way
Learning to adapt the way we work is important for advancing our career, but this can be harder than we expect.
2020-07-29
153 reads
2020-07-28
195 reads
The Computing Revolution
Steve reflects on some of the ideas of how Microsoft imagines the future of computing.
2020-07-27
191 reads
2020-07-25
396 reads
2020-07-24
99 reads
2020-07-23
98 reads
Hacking the Admin
A Twitter hack brings into the question of who can make changes in production for Steve.
2020-07-22
472 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