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
3,087 reads
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
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 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,278 reads
Learn how to deploy SQL Server on Kubernetes using Docker Desktop on Windows. Unlock powerful capabilities for your database.
2026-06-22
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
Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.
2026-06-19
1,262 reads
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
Learn how you can run a simple LLM on your own machine with Python.
2026-06-17
3,904 reads
You were minding your own business, and all of a sudden it happened.
2026-06-17
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Comments posted to this topic are about the item BIT_COUNT() V
Comments posted to this topic are about the item How We Reduced SQL Server...
Comments posted to this topic are about the item An Eventual Consistency Scam
What does this return on SQL Server 2025?
select bit_count(null)See possible answers