Coding More Carefully
If you had less resources or compilation too longer, would you code more carefully? Steve Jones talks about the benefits that might come from not having the latest and greatest hardware.
2012-01-12
225 reads
Editorials
Cloud Safety
Is the cloud secure? How can you be sure? Steve Jones talks a little about some ways you can try to check on your cloud provider.
2012-01-11
183 reads
Referencing Remote Data
Synonyms were added to SQL Server to make the references to remote data easier. However Steve Jones doesn't use them, do you? Are there benefits?
2012-01-10
162 reads
On Database Migrations and Agility
It always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development. Ideally, yes; but reality gets in the way.
2012-01-09
166 reads
The Stubborn DBA
Today we have a guest editorial from Phil Factor. Phil wonders why so many people in technology can be stubborn. Are you a stubborn DBA?
2012-01-09
540 reads
Read-only Data
Today's poll looks at read only data and how you handle the backup and recovery of this data.
2012-01-06
155 reads
Are Auto-Updates Good?
Internet Explorer is going to get automatic updates soon and Steve Jones thinks it's a mixed blessing.
2012-01-05
135 reads
Truth and Demos
Today Steve Jones reminds us that we are all selling something in technology, even if it's our reputation. We ought to be truthful in our dealings with our clients.
2012-01-04
142 reads
Cloud Patches
The cloud changes the way that we can administer and deploy changes to our systems. Steve Jones highlights an interesting idea, and hopes we get similar techniques applied to databases in the cloud.
2012-01-03
131 reads
SharePoint - Subversive?
A reflective editorial on how SharePoints and other collaborative work spaces are getting used.
2012-01-02
244 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