Staying High
Today we have a guest editorial from Tim Mitchell. Tim talks about the need to stay motivated in your career after an event ends.
2011-10-03
126 reads
Editorials
Closing Out Replies
This editorial was originally published on Oct 17, 2006. It is being republished as Steve is at SQLBits 9 today. Should we change the way we deal with posts and replies? Answer today.
2011-09-30
78 reads
What’s In Your (Junk) Drawers?
Today we have a guest editorial from Andy Warren. Andy talks today about he various items that collect around your work space. Are they useful? should you be cleaning things up? What does this say about you?
2011-09-29
125 reads
Bits Bound
Steve Jones talks about his trip to SQL Bits 9: Query Across the Mersey, which begins today.
2011-09-28
94 reads
Know when to hold 'em
It's time for the SQLServerCentral Party at PASS and Steve Jones talks about the event.
2011-09-27
84 reads
Probabilities and Disaster Recovery
Today Steve Jones talks about the probabilities of different types of disasters occurring in your enterprise. He reminds you that the effort spent on disaster recovery ought to be related to the cost of the disaster, and the risk of it actually occurring.
2011-09-26
225 reads
Where are all the MVBs?
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
2011-09-26
146 reads
Big Gaps
Today Steve Jones talks about the gaps in our knowledge and our skill sets. He asks which things you think that all data professionals should be learning.
2011-09-23
366 reads
A Better Application Model
The AppStore model is one that Steve Jones likes, but he'd like to see it slightly more open over time and allow other companies to vet applications that users can then install on any system or device.
2011-09-22
108 reads
Data Quality on the Open Web
As we look to take more data from customers and clients and embed it in our applications, data quality becomes a bigger issue
2011-09-21
92 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