The Complexity of Metrics
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
367 reads
Editorials
2023-02-06 (first published: 2023-02-01)
3,795 reads
The Senior Advantage
Being more senior in a role can be an advantage if you work at using your extra knowledge.
2023-02-03
148 reads
Speakers Are Normal People
Today Steve encourages everyone to feel welcome in the data professional community.
2023-01-27
122 reads
Losing Track of Data
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
2023-01-25
109 reads
The Challenge of Deleting Data
Removing data from your systems isn't as easy as you might think. It is especially important to be aware when you are doing this for compliance.
2023-01-23
214 reads
The Power of Community in Times of Uncertainty
The last two weeks have brought a (seemingly) daily deluge of difficult news in the tech sector. Microsoft, Google, Facebook, and Amazon have all had significant layoffs with many friends in the #SQLFamily and data community being impacted. In times of uncertainty and heightened anxiety, it’s essential to have a group you can turn to […]
2023-01-21
120 reads
Learning Leads To Learning
I am an amateur radio operator. In the US this is commonly referred to as a ham, or a ham radio operator. My call sign is KC1KCE, as issued by the US government through the FCC. And yeah, I can hear you now, a ham is the geek equivalent of a cross-fitter. How do you […]
2023-01-20 (first published: 2023-01-14)
155 reads
2023-01-20
172 reads
The Cost of Employee Turnover
Culture is important retaining employers. Companies are finding this more valuable every day.
2023-01-20 (first published: 2023-01-07)
230 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