Rewrite the Coding Rules
If we rewrite the coding rules, will software be more secure? Steve Jones thinks it might and that we should be constantly looking to change the techniques, patterns, and skills we have.
2012-09-24
220 reads
Editorials
Teammates
This Friday Steve Jones wants you to have some fun and compare yourself to an athlete or media figure, or even a fictional character.
2012-09-21
140 reads
Data Worms
Worms have been around a long time in computer systems. However changes in the global policies of governments and the possible retaliation for cyber warfare should have DBAs concerned.
2012-09-20
159 reads
2012-09-19
191 reads
Compress Everything
Data grows constantly and the size of some of our databases seems to have no end in sight. Steve Jones notes that we might just want to compress everything, just to keep up.
2012-09-18
282 reads
Three Rules for Database Development
Today Steve Jones talks about a series of rules he found for database development.
2012-09-17
604 reads
A Quick Count
This Friday Steve Jones wants to know if your career is also helping your wardrobe. (This editorial was originally published on Aug 23, 2007. It is being re-run as Steve is on vacation.)
2012-09-14
190 reads
More CPU Means More Data
Faster CPUs allow us to perform more complex modeling and analysis of variables, and hopefully come up with better decisions. However that more complex analysis means more data.
2012-09-13
176 reads
Creativity
What if you could stop all work for a month and have people find ways to improve the business? Would you take the chance?
2012-09-12
161 reads
Mining and Algorithms
The algorithms that you use to query or mine data are very important. Amazon knows their recommendations algorithms are important. Do you know what's important in your job?
2012-09-11
287 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