2019-05-16
609 reads
Editorials
Microsoft and Minecraft and Training Kids
Today we have a guest editorial from Andy Warren, looking at learning.
2019-05-15 (first published: 2015-02-23)
548 reads
Where Do You End Up as a DBA?
Steve Jones talks about careers, and where you might take your career over time.
2019-05-14 (first published: 2015-02-20)
733 reads
Communicate Smarter Not More
After installing Microsoft Teams, Steve has a bit of communication overload.
2019-05-13
217 reads
2019-05-11
132 reads
The Impediments to Change
SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don't look to upgrade all of our existing instances, we can't buy older versions when the new one is released. Often many of […]
2019-05-10
258 reads
The Death of the GDPR
The GDPR is struggling with enforcement against some of the larger tech companies. Steve thinks this is a problem, but it might not matter for smaller companies.
2019-05-09
517 reads
Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
2019-05-08
270 reads
Really Important Software
Software often controls hardware, which can make it the critical part of a system. That's something we should be learning from the Boeing 737-Max crashes.
2019-05-06
270 reads
The Blast Radius of a database
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
2019-05-04
506 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