Making a PostgreSQL Backup in a Container
I needed to back up a PostgreSQL database as a part of the repro for an issue I had. I hadn’t ever made a backup of PostgreSQL, so this...
2025-02-19
135 reads
Blog Posts
SQL Server Migration Using a Distributed Availability Group
SQL Server migrations are a headache, ask anyone who’s been through the pain of moving a reasonably large server and I’m sure they will agree. There are all sorts...
2025-02-19 (first published: 2025-02-05)
1,475 reads
The hell of Git line endings and the (not so) simple fix
I wrote a stream-of-consciousness post a few months ago about what I do in my day job at Microsoft, working in the Database Docs team. Basically we spend most...
2025-02-19 (first published: 2025-02-12)
340 reads
Data Strategy Checklist for 2025
Reflecting on data strategy projects from 2024, key lessons include starting with clear business objectives, prioritizing data ethics and security, and fostering collaboration between business and IT teams. Also,...
2025-02-17
22 reads
Visualising SQL Server in Kubernetes
The other day I came across an interesting repo on github, KubeDiagrams. What this repo does is generate Kubernetes architecture diagrams from Kubernetes manifest files…nice! Deploying applications to Kubernetes...
2025-02-17 (first published: 2025-02-06)
344 reads
When is the perfect moment to build a data strategy in a company?
Introduction The challenge enterprises face is adopting new technologies to manage data. But, even more importantly, using the latest technologies is not a solution by itself, and companies should think first about adding value to the organization through...
2025-02-16
9 reads
Advice I Like: Transactions and Relationships
Life gets better as you replace transactions with relationships. – from Excellent Advice for Living This is incredible advice. I think that much of the complaints about the US...
2025-02-14
17 reads
Choosing to not drive the Tesla
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla at home recently. A few people asked me about it, so I decided to do...
2025-02-14
37 reads
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your...
2025-02-14 (first published: 2025-02-05)
744 reads
How-To Convert Excel Date & Time to SQL
Hey data friends! This one comes from my personal vault (aka backlog of drafts I’ve been needing to write up) and is a really simple code that I always...
2025-02-14 (first published: 2025-01-28)
1,178 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers