Jobs for Data Scientists
Steve Jones talks about data science and the growing number of jobs that are available in this field.
2011-08-02
180 reads
Editorials
A Cast of Thousands
In a guest editorial, Rodney Landrum offers a light-hearted guide to role of each member of the cast in a typical SQL code deployment.
2011-08-01
158 reads
The Impact of Outages
Steve Jones talks about the problems of outages, and why we ought to perhaps introduce failure into our systems to help us learn to cope with them.
2011-08-01
81 reads
Geeky Distractions
This Friday Steve Jones has a non-work related, but fun poll. Let us know what your geeky media recommendations are this year.
2011-07-29
156 reads
You Can Telecommute
Today Steve Jones tells you can implement telecommuting at your job and gives you a few ideas how to get it approved.
2011-07-28
252 reads
Time for a ROWID?
Steve Jones looks to the future of SQL Server and wonders if we ought to add a rowid to the internal structures.
2011-07-27
246 reads
NewSQL Can Save the World
A new breed of products use the relational model and address the scalability concerns of many RDBMSes. Today Steve Jones talks about NewSQL databases.
2011-07-26
230 reads
Patches for SQL 10 and Techniques for SQL 11
Steve rounds up the patch news for SQL Server this week along with a look forward to the next version of the platform.
2011-07-25
128 reads
Be Reasonable
Be reasonable. That's how Steve Jones thinks managers ought to behave towards their employees.
2011-07-21
165 reads
I Want Stupid Employees
Why don't employers want to fund training? Steve Jones has a few thoughts after a great piece that shows the lack of wisdom in withholding training.
2011-07-20
329 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