How Do We Learn?
With a huge increase in the number of online learning frameworks, Dave Convery wonders how comfortable people are with this new way of polishing their skills.
2013-06-03
228 reads
Editorials
Relying on Algorithms
Today Steve Jones looks at the way software affects the world and how we might be worried about how things might change in the future.
2013-06-03
129 reads
The Bicentennial
Tomorrow is the bicentennial SQL Saturday event. SQL Saturday #200 takes place in Philadelphia, and Steve Jones has some thoughts as he travels to the City of Brotherly Love.
2013-05-31
81 reads
The Speed of Azure
There isn't a lot of acceptance of Azure from DBAs. Steve Jones talks about some of the advantages of Azure and thinks that we should be working to ensure that our internal systems respond at the same speed as people can get from Azure.
2013-05-30
180 reads
Data Will Drive the World
Data and software will impact our lives more and more in the future. Steve Jones talks about some of the potential ways in which both of these have changed the world.
2013-05-28
169 reads
2013-05-27
65 reads
Trusting Systems
The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.
2013-05-23
115 reads
Understanding HA
Dealing with disaster situations or trying to maintain an HA environment can be stressful. However knowledge about your goals and the capabilities of each technology, along with practice, can make things much easier.
2013-05-22
242 reads
How do you solve T-SQL problems?
It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.
2013-05-21
430 reads
Morphing Microsoft
Is Microsoft trying to move away from just being a software vendor? It seems they'd like to and that's a goal, but are they moving in the right direction? Steve Jones has a few ideas to help them.
2013-05-20
135 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