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

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

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

📝 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 a VSTO Add-In in C# and VB.NET as well as a VBA Add-In. The most complete version is C#.

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.

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

Transact-SQL scripts and gists

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

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

Toolbox repository for Madeira's consultant team

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

Simple SQL query builder for .NET

BETL. Meta data driven ETL generation using T-SQL

A collection of scripts to use with indexes in SQL Server

Working with the Yelp Dataset in Azure SQL and SQL Server

Track System Performance (CPU / RAM / Memory / SQL Server) using this NuGet Package. Requires .Net framework 3.5+. It is an Open Source project under MIT License.

The detailed explanation could be found on Red Gate SimpleTalk's link 'SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server' https://www.red-gate.com/simple-talk/sql/sql-development/sqlclr-practice-creating-better-way-sending-email-sql-server/

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

A set of scripts for managing logins and permissions on SQL Server databases.

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

The detailed explanation could be found on Red Gate SimpleTalk's link 'An Easier Way of Transposing Query Result in SQL Server' https://www.red-gate.com/simple-talk/sql/t-sql-programming/easier-way-transposing-query-result-sql-server/

Sources for YourSqlDba : Database maintenance solution as a single SQL script

T-Sql type checker that detects improper joins, invalid null value operations, enumeration check constraint violations, incorrect use of temporary table at call site, more. On-line demo available.

💾 📚 📂 Sample Querying , Data and Training Materials with Transact-SQL

Istanbul Şehir University Lecture Notes Of MSSQL Database

Simple tool to browse between dependent objects on MS SQL Server

A 100% T-SQL based unit testing framework for SQL Server

Transitive Closure Clustering with T-SQL, SQLCLR and JSON

This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring