A Lack of Architecture and Planning
Today Steve talks about how we end up with software systems that don't appear to be well engineered.
2024-08-19
212 reads
Editorials
Analyzing Breached Data
After a recent data breach, Steve read about an analysis of the data. He has a few thoughts on the process that Troy Hunt went through to dig into the data.
2024-08-17
124 reads
What Do You Drop?
Time is a valuable resource in your lives, and when you decide to tackle something, something else gets dropped.
2024-08-16
112 reads
Prevent SQL Injection
SQL Injection continues to be a problem and Steve has a few thoughts today on how to reduce your vulnerabilities.
2024-08-14
265 reads
A Checklist for Learning
A checklist can be helpful, but it needs to be more than a list of things if it's going to drive your career.
2024-08-12
442 reads
Getting and keeping fit
Don't worry, this is a technical editorial, but the initial analogy starts a bit personal. For the past decade, I've been on a journey to get fit, facing setbacks along the way, such as surgery complications and broken bones, torn cartilage, and, most recently, broken metal implants. Throughout this time, my overall physical fitness has […]
2024-08-10
96 reads
2024-08-09
123 reads
Relationally Divided over EAV
A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.
2024-08-07 (first published: 2013-12-09)
3,425 reads
MTTD
Achieving high availability is hard. Today Steve discusses the challenges of five nines of uptime.
2024-08-05 (first published: 2019-09-11)
371 reads
What Sport Would You Play?
We’re halfway through the Olympics, with all the usual drama – highs, lows, special interest stories - and even a surprise hero in Yusuf Dikec at the 10-meter air pistol (the memes have been strong with this one). As I was talking with my children this week, one of them asked, “So dad, what sport […]
2024-08-04 (first published: 2024-08-03)
84 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
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers