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

Templates for naming convention - TSQL, JavaScript, C#, R, Python, Powershell

Statically typechecks a common SQL dialect and translates it to various RDBMS backends

Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net

Инструменты обслуживания и разработки для MS SQL Server, а также другие интересности

SQL Server Toolbox by the Sparkhound SQL Team

▪️ An engine for searching patterns in the source code, based on Unified AST or UST. At present time C#, Java, PHP, PL/SQL, T-SQL, MySql, and JavaScript are supported. Patterns can be described within the code or using a DSL.

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

🐸 Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.

A big collection of SQL Server Queries and documeantations to fix your SQL Server's bottle neck

Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier

Transact-SQL scripts and gists

SQL language (T-SQL, MySQL and PostgreSQL dialects) plugin for SonarQube

PowerShell Module to interact with Lansweeper Database

advanced SQL filter builder. Demo:

An SQL Parser/Lexer for C#

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

An Automated Role Based Access Control .NET framework with T-SQL Query Parser which automatically parse select, insert, update, delete queries based on the logged in user role

Jenesis Data Store: a dynamic, cross platform, high performance, ORM data-mapper. Designed to assist in rapid development and data mining

Simple SQL query builder for .NET

Toolbox repository for Madeira's consultant team

Talks that I have given

An app that let you run distributed cross database SQL query

Library Written in C# For Colorizing SQL Server T-SQL Scripts in .Net

C#/VB.NET database utility to write pure Microsoft SQL/MySQL/PostgreSql/Oracle/SQLite/ODBC/OleDb queries and load data into environment variables and instances. This is core package only.

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

SQL Server monitoring tool based on PowerShell v3 and TSQL scripts only

This automation has been designed to eliminate manual efforts on Space Capacity ESC tickets where DBA has to add new data or log files on new volume, and restrict data or log files on old volume. Apart from this, this procedure can be used for variety of tasks related to capacity management.