2021-04-14
62 reads
Editorials
2021-04-13
188 reads
Easing Back to the Office
Companies are starting to bring people back to the office. Microsoft has announced their policy, and Steve wonders if more will follow.
2021-04-12
129 reads
2021-04-10
135 reads
2021-04-09
149 reads
2021-04-08
238 reads
Growing Outside of the English World
The world is bigger than one country, and Steve is trying to remember that.
2021-04-07
88 reads
Removing SA from Azure SQL Database
Azure SQL Database is getting the ability to turn off SQL authentication.
2021-04-06 (first published: 2021-03-23)
847 reads
Maintenance Windows
Is it better to ask forgiveness than permission? Some people take that approach to maintenance windows, but that isn't permissible in the cloud.
2021-04-05
180 reads
Malleable Source Control
Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]
2021-04-03
227 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