Real Time Dangers
Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.
2011-11-08
152 reads
Editorials
Going Green in Software Development
Today Steve Jones talks about the impact of better software programming on the energy use in your company's data center.
2011-11-07
110 reads
Never offend a captive audience
Write what you choose to when the reader can, in turn, choose not to read your work; but when you are writing about Technology, you have a captive audience. They need to read your work to keep abreast of the technology. Don't gratuitously offend them. It is not the action of a gentleman, D____it!
2011-11-07
124 reads
ETL
Today we have an editorial that was originally published on Aug 31, 2006 as Steve is traveling at DevConnections. It still seems relevant, so answer the poll this week.
2011-11-04
217 reads
Laptop Boy Scouts
This editorial was originally published on Jan 10, 2007. Steve is at DevConnections, so it is being republished. This piece talks about laptop security when you are working in a public place.
2011-11-03
99 reads
Password Help
Today we have an editorial that was originally published on Oct 9, 2006. Steve Jones talks about the issues of turnover, passwords, and security.
2011-11-02
125 reads
Doubly Wrong
Today we have an editorial that was originally published on Nov 7, 2006 as Steve is at DevConnections. This one talks about SPAM and security.
2011-11-01
79 reads
Gold in the Execution Plan hills
There's more information hidden behind those graphical plans than you might first suspect.
2011-10-31
237 reads
Happy Halloween 2011
It's Halloween day, the night for dressing up in costume and being a little silly. Hopefully it's also a fun day without anything going wrong for you at work.
2011-10-31
77 reads
Employee Slurping
This editorial was originally published on Oct 21, 2006. It is being re-run as Steve is out at SQL in the City today. This one talks about the security of USB devices and the potential problems of employees copying data.
2011-10-28
189 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