A Cloudy Future
The future of employment in the technology industry means learning to do more with less.
2012-09-10
141 reads
Editorials
Document First, Code Later
Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema.
2012-09-10
306 reads
The Dream Machine
This Friday Steve Jones has a fun poll. If your new boss told you to spec out a machine, what would you choose?
2012-09-07
152 reads
Privacy
Privacy is a big deal in the digital world, but it's also something companies don't handle well. Steve Jones notes that however things change in the future, the data professional will need to pay more attention to issues in this area.
2012-09-06
102 reads
Rogue Algorithms
As computers get more complex and automated, the chance for rogue algorithms grows. Steve Jones reminds us that we should be careful in how we code and that a little forethought from managers can help.
2012-09-05
209 reads
Ridiculous
Bad behavior at conferences hasn't been a problem at SQL Server events, but it has been elsewhere. Steve Jones thinks this is unacceptable.
2012-09-04
342 reads
2012-09-03
68 reads
Finding a Balance
This editorial was originally published on Nov 19, 2007. It is being republished as Steve is on vacation. With the tremendous amount of digital storage that people can carry around these days, how do you balance the security risks.
2012-08-31 (first published: 2007-11-16)
162 reads
The Personal Checksum
An interesting method of preventing restaurant fraud and a poll for other ways to determine the accuracy of data. This editorial was originally published on Nov 2, 2007. It is being republished as Steve is on vacation.
2012-08-30 (first published: 2007-11-02)
280 reads
Watch Your Mouth
The way you talk creates an impression at others. Steve Jones reminds us that we should be careful about using foul language.
2012-08-29
253 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