Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
This article shows how you can generate embeddings in SQL Server 2025, store them, and use them in your queries.
2026-06-08
833 reads
Articles
Microsoft are retiring role-based certifications. Here’s why they shouldn’t
In this Simple Talk opinion piece, Microsoft certification veteran Dr Greg Low considers – and shares his thoughts on – the recent announcement that many role-based Microsoft certifications are being retired.
2026-06-08
2026-06-05 (first published: 2026-05-06)
1,858 reads
Understanding SQL Server PARTITION BY with Examples
Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]
2026-06-05
2,849 reads
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts. However, there are limitations to what can be done with the Structure Query Language (SQL). That is where dbt Python models can be used to perform complex tasks. A dbt Python model is a function that reads […]
2026-06-03
2,012 reads
Using Containers to Avoid Installing SQL Server
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]
2026-06-02 (first published: 2024-09-06)
6,904 reads
Fuzzy String Matching in SQL Server 2025
Learn about the new fuzzy matching functions in SQL Server 2025.
2026-06-01
2,462 reads
Vibe coding and databases: the hidden risks of AI-generated database code
Explore how Andrej Karpathy’s “vibe coding” trend reached databases. Uncover risks, real incidents, and 5 critical failure patterns
2026-06-01
Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now
SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.
2026-05-29
5,345 reads
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses. It already assumes that data is extracted and loaded into raw tables. The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]
2026-05-27
1,030 reads
Blogs
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...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
What Is The Most Important Element Of A Great User Experience?
Hello everyone, I have been exploring different website designs and digital products recently, and...
BCA KCU SOEKARNO HATTA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227...
BCA KCU PASURUAN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur 67111 @BCA...
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