Index Fragmentation Explained: Page Splits, Logical Reads, and What to Do
Index fragmentation can silently degrade your query performance over time. Learn what happens at the page level, how to measure it, and how to fix it.
2026-06-22
3,951 reads
Articles
How to Deploy SQL Server on Kubernetes running on Windows
Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.
2026-06-22
Why even the best teams struggle with cloud migrations
Grant Fritchey explains the concept of ‘unknown unknowns’, points out what to watch out for in a cloud migration, and offers proven strategies to help your migration go as smooth as possible.
2026-06-22
You Probably Don't Need a Vector Database
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
2026-06-19
1,389 reads
The LLM layer you’re probably missing (LLM gateway pattern explained)
The LLM gateway pattern is a thin service layer that sits between your app and large language model (LLM) providers, centralizing every AI call through a single entry point. It gives you immediate control over routing, logging, retries, fallbacks, and cost tracking – preventing the chaos of scattered integrations, unclear billing, and provider lock-in as your system scales. Learn all you need to know about the LLM gateway pattern in this article.
2026-06-19
What Happens When You Ask a Local AI to Query Your Database?
Learn how you can run a simple LLM on your own machine with Python.
2026-06-17
4,331 reads
Your Database Just Hit One Terabyte: Now What?
You were minding your own business, and all of a sudden it happened.
2026-06-17
Calculating the Harmonic Mean in Power BI
Learn how you can add a harmonic mean calculation in Power BI.
2026-06-16 (first published: 2026-06-15)
1,060 reads
Display Active Slicers in Power BI using Dynamic DAX
Learn how to enhance visibility using slicers in Power BI for better report filtering and user experience.
2026-06-15
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Taking SQL art from shamrocks and Easter eggs to something your DBA manager might actually care about. If you've been following my SQL spatial art series — shamrocks, Easter eggs, Christmas trees — you'll know I have a habit of finding increasingly creative misuses for SQL Server's geometry data type. Most of them have been […]
2026-06-12
4,778 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers