How important is having great soft skills as a Software Engineer for personal growth and career successAs an Engineer, I would like to understand what I need to do to...
2024-06-21 (first published: 2024-05-26)
292 reads
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-05-25 (first published: 2024-05-24)
61 reads
Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar to SQL Compare deployments, but with your code source control, which is where you want...
2024-05-24
33 reads
insoucism – n. the inability to decide how much sympathy your situation really deserves, knowing that so many people have it far worse and others far better, that some...
2024-05-24
60 reads
There are several tools out there to make your life easier by creating an ERD for your existing db. Everything works pretty well when you have a small number...
2024-06-12 (first published: 2024-05-23)
601 reads
this month is the big month and a month to remember their are so many announcements has been done in this month – May -2024 . As this is...
2024-05-23
41 reads
There is a nice article at Harness.io on their use of feature flags and how they deployed their next generation experience. It’s worth a read if you want to...
2024-05-22
54 reads
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to blog about. Everything announced at Build can be found in the Microsoft Build 2024 Book of...
2024-06-12 (first published: 2024-05-22)
270 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative data career or just want a new skill under your belt, learning SQL is a...
2024-05-21
112 reads
This comic was retweeted into my timeline on Twitter (I refuse to call it X). Here’s the dialog from the comic, for those that don’t want to click through...
2024-05-20
21 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...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
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