The General Database Platform
It seems that many people who choose NoSQL platforms still need relational features. Steve speculates on why.
2022-05-18
179 reads
Editorials
2022-05-16 (first published: 2018-01-15)
335 reads
Will Hosted Services Take Your Job?
This week I was honored to be able to attend, and present a session at, SQLDay in Wroclaw Poland. I fell in love with Poland the very first time I attended this event, so I look forward to any time I can go again. This year, Pavel Potasinski presented the keynote: The Evolution of the […]
2022-05-14
128 reads
2022-05-13
1,447 reads
Living Up To Your Word
Steve feels it is not only important to keep your word, but communicate clearly what you mean to others.
2022-05-11
362 reads
Crazy Interview Questions
Interviews are always a challenge, but sometimes there are crazy questions. We can do better, especially in terms of how we evaluate the answer to a question.
2022-05-09
556 reads
Finding New Employment
You can find new employment with a little work and choose the best job for you.
2022-05-07
168 reads
2022-05-06
89 reads
Project Zero for Better Security
Project Zero from Google aims to study zero day vulnerabilities. Steve hopes it leads to better security.
2022-05-04
104 reads
2022-05-02
96 reads
Blogs
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...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
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