Daily Coping 26 Dec 2022
Today’s coping tip is to see how many people you can smile at today. Easy one for me. I find this makes me happier and my day better when...
2022-12-26
24 reads
SQLBits 2023
Super excited that I was selected to speak at SQLBits 2023. The conference is taking place 14-18 March 2023 in Wales. I have never been to Wales and am...
2023-01-06 (first published: 2022-12-23)
248 reads
A Big Year for Travel
I do tend to travel a good amount as my kids have gotten older. The pandemic slowed things for a year, but only then. Someone remarked on this year...
2022-12-23
21 reads
Daily Coping 23 Dec 2022
Today’s coping tip is to be generous. Feed someone with food, love, or kindness today It’s often a family day today, as work ends and we prepare for Christmas....
2022-12-23
22 reads
Daily Coping 22 Dec 2022
Today’s coping tip is to buy an extra item and donate to a local food bank. The food banks in my area are only open limited days, especially post...
2022-12-22
26 reads
Use the output of a Script activity as the items in a ForEach activity in Data Factory
In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements...
2023-01-09 (first published: 2022-12-22)
377 reads
Daily Coping 21 Dec 2022
Today’s coping tip is to listen wholeheartedly to someone else, without judging them. I get the chance to talk with lots of people. I make it a point when...
2022-12-21
24 reads
Understanding Keys and Certificates with TDE
When you first look at the encryption hierarchy for TDE in SQL Server it can be a bit daunting. There seem to be a lot of objects involved and...
2023-01-04 (first published: 2022-12-21)
344 reads
T-SQL Tuesday #157- “End of Year Activity” – RECAP
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
260 reads
Daily Coping 20 Dec 2022
Today’s coping tip is to do something helpful for a friend or family member. Easy one for me. My daughter came home from University yesterday, and I took time...
2022-12-20
22 reads
Blogs
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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....
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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