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,177 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Fuzzy String Matching in SQL Server 2025
Learn about the new fuzzy matching functions in SQL Server 2025.
2026-06-01
3,235 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,308 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,229 reads
2025-12-22
10,982 reads
2025-11-17
3,953 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,922 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,334 reads
2025-07-28
11,619 reads
How to Work with RStudio and SQL Server
Learn how to get started running R scripts in R/Studio for data analysis.
2025-06-30
2,257 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers