ktaranov / sqlserver-kit

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

visual-studio sql sql-server database examples sql-server-database sql-query rdl tsql sql-statement t-sql ssms sql-script ssrs visual-studio-2017 sql-server-management-studio reporting-services visual-studio-community sql-server-reporting-services

Updated Apr 30, 2020
Visual Basic .NET

microsoft / openCypherTranspiler

Star

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.

graph transpiler property-graph t-sql cypher-query-language opencypher

Updated Nov 12, 2019
C#

tomaztk / MSSQLSERVER_Pandas

Star

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

python sql pandas mssql t-sql mssqlserver python-pandas

Updated Jul 15, 2018
Python

rudi-bruchez / tsql-scripts

Star

Transact-SQL scripts and gists

sql-server database-administration mssql sqlserver tsql t-sql

Updated Mar 26, 2020
TSQL

Thomas-S-B / SQLServerTools

Star

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

Updated Dec 18, 2019
TSQL

basvdberg / BETL

Star

BETL. Meta data driven ETL generation using T-SQL

metadata automation sql sql-server etl business-intelligence t-sql ssis etl-framework etl-automation meta-data-engine

Updated Dec 11, 2019
TSQL

ericcobb / SQL-Server-Metrics-Pack

Star

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

sql-server database-administration sqlserver t-sql sql-server-metrics-pack

Updated Dec 24, 2019
TSQL

somdipdey / SystemPerformance

Star

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.

c-sharp performance sql-server system ram ms-sql-server mssql memory-management performance-analysis cpu-monitoring dotnet-framework t-sql nuget-package mssqlserver

Updated Nov 4, 2017
C#

arvindshmicrosoft / YelpDatasetSQL

Star

Working with the Yelp Dataset in Azure SQL and SQL Server

machine-learning sql-server graph text-analysis yelp mssql t-sql yelp-dataset yelp-challenge multi-class-classification r-server azuresqldb yelp-dataset-analysis azuresql

Updated Jun 13, 2020
TSQL

Darko-Martinovic / SQLCLR

Star

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/

dotnet t-sql sqlclr

Updated Feb 19, 2019
SQLPL

ericcobb / SQL-Server-Permissions-Manager

Star

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

sql-server permission-manager sqlserver t-sql

Updated Mar 8, 2019
PLpgSQL

JSuder-xx / TSqlStrong

Star

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.

sql static-code-analysis flowtype enumeration t-sql null-safety