A Model Context Protocol (MCP) server that provides tools for interacting with SQL Server databases. This server allows Large Language Models (LLMs) to query and inspect SQL Server databases through a ...

This repo is a collection of T-SQL scripts I wrote while supporting SQL Server 2008 through 2016. Most are simply quality of life functions, while others such as my availability group SQL agent job ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

Though businesses typically use Microsoft's SQL Server for mundane items such as customer names, addresses and sales amounts, you can also store entire PDFs in a database record. Data items called ...

I used to know how to do this but have forgotten. How do I set a variable to an item returned by a query using TSQL (SQL Server). I have delcared my @variable and need to set it to an item returned by ...

this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...