Using SQL Compare with Redgate Data Modeler
Redgate recently released SQL Compare v16, which included a new feature to work with Redgate Data Modeler. I decided to give it a try in this post. I’ll take...
2026-01-22
2 reads
Blog Posts
An LLM Saved My ATtiny85 From Certain Death
I almost ordered parts for a circuit that would have destroyed itself the instant I powered it on.
Instead, an LLM caught the critical flaw in my design, saving me...
2026-01-21 (first published: 2026-01-07)
216 reads
Learning from Mistakes: T-SQL Tuesday #194
We’re a week late, once again my fault. I was still coming out of the holidays and forgot to check on my host. Luckily, Louis Davidson (who did have...
2026-01-21 (first published: 2026-01-20)
25 reads
NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and DiskSpd results and analysis.
2026-01-21 (first published: 2026-01-07)
212 reads
Who’s the Winningest Coach (with AI Help)
I was listening to the radio the other day and the hosts were discussing the NFL playoffs in 2026. Someone mentioned the winningest coach was Nick Sirianni of the...
2026-01-21
8 reads
SSMS 22 still inserting tabs instead of spaces
I’m not trying to start up a debate whether you should use tabs or spaces when indenting code. Personally, I prefer spaces because when I copy the code to...
2026-01-20 (first published: 2026-01-19)
55 reads
Stupid Things I Did With AI: ASCII Art
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece of ASCII Art. I have a screenshot here: For some reason, I thought, “I should...
2026-01-20 (first published: 2026-01-19)
14 reads
Monday Monitor Tips: Learning While Using the Tool
A customer was asking about what certain items in Redgate Monitor mean. They have a variety of skills on their staff, and they have developers accessing Redgate Monitor. This...
2026-01-19 (first published: 2026-01-05)
193 reads
2026-01-19 (first published: 2026-01-08)
197 reads
Simple Talks Podcasting in 2026
I’m in the UK today, having arrived this morning in London. Hopefully, by this time ,I’m in Cambridge and at the Redgate office. Maybe sitting in the foyer alcove,...
2026-01-19
8 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers