Power Automate: Sending Emails As A Different User
A common frustration when sending emails from Power Automate is how to force Power Automate to send your emails from a specific user. While there
2023-01-11 (first published: 2023-01-04)
484 reads
Installing Flyway Community on Windows
One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway...
2023-01-13 (first published: 2023-01-04)
213 reads
Daily Coping 4 Jan 2023
Today’s coping tip is to share something helpful with a friend that you learned recently. I share a lot with my wife and kids. They are a big part...
2023-01-04
12 reads
How Secure is TDE?
When we consider how secure a form of encryption is there are two things we want to consider. Let’s discuss each of these in turn. What are We Protected...
2023-01-13 (first published: 2023-01-03)
402 reads
Daily Coping 3 Jan 2023
Today’s coping tip is to use one of your strengths in a new or creative way. I have a lot of strengths. They’ve helped me to be successful. This...
2023-01-03
24 reads
Daily Coping 2 Jan 2023
Today’s coping tip is to start the new year off with something new – listen, watch, read something completely different. I started listening to more country music last year....
2023-01-02
20 reads
Running SQL Server on Apple Silicon
Last week I purchased a shiny new MacBook Air with an M2 processor. After I got all the standard stuff up and running, I set out to learn how...
2023-01-11 (first published: 2023-01-02)
773 reads
SQLPlayer is renaming
It was about time. The blog and all related services are being changed the name. From SQL Player to Azure Player. You probably noticed over several years that the...
2023-01-02 (first published: 2023-01-01)
71 reads
T-SQL Tuesday #121: Gifts received for this year Redux 2022 Edition
Trigger warning: suicidal ideation, depression, bipolar, mania If you would prefer to stick to all the positives skip to the numbered list at the bottom.
The post T-SQL Tuesday #121:...
2022-12-31
28 reads
Goal Progress for Dec 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. December is usually quiet, though this year I spent the...
2022-12-30
21 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