(2023-Apr-10) Yes, Azure Data Factory (ADF) can be used to access and process REST API datasets by retrieving data from web-based applications.To use ADF for this purpose, you can simply...
2023-04-19 (first published: 2023-04-10)
8,848 reads
I set goals at the beginning of 2023 for Q1. I didn’t do well, as my evaluation earlier this week has a D for my efforts. I’m re-evaluating things,...
2023-04-07
30 reads
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure...
2023-04-19 (first published: 2023-04-06)
384 reads
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL...
2023-04-06
113 reads
There is a survey from the WIT group for female speakers. If you are a woman and speak in front of groups, or used to, please fill it out....
2023-04-05
54 reads
This is going to be a rant. I'm just a bit frustrated. When organizers work hard to assemble an event, and speakers submit to speak, we...
2023-04-05
10 reads
You can register today for the 2023 PASS Data Community Summit. This year the event is in Seattle, Nov 14-17, and in-person only. The event was a lot of...
2023-04-21 (first published: 2023-04-05)
100 reads
Hello all, I’ve been speaking to various people about EightKB and there does seem to be a misunderstanding out there about the topics of submissions that we are looking...
2023-04-05
33 reads
Zach's 1st MegaCon 2011 Hello Dear Reader! This past week is a blur. It was a tough week at work. That sentence is an understatement, but its really all I...
2023-04-04
43 reads
The grade for March is also D. Details below, but just not making a lot of progress in these areas. In fact, I find myself not motivated to work...
2023-04-03
29 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