Programming
Programming is an important skill, perhaps extremely important for the future. Steve Jones thinks that's true.
2013-07-10
310 reads
Editorials
Reporting on Data
Reporting is an important skill for many data professionals. Steve Jones has a few things you might consider working on as a data professional.
2013-07-09
275 reads
Your Frame of Reference
How you examine and approach a problem might have a large impact on how you solve it. Steve Jones notes that it's important that all of us look at the problem from the point of view of the customer, as well as our own view.
2013-07-08
91 reads
A Better Conference
Is there a better way to put together a conference or event? Today Steve Jones speculates on how events are run and how we might change things.
2013-07-05
118 reads
2013-07-04
60 reads
Who's Got Your Data?
The state of data security might get worse in the future as more companies gather and share more data.
2013-07-03
150 reads
The Intrusion of Life
Life intrudes on work at times, and we must learn to balance the limited time we have. However we also need to remember that we work to live, not live to work.
2013-07-02
287 reads
Achieve Better Performance
This week Steve Jones talks performance and a few things you might want to do that can help your career and employer.
2013-07-01
340 reads
Give
The world is bigger than you, and when you help others, you realize that. Making that change might also make you happier, and more successful, in your career.
2013-07-01
113 reads
2013-06-28
192 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
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...
Forums
BCA KCP Pasar Kebayoran Lama Telp:0821-8200-174
Telp/Wa 62 8218200174 Jl. Raya Kby. Lama No.174, RT.8/RW.3, Cipulir, Kec. Kebayoran Lama, Kota...
ALAMAT BCA KCU SCBD Telp/Wa:0821-8200-233
Tlp Cs Bca 08218200233 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Alamat BCA KCP Mayestik Telp/Wa:0821-8200-2031
Phone Cs 08218200203 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta...
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