The Book of Redgate: Taking Breaks
We work hard at Redgate, though with a good work-life balance. One interesting observation for me (as an American) is how well most of the company in the UK...
2026-06-12
44 reads
Blog Posts
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if you manage either (or both), you've probably wondered how they compare when it comes to...
2026-06-11 (first published: 2026-06-08)
199 reads
Creating a SQL Stored Procedure to Load a SCD2
This is a blog that I am writing for future me and hopefully it’ll help a few of you save some time too! It’s not often that I get...
2026-06-11
31 reads
Database AI Agents: The Read-Only Rule
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A read-only advisory system does exactly two things: it observes and it recommends. It never acts....
2026-06-11
28 reads
From SQL Saturday to Day of Data
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday, and everything that went right—and wrong—along the way.
2026-06-11 (first published: 2026-06-06)
34 reads
Monday Monitor Tips: AI Alert Analysis
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check out this new feature we’ve added for alerts. This is a great addition to help...
2026-06-11 (first published: 2026-06-08)
30 reads
My Toolbox - AI
I trusted AI to redesign this entire blog. The layout, the CSS, the deployment pipeline, the shortcodes. I use it to build home automation, organize my notes, fix my...
2026-06-11 (first published: 2026-06-07)
19 reads
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s topic is chosen by myself, and it’s inspired by a blog post of Alexander Arvidsson....
2026-06-11 (first published: 2026-06-08)
19 reads
Funny Money: #SQLNewBlogger
While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another...
2026-06-10
78 reads
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a few aggregations — and watched your machine struggle — there's a better tool for the...
2026-06-10 (first published: 2026-05-21)
398 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers