SQL, MDX, DAX – the languages of data
Ramblings of a retired data architect Let me start by saying that I have been working with data for over thirty years. I think that just means I am...
2026-01-14 (first published: 2026-01-12)
65 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-12 (first published: 2026-01-07)
14 reads
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for running containerized workloads. While Kubernetes is one of the best orchestration tools, it also presents...
2026-01-12 (first published: 2025-12-31)
132 reads
Setting PK Names in Redgate Data Modeler
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names. I had to test and discover if I could make things better, and I could....
2026-01-12
42 reads
Streamlining Azure VM Moves Into Availability Zones
One of the more frustrating aspects about creating an Azure virtual machine is that if you do not place it into an availability zone at deployment time, you’ve traditionally...
2026-01-12 (first published: 2025-12-15)
108 reads
A New Word: Fawtle
fawtle – n. a weird little flaw built into your partner that somehow only endears them more to you, in the way that impurities dissolved in water are what...
2026-01-09
16 reads
Flyway Tips: AI Deployment Script Descriptions
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests, demands, suggestions, and more about how to add AI into our products and help developers...
2026-01-09
17 reads
Keeping MS Docs Up to Date
One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...
2026-01-09 (first published: 2025-12-10)
225 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-09 (first published: 2026-01-07)
16 reads
2026-01-09 (first published: 2026-01-08)
17 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?