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
70 reads
Looking Back at 2025: Volunteering Is My Way of Life
It’s been a minute since I’ve written anything here, but looking back on the past year feels like the perfect way to start again. 2025
2026-01-09
5 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
52 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
79 reads
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer (ALB) and Network Load Balancer(NLB). And, our good friend S3 now supports post-quantum TLS key...
2026-01-09 (first published: 2026-01-08)
56 reads
2026-01-19 (first published: 2026-01-08)
259 reads
Another Change
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity firm. There are no details of terms, and you can read the press release. It’s...
2026-01-07
32 reads
Using Prompt AI to Help Setup Data Analysis
I used Claude to build an application that loaded data for me. However, there were a few others things I needed done to help me get the data ready...
2026-01-23 (first published: 2026-01-07)
363 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)
308 reads
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)
306 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers