SQL Server Engineering in Austin
I was lucky enough to attend SQL Saturday Austin 2025 a little over a week ago in conjunction with some work at the Redgate office. The opening keynote at...
2025-05-19 (first published: 2025-05-12)
957 reads
Blog Posts
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It allows you to schedule PostgreSQL commands directly from your database, similar...
2025-05-19 (first published: 2025-04-24)
386 reads
A Conversation That Refused to End: What We Learned from Our First Event in Zurich
On May 8, 2025, we hosted our first official event in Switzerland at Prime Tower, Zurich. The gathering marked an important step in our journey to support organizations as...
2025-05-16 (first published: 2025-05-15)
25 reads
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I explained how you can call a Fabric REST API endpoint from Azure Data Factory (or...
2025-05-16 (first published: 2025-04-28)
777 reads
The Book of Redgate: Customer Quotes
Many organizations list customer testimonials and quotes on their websites or literature. It makes sense to show off those places where you’ve done well in hopes of influencing others...
2025-05-16 (first published: 2025-04-25)
394 reads
The Book of Redgate: Do Your Best Work
One of our mission statements in the Book of Redgate says: attempt to do the best work of your life. I’d like to think that at most points in...
2025-05-16
82 reads
A DevOps Workshop Tomorrow in Atlanta
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so do that if you can make it. Here’s the rough outline Vision Session – w/...
2025-05-14
17 reads
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes...
2025-05-14 (first published: 2025-04-28)
688 reads
Testing for End of Month in PowerShell
This is one of those blog posts you write so that 2 years later, you can look it up to remind yourself how to do something.
I found myself needing...
2025-05-14 (first published: 2025-04-28)
437 reads
T-SQL Tuesday #186–Agent Jobs
It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month...
2025-05-13
25 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers