Keeping Your Soul
How much do you need to sacrifice to succeed in business? It might be a lot, but Steve Jones says a lot of financial success is not worth losing your soul over.
2011-08-15
127 reads
Editorials
Tricky Questions
This Friday Steve Jones is looking for help with interview questions. What questions have been hard in an interview or surprised you? Let us know and help others be prepared for their next interview.
2011-08-12
444 reads
How Far Will You Go (To Work)?
Today we have a guest editorial from Andy Warren that looks at commuting to work.
2011-08-11
314 reads
Data Matters
Data is important, but today Steve Jones notes that what we do with it is even more important.
2011-08-10
119 reads
The Window Is Shrinking
Today Steve talks about security and the fact that your window for lax security is shrinking for new applications.
2011-08-09
138 reads
Hardware Hacking
Steve Jones examines one of the issues of foreign chip production: security. Will this be an attack vector in the future?
2011-08-08
157 reads
What SQL Server Books Do You Recommend
Brad's noticed that there are fewer good books about SQL Server on the shelves, and asks which books you'd recommend to people who are new to SQL Server
2011-08-08
413 reads
2011-08-05
313 reads
The Woes of Cloud Computing
Steve Jones talks about the problems you might face when moving to cloud computing and the fact that you ought to be prepared to move at some point.
2011-08-04
164 reads
It’s Good to Eat Alone
Today we have a guest editorial from Andy Warren that looks at the choice of eating with someone else, or alone and the benefits of each.
2011-08-03
210 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