Useful links, scripts, tools and best practice for Microsoft SQL Server Database
- Repo Folders and Files
- SQL Server Web Resources
- BIML Resources and Bloggers
- PowerShell and SQL Server
- TSQL Format Code
- SQL Server Test Data Generation
- Free SQL Server and R ebooks
- Paid SQL Server ebooks
- License
- SQL Server Data Types
- SQL Server Drivers
- SQL Server Edition
- SQL Server Hints
- SQL Server Name Convention and T-SQL Programming Style
- SQL Server Licensing
- SQL Server People
- SQL Server Trace Flag (Complete list - 620 trace flags)
- SQL Server Version (Complete list - from SQL Server 1.0 to SQL Server 2019)
- Articles
- CLR procedures
- Extended Events
- Known Errors
- SQL Server Sample Databases and Datasets
- Scripts
- Awesome SQL Server Diagnostic Information Queries (by Glenn Alan Berry)
- SQL Managed Instance Diagnostic Information Queries
- Azure SQL Database Diagnostic Information Queries
- SQL Server 2019 Diagnostic Information Queries
- SQL Server 2017 Diagnostic Information Queries
- SQL Server 2016 Diagnostic Information Queries
- SQL Server 2014 Diagnostic Information Queries
- SQL Server 2012 Diagnostic Information Queries
- SQL Server 2008 R2 Diagnostic Information Queries
- SQL Server 2008 Diagnostic Information Queries
- SQL Server 2005 Diagnostic Information Queries
- Table count alternative (by Jes Schultz Borland)
- Foreign Key batch rename (by Wes Henriksen)
- Count character matches
- and many others...
- Awesome SQL Server Diagnostic Information Queries (by Glenn Alan Berry)
- Solution
- dbWarden a free SQL Server Monitoring Package (by Stevie Rounds and Michael Rounds)
- Base line Collector script (by Robert Virag)
- SysJobHistory (by David Wentzel)
- SSMS
- SSMS addins (37 useful free and paid SSMS Addins)
- SSMS Snippets
- SSMS Shortcuts (More than 300 Shortcuts)
- SSMS Tips (Complete guide about hidden gems of SSMS)
- Stored Procedure
- sp_RestoreGene (by Paul Brewer)
- usp_who5 (by Sean Smith)
- usp_String_Search (by Sean Smith)
- usp_BulkUpload
- usp_TableUnpivot
- and many others...
- User Defined Function
- udf_parseJSON
- udf_RenderXMLToString
- udf_RTF2Text
- udf_SplitStringByDelimiter
- udf_Tally
- and many others...
- Utilities (Complete list of 395 SQL Server paid and free Utilities and Tools)
- Blogs
- Brent Ozar feedly reading list
- SQL Central Blog Scripts
- SQL Central Blog Articles
- SQL Central Blog Stairways
- DatabaseWeekly
- MSSQLTips
- BRENT OZAR scripts, videos and articles
- Simple-talk Articles
- SentryOne Blog
- Glenn Berry's SQL Server Performance
- Kenneth Fisher SQLStudies Blog
- Best SQL Server Perfomance Blog
- Weblogs SQLTeam Blogs
- SQLShack
- SQL Kiwi by Paul White
- DatabseJournal SQL Server Blog
- SQLPass
- Vertabelo Blog
- Midnightdba Blog
- Madeiradata Blog
- SQL Server Performance Articles
- SQL and more with KRUTI Blog
- SQL Authority
- TECHNET SQL Server Blog
- SQL Server Database Engine Blog
- SQL Server BI Blog
- Andy Yun SQLBeck Blog
- Curated SQL
- Blog do Ezequiel
- SQLHA Blog
- SQLSecurity Blog
- SQL.ru SQL Server (Russian)
- C# Corner SQL Server Articles
- TechTarget Blog
- Toad SQL Server Blog
- SQL-Articles
- DallasDBAs Blog
- UpSearch Blog
- SQL tutorial
- ProData Blog
- DallasDBAs.com Blog
- SQLBI Blog
- RDX Blog
- Codingsight
- Solomon Rutzky's SQL Quantum Leap Blog
- Niels Berglund Blog
- BornSQL Blog
- Kevin Chant Blog
- SQLBlog.org
- Idera SQL Server Blog
- SQL Server Science Blog (by Max Vernon)
- Kohera SQL Server Blog
- Security (great thanks to Troy Hunt)
- SQL injection
- sqlmap - The tool for mounting SQL injection attacks tests against a running site
- 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
- Exploit databases and breach coverage
- seclists.org – Heaps of exploits consolidated from various bug tracking lists
- Exploit Database – Very comprehensive list of vulnerabilities
- Data Loss DB – Good list of breaches including stats on number of records compromised
- Information is Beautiful: World’s Biggest Data Breaches
- Biggest data breaches in history (by Dave Albaugh)
- Microsoft SQL Server Permissions Posters
- Module Signing Info - Info and resources related to module signing (i.e. Certificates, Asymmetric Keys,
ADD SIGNATURE
, etc) in T-SQL and SQLCLR
- SQL injection
- Free Videos
- Youtube Brent Ozar
- Youtube Free SQL Server Statisctics Class
- SQLPASSTV videos
- IDERA Resource Center
- MSSQLTips SQL Server Webcasts and Videos
- SQL Server Videos
- TECHNET How do I Videos
- Veeam Learn Microsoft SQL Server
- MidnightDBA ITBookWorm Video
- SQL Server Hangouts (by Boris Hristov, Cathrine Wilhelmsen)
- Youtube russianVC (Russian)
- Youtube SSMSBoost tutorials
- Youtube Redgate Videos
- User Group.tv (by Shawn Weisfeld)
- SQLPass Virtual Chapters
- Youtube SQLpassion
- SQLBits Video
- Pragmatic Works Free Training Webinars
- Youtube Pragmatic Works Video (by Devin Knight and Manuel Quintana)
- TechEd SQL Server Videos
- Build 2018 conference
- New Stars of Data SQL Server Video
- Youtube Community 1nn0va (by Community 1nn0va)
- Free Database Podcasts
- 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)
- 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)
- GroupBy.org - Group By is a free online event for the community, by the community (by Brent Ozar team)
- DevopsCafe (by John Willis and Damon Edwards)
- SQLPlayer (by Kamil Nowinski and Damian Widera)
- Data Driven (by Frank La Vigne and Andy Leonard)
- 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)
- Courses
- Free
- SQLBolt - Learn SQL with simple, interactive exercises
- Learning Extended Events in 60 Days and new link (by Jason Brimhall)
- Learn SQL Server by solving problems (by Little Kendra)
- Codecademy Learn SQL
- Codecademy SQL: Table Transformation
- Codecademy SQL: Analyzing Business Metrics
- MVA SQL Server Courses
- How to Think Like the SQL Server Engine
- Free SQL Tutorials
- OpenedX Microsoft Courses
- SQLBolt - Learn SQL with simple, interactive exercises
- SQL Tutorial
- HackerRank.com - SQL interactive exercises and many others languages
- SQL-EX.ru - Practical skills of SQL language (Russian, English)
- Free Azure certification training courses
- SQL Server Tutorial (by Tutorial Gateway)
- Intro to SQL: Querying and managing data
- T-SQL Tutorial (by TutorialSpoint)
- T-SQL Tutorial and examples (by tsql.info)
- Red Gate Data Platform courses (by Red Gate)
- SQLZoo tutorial
- edX SQL Courses (by edX)
- SQL Murder Mystery (by NUKnightLab)
- SQL Murder Mystery with answers (by Erika Pullum)
- SQL Problems and solutions (by S. I. Moiseenko)
- Paid
- Lynda Courses
- Veeam Free Courses
- SQLSkills Trainings
- Brent Ozar Team Trainings
- Pluralsight Courses
- SolidQ Classes
- JOOQ SQL Masterclass
- Learn SQL Server High Availability & Disaster Recovery (by Edwin M Sarmiento)
- Madeira Data Solutions Academy
- SQLpassion Online Academy (by Klaus Aschenbrenner)
- Vertabelo Academy
- 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)
- Free
- SQL Server Deprecated database engine features and Backwards Compatibility
- Deprecated Features in SQL Server Replication
- Deprecated database engine features in SQL Server 2022
- Deprecated database engine features in SQL Server 2019
- Deprecated database engine features in SQL Server 2017
- Deprecated database engine features in SQL Server 2016
- 2014 Backwards Compatibility
- 2012 Backwards Compatibility
- 2008 R2 Backwards Compatibility
- 2008 Backwards Compatibility
- 2005 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
- SQL Saturdays
- Pass Sumit - Red Gate
- SQLBits
- Microsoft Ignite
- Microsoft Build
- Devintersection
- SentryOne SQL Server Virtual Conference
- Red Gate SQL Server Online Events
- EigthKB Sql Server Internals Conference
- DataWeekender
- Dativerse
- Future Data Driven
- DataMinds Connect
- New Stars of Data
- Data Weekender
- Data Toboggan
- The SQL Server & Azure SQL Conference
- Microsoft Build
- Microsoft Ignite
- Microsoft Inspire
- DataMinutes
- Data & AI Summit
- 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
- Other
- 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)
- SSIS Performance Benchmarks
- Using Excel to parse Set Statistics IO output (by Vicky Harp)
- Stackoverflow SQL Server
- DBA Stackexchange SQL Server
- Server Fault - is a question and answer site for system and network administrators
- SQL Server Connection Strings
- SQL Connection String Generator for .NET
- SQL Injection Cheat Sheet (by Ferruh Mavituna)
- Stackoverflow SQL Anti Patterns
- Azure Speed (by Blair Chen)
- DBFiddle - test your queries online
- SQLize Online - is a free online SQL environment for quickly running, experimenting with and sharing SQL code
- Experts-Exchange.com MS SQL Server Topics
- Paste The Plan - share query plans quickly and easily (by Brent Ozar Team)
- StackExchange DataExplorer Query On line
- 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
- 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 CheckDB - completes the MinionWare maintenance and backups suite (by Minionware)
- Minion Reindex - Index maintenance that is fully automated (by Minionware)
- OrcaMDF - C# parser for MDF files (by Mark S. Rasmussen)
- Microsoft SQL Server Zabbix templates
- Telegraf SQL Server Plugin (by influxdata)
- SDU Tools - pure TSQL functions Toolkit (by SQLDownUnder)
- Microsoft SQL Server Publications
- SQL Server Feedback
- Docs Overview SQL Tools
- SQL ConstantCare®: clear, personal advice for your SQL Server (by Brent Ozar)
- The SQL Server Execution Plan Reference (by Hugo Kornelis)
- EC2 Instance Calculator
- AWS Calculator
- Azure Instance Calculator
- PowerBI Premium Calculator
- Nuodb Oracle and SQL Server Calculator
- Github SQL Trending
- SQLCallStackResolver - Utility to resolve SQL Server callstacks to their correct symbolic form (by Arvind Shyamsundar)
- Azure updates
- Guides for Microsoft SQL Server Express (by John McCall)
- SQL Server Diagrams
- 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 Assessment API rules in .csv format (by Microsoft)
- 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
- SQLFacts - A powerful suite of FREE TSQL tools for SQL Server database professionals
BIML - Business Intelligence Markup Language
BIML Resources
- BimlScript.com
- Varigence
- Biml Forum at Varigence
- SQLServerCentral.com
- Stairway to Biml
- Biml User Group at LinkedIn
- Building Blocks of Biml (Pluralsight course by Stacia Misner Varga)
BIML Bloggers
- Ben Weissman
- Bill Fellows
- Boris Hristov
- Brian Bønk
- Cathrine Wilhelmsen
- Datachix: Julie Smith and Audrey Hammonds
- Davide Mauri
- Erik Hudzik
- Hennie de Nooijer
- John Welch
- Joost van Rossum
- Marco Schreuder
- Meagan Longoria
- Nicholas Sorrell
- Paul Te Braak
- Peter Schott
- Reeves Smith
- Roelant Vos
- Rui Custódio
- Tim Mitchell
- Warwick Rudd
- 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)
- PowerShell SQLPass articles and video
- PowerShell Blog NetNerds
- QS Config (by Derik Hammer)
- Idera 89 Free SQL Server PowerShell Scripts
- Powershell SQL Server Library (PSSQLLib) (by Sander Stad) (Github)
- Trello Board: Powershell and SQL Client Tools
- PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server (Github)
- PowerShell DBA Reports (Github)
- PowerShell sqlCheck (Bitbucket) (by Josh Feierman)
- ReportingServicesTools - Reporting Services Powershell Tools (by Microsoft)
- Powershell xSQLServer module contains DSC resources for deployment and configuration of SQL Server (Github by Microsoft)
- 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)
- PowerBIETL - a developer tool to quickly load a SQL Database using PowerBIDesktop queries (by DevScope)
- SQLinform Online Web
- SQLinform Online Utility
- Instant SQL Formatter
- http://poorsql.com/
- http://www.architectshack.com/PoorMansTSqlFormatter.ashx
- http://www.ssmstoolspack.com/
- http://www.devart.com/dbforge/sql/sqlcomplete/
- http://www.apexsql.com/sql_tools_refactor.aspx
- http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio
- https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/
- http://www.convertcsv.com/generate-test-data.htm
- https://github.com/benkeen/generatedata
- https://sourceforge.net/projects/dbmonster/
- https://sourceforge.net/projects/spawner/
- Tools for Generating Mock Data
- https://mockaroo.com
- https://anonymize.strd.co/
SQL Server:
- Awesome Red Gate ebooks
- SQL Developers
- 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ć)
- XML Stairway
- 119 SQL Code Smells
- High Performance Techniques for SQL Server (by SentryOne)
- SQL DBA
- SQL Server Internals: In-Memory OLTP (by Kalen Delaney)
- Fundamentals Of SQL Server 2012 Replication (by Sebastian Meine)
- Tribal SQL
- 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)
- SQL Developers
- Microsoft huge collection
- Microsoft large collection
- Largest FREE Microsoft eBook Giveaway!
- OnlineVideoLectures ebooks
- Brent Ozar ebooks
- E-books SQL Server Directory
- Syncfusion Techportal
- Modern Storage Strategies for SQL Server
- Migrating SQL Server Databases to Azure
- SentryOne Free eBooks
- Microsoft Cloud Security for Enterprise Architects (PDF)
- Brent Ozar SQL Server Setup Checklist eBook
- Introducing Microsoft SQL Server 2016
- 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)
- Query Optimization with SentryOne Plan Explorer
- 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)
R:
- BookDown - Write HTML, PDF, ePub, and Kindle books with R Markdown
- FreeComputerBooks R EBooks
- Effective Graphs with Microsoft R Open
- 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)
- An Introduction to Statistical Learning with Applications in R (by Gareth James, Daniela Witten, Trevor Hastie and Robert Tibshirani)
- 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)
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.