Parameter Sniffing in Production: How a 200ms Query Became a 90-Second Outage
Learn how parameter sniffing appeared in a real system and how the issues were solved.
2026-06-29
4,565 reads
Articles
Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — so you catch broken measures, duplicate rows, and faulty relationships before they reach your reports. This article walks through how to use UDFs alongside PQL.Assert to standardize testing across your team, and how to automate those tests with Power Automate or a Fabric Notebook.
2026-06-29
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Learn about an alternative strategy for avoiding hardcoded literal values in SQL Server queries by using single-row views designed to mimic enum behavior.
2026-06-26
2,887 reads
Add Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster
I used the guide in a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 to install a SQL Server 2008 on a Windows Server 2008 failover cluster (WSFC). Now, I would like to upgrade and migrate my SQL Server 2008 failover clusters to SQL Server 2022 running on Windows Server 2022. What is the process for installation and configuration?
2026-06-26
How to host an AI text embeddings model for SQL Server using Ollama
When we want to use AI-based comparisons of text, via vector search in SQL Server, we need to first generate embeddings for the text. An embedding is a numeric representation of meaning, usually represented by vectors. In this article, I’ll show you how to use Ollama to host a server locally that can be used to generate embeddings.
2026-06-24
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,041 reads
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,202 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
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers