SQLPlanner
a free Windows and SQL Server Monitoring Solution (by Chandan Kumar)
a free Windows and SQL Server Monitoring Solution (by Chandan Kumar)
SQL Server KIT
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.
Repo Folders and Files
SQL Server Web Resources
BRENT OZAR
scripts, videos and articles
SQL.ru SQL Server
(Russian)
SQL Server Science Blog
(by Max Vernon)
sqlmap - The tool for mounting SQL injection attacks tests against a running site
sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. It comes with a powerful detection engine, many niche features for the ultimate penetration tester and a broad range of switches lasting…
In 3 lists
Drupal 7 SQL injection flaw of 2014
great example of how impactful it still is (patch it within 7 hours or you are owned)
Ethical Hacking: SQL Injection
If you really want to go deep, here is five and a half hours worth of Pluralsight content
seclists.org
Heaps of exploits consolidated from various bug tracking lists
Exploit Database
Very comprehensive list of vulnerabilities
In 8 listsDetails
Data Loss DB
Good list of breaches including stats on number of records compromised
Biggest data breaches in history
(by Dave Albaugh)
Module Signing Info
Info and resources related to module signing (i.e. Certificates, Asymmetric Keys, ADD SIGNATURE, etc) in T-SQL and SQLCLR
SQL Server security best practices
(by Microsoft)
SQL Server Hangouts
(by Boris Hristov, Cathrine Wilhelmsen)
Youtube russianVC
(Russian)
User Group.tv
(by Shawn Weisfeld)
Youtube Pragmatic Works Video
(by Devin Knight and Manuel Quintana)
Youtube Community 1nn0va
(by Community 1nn0va)
SQL Server Radio
(by Guy Glantser and Matan Yungman)
SQL Data Partners
(by Carlos L Chacon, César Oviedo and Adrian Miranda)
Away from the Keyboard
(by Cecil Phillip and Richie Rump)
In 2 lists
RunAs Radio
(by Richard Campbell and Greg Hughes)
People Talking Tech
(by Denny Cherry)
NET Rocks!
(by Richard Campbell and Carl Franklin)
SQL Down Under Podcast
(by Greg Low)
Free sql server video tutorials for beginners
(by PRAGIM Technologies)
Dear SQL DBA
(by Kendra Little)
DevopsCafe
(by John Willis and Damon Edwards)
In 2 lists
SQLPlayer
(by Kamil Nowinski and Damian Widera)
Data Driven
(by Frank La Vigne and Andy Leonard)
In 2 lists
SQL Undercover Podcast
(by David Fowler and Adrian Buckman)
Dallas DBAs
(by Kevin Hill)
SQL Server Pain Relief: Office Hours
(by Brent Ozar)
Azure DevOps Podcast
(by Microsoft)
Mixed Extents
(by EightKB)
SQLBolt - Learn SQL with simple, interactive exercises
Learn SQL with simple, interactive exercises.
In 3 lists
Learning Extended Events in 60 Days
and new link (by Jason Brimhall)
Learn SQL Server by solving problems
(by Little Kendra)
In 3 lists
SQL Tutorial
Exercícios progressivos de SQL direto no navegador, ideais para fixar consultas e joins.
In 3 lists
HackerRank.com - SQL interactive exercises and many others languages
Practice coding, prepare for interviews, and get hired.
In 2 lists
SQL-EX.ru - Practical skills of SQL language
(Russian, English)
SQL Server Tutorial
(by Tutorial Gateway)
T-SQL Tutorial
(by TutorialSpoint)
T-SQL Tutorial and examples
(by tsql.info)
Red Gate Data Platform courses
(by Red Gate)
edX SQL Courses
(by edX)
SQL Murder Mystery
(by NUKnightLab)
In 2 lists
SQL Murder Mystery with answers
(by Erika Pullum)
SQL Problems and solutions
(by S. I. Moiseenko)
Advanced T-SQL Puzzles
(by Scott Peters)
In 2 lists
Leetcode SQL Problems
Enhance your skills, expand your knowledge and prepare for technical interviews.
In 2 lists
Learn SQL Server High Availability & Disaster Recovery
(by Edwin M Sarmiento)
SQLpassion Online Academy
(by Klaus Aschenbrenner)
Darling Data - The Best SQL Server Training On The Internet?
(by Erik Darling)
W3Resource SQL Exercises, Practice, Solution
(by w3resource)
LinkedIn SQL Server cources
(by LinkedIn)
Azure Data Studio feedback
is an open source data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
In 4 lists
SQLServerCentral Forum
(more than 10^6 People)
Slack #sqlhelp
(more than 900 People)
Slack #firstresponderkit
(more then 90 People)
Twitter #SQLServer
, Twitter #SQLFamily, Twitter #sqlhelp (more than 500 People)
SQL.ru SQL Server Forum
(more than 10^5 People, Russian)
VK.com #sqlcom
(more than 3600 People, Russian)
Russian SQL Server User Group
(900 People, Russian)
SQLcom.ru telegram chat
(1900 People, Russian)
PowerBI telegram chat
(295 People, Russian)
PostgesSQL telegram chat
(2823 People, Russian)
DBA telegram chat
(1389 People, Russian)
Microsoft Ignite
Online - Microsoft annual conference.
In 2 lists
SQLFluff - A SQL linter and auto-formatter for Humans
A modular SQL linter and auto-formatter designed to enforce consistent style and catch errors in SQL code.
In 4 lists
sp_whoisactive
(documentation) and github repo for it sp_WhoIsActive (by Adam Machanic)
SQL Server Ola Hallengren's Maintenance Solution
(by Ola Hallengren) (Github)
Standby restore script output for Ola Hallengren's Maintenance Solution
(by jzagelbaum) (Github)
SqlQueryStress - SQL query stress simulator for SQL Server
(by Adam Machanic and Erik Ejlskov Jensen)
Statistic Parser
(by Richie Rump) (Github)
SQL Generator
(by Richie Rump) (Github)
Columnstore Indexes Scripts Library
(by Niko Neugebauer) (Github)
MOSL - Memory Optimized Script Library
(by Niko Neugebauer) (Github)
sp_SrvPermissions - stored procedure for list Server permissions
(by Kenneth Fisher)
mssql-docker - Official Microsoft repository for SQL Server in Docker resources
(by Microsoft) (Github)
SQLCover - TSQL code coverage tool for SQL Server 2008+
(by Ed Elliott) (Github)
Azure Blob Storage Backup
(by Randolph West) (Github)
Machine Learning Templates with SQL Server 2016 R Services
(by Sheri Gilley) (Github)
dbfs - A tool for mounting MS SQL Server DMVs using FUSE
(by Microsoft)
Opserver - Stack Exchange's Monitoring System
(by Stack Exchange)
In 3 lists
Bosum - Time Series Alerting Framework
(by Stack Exchange)
In 2 lists
DbSharp - is a DAL Generator
(by Higty)
YourSqlDba - Database maintenance solution as a single SQL script
(by Maurice Pelchat)
ssis-dashboard - HTML5 SQL Server Integration Services Dashboard
(by Davide Mauri)
SQL Server Regex - run regular expressions in SQL Server
(by Dev Nambi)
Binary Formatter - format binary files (e.g. DLL / CER / PVK) into hex bytes string for SQL script
(by Solomon Rutzky / Sql Quantum Leap)
XESmartTarget - configurable target for SQL Server Extended Events
(by Gianluca Sartori)
Schemazen - script and create SQL Server objects quickly
(by Seth Reno)
soddi - StackOverflow Data Dump Importer
(by Brent Ozar team)
Automatically fix high VLF counts in SQL Server 2012+
(by Tracy Boggiano)
SQLServerSpaceAnalysis PowerBI
(by Jana Sattainathan)
ZabbixMSSQL - Zabbix Template and tools for Microsoft SQL Server
(by Sergey Kolesnik)
tsql-parser - Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net
(by Bruce Dunwiddie)
tsqllint - Configurable linting for TSQL
(by tsqllint)
In 3 lists
Rezoom.SQL - F# ORM for SQL databases
(by Robert Peele)
In 2 lists
SQL query builder, written in C#
SqlKata Query Builder is a powerful Sql Query Builder written in C#.
In 3 lists
php-crud-api - Single file PHP script that adds a REST API to a SQL database
(by Maurits van der Schee)
sql2xls - SQL to Excel Export Tool
(by Randolph West)
DBA MultiTool - T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general…
(by John McCall)
In 2 lists
EFCore.BulkExtensions - Entity Framework Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD)…
(by Boris Djurdjevic)
In 3 lists
Performance Analysis of Logs (PAL) Tool
(by Clint Huffman)
databases_scripts - SQL Server useful scripts
(by Dmitriy Gavrikov)
Export Prometheus metrics from SQL queries
(by Alberto Donato)
ASSP - Analysis Services Stored Procedure Project
(by Darren Gosbell)
SQL Server and Azure SQL Labs and Workshops
(by Microsoft)
MsSqlDependencyBrowser - Simple tool to browse between dependent objects on MS SQL Server
(by Aleksej Usharovskij)
Projects-MS-SQL-Server-DBA - Utilities and Scripts for SQL Server dba
(by Evgeniy Gribkov)
Toolbox repository for Madeira's consultant team
(by Madeira)
Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations
(by Eivind Gussiås Løksetheloekset, Mark Junker, Tom Marien)
In 3 lists
SQL Server in Docker
(by Microsoft)
ActiveRecord SQL Server Adapter - SQL Server Adapter For Rails
(by rails-sqlserver)
In 3 lists
EFCorePowerTools - Reverse engineering, model visualization and migrations UI for EF Core
(by Erik Ejlskov Jensen)
In 3 lists
SqlTableDependency - a high-level C# component used to audit, monitor and receive notifications on SQL Server's record…
(by Christian Del Bianco)
In 3 lists
Dotmim.Sync - a brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard…
A brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard 2.0
In 2 lists
Hekaton-based shock absorber pattern for SQL Server
(by Daniel Hutmacher)
HammerDBBenchmark - Swarchy T101 Wilson HammerDb Benchmark Setup Scripts for SQL Server
(by Swarchy T101 Wilson)
sqlblockedprocesses - SQL Server Blocked Process Report Viewer
(by Michael J. Swart)
SQL# SQLCLR functions
(by Sql Quantum Lift)
SQL Server Latch Classes Library
(by Paul S. Randal)
SQL Server Wait Types Library
(by Paul S. Randal)
Waitopedia - is a comprehensive resource of information about SQL Server waits
(by Spotlight Essentials)
SQL Server wait types
(by SQLShack.com)
Using Excel to parse Set Statistics IO output
(by Vicky Harp)
Server Fault - is a question and answer site for system and network administrators
A question and answer site for system and network administrators.
In 3 lists
SQL Injection Cheat Sheet
(by Ferruh Mavituna)
In 3 lists
Azure Speed
(by Blair Chen)
Paste The Plan - share query plans quickly and easily
(by Brent Ozar Team)
Dell Databases Wiki
(by Doug Bernhardt)
SqlServerSearcher - open source C# tool for searching SQL Server objects
(by Allan Simonsen)
DbUp is a .NET library that helps you to deploy changes to SQL Server databases
.NET library that helps you to deploy changes to SQL Server databases. It tracks which SQL scripts have been run already, and runs the change scripts that are needed to get your database up to date.
In 3 lists
SQL Server monitor - manages sql server performance
(by Wilson Chen)
How's My Plan? - .SQLPLAN analyzer
(by Daniel Janik)
Minion Backup - The new standard in SQL Server backups
(by Minionware)
Minion Reindex - Index maintenance that is fully automated
(by Minionware)
OrcaMDF - C# parser for MDF files
(by Mark S. Rasmussen)
Telegraf SQL Server Plugin
(by influxdata)
In 8 listsDetails
SDU Tools - pure TSQL functions Toolkit
(by SQLDownUnder)
The SQL Server Execution Plan Reference
(by Hugo Kornelis)
EC2 Instance Calculator
💸 Easy Amazon EC2 Instance Comparison. Operated by Vantage as a free lead-gen surface for its commercial FinOps platform.
In 2 lists
In 2 lists
Guides for Microsoft SQL Server Express
(by John McCall)
SQL Cheat Sheet for MySQL
(by Luke Harrison)
Azure Database Migration Guide
(by Microsoft)
Hermitage: Testing transaction isolation levels in relation databases
(by Martin Kleppmann)
csv to INSERT online converter - translates your tab-delimited data into a T-SQL INSERT statement
(by Structured Concepts AB)
SQL Server Diagrams
(by George Squillace)
New Stars of Data 2020 Presentations
(by SQLGrillen)
Get Your ColumnScore
(by ColumnScore)
SQL cheat sheet for PostgreSQL and Oracle
(by Marc Wilson)
Bllitz Excel UI
(by Alex)
Industry-specific Data Models - cover Subject Areas and are used to create Enterprise Data Models
A huge list of database templates collected over 25 years by Barry Williams to represent any business process.
In 2 lists
sql-log-shipping-service - provides a solution for automatically restoring SQL Server transaction log backups
(by Trimble Online Source Store)
BIML Resources and Bloggers
SQL Reserved Words
(by Markus Winand)
PowerShell and SQL Server
SQL Server & Windows Documentation Using Windows PowerShell
(by Kendal Vandyke)
Stairway to SQL PowerShell
(by Ben Miller)
SQL Server Health Check Script with Powershell
(by Atul Kapoor)
Universal SQL Server Installation Scripts
(by Prakash Heda) (Github)
Powershell SQL Server Performance Health Check
(by Omid Afzalalghom) (Github)
PSCI - Powershell Continuous Integration
(by Objectivity Bespoke Software Specialists) (Github)
SQLTranscriptase - SQL Server Documentation in Powershell
(by Vijay Bandi) (Github)
SQL Server PowerShell Extensions (SQLPSX)
(by Mike Shepard) (Github)
PowerShell dbatools for SQL Server
(by Chrissy LeMaire) (Github)
Create a Monitoring Server for SQL Server with PowerShell
(by Laerte Junior)
QS Config
(by Derik Hammer)
Powershell SQL Server Library (PSSQLLib)
(by Sander Stad) (Github)
In 2 lists
PowerShell DBA Reports
(Github)
PowerShell sqlCheck
(Bitbucket) (by Josh Feierman)
Export-DMVInformation - Export the resuts from Glenn Berry's DMV queries directly to Excel
(Github) (by Sander Stad)
Export-QueryToSQLTable - Export one or more query results run against one or more instances/databases to table
(by Jana Sattainathan) (Github)
TSQL Format Code
SQL Server Test Data Generation
https://mockaroo.com
Random data generator for CSV / JSON / SQL / Excel.
In 3 lists
Free SQL Server and R ebooks
Awesome Red Gate ebooks
SQL Developers; SQL DBA
Defensive Database Programming
(by Alex Kuznetsov)
Inside the SQL Server Query Optimizer
(by Benjamin Nevarez)
SQL Server Execution Plans, 3rd Edition
(by Grant Fritchey)
SQL Server Source Control Basics
(by Robert Sheldon, Rob Richardson & Tony Davis)
The Art of XSD
(by Jacob Sebastian)
The Redgate Guide to SQL Server Team-based Development
(by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić)
High Performance Techniques for SQL Server
(by SentryOne)
SQL Server Internals: In-Memory OLTP
(by Kalen Delaney)
Fundamentals Of SQL Server 2012 Replication
(by Sebastian Meine)
SQL Server Transaction Log Management
(by Tony Davis and Gail Shaw)
The Art of SQL Server FILESTREAM
(by Jacob Sebastian and Sven Aelterman)
SQL Server Concurrency: Locking, Blocking and Row Versioning
(by Kalen Delaney)
SQL Server Backup and Restore
(by Shawn McGehee)
Troubleshooting SQL Server: A Guide for the Accidental DBA
(by Jonathan Kehayias and Ted Krueger )
SQL Server Hardware
(by Glen Berry)
Giving away millions of free Microsoft Ebooks
(by Eric Ligman)
Free Phil Factor eBook: Confessions of an IT Manager
(by Phil Factor)
Power BI from Rookie to Rock Star book
(by Reza Rad)
Online Book: Analytics with Power BI and R
(by Leila Etaati)
Architecture of a Database System
(by Joseph M. Hellerstein, Michael Stonebraker and James Hamilton)
Troubleshooting SQL Server Performance
(by Kevin Kline)
Azure Machine Learning Studio: An Unleashed Guide
(by Leila Etaati)
Nutanix Best Practices for SQL Server 2016
(by Nutanix, Inc.)
Cloud Analytics with Microsoft Azure
(by Has Altaiar, Jack Lee, Michael Peña)
Snowflake for SQL Server Users Part 1 – Core Concepts
(by Dr Greg Low)
The Fundamental Guide To Sql Query Optimization
(by Janis Griffin)
An Expert Guide To Sql Server Performance Tuning
(by Brent Ozar, Pinal Dave, Janis Griffin)
Microsoft® SQL Server® Notes for Professionals book
(by GoalKicker Books)
BookDown - Write HTML, PDF, ePub, and Kindle books with R Markdown
Authoring Books with R Markdown.
In 2 lists
Little Book of R for Time Series
(by Avril Coghlan)
Little Book of R for Biomedical Statistics
(by Avril Coghlan)
Little Book of R for Multivariate Analysis
(by Avril Coghlan)
Text Mining with R
(by Julia Silge and David Robinson)
In 2 lists
An Introduction to Statistical Learning with Applications in R
(by Gareth James, Daniela Witten, Trevor Hastie and Robert Tibshirani)
In 2 lists
SQL Server Paid Books
T-SQL Fundamentals
361 pages (by Itzik Ben-Gan)
T-SQL Querying (Developer Reference)
803 pages (by Itzik Ben-Gan)
Great Post, Erik
342 pages (by Erik Darling)
Learn T-SQL Querying
450 pages (by Pedro Lopes, Pam Lahoud)
SQL Server 2017 Query Performance Tuning
823 pages (by Grant Fritchey)
Query Store for SQL Server 2019
236 pages (by Tracy Boggiano, Grant Fritchey)
SQL Server 2019 Revealed
444 pages (by Bob Ward)
Pro SQL Server Internals
840 pages (by Dmitri Korotkevitch)
Pro SQL Server Always On Availability Groups
332 pages (by Uttam Parui, Vivek Sanil)
Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server
260 pages (by Lisa Bohm)
Hands-On SQL Server 2019 Analysis Services
(by Steve Hughes)
Related lists in Programming Languages
See category94
Awesome Rust
rust-unofficial/awesome-rust
A curated list of Rust code and resources.
94
Awesome Mac
jaywcjlove/awesome-mac
This project is dedicated to collecting high-quality macOS software and organizing them systematically by different categories for easy search and use.
94
Awesome Python
vinta/awesome-python
Curated Python frameworks, libraries and resources.
94
Awesome C++
fffaraz/awesome-cpp
A curated list of awesome C++ (or C) frameworks, libraries, resources, and shiny things. Inspired by awesome-... stuff.
94
Awesome Go
avelino/awesome-go
Curated Go frameworks and libraries.
94
Awesome PHP
ziadoz/awesome-php
A curated list of amazingly awesome PHP libraries, resources and shiny things.