When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I...
2023-02-14 (first published: 2023-02-13)
52 reads
Today’s coping tip is to send a message to let someone know you’re thinking of them. I reached out a friend the other day, someone I know from the...
2023-02-10
31 reads
Microsoft Purview, formally called Azure Purview (see Azure Purview is generally available) has recently released a number of new cool features. I wanted to call out a few of...
2023-02-22 (first published: 2023-02-09)
446 reads
Today’s coping tip is to write down your hopes or plans for the future. Hopes are vague, and plans are easier, so here are some plans: Plan a trip...
2023-02-09
39 reads
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG Training Days. The Rocky Mountain Oracle User Group has put this on for years, and...
2023-02-07
25 reads
Today’s coping tip is to go to bed in good time and allow yourself to recharge. I need this reminder. Lately I’ve struggled to sleep well, through the night,...
2023-02-07
18 reads
Hello Dear Reader! After a weekend with a lot of activities, it was a down week here at Casa Balls. Woke up and walked a lot. I'm still not...
2023-02-06
43 reads
In order to generate migrations, we need to configure Flyway to use a shadow database. This post looks at that process. This is part of a series of working...
2023-02-08 (first published: 2023-02-06)
132 reads
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
283 reads
Today’s coping tip is to get back in contact with an old friend. This is something I don’t do too often, but I have done a few times. I’ve...
2023-02-06
20 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
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