Useful links, scripts, tools and best practice for Microsoft SQL Server Database
- Repo Folders and Files
- SQL Server Web Resources
- PowerShell and SQL Server
- TSQL Format Code
- SQL Server Test Data Generation
- Free SQL Server and R ebooks
- 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 - 598 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)
- Table count alternative (by Jes Schultz Borland)
- Foreign Key batch rename (by Wes Henriksen)
- Count character matches
- and many others...
- 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 278 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
- SQLSentry Blog
- Glenn Berry's SQL Server Performance
- Kenneth Fisher SQLStudies Blog
- Best SQL Server Perfomance Blog
- Weblogs SQLTeam Blogs
- SQLMag
- SQLShack
- LessThanDot SQL Server Blog
- SQLBlog
- 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
- ProData Blog
- Red9 SQL Server Performance Blog
- DallasDBAs.com Blog
- SQLBI Blog
- RDX Blog
- Codingsight
- Solomon Rutzky's SQL Quantum Leap Blog
- Niels Berglund Blog
- BornSQL Blog
- Kevin Chant 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’re owned)
- Ethical Hacking: SQL Injection – If you really want to go deep, here’s 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
- PunkSPIDER – Lots of vulnerabilities of all kinds all over the web (about 90M sites scanned with over 3M vulns at present)
- Data Loss DB – Good list of breaches including stats on number of records compromised
- Information is Beautiful: World’s Biggest Data Breaches – Fantastic visualisation of incidents that give a great indication of scale
- 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
- 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 Redgate Videos
- User Group.tv (by Shawn Weisfeld)
- SQLPass Virtual Chapters
- Youtube SQLpassion
- SQLBits Video
- Business Intelligence Videos
- Pragmatic Works Free Training Webinars
- Youtube Pragmatic Works Video (by Devin Knight and Manuel Quintana)
- MVP: Data Platform
- Build 2018 conference
- Courses
- Free
- 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
- Number and Date Tables
- 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)
- Free
- SQL Server Backwards Compatibility
- SQL Server System Views Map
- Microsoft Troubleshooting and security guides
- 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 #sqlhelp (more than 500 People)
- 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 (1110 People, Russian)
- PowerBI telegram chat (295 People, Russian)
- PostgesSQL telegram chat (2823 People, Russian)
- DBA telegram chat (1389 People, Russian)
- Open Source Projects
- 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)
- 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
- sp_SizeOptimiser - a stored procedure that recommends space saving and corrective data type measures based on SQL Server database schemas (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)
- Other
- sp_whoisactive (documentation) and github repo for it sp_WhoIsActive (by Adam Machanic)
- 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)
- RSS Most Recent SQL Server KBs
- Stackoverflow SQL Anti Patterns
- Azure Speed (by Blair Chen)
- SQLFiddle
- DBFiddle
- 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 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
- Performance Analysis of Logs (PAL) Tool (by Clint Huffman)
- 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)
- http://sqlinform.com/
- http://www.dpriver.com/pp/sqlformat.htm
- http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio
- http://www.apexsql.com/sql_tools_refactor.aspx
- http://poorsql.com/
- http://www.architectshack.com/PoorMansTSqlFormatter.ashx
- http://www.ssmstoolspack.com/
- http://www.devart.com/dbforge/sql/sqlcomplete/
- http://www.sql-format.com/
- http://extras.sqlservercentral.com/prettifier/prettifier.aspx
- https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/
- https://github.com/benkeen/generatedata
- https://sourceforge.net/projects/dbmonster/
- https://sourceforge.net/projects/spawner/
- http://databene.org/databene-benerator
- Tools for Generating Mock Data?
- https://mockaroo.com
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, 2nd 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
- 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!
- Microsoft MVA Free ebooks
- OnlineVideoLectures ebooks
- Brent Ozar ebooks
- E-books SQL Server Directory
- TOAD SQL Server ebooks
- Syncfusion Techportal
- Modern Storage Strategies for SQL Server
- Migrating SQL Server Databases to Azure
- SQL Sentry 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.)
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)