项目作者： ktaranov
项目描述 ：
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
高级语言： PLpgSQL
项目地址: git://github.com/ktaranov/sqlserver-kit.git
SQL Server KIT
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
Table of Contents
Repo Folders and Files
⬆ back to top
SQL Server Web Resources
- Blogs
- Security (great thanks to Troy Hunt)
- Free Videos
- Free Database Podcasts
- Courses
- SQL Server Deprecated database engine features and Backwards Compatibility
- SQL Server System Views Map
- Microsoft Troubleshooting and security guides
- SQL Server feedbacks
- Social, Forum and Messenger SQL Server Groups
- 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)
- Reddit –
/r/sqlserver, /r/sql, and /r/database - SQL.ru SQL Server Forum (more than 10^5 People, Russian)
- VK.com #sqlcom (more than 3600 People, Russian)
- SQL Server User Group Meetings
- 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)
- SQLTeam SQL Server Forum
- Red Gate SQL Server Forum
- Microsoft SQL Server on Q&A
- SQL Server Conferences
- Open Source Projects
- SQLFluff - A SQL linter and auto-formatter for Humans
- sp_whoisactive (documentation) and github repo for it sp_WhoIsActive (by Adam Machanic)
- Brent Ozar SQL Server First Responder Kit (Github)
- 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)
- WorkloadTools - collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud (by Gianluca Sartori)
- 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)
- sp_DBPermissions - stored procedure for list database permissions (by Kenneth Fisher)
- stpChecklist_Seguranca - stored procedure with more than 70 security items to validate your SQL Server database (by Dirceu Resende)
- 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)
- tSQLt - testing framework for Microsoft SQL Server (Github)
- SQLCop - tSQLt tests to highlight potential problems in your database (Red Gate)
- T-SQL SimMetrics string matching algorithms (Github)
- Azure Blob Storage Backup (by Randolph West) (Github)
- StackExchange.DataExplorer - free tool for executing SQL queries against Stack Exchange databases (Github)
- Machine Learning Templates with SQL Server 2016 R Services (by Sheri Gilley) (Github)
- Campaign Optimization - Predicting How and When to Contact Leads Implemented on SQL Server 2016 R Services (by Sheri Gilley) (Github)
- SQL Server Performance Dashboards - contains all Microsoft based reports, custom built reports, modified reports and the TSQL setup (by Arun Sirpal)
- tigertoolbox - Repository for Tiger team for “as-is” solutions and tools/scripts that the team publishes for SQL Server (Github)
- SQL Server FineBuild - makes it easy for anyone to produce a best-practice installation and configuration of SQL Server (by Brian Davis)
- Pssdiag/Sqldiag Manager - is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine (Github)
- sql-xplat-cli - Repository for the new SQL cross-platform command line tools (by Microsoft)
- dbfs - A tool for mounting MS SQL Server DMVs using FUSE (by Microsoft)
- Opserver - Stack Exchange’s Monitoring System (by Stack Exchange)
- Bosum - Time Series Alerting Framework (by Stack Exchange)
- BismNormalizer - is a free and open-source tool to manage Microsoft Analysis Services tabular models (by Christian Wade)
- DbSharp - is a DAL Generator (by Higty)
- YourSqlDba - Database maintenance solution as a single SQL script (by Maurice Pelchat)
- OpenQueryStore - collection of scripts that add Query Store like functionality to pre-SQL Server 2016 Instance
- 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)
- ExtendedTSQLCollector - Custom collector types to extend and simplify the features offered by the built-in SQL Server Data Collector and read data from Extended Events and/or queries (by Gianluca Sartori)
- 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)
- splittinglargefiles - Process for splitting large files in a filegroup that has grown out of control. (by Tracy Boggiano)
- olamaintconfigtables - This are tables and jobs that can use to run Ola’s scripts as T-SQL Jobs and run on Linux (by Tracy Boggiano)
- SQL Undercover Toolbox - A collection of cool and useful tools, procedures and scripts for the discerning DBA (by SQL Undercover)
- dba-database - Database containing DBA helper code and open source software (by Andy Mallon)
- SQLServerSpaceAnalysis PowerBI (by Jana Sattainathan)
- SQL Server Telegram Bot
- ZabbixMSSQL - Zabbix Template and tools for Microsoft SQL Server (by Sergey Kolesnik)
- AGLatency - analyze AG log block movement latency between replicas and create report accordingly (by Simon Su)
- SQLSetupTools - FixMissingMSI, Product Browser, SQL Registry Viewer (by Simon Su)
- 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)
- Rezoom.SQL - F# ORM for SQL databases (by Robert Peele)
- SQLtoExcel - Exports the output of one or more TSQL script queries to Excel (by Dave Mason)
- Analysis Services - Analysis Services samples and community projects (by Microsoft)
- ms-sql-express-replication - replication library written for MS SQL Sever Express edition (by Jan Halama)
- SQL query builder, written in C#
- 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)
- azureblobstoragesync - Backup any version of your on-premises SQL Server database to a network share or Azure Blob Storage and restore it too (by Randolph West)
- sql_profiler - Microsoft SQL-Server Profiler (command-line) for Linux/Mac/Windows (by Stefan Steiger)
- dbops - Powershell module that provides continuous database deployments on any scale (by Kirill Kravtsov)
- TabularTranslator - allow create translations for a translation file generated by SSDT for tabular models with the compatibility level 1200 and up (by Kjonge)
- TSqlStrong - T-Sql type checker that detects improper joins, possibly null value operations, enumeration check constraint violations, incorrect use of temporary table at call site, and more (by John Suder)
- SQL Power Doc - is a collection of Windows PowerShell scripts and modules that discover, document, and diagnose SQL Server instances and their underlying Windows OS & machine configuration (by Kendal Van Dyke)
- rsqlserver - Sql Server driver database interface (DBI) driver for R
- DBA MultiTool - T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs. (by John McCall)
- language-extensions-sqlserver - SQL Server Language Extensions project (by Microsoft)
- AzureRMR - R package for interacting with Azure Resource Manager (by Microsoft)
- EntityFramework.Utilities - Provides extensions for EntityFramework that doesn’t exist out of the box like delete and update by query and bulk inserts (by Mikael Eliasson)
- EFCore.BulkExtensions - Entity Framework Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD) operations on SQL Server and SQLite (by Boris Djurdjevic)
- Performance Analysis of Logs (PAL) Tool (by Clint Huffman)
- SQL-Server-Permissions-Manager - a set of scripts for managing logins and permissions on SQL Server databases (by Eric Cobb)
- AwesomeSQLServer - collection of SQL Server Queries and documentations to fix your SQL Server’s bottle neck (by SqlAdmin)
- databases_scripts - SQL Server useful scripts (by Dmitriy Gavrikov)
- sp_PressureDetector - stored procedure for quickly detecting CPU and Memory pressure on a SQL Server (by Erik Darling)
- sp_HumanEvents - make Extended Events easier and more approachable for the average admin to troubleshoot common scenarios (by Erik Darling)
- Export Prometheus metrics from SQL queries (by Alberto Donato)
- homebrew-mssql-release - brew formulae for Microsoft ODBC Driver for SQL Server and SQL Server Command Line Utilities (by Microsoft)
- ASSP - Analysis Services Stored Procedure Project (by Darren Gosbell)
- Data-Blogger-Resource-Kit - Includes resources for use by bloggers, microbloggers, vloggers, and origami enthusiasts who focus on SQL Server (by Andy Andy Mallon)
- SQL-Server-Multi-Thread - a framework to do multi-threading in T-SQL using SQL Server Agent jobs. (by )
- 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)sp_alter_column stored procedure is able to alter a column with dependencies (by Sergio Govoni)- Toolbox repository for Madeira’s consultant team (by Madeira)
mssql-jobs-hadr - maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring (by Eitan Blumin)- Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations (by Eivind Gussiås Løksetheloekset, Mark Junker, Tom Marien)
- SQL Server in Docker (by Microsoft)
- ActiveRecord SQL Server Adapter - SQL Server Adapter For Rails (by rails-sqlserver)
- EFCorePowerTools - Reverse engineering, model visualization and migrations UI for EF Core (by Erik Ejlskov Jensen)
- SqlTableDependency - a high-level C# component used to audit, monitor and receive notifications on SQL Server’s record table changes (by Christian Del Bianco)
- EFSecondLevelCache.Core - Entity Framework Core Second Level Caching Library (Redis) (by Vahid Nasiri)
- Dotmim.Sync - a brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard 2.0
- 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)
- sp_CRUDGen - stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types (by Kevin Martin)
- sp_Develop - can be used by database developers, software developers and for performing database code (smell) reviews.s (by Kevin Martin)
- DBA Dash - Performance monitoring tool for SQL Server (by Trimble)
- lowlydba.sqlserver - A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server - (by John McCall)
- SQLWatch - SQLWATCH is an Open Source and completely free SQL Server Monitoring project (by Marcin Gminski)
- Azure_Synapse_Toolbox - Repository of tools/queries for managing and monitoring Azure Synapse (by Microsoft)
- Other
⬆ back to top
BIML Resources and Bloggers
BIML - Business Intelligence Markup Language
BIML Resources
BIML Bloggers
⬆ back to top
PowerShell and SQL Server
⬆ back to top
⬆ back to top
SQL Server Test Data Generation
⬆ back to top
Free SQL Server and R ebooks
SQL Server:
R:
⬆ back to top
SQL Server Paid Books
⬆ back to top
License
MIT
If some procedures or scripts are restricted due to ELUA (or we can not find original author), please email us or add issue - we remove/update it immediately.
Thanks for understanding and patience.
