Un-Migrating From the Cloud: T-SQL Tuesday #199
This month we have a very interesting invitation from Koen Verbeeck. He has hosted once before, and agreed to help me out this month by tackling another topic. We’ve...
2026-06-09
4 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-08
25 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-08
24 reads
QUOTENAME Basics: #SQLNewBlogger
Recently I ran across some code that used a lot of QUOTENAME() calls. A colleague was having some trouble with the code, but what struck me was that I...
2026-06-08 (first published: 2026-05-20)
308 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-08
3 reads
When growing companies outgrow Excel
There are some telltale signs that your growing business has outgrown Excel for your reporting needs. Excel is probably the most adopted piece of software out there, and I...
2026-06-08 (first published: 2026-05-20)
246 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-06
30 reads
A New Word: La Guadière
la guadière – n. a glint of goodness you notice in something that you wouldn’t expect, which is often only detectable by sloshing them back and forth in your...
2026-06-05
24 reads
AI Insights for Database Monitoring: A DBA’s Perspective
Second in a series on Ai and databases. One Story, three signals – I have a backup of a critical database that has failed three times, the recovery point...
2026-06-05 (first published: 2026-06-04)
25 reads
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage workload concurrency. Redshift's Workload Management (WLM) queues enable you to control how queries share resources,...
2026-06-05 (first published: 2026-05-18)
123 reads
Blogs
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
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...
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...
Forums
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
Comments posted to this topic are about the item Vector Search in SQL Server...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers