Cutting Edge Technology
Cutting edge technology might vary for many people, and Steve wonders what you think.
2021-01-29
110 reads
Editorials
Impact Minutes
When downtime strikes, we may have to make decisions about which systems to focus our efforts upon. Steve talks about the impact of a disaster on your choices.
2021-01-28
108 reads
Remembering the Past
We had unfortunately lost quite a few members of our SQL Family. We have a new way to remember them.
2021-01-27
171 reads
Live versus Stored Data
Is it always important to have the most current data? Steve notes that you might need to make a decision here.
2021-01-26
147 reads
Are You Empowered?
Many people don't feel like they can make changes in their work environment. Today Steve notes this is common in many organizations.
2021-01-25
117 reads
Data Privacy Grows in California
Changes in data privacy law in California are demanded by consumers.
2021-01-23
78 reads
A Beginning Project
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
274 reads
How to Grow In Your Career
Today Steve Jones gives you ideas on how to keep learning and growing your career.
2021-01-20 (first published: 2018-01-19)
317 reads
2021-01-19 (first published: 2018-01-23)
404 reads
Default Credentials
Using default credentials is a poor practice, but people still continue to forget to change them.
2021-01-18
321 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