Optimized Locking in SQL Server 2025
Learn about Optimized Locking in the latest versions of SQL Server and Azure SQL Database.
2026-10-02
3,033 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
How to Work with On-Premises AI Models to Generate T-SQL Code
See how a small local model performs on some SQL tasks. This shows how Ollama can run a model on your laptop.
2026-08-10
3,394 reads
Fuzzy String Matching in SQL Server 2025
Learn about the new fuzzy matching functions in SQL Server 2025.
2026-06-01
3,326 reads
What is New in SQL Server 2025
Learn about the latest version of SQL Server and get help installing it on your system.
2026-05-04
8,493 reads
Vectors in SQL Server 2025
Introduction SQL Server 2025 introduced new features, including vectors. The main purpose of vectors is to create a new semantic search with the help of AI. Modern AI models represent text as vectors (embeddings) that capture semantic meaning. Similar meanings produce vectors that are close to each other in this vector space, allowing AI systems to […]
2026-03-23
10,511 reads
2025-12-22
11,080 reads
2025-11-17
3,998 reads
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
This article looks at using the FP-Growth algorithm from Python to mine data in SQL Server.
2025-09-08
2,963 reads
How to create your custom GPT SQL Expert
Introduction ChatGPT includes custom GPTs. You can create your own custom GPT. In this article, we will demonstrate how to create a custom GPT expert in SQL Server. Requirements To create your own GPT, you need to use the paid version of ChatGPT. First, go to ChatGPT. Secondly, if you don’t have the paid version, […]
2025-08-15 (first published: 2025-08-11)
5,386 reads
2025-07-28
11,686 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers