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,271 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,280 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,376 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,332 reads
2025-12-22
11,028 reads
2025-11-17
3,970 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,941 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,351 reads
2025-07-28
11,635 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,284 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I