2022-03-23
111 reads
Editorials
Is CosmosDB the One?
CosmosDB is a flexible, powerful database, but is it the best one? Steve has a few thoughts.
2022-03-21
246 reads
SQLBits Report
Last week I attended my first in-person event in over two years. SQLBits, the largest data platform conference in Europe, was a hybrid event and marked the first time many of us met in person in ages. It was a huge success as folks from around the world gathered to learn...and celebrate! I heard several […]
2022-03-19
115 reads
2022-03-18
149 reads
The Chief Data Officer
The idea of a Chief Data Officer is growing in many companies. Steve thinks this is a good thing.
2022-03-16
167 reads
The Challenges of Changing Software Tools
The way different generations use computers could affect how we built software tools.
2022-03-14
133 reads
2022-03-11 (first published: 2017-05-04)
323 reads
The (Former) Complexity of PowerShell
Steve Jones notes that PowerShell seems to becoming an easier to use language for SQL Server professionals.
2022-03-09 (first published: 2017-01-19)
431 reads
Would You Still Love Linux If Windows Was Free?
A guest editorial today looks at the OS debate: Windows v Linux.
2022-03-07 (first published: 2017-02-07)
447 reads
Using Technology for Health
I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
2022-03-05
128 reads
Blogs
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....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
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