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

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

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

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

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

BETL. Meta data driven ETL generation using T-SQL

A collection of scripts to use with indexes in SQL Server

Simple SQL query builder for .NET

Toolbox repository for Madeira's consultant team

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/

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

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

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/

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.

Simple tool to browse between dependent objects on MS SQL Server

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

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

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

Istanbul Şehir University Lecture Notes Of MSSQL Database

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

Transitive Closure Clustering with T-SQL, SQLCLR and JSON

Containing the tasks from Softuni's course "DB Basics"