Model Context Protocol (MCP) has gained considerable momentum as a standard connector between LLM-powered tools and local systems, internal and external APIs, and data sources. From major clouds to ...

See Configuring Claude Desktop / Claude Code for examples. A comprehensive Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides extensive SQL Server ...

There are several Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) that can be used to monitor indexes in SQL Server. In this article, I will explain some of them.

Part of the SQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates ...

Welcome to this Microsoft solutions workshop on SQL Server 2019 Workshop. In this course you will learn how to solve modern data challenges with SQL Server 2019 using a hands-on lab approach. This ...

Part of the SQL Server 2022 blog series. Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST ...

Databricks Lakehouse Platform combines cost-effective data storage with machine learning and data analytics, and it's available on AWS, Azure, and GCP. Could it be an affordable alternative for your ...

A common task that all database and system administrators face is patching systems. Patching your systems is very important -- first and foremost, security fixes are included in patches. Patches also ...

Here, I am going to discuss some basic and most important configurations of the SQL Server Instance and Database Level which might be ignored and can cause performance issues. Although this is not the ...