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

📕 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 の各種情報を取得するためのユーティリティ

dbt adapter for SQL Server and Azure SQL

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

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

Toolbox repository for Madeira's consultant team

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

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

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

Simple SQL query builder for .NET

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

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

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

BETL. Meta data driven ETL generation using T-SQL

Working with the Yelp Dataset in Azure SQL and SQL Server

A collection of scripts to use with indexes in SQL Server

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/

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 '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/

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.

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

In this project, I examined the terms database first and code first and developed an application.

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.

Istanbul Şehir University Lecture Notes Of MSSQL Database

Useful T-SQL containers