Better Technical Interviews
Technical interviews don't work great, but are they dead? Is there a better way? Steve Jones comments today.
2013-06-27
360 reads
Editorials
Great Engineering Culture
Building great culture in a company is hard, and it takes work. Building great engineering culture can be more challenging, given the strong ideas and opinions people have in technology. Steve Jones has a few thoughts today.
2013-06-26
159 reads
More Data Security Issues
The state of data security is getting better in the US, according to the 2013 survey from Symmatec. However we still have issues.
2013-06-25
125 reads
Great DBAs do <blank>
We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?
2013-06-24
297 reads
When Is Work, Work?
Where is the dividing line between work time and personal time? As more and more employees get new phones, such as the Blackberry and iPhone, is the line becoming too blurred? Are there legal implications?
2013-06-24 (first published: 2008-09-09)
309 reads
A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
2013-06-21 (first published: 2008-08-14)
212 reads
Lost in Space
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
2013-06-20 (first published: 2008-09-03)
189 reads
SQL Server Should Work for Us
SQL Server is a great platform, but there are problems in places. Steve Jones thinks that fixing some issues might be a good investment for Microsoft.
2013-06-19
206 reads
The Best Programmers
How do keep the best programmers? Steve Jones has a few thoughts that might cause you to rethink how you manage your programming stars.
2013-06-18
390 reads
Losing Data
As data professionals, we want to avoid losing data. We won't always be successful, but we can avoid making the easy mistakes.
2013-06-17
115 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