This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...
2022-11-04 (first published: 2022-10-21)
123 reads
Today’s coping tip is to do something constructive to improve a difficult situation. My life is amazing, but there are certainly some difficult times. Sometimes at work, sometimes at...
2022-10-21
19 reads
I'm excited to be presenting my talk on Building a complete API in Azure
2022-10-21 (first published: 2022-10-20)
35 reads
Today’s coping tip is to avoid blaming yourself or others. Find a helpful way forward. I’ve been busy lately. My days are jammed up with a number of presentations...
2022-10-20
29 reads
First, the numbers. We registered 240 people, had about 110 on site. That’s definitely better than last year and still quite a bit under what it was pre-Covid. I’ll...
2022-11-04 (first published: 2022-10-19)
136 reads
Today’s coping tip is to take time to reflect on what you have accomplished recently. What have I done recently? Lots of stuff, but a couple things come out...
2022-10-19
16 reads
I upgraded my primary laptop to Windows 11. A few people had said they liked it, I know that I needed to keep up at some point, and in...
2022-10-19
33 reads
A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost...
2022-10-31 (first published: 2022-10-19)
440 reads
Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing?...
2022-10-31 (first published: 2022-10-18)
615 reads
Announced at Microsoft Ignite were some new product features related to data platform and AI. Below are the ones I found most interesting: Azure Cosmos DB adds distributed PostgreSQL...
2022-10-18
33 reads
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
I’m excited to announce the release of a new open-source project that fully automates...
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