t-sql

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

A set of F# Type Providers for statically typed access to MS SQL database

Open-source Repository of Useful Scripts and Solutions for the Microsoft Data Platform

dbt adapter for SQL Server and Azure SQL

📕 Various example reports I use for SQL Server Reporting Services (SSRS) as well as documents for unit testing, requirements and a style guide template.

📝 This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, Markup or Markdown Languages. The functionality within the ribbon allows a quick way of preparing a bulk data load. Otherwise, the requests can be both time-consuming and error prone. It is written in 3 different versions as…

SQL Server の各種情報を取得するためのユーティリティ

🛠️ T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.

This tool transpiles openCypher graph query language to a relational database query language. This project publishes a T-SQL for Microsoft SQL Server as the target query language.

A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.

The sp_who3 stored procedure is a custom and open source alternative to the sp_who system stored procedures available in SQL Server.

Samples showing how to use Microsoft.SqlServer.TransactSql.ScriptDom classes

Banco de Dados para Estudo

Transact-SQL scripts and gists

This repo is the home of various SQL-Server-Tools

Using Python Pandas dataframe to read and insert data to Microsoft SQL Server

sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.

Simple SQL query builder for .NET

A collection of scripts for gathering metrics from SQL Server's underlying DMO's.

Useful T-SQL containers