2022-07-30
360 reads
Editorials
Being Reasonable
Most of work in teams, which means we are accountable to reach other, but we should also treat each other as we'd want to be treated.
2022-07-29
169 reads
The Azure Carrot
There is a promotion for SQL Server 2012 customers that might be considering the cloud and worried about support.
2022-07-27
144 reads
AI Ethics
I found this article to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many […]
2022-07-25
136 reads
Query Tuning, Why Bother?
Today Grant wonders why we spend so much time trying to learn about query tuning.
2022-07-23
327 reads
2022-07-22
175 reads
A Culture That Allows Mistakes
The culture in which we work is important. Having a culture that accepts and allows mistakes can help your organization. Not having this can make the environment much worse.
2022-07-20
267 reads
2022-07-18
193 reads
Time To Recharge
Redgate is a great place to work for a lot of reasons. One of those has come up for me. It's time for my sabbatical. Every five years we get six weeks paid leave. Mine starts Monday. I'll still be clearing out my email (the thought of six weeks worth gives me horrors), and I'll […]
2022-07-16
183 reads
Which Work Is Suited for In-Person?
What is the best way to use an office? Or is there even a best way? Steve asks the question today.
2022-07-15
156 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