The tsql_parser library can be used to format gnarly/headache-inducing T-SQL stored procedure code (> 1000 LoC) into easy to understand T-SQL. It can also be used to tokenize a T-SQL string and ...

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 ...

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure SQL DB and Synapse) ...

The examples below show how to replace multiple stored procedure parameters using only one XML data type parameter. Even better, these examples show how to pass XML data to stored procedures, and how ...

Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here: ...

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID, ...