The Book of Redgate: Get the right stuff done
Another of our values: The facing page has this quote: “We admire people who get stuff done. While there’s a place for planning, thinking and process it is better...
2026-01-16
15 reads
Blog Posts
Using Prompt AI for a Travel Data Analysis
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2026-01-16 (first published: 2025-12-31)
315 reads
2026-01-14 (first published: 2026-01-05)
452 reads
SQL Server 2025 Developer Edition – One size fits all
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine. This version focuses on AI features and better performance, aiming to meet the needs of...
2026-01-14 (first published: 2026-01-05)
755 reads
How to Troubleshoot a Runaway Transaction Log File
Part of being a DBA is dealing with transaction logs that grow uncontrolled for some reason. This often gets raised to the DBA in the form of a drive...
2026-01-13
5 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)
150 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
51 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)
126 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
29 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
22 reads
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers