2025-10-22
130 reads
Editorials
Limiting the Ability to Concentrate and Collaborate
Open offices have an interesting side effect: less collaboration.
2025-10-20 (first published: 2018-08-27)
169 reads
I Love Editorials
Why do I love editorials, I can hear you asking. The answer is simple. It's all about opinions. I have opinions. Lots of them. Lots and lots of them. I'm flying home from Hong Kong after visiting a Redgate customer. They are doing amazing work.. It's so cool getting to see how people are solving […]
2025-10-18
52 reads
The Journey to PostgreSQL (or anything)
Learning is fundamental in technology. Steve has a few thoughts on adopting a new technology at work.
2025-10-17
115 reads
2025-10-15
102 reads
The Improvement Limit
How much of a difference can you make at a job? Steve has a few thoughts today.
2025-10-13
103 reads
Technological Dinosaurs or Social Dinosaurs?
You're going to have to bear with me on this one because my thoughts aren't fully formed. As I'm sure I've mentioned, I'm a little elderly (and you thought I was going to talk about radios). As such, I've seen the death of a few technologies. I may not have shared this widely, but my […]
2025-10-11
164 reads
Start Fixing Your DB with Better Code
The best way to improve your database performance is with better code. We all know that, but few of us actually end up making those changes.
2025-10-10 (first published: 2017-11-16)
591 reads
Is Rolling Back The Same as Failing?
When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?
2025-10-08 (first published: 2014-03-04)
300 reads
Getting Fired
When should a DBA get fired? Steve Jones thinks it should be rare and gives you two cases.
2025-10-06 (first published: 2014-03-27)
697 reads
Blogs
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers