Optimized Locking in SQL Server 2025
Learn about Optimized Locking in the latest versions of SQL Server and Azure SQL Database.
2026-10-02
2,865 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,360 reads
Fuzzy String Matching in SQL Server 2025
Learn about the new fuzzy matching functions in SQL Server 2025.
2026-06-01
3,317 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,467 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,465 reads
2025-12-22
11,066 reads
2025-11-17
3,987 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,955 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,379 reads
2025-07-28
11,679 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers