<commit_before># SQL Server KIT

<a name="header01"></a>
<a name="header02"></a>
<a name="header020"></a>
<a name="header03"></a>
<a name="header04"></a>
<a name="header05"></a>
<a name="header06"></a>
<a name="header07"></a>
<a name="header08"></a>
<a name="header09"></a>
[![licence badge]][licence]
[![stars badge]][stars]
[![forks badge]][forks]
[![issues badge]][issues]
[![Average time to resolve an issue](http://isitmaintained.com/badge/resolution/ktaranov/sqlserver-kit.svg)](http://isitmaintained.com/project/ktaranov/sqlserver-kit "Average time to resolve an issue")
[![Join the chat at https://gitter.im/sqlserver-kit/Lobby](https://badges.gitter.im/sqlserver-kit/Lobby.svg)](https://gitter.im/sqlserver-kit/Lobby?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)
[![contributors_badge]][contributors]

[licence badge]:https://img.shields.io/badge/license-MIT-blue.svg
[stars badge]:https://img.shields.io/github/stars/ktaranov/sqlserver-kit.svg
[forks badge]:https://img.shields.io/github/forks/ktaranov/sqlserver-kit.svg
[issues badge]:https://img.shields.io/github/issues/ktaranov/sqlserver-kit.svg
[contributors_badge]:https://img.shields.io/github/contributors/ktaranov/sqlserver-kit.svg

[licence]:https://github.com/ktaranov/sqlserver-kit/blob/master/LICENSE.md
[stars]:https://github.com/ktaranov/sqlserver-kit/stargazers
[forks]:https://github.com/ktaranov/sqlserver-kit/network
[issues]:https://github.com/ktaranov/sqlserver-kit/issues
[contributors]:https://github.com/ktaranov/sqlserver-kit/graphs/contributors

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Headers:
 - [Repo Folders and Files](#repo-folders-and-files)
 - [SQL Server Web Resources](#sql-server-web-resources)
 - [BIML Resources and Bloggers](#biml-resources-and-bloggers)
 - [SQL Server Sample Databases and Datasets](#sql-server-sample-databases-and-datasets)
 - [Microsoft Transact-SQL Hints](#microsoft-transact-sql-hints)
 - [PowerShell and SQL Server](#powershell-and-sql-server)
 - [TSQL Format Code](#tsql-format-code)
 - [SQL Server Test Data Generation](#sql-server-test-data-generation)
 - [Free SQL Server, R ebooks](#free-ebooks)
 - [License](#license)


## Repo Folders and Files
 - [SQL Server Data Types](/SQL%20Server%20Data%20Types.md)
 - [SQL Server Edition](/SQL%20Server%20Edition.md)
 - [SQL Server Name Convention and T-SQL Programming Style](/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md)
 - [SQL Server Licensing](/SQL%20Server%20Licensing.md)
 - [SQL Server People](/SQL%20Server%20People.md 'Most Valuable SQL Server professionals')
 - [SQL Server Trace Flag](/SQL%20Server%20Trace%20Flag.md 'Complete list - 521 Trace Flags') (**Complete list - 521 trace flags**)
 - [SQL Server Version](/SQL%20Server%20Version.md 'List of all Microsoft SQL Sever versions') (**Complete list - from SQL Server 1.0 to SQL Server 2017**)
 - [Articles](/Articles)
 - [CLR procedures](/CLR)
    - [SplitterB_CLR](/CLR/SplitterB_CLR.sql)
 - [Extended Events](/Extended_Events)
 - [Known Errors](/Errors)
 - [Solution](/Solution)
    - [dbWarden](/Solution/dbWarden) a free SQL Server Monitoring Package (by <NAME> and <NAME>)
    - [Base line Collector script](/Solution/BaselineCollector) (by <NAME>)
    - [Ola Maintenance Solution](/Solution/Ola_Maintenance_Solution) (by <NAME>)
    - [SQLQueryStress](/Solution/SQLQueryStress) (by <NAME>)
    - [SysJobHistory](/Solution/SysJobHistory) (by <NAME>)
 - [SSMS](/SSMS)
    - [SSMS addins](/SSMS/SSMS_Addins.md) (**32 useful free and paid SSMS Addins**)
    - [SSMS Snippets](/SSMS/SSMS_Snippets)
    - [SSMS Shortcuts](/SSMS/SSMS_Shortcuts.md) (**More than 300 Shortcuts**)
    - [SSMS Tips](/SSMS/SSMS_Tips.md) (**Complete guide about hidden gems of SSMS**)
 - [Scripts](/Scripts)
    - **Awesome SQL Server Diagnostic Information Queries** (by <NAME>)
      - [SQL Server 2017 Diagnostic Information Queries](/Scripts/SQL%20Server%202017%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2016 Diagnostic Information Queries](/Scripts/SQL%20Server%202016%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2014 Diagnostic Information Queries](Scripts/SQL%20Server%202014%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2012 Diagnostic Information Queries](/Scripts/SQL%20Server%202012%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2008 R2 Diagnostic Information Queries](/Scripts/SQL%20Server%202008%20R2%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2008 Diagnostic Information Queries](/Scripts/SQL%20Server%202008%20Diagnostic%20Information%20Queries.sql)
    - [Table count alternative](/Scripts/Table%20Count%20alternative.sql) (by <NAME>)
    - [Foreign Key batch rename](/Scripts/Foreign%20Key%20batch%20rename.sql) (by <NAME>)
    - [Count character matches](/Scripts/Count%20character%20matches.sql)
    - and many others...
 - [Stored Procedure](/Stored_Procedure)
   - [sp_DBPermissions](/Stored_Procedure/sp_DBPermissions.sql) (by <NAME>)
   - [sp_SrvPermissions](/Stored_Procedure/sp_SrvPermissions.sql) (by <NAME>)
   - [sp_RestoreGene](/Stored_Procedure/sp_RestoreGene.sql) (by <NAME>)
   - [usp_who5](/Stored_Procedure/usp_who5.sql) (by <NAME>)
   - [usp_String_Search](/Stored_Procedure/usp_String_Search.sql) (by <NAME>)
   - [usp_BulkUpload](/Stored_Procedure/usp_BulkUpload.sql)
   - [usp_TableUnpivot](/Stored_Procedure/usp_TableUnpivot.sql)
   - and many others...
 - [User Defined Function](/User_Defined_Function)
    - [udf_parseJSON](/User_Defined_Function/udf_parseJSON.sql)
    - [udf_RenderXMLToString](/User_Defined_Function/udf_RenderXMLToString.sql)
    - [udf_RTF2Text](/User_Defined_Function/udf_RTF2Text.sql)
    - [udf_SplitStringByDelimiter](/User_Defined_Function/udf_SplitStringByDelimiter.sql)
    - [udf_Tally](/User_Defined_Function/udf_Tally.sql)
    - and many others...
 - [Utilities](/Utilities) (**complete list of 229 SQL Server paid and free Utilities and Tools**)

[*Back to top*](#header01)


## SQL Server Web Resources
 - Blogs
    - [SQL Central Blog Scripts](http://www.sqlservercentral.com/Scripts/)
    - [SQL Central Blog Articles](http://www.sqlservercentral.com/Articles/)
    - [SQL Central Blog Stairways](http://www.sqlservercentral.com/stairway/)
    - [DatabaseWeekly](http://www.databaseweekly.com/)
    - [MSSQLTips](https://www.mssqltips.com/get-free-sql-server-tips/)
    - [BRENT OZAR](https://www.brentozar.com/) scripts, videos and articles
    - [Simple-talk Articles](https://www.simple-talk.com/)
    - [SQLSentry Blog](http://blogs.sqlsentry.com)
    - [<NAME>'s SQL Server Performance](http://sqlserverperformance.wordpress.com/)
    - [<NAME> SQLStudies Blog](http://sqlstudies.com/)
    - [Best SQL Server Perfomance Blog](http://sqlperformance.com/)
    - [Weblogs SQLTeam Blogs](http://weblogs.sqlteam.com/)
    - [SQLMag](http://sqlmag.com/)
    - [SQLShack](http://www.sqlshack.com/)
    - [LessThanDot SQL Server Blog](http://blogs.lessthandot.com/index.php/category/datamgmt/dbprogramming/mssqlserver/)
    - [SQLBlog](http://sqlblog.com)
    - [DatabseJournal SQL Server Blog](http://www.databasejournal.com/features/mssql/)
    - [SQLPass](http://www.sqlpass.org/Home.aspx)
    - [Vertabelo Blog](http://www.vertabelo.com/blog)
    - [Midnightdba Blog](http://www.midnightdba.com/Jen/)
    - [Madeiradata Blog](http://www.madeiradata.com/blog/)
    - [SQL Server Performance Articles](http://www.sql-server-performance.com/category/articles/)
    - [SQL and more with KRUTI Blog](http://sqlandmorewithkruti.blogspot.ru/search/label/SQL%20Server)
    - [SQL Authority](http://blog.sqlauthority.com/)
    - [TECHNET SQL Server Blog](https://blogs.technet.microsoft.com/dataplatforminsider/)
    - [SQL Server Database Engine Blog](https://blogs.msdn.microsoft.com/sqlserverstorageengine/)
    - [SQL Server BI Blog](https://sqlserverbiblog.wordpress.com/)
    - [Andy Yun SQLBeck Blog](https://sqlbek.wordpress.com/)
    - [Curated SQL](http://curatedsql.com/)
    - [Blog do Ezequiel](https://blogs.msdn.microsoft.com/blogdoezequiel/)
    - [SQLHA Blog](http://sqlha.com/blog/)
    - [SQLSecurity Blog](http://www.sqlsecurity.com/home)
    - [SQL.ru SQL Server](http://www.sql.ru/blogs/t-sql) (Russian)
    - [C# Corner SQL Server Articles](http://www.c-sharpcorner.com/technologies/sql-server)
    - [TechTarget Blog](http://searchsqlserver.techtarget.com/)
    - [Toad SQL Server Blog](http://www.toadworld.com/platforms/sql-server/b/weblog)
    - [SQL-Articles](http://sql-articles.com/articles/)
    - [DallasDBAs Blog](http://dallasdbas.com/blog/)
    - [UpSearch Blog](https://upsearch.com/blog/)
    - [ProData Blog](http://blogs.prodata.ie/)
    - [Red9 SQL Server Performance Blog](https://red9.com/blog/)
    - [DallasDBAs.com Blog](http://dallasdbas.com/blog/)
    - [SQLBI Blog](http://www.sqlbi.com)
    - [RDX Blog](http://blog.rdx.com)
    - [Codingsight](http://codingsight.com/)
 - Security (great thanks to [Troy Hunt](https://www.troyhunt.com/troys-ultimate-list-of-security-links/))
   - SQL injection
     - [sqlmap](http://sqlmap.org/) – The tool for mounting SQL injection attacks tests against a running site
     - [Drupal 7 SQL injection flaw of 2014](https://www.drupal.org/PSA-2014-003) – great example of how impactful it still is (patch it within 7 hours or you’re owned)
     - [Ethical Hacking: SQL Injection](http://www.pluralsight.com/courses/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](http://seclists.org) – Heaps of exploits consolidated from various bug tracking lists
     - [Exploit Database](https://www.exploit-db.com/) – Very comprehensive list of vulnerabilities
     - [PunkSPIDER](https://www.punkspider.org/) – Lots of vulnerabilities of all kinds all over the web (about 90M sites scanned with over 3M vulns at present)
     - [Data Loss DB](http://datalossdb.org/) – Good list of breaches including stats on number of records compromised
     - [Information is Beautiful: World’s Biggest Data Breaches](http://www.informationisbeautiful.net/visualizations/worlds-biggest-data-breaches-hacks/) – Fantastic visualisation of incidents that give a great indication of scale
     - [Biggest data breaches in history](https://www.comparitech.com/blog/information-security/biggest-data-breaches-in-history/) (by <NAME>)
   - [SQL Server Database Engine Permission Posters](http://social.technet.microsoft.com/wiki/contents/articles/11842.sql-server-database-engine-permission-posters.aspx)
 - Free Videos
   - [Youtube <NAME>](https://www.youtube.com/user/BrentOzar/videos)
   - [IDERA Resource Center](https://www.idera.com/resourcecentral)
   - [MSSQLTips SQL Server Webcasts and Videos](https://www.mssqltips.com/sql-server-webcasts/)
   - [SQL Server Videos](http://www.sqlservervideos.com/)
   - [TECHNET How do I Videos](https://technet.microsoft.com/en-us/library/dd353197.aspx)
   - [Veeam Learn Microsoft SQL Server](http://go.veeam.com/learn-microsoft-sql-server-free-video-tutorial-course.html)
   - [MidnightDBA ITBookWorm Video](http://midnightdba.itbookworm.com/)
   - [SQL Server Hangouts](https://www.youtube.com/playlist?list=PLvcGRPk71pmRi2UZHKfyruJKu_zHZ0ROc) (by <NAME>, <NAME>)
   - [Youtube russianVC](https://www.youtube.com/channel/UC0UA5gKnOq9TM1RNvMIArwg) (Russian)
   - [Youtube Redgate Videos](https://www.youtube.com/redgate)
   - [Dell DBA days the Brent Ozar Unlimited 2015](https://software.dell.com/event/webcast-series-dell-dba-days-the-brent-ozar-unlimited-show890450)
   - [Dell DBA days the Brent Ozar Unlimited 2016](https://software.dell.com/event/live-webcast-series-dell-dba-days-the-brent-ozar-unlimited-show-the-se8112821)
   - [User Group.tv](http://usergroup.tv/) (by <NAME>)
   - [SQLPass Virtual Chapters](http://www.sqlpass.org/passchapters/virtualchapters.aspx)
   - [Youtube SQLpassion](https://www.youtube.com/channel/UCkrUQVPrv36Musorn0K4KoA)
   - [SQLBits Video](http://sqlbits.com/)
   - [Business Intelligence Videos](http://www.bidn.com/Videos/Videos)
   - [Pragmatic Works Free Training Webinars](http://pragmaticworks.com/Training/FreeTrainingWebinars)
   - [Youtube Pragmatic Works Video](https://www.youtube.com/user/PragmaticWorks) (by <NAME> and <NAME>)
   - [MVP: Data Platform](https://channel9.msdn.com/Blogs/MVP-Data-Platform)
 - Free Database Podcasts
   - [SQL Server Radio](http://www.sqlserverradio.com/) (by <NAME> and <NAME>)
   - [SQL Data Partners](http://sqldatapartners.com/podcast/) (by <NAME>, <NAME> and <NAME>)
   - [Away from the Keyboard](http://awayfromthekeyboard.com/) (by <NAME> and <NAME>)
   - [RunAs Radio](http://runasradio.com/) (by <NAME> and <NAME>)
   - [People Talking Tech](http://peopletalkingtech.com/) (by <NAME>)
   - [NET Rocks!](http://www.dotnetrocks.com/) (by <NAME> and <NAME>)
   - [SQL Down Under Podcast](http://www.sqldownunder.com/Podcasts) (by <NAME>)
   - [Free sql server video tutorials for beginners](http://csharp-video-tutorials.blogspot.ru/p/free-sql-server-video-tutorials-for.html) (by PRAGIM Technologies)
   - [Midnight DBA Podcast](http://midnightdba.itbookworm.com/Show) (by Sean and <NAME>)
   - [Dear SQL DBA](https://www.littlekendra.com/dearsqldba/) (by <NAME>)
   - [GroupBy.org - Group By is a free online event for the community, by the community](https://groupby.org/) (by Brent Ozar team)
   - [DevopsCafe](http://devopscafe.org/) (by <NAME> and <NAME>)
   - [SQLDataPartners Podcast](http://sqldatapartners.com/podcast/)
   - [SQLPlayer](http://sqlplayer.net/) (by <NAME> and <NAME>)
   - [Data Driven](http://datadriven.tv/) (by <NAME> and <NAME>)
 - Courses
   - Free
     - [Learn SQL Server by solving problems](https://sqlworkbooks.com/courses-overview/) (by <NAME>)
     - [Codecademy Learn SQL](https://www.codecademy.com/learn/learn-sql)
     - [Codecademy SQL: Table Transformation](https://www.codecademy.com/learn/sql-table-transformation)
     - [Codecademy SQL: Analyzing Business Metrics](https://www.codecademy.com/learn/sql-analyzing-business-metrics)
     - [MVA SQL Server Courses](https://mva.microsoft.com/product-training/sql-server)
     - [How to Think Like the SQL Server Engine](https://learnfrom.brentozar.com/courses/how-to-think-like-the-engine-an-introduction-to-sql-server-internals/)
     - [Number and Date Tables](https://www.brentozar.com/archive/2016/01/video-free-training-of-the-week-number-and-date-tables/)
     - [Free SQL Tutorials](http://www.guru99.com/sql.html)
     - [OpenedX Microsoft Courses](https://openedx.microsoft.com/)
     - [SQLBolt - Learn SQL with simple, interactive exercises](https://sqlbolt.com/)
     - [SQL Tutorial](https://sqlzoo.net)
     - [HackerRank.com - SQL interactive exercises and many others languages](https://www.hackerrank.com/domains/sql)
     - [SQL-EX.ru - Practical skills of SQL language](http://www.sql-ex.ru) (Russian, English)
   - Paid
     - [Lynda Courses](http://www.lynda.com/SQL-Server-training-tutorials/456-0.html)
     - [Veeam Free Courses](https://go.veeam.com/microsoft-sql-series-webinars.html)
     - [SQLSkills Trainings](https://www.sqlskills.com/sql-server-training/online-training/)
     - [Brent Ozar Team Trainings](https://learnfrom.brentozar.com/)
     - [Pluralsight Courses](https://www.pluralsight.com/search?q=sql+server&categories=all)
     - [SolidQ Classes](https://training.solidq.com/classes/)
     - [JOOQ SQL Masterclass](http://www.jooq.org/training/)
     - [Learn SQL Server High Availability & Disaster Recovery](https://learnsqlserverhadr.com/) (by <NAME>)
     - [Madeira Data Solutions Academy](http://madeira-data-solutions.teachable.com/)
     - [SQLpassion Online Academy](http://www.sqlpassion.at/online-training/index.html) (by <NAME>)
 - SQL Server Backwards Compatibility
   - [2017 Backwards Compatibility](https://docs.microsoft.com/en-us/sql/database-engine/sql-server-database-engine-backward-compatibility)
   - [2016 Backwards Compatibility](https://docs.microsoft.com/en-us/sql/database-engine/sql-server-database-engine-backward-compatibility)
   - [2014 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc280407(v=sql.120).aspx)
   - [2012 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc707787(v=sql.110).aspx)
   - [2008 R2 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc707787(v=sql.105).aspx)
   - [2008 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc707787(v=sql.100).aspx)
   - [2005 Backwards Compatibility](http://technet.microsoft.com/en-us/library/ms143532(v=sql.90).aspx)
 - SQL Server System Views Map
   - [SQL Server 2008 System Views Map](https://www.microsoft.com/en-us/download/details.aspx?id=9301)
   - [SQL Server 2012 System Views Map](https://www.microsoft.com/en-us/download/details.aspx?id=39083)
 - Microsoft Troubleshooting and security guides
   - [Solving Connectivity errors to SQL Server](https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server)
   - [Troubleshooting connectivity issues with Microsoft Azure SQL Database](https://support.microsoft.com/en-in/help/10085/troubleshooting-connectivity-issues-with-microsoft-azure-sql-database)
   - [Troubleshooting Always On Issues](https://support.microsoft.com/en-us/help/10179/troubleshooting-alwayson-issues)
   - [Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform](https://aka.ms/gdprsqlwhitepaper)
 - Social, Forum and Messenger SQL Server Groups <a id="sql-social"></a>
   - [SQLServerCentral Forum](http://www.sqlservercentral.com/Forums/) (more than 10^6 People)
   - [Slack #sqlhelp](https://sqlcommunity.slack.com/messages/sqlhelp/) (more than 700 People)
   - [Slack #firstresponderkit](https://sqlcommunity.slack.com/messages/firstresponderkit/) (more then 70 People)
   - [Twitter #sqlhelp](https://twitter.com/hashtag/sqlhelp) (more than 500 People)
   - [SQL.ru SQL Server Forum](http://www.sql.ru/forum/microsoft-sql-server) (more than 10^5 People, Russian)
   - [VK.com #sqlcom](https://vk.com/sqlcom) (more than 3600 People, Russian)
   - [SQL Server User Group Meetings](https://www.mssqltips.com/sql-server-user-groups/)
   - [Russian SQL Server User Group](https://www.facebook.com/groups/144858492215825/) (434 People, Russian)
   - [SQLcom.ru telegram channel](https://t.me/sqlcom) (284 People, Russian)
 - Open Source Projects <a id="open-source">
    - [Brent Ozar SQL Server First Responder Kit](https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit) (Github)
    - [SQL Server Maintenance Solution](https://github.com/olahallengren/sql-server-maintenance-solution) (by <NAME>) (Github)
    - [Statistic Parser](https://github.com/Jorriss/StatisticsParser) (by <NAME>) (Github)
    - [SQL Generator](https://github.com/Jorriss/sqlgenerator) (by <NAME>) (Github)
    - [Columnstore Indexes Scripts Library](https://github.com/NikoNeugebauer/CISL) (by <NAME>) (Github)
    - [MOSL - Memory Optimized Script Library](https://github.com/NikoNeugebauer/MOSL) (by <NAME>) (Github)
    - [mssql-docker - Official Microsoft repository for SQL Server in Docker resources](https://github.com/ktaranov/mssql-docker) (by Microsoft) (Github)
    - [SQLCover - TSQL code coverage tool for SQL Server 2008+](https://github.com/GoEddie/SQLCover) (by <NAME>liott) (Github)
    - [tSQLt testing framework for Microsoft SQL Server](https://github.com/tSQLt-org/tSQLt) (Github)
    - [T-SQL SimMetrics string matching algorithms](https://github.com/GuerrillaAnalytics/similarity) (Github)
    - [Azure Blob Storage Backup](https://github.com/bornsql/azureblobstoragesync) (by <NAME>) (Github)
    - [StackExchange.DataExplorer - free tool for executing SQL queries against Stack Exchange databases](https://github.com/StackExchange/StackExchange.DataExplorer) (Github)
    - [Machine Learning Templates with SQL Server 2016 R Services](https://github.com/Microsoft/SQL-Server-R-Services-Samples) (by <NAME>) (Github)
    - [Campaign Optimization - Predicting How and When to Contact Leads Implemented on SQL Server 2016 R Services](https://github.com/Microsoft/r-server-campaign-optimization) (by <NAME>) (Github)
    - [SQL Server Performance Dashboards - contains all Microsoft based reports, custom built reports, modified reports and the TSQL setup](http://sqldashboards.codeplex.com/) (by <NAME>)
    - [tigertoolbox - Repository for Tiger team for "as-is" solutions and tools/scripts that the team publishes for SQL Server](https://github.com/Microsoft/tigertoolbox) (Github)
    - [SQL Server FineBuild - makes it easy for anyone to produce a best-practice installation and configuration of SQL Server](https://sqlserverfinebuild.codeplex.com/) (by <NAME>)
    - [Pssdiag/Sqldiag Manager - is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine](https://github.com/Microsoft/DiagManager) (Github)
    - [sql-xplat-cli - Repository for the new SQL cross-platform command line tools](https://github.com/Microsoft/sql-xplat-cli) (by Microsoft)
    - [dbfs - A tool for mounting MS SQL Server DMVs using FUSE](https://github.com/Microsoft/dbfs) (by Microsoft)
    - [Opserver - Stack Exchange's Monitoring System](https://github.com/opserver/Opserver) (by Stack Exchange)
    - [Bosum - Time Series Alerting Framework](https://github.com/bosun-monitor/bosun) (by Stack Exchange)
    - [BismNormalizer - is a free and open-source tool to manage Microsoft Analysis Services tabular models](https://github.com/christianwade/BismNormalizer) (by <NAME>)
    - [DbSharp - is a DAL Generator](https://www.codeproject.com/Articles/776811/DbSharp-DAL-generator-tool) (by Higty)
    - [YourSqlDba - Database maintenance solution as a single SQL script](https://github.com/pelsql/YourSqlDba) (by <NAME>)
    - [OpenQueryStore - collection of scripts that add Query Store like functionality to pre-SQL Server 2016 Instance](https://github.com/OpenQueryStore/OpenQueryStore)
    - [ssis-dashboard - HTML5 SQL Server Integration Services Dashboard](https://github.com/yorek/ssis-dashboard) (by <NAME>)
 - Other
    - [sp_whoisactive](http://whoisactive.com/) (by <NAME>)
    - [SQL# CLR functions](http://www.sqlsharp.com/) (by Sql Quantum Lift)
    - [SQL Server Latch Classes Library](https://www.sqlskills.com/help/latches/) (by <NAME>)
    - [SQL Server Wait Types Library](https://www.sqlskills.com/help/waits/) (by <NAME>)
    - [Waitopedia - is a comprehensive resource of information about SQL Server waits](https://www.spotlightessentials.com/waitopedia) (by Spotlight Essentials)
    - [SQL Server wait types](https://www.sqlshack.com/sql-server-wait-types/) (by SQLShack.com)
    - [SSIS Performance Benchmarks](http://ssisperformance.com/)
    - [Using Excel to parse Set Statistics IO output](http://vickyharp.com/2012/03/using-excel-to-parse-set-statistics-io-output/) (by <NAME>)
    - [Stackoverflow SQL Server](http://stackoverflow.com/questions/tagged/sql-server)
    - [DBA Stackexchange SQL Server](http://dba.stackexchange.com/questions/tagged/sql-server)
    - [Server Fault - is a question and answer site for system and network administrators](https://serverfault.com/)
    - [SQL Server Connection Strings](http://www.connectionstrings.com/sql-server/)
    - [SQL Injection Cheat Sheet](https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/) (by <NAME>)
    - [RSS Most Recent SQL Server KBs](https://support.microsoft.com/en-us/rss?rssid=1044)
    - [Stackoverflow SQL Anti Patterns](http://stackoverflow.com/questions/346659/what-are-the-most-common-sql-anti-patterns)
    - [Azure Speed](http://www.azurespeed.com/) (by <NAME>)
    - [SQLFiddle](http://sqlfiddle.com)
    - [Experts-Exchange.com MS SQL Server Topics](https://www.experts-exchange.com/topics/ms-sql-server/)
    - [Paste The Plan - share query plans quickly and easily](https://www.brentozar.com/pastetheplan/) (by Brent Ozar Team)
    - [StackExchange DataExplorer Query On line](http://data.stackexchange.com/stackoverflow/query/new)
    - [Dell Databases Wiki](http://en.community.dell.com/techcenter/storage/w/wiki/5018.sc-series-technical-documents) (by <NAME>)
    - [SDUTools - Free Tools for DBAs and Developers on pure TSQL](http://sqldownunder.azurewebsites.net/Resources/SDUTools) (by SQL Down Under)
    - [SqlServerSearcher - open source C# tool for searching SQL Server objects](https://github.com/CoderAllan/SqlServerSearcher) (by <NAME>)
    - [DbUp is a .NET library that helps you to deploy changes to SQL Server databases](https://github.com/DbUp/DbUp)
    - [SQL Server monitor - manages sql server performance](https://github.com/unruledboy/SQLMonitor) (by <NAME>)
    - [How's My Plan? - .SQLPLAN analyzer](http://www.howsmyplan.com/) (by <NAME>)
    - [Minion Backup - The new standard in SQL Server backups](http://minionware.net/backup/) (by Minionware)
    - [Minion CheckDB - completes the MinionWare maintenance and backups suite](http://minionware.net/checkdb/) (by Minionware)
    - [Minion Reindex - Index maintenance that is fully automated](http://minionware.net/reindex/) (by Minionware)

[*Back to top*](#header02)


## BIML Resources and Bloggers
BIML - [Business Intelligence Markup Language](https://varigence.com/biml)

BIML Resources
- [BimlScript.com](http://bimlscript.com/)
- [Varigence](https://varigence.com/Biml)
- [Biml Forum at Varigence](https://varigence.com/Forums?forumName=Biml)
- [SQLServerCentral.com](http://www.sqlservercentral.com/search/?q=Biml)
- [Stairway to Biml](http://www.sqlservercentral.com/stairway/100550/)
- [Biml User Group at LinkedIn](https://www.linkedin.com/groups/4640985)
- [Building Blocks of Biml (Pluralsight course by <NAME>)](https://app.pluralsight.com/library/courses/building-blocks-biml/table-of-contents)
- [Biml-tagged posts on this blog](http://sqlblog.com/blogs/andy_leonard/archive/tags/BIML/default.aspx)

BIML Bloggers
- [<NAME>](https://www.solisyon.de/biml-blog-de/)
- [<NAME>](http://billfellows.blogspot.com/search/label/Biml)
- [<NAME>](http://borishristov.com/biml/)
- [<NAME>](http://www.bonk.dk/biml/)
- [<NAME>](http://www.cathrinewilhelmsen.net/biml/)
- [Datachix: <NAME> and <NAME>](http://datachix.com/)
- [<NAME>](http://www.made2mentor.com/category/biml/)
- [<NAME>](http://sqlblog.com/blogs/davide_mauri/archive/tags/BIML/default.aspx)
- [<NAME>](http://www.anexinet.com/blog/author/ehudzik/)
- [<NAME>](http://bifuture.blogspot.com/search/label/BIML)
- [<NAME>](http://agilebi.com/jwelch/tag/biml/)
- [<NAME>](http://microsoft-ssis.blogspot.com/search/label/BIML)
- [<NAME>](http://blogs.lessthandot.com/index.php/tag/biml/)
- [<NAME>](http://blog.in2bi.eu/biml/)
- [<NAME>](http://www.frysdisken.net/)
- [<NAME>](https://datasavvy.wordpress.com/category/biml/)
- [<NAME>](http://sorrell.github.io/)
- [<NAME>](https://paultebraak.wordpress.com/tag/biml/)
- [<NAME>](http://schottsql.blogspot.com/search/label/BIML)
- [<NAME>](https://reevessmith.wordpress.com/category/biml/)
- [<NAME>](http://roelantvos.com/blog/?tag=biml)
- [<NAME>](http://www.bi4all.pt/taxonomy/term/75)
- [<NAME>](http://samuelvanga.com/category/biml/)
- [<NAME>](http://www.imgroup.com/author/stephen-leach/)
- [<NAME>](https://www.timmitchell.net/post/tag/biml/)
- [<NAME>](http://www.sqlmastersconsulting.com.au/SQL-Server-Blog/PID/1675/mcat/1682/evl/0/nsw/t/EDNSearch/Biml)

[*Back to top*](#header020)


## SQL Server Sample Databases and Datasets
Alternative download link for some sample databases: http://bit.ly/ya-ssk

 - [AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3](https://www.microsoft.com/en-us/download/details.aspx?id=49502)
 - [Microsoft SQL Server Community Projects & Samples](http://sqlserversamples.codeplex.com/)
 - [Adventure Works 2014 Sample Databases](https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/adventure-works-2014)<commit_msg>Update Adventure Works 2014 Sample Databases link<commit_after># SQL Server KIT

<a name="header01"></a>
<a name="header02"></a>
<a name="header020"></a>
<a name="header03"></a>
<a name="header04"></a>
<a name="header05"></a>
<a name="header06"></a>
<a name="header07"></a>
<a name="header08"></a>
<a name="header09"></a>
[![licence badge]][licence]
[![stars badge]][stars]
[![forks badge]][forks]
[![issues badge]][issues]
[![Average time to resolve an issue](http://isitmaintained.com/badge/resolution/ktaranov/sqlserver-kit.svg)](http://isitmaintained.com/project/ktaranov/sqlserver-kit "Average time to resolve an issue")
[![Join the chat at https://gitter.im/sqlserver-kit/Lobby](https://badges.gitter.im/sqlserver-kit/Lobby.svg)](https://gitter.im/sqlserver-kit/Lobby?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)
[![contributors_badge]][contributors]

[licence badge]:https://img.shields.io/badge/license-MIT-blue.svg
[stars badge]:https://img.shields.io/github/stars/ktaranov/sqlserver-kit.svg
[forks badge]:https://img.shields.io/github/forks/ktaranov/sqlserver-kit.svg
[issues badge]:https://img.shields.io/github/issues/ktaranov/sqlserver-kit.svg
[contributors_badge]:https://img.shields.io/github/contributors/ktaranov/sqlserver-kit.svg

[licence]:https://github.com/ktaranov/sqlserver-kit/blob/master/LICENSE.md
[stars]:https://github.com/ktaranov/sqlserver-kit/stargazers
[forks]:https://github.com/ktaranov/sqlserver-kit/network
[issues]:https://github.com/ktaranov/sqlserver-kit/issues
[contributors]:https://github.com/ktaranov/sqlserver-kit/graphs/contributors

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Headers:
 - [Repo Folders and Files](#repo-folders-and-files)
 - [SQL Server Web Resources](#sql-server-web-resources)
 - [BIML Resources and Bloggers](#biml-resources-and-bloggers)
 - [SQL Server Sample Databases and Datasets](#sql-server-sample-databases-and-datasets)
 - [Microsoft Transact-SQL Hints](#microsoft-transact-sql-hints)
 - [PowerShell and SQL Server](#powershell-and-sql-server)
 - [TSQL Format Code](#tsql-format-code)
 - [SQL Server Test Data Generation](#sql-server-test-data-generation)
 - [Free SQL Server, R ebooks](#free-ebooks)
 - [License](#license)


## Repo Folders and Files
 - [SQL Server Data Types](/SQL%20Server%20Data%20Types.md)
 - [SQL Server Edition](/SQL%20Server%20Edition.md)
 - [SQL Server Name Convention and T-SQL Programming Style](/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md)
 - [SQL Server Licensing](/SQL%20Server%20Licensing.md)
 - [SQL Server People](/SQL%20Server%20People.md 'Most Valuable SQL Server professionals')
 - [SQL Server Trace Flag](/SQL%20Server%20Trace%20Flag.md 'Complete list - 521 Trace Flags') (**Complete list - 521 trace flags**)
 - [SQL Server Version](/SQL%20Server%20Version.md 'List of all Microsoft SQL Sever versions') (**Complete list - from SQL Server 1.0 to SQL Server 2017**)
 - [Articles](/Articles)
 - [CLR procedures](/CLR)
    - [SplitterB_CLR](/CLR/SplitterB_CLR.sql)
 - [Extended Events](/Extended_Events)
 - [Known Errors](/Errors)
 - [Solution](/Solution)
    - [dbWarden](/Solution/dbWarden) a free SQL Server Monitoring Package (by <NAME> and <NAME>)
    - [Base line Collector script](/Solution/BaselineCollector) (by <NAME>)
    - [Ola Maintenance Solution](/Solution/Ola_Maintenance_Solution) (by <NAME>)
    - [SQLQueryStress](/Solution/SQLQueryStress) (by <NAME>)
    - [SysJobHistory](/Solution/SysJobHistory) (by <NAME>)
 - [SSMS](/SSMS)
    - [SSMS addins](/SSMS/SSMS_Addins.md) (**32 useful free and paid SSMS Addins**)
    - [SSMS Snippets](/SSMS/SSMS_Snippets)
    - [SSMS Shortcuts](/SSMS/SSMS_Shortcuts.md) (**More than 300 Shortcuts**)
    - [SSMS Tips](/SSMS/SSMS_Tips.md) (**Complete guide about hidden gems of SSMS**)
 - [Scripts](/Scripts)
    - **Awesome SQL Server Diagnostic Information Queries** (by <NAME>)
      - [SQL Server 2017 Diagnostic Information Queries](/Scripts/SQL%20Server%202017%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2016 Diagnostic Information Queries](/Scripts/SQL%20Server%202016%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2014 Diagnostic Information Queries](Scripts/SQL%20Server%202014%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2012 Diagnostic Information Queries](/Scripts/SQL%20Server%202012%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2008 R2 Diagnostic Information Queries](/Scripts/SQL%20Server%202008%20R2%20Diagnostic%20Information%20Queries.sql)
      - [SQL Server 2008 Diagnostic Information Queries](/Scripts/SQL%20Server%202008%20Diagnostic%20Information%20Queries.sql)
    - [Table count alternative](/Scripts/Table%20Count%20alternative.sql) (by <NAME>)
    - [Foreign Key batch rename](/Scripts/Foreign%20Key%20batch%20rename.sql) (by <NAME>)
    - [Count character matches](/Scripts/Count%20character%20matches.sql)
    - and many others...
 - [Stored Procedure](/Stored_Procedure)
   - [sp_DBPermissions](/Stored_Procedure/sp_DBPermissions.sql) (by <NAME>)
   - [sp_SrvPermissions](/Stored_Procedure/sp_SrvPermissions.sql) (by <NAME>)
   - [sp_RestoreGene](/Stored_Procedure/sp_RestoreGene.sql) (by <NAME>)
   - [usp_who5](/Stored_Procedure/usp_who5.sql) (by <NAME>)
   - [usp_String_Search](/Stored_Procedure/usp_String_Search.sql) (by <NAME>)
   - [usp_BulkUpload](/Stored_Procedure/usp_BulkUpload.sql)
   - [usp_TableUnpivot](/Stored_Procedure/usp_TableUnpivot.sql)
   - and many others...
 - [User Defined Function](/User_Defined_Function)
    - [udf_parseJSON](/User_Defined_Function/udf_parseJSON.sql)
    - [udf_RenderXMLToString](/User_Defined_Function/udf_RenderXMLToString.sql)
    - [udf_RTF2Text](/User_Defined_Function/udf_RTF2Text.sql)
    - [udf_SplitStringByDelimiter](/User_Defined_Function/udf_SplitStringByDelimiter.sql)
    - [udf_Tally](/User_Defined_Function/udf_Tally.sql)
    - and many others...
 - [Utilities](/Utilities) (**complete list of 229 SQL Server paid and free Utilities and Tools**)

[*Back to top*](#header01)


## SQL Server Web Resources
 - Blogs
    - [SQL Central Blog Scripts](http://www.sqlservercentral.com/Scripts/)
    - [SQL Central Blog Articles](http://www.sqlservercentral.com/Articles/)
    - [SQL Central Blog Stairways](http://www.sqlservercentral.com/stairway/)
    - [DatabaseWeekly](http://www.databaseweekly.com/)
    - [MSSQLTips](https://www.mssqltips.com/get-free-sql-server-tips/)
    - [BRENT OZAR](https://www.brentozar.com/) scripts, videos and articles
    - [Simple-talk Articles](https://www.simple-talk.com/)
    - [SQLSentry Blog](http://blogs.sqlsentry.com)
    - [<NAME> SQL Server Performance](http://sqlserverperformance.wordpress.com/)
    - [<NAME> SQLStudies Blog](http://sqlstudies.com/)
    - [Best SQL Server Perfomance Blog](http://sqlperformance.com/)
    - [Weblogs SQLTeam Blogs](http://weblogs.sqlteam.com/)
    - [SQLMag](http://sqlmag.com/)
    - [SQLShack](http://www.sqlshack.com/)
    - [LessThanDot SQL Server Blog](http://blogs.lessthandot.com/index.php/category/datamgmt/dbprogramming/mssqlserver/)
    - [SQLBlog](http://sqlblog.com)
    - [DatabseJournal SQL Server Blog](http://www.databasejournal.com/features/mssql/)
    - [SQLPass](http://www.sqlpass.org/Home.aspx)
    - [Vertabelo Blog](http://www.vertabelo.com/blog)
    - [Midnightdba Blog](http://www.midnightdba.com/Jen/)
    - [Madeiradata Blog](http://www.madeiradata.com/blog/)
    - [SQL Server Performance Articles](http://www.sql-server-performance.com/category/articles/)
    - [SQL and more with KRUTI Blog](http://sqlandmorewithkruti.blogspot.ru/search/label/SQL%20Server)
    - [SQL Authority](http://blog.sqlauthority.com/)
    - [TECHNET SQL Server Blog](https://blogs.technet.microsoft.com/dataplatforminsider/)
    - [SQL Server Database Engine Blog](https://blogs.msdn.microsoft.com/sqlserverstorageengine/)
    - [SQL Server BI Blog](https://sqlserverbiblog.wordpress.com/)
    - [<NAME> SQLBeck Blog](https://sqlbek.wordpress.com/)
    - [Curated SQL](http://curatedsql.com/)
    - [Blog do Ezequiel](https://blogs.msdn.microsoft.com/blogdoezequiel/)
    - [SQLHA Blog](http://sqlha.com/blog/)
    - [SQLSecurity Blog](http://www.sqlsecurity.com/home)
    - [SQL.ru SQL Server](http://www.sql.ru/blogs/t-sql) (Russian)
    - [C# Corner SQL Server Articles](http://www.c-sharpcorner.com/technologies/sql-server)
    - [TechTarget Blog](http://searchsqlserver.techtarget.com/)
    - [Toad SQL Server Blog](http://www.toadworld.com/platforms/sql-server/b/weblog)
    - [SQL-Articles](http://sql-articles.com/articles/)
    - [DallasDBAs Blog](http://dallasdbas.com/blog/)
    - [UpSearch Blog](https://upsearch.com/blog/)
    - [ProData Blog](http://blogs.prodata.ie/)
    - [Red9 SQL Server Performance Blog](https://red9.com/blog/)
    - [DallasDBAs.com Blog](http://dallasdbas.com/blog/)
    - [SQLBI Blog](http://www.sqlbi.com)
    - [RDX Blog](http://blog.rdx.com)
    - [Codingsight](http://codingsight.com/)
 - Security (great thanks to [Troy Hunt](https://www.troyhunt.com/troys-ultimate-list-of-security-links/))
   - SQL injection
     - [sqlmap](http://sqlmap.org/) – The tool for mounting SQL injection attacks tests against a running site
     - [Drupal 7 SQL injection flaw of 2014](https://www.drupal.org/PSA-2014-003) – great example of how impactful it still is (patch it within 7 hours or you’re owned)
     - [Ethical Hacking: SQL Injection](http://www.pluralsight.com/courses/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](http://seclists.org) – Heaps of exploits consolidated from various bug tracking lists
     - [Exploit Database](https://www.exploit-db.com/) – Very comprehensive list of vulnerabilities
     - [PunkSPIDER](https://www.punkspider.org/) – Lots of vulnerabilities of all kinds all over the web (about 90M sites scanned with over 3M vulns at present)
     - [Data Loss DB](http://datalossdb.org/) – Good list of breaches including stats on number of records compromised
     - [Information is Beautiful: World’s Biggest Data Breaches](http://www.informationisbeautiful.net/visualizations/worlds-biggest-data-breaches-hacks/) – Fantastic visualisation of incidents that give a great indication of scale
     - [Biggest data breaches in history](https://www.comparitech.com/blog/information-security/biggest-data-breaches-in-history/) (by <NAME>)
   - [SQL Server Database Engine Permission Posters](http://social.technet.microsoft.com/wiki/contents/articles/11842.sql-server-database-engine-permission-posters.aspx)
 - Free Videos
   - [Youtube <NAME>](https://www.youtube.com/user/BrentOzar/videos)
   - [IDERA Resource Center](https://www.idera.com/resourcecentral)
   - [MSSQLTips SQL Server Webcasts and Videos](https://www.mssqltips.com/sql-server-webcasts/)
   - [SQL Server Videos](http://www.sqlservervideos.com/)
   - [TECHNET How do I Videos](https://technet.microsoft.com/en-us/library/dd353197.aspx)
   - [Veeam Learn Microsoft SQL Server](http://go.veeam.com/learn-microsoft-sql-server-free-video-tutorial-course.html)
   - [MidnightDBA ITBookWorm Video](http://midnightdba.itbookworm.com/)
   - [SQL Server Hangouts](https://www.youtube.com/playlist?list=PLvcGRPk71pmRi2UZHKfyruJKu_zHZ0ROc) (by <NAME>, <NAME>)
   - [Youtube russianVC](https://www.youtube.com/channel/UC0UA5gKnOq9TM1RNvMIArwg) (Russian)
   - [Youtube Redgate Videos](https://www.youtube.com/redgate)
   - [Dell DBA days the Brent Ozar Unlimited 2015](https://software.dell.com/event/webcast-series-dell-dba-days-the-brent-ozar-unlimited-show890450)
   - [Dell DBA days the Brent Ozar Unlimited 2016](https://software.dell.com/event/live-webcast-series-dell-dba-days-the-brent-ozar-unlimited-show-the-se8112821)
   - [User Group.tv](http://usergroup.tv/) (by <NAME>)
   - [SQLPass Virtual Chapters](http://www.sqlpass.org/passchapters/virtualchapters.aspx)
   - [Youtube SQLpassion](https://www.youtube.com/channel/UCkrUQVPrv36Musorn0K4KoA)
   - [SQLBits Video](http://sqlbits.com/)
   - [Business Intelligence Videos](http://www.bidn.com/Videos/Videos)
   - [Pragmatic Works Free Training Webinars](http://pragmaticworks.com/Training/FreeTrainingWebinars)
   - [Youtube Pragmatic Works Video](https://www.youtube.com/user/PragmaticWorks) (by <NAME> and <NAME>)
   - [MVP: Data Platform](https://channel9.msdn.com/Blogs/MVP-Data-Platform)
 - Free Database Podcasts
   - [SQL Server Radio](http://www.sqlserverradio.com/) (by <NAME> and <NAME>)
   - [SQL Data Partners](http://sqldatapartners.com/podcast/) (by <NAME>, <NAME> and <NAME>)
   - [Away from the Keyboard](http://awayfromthekeyboard.com/) (by <NAME> and <NAME>)
   - [RunAs Radio](http://runasradio.com/) (by <NAME> and <NAME>)
   - [People Talking Tech](http://peopletalkingtech.com/) (by <NAME>)
   - [NET Rocks!](http://www.dotnetrocks.com/) (by <NAME> and <NAME>)
   - [SQL Down Under Podcast](http://www.sqldownunder.com/Podcasts) (by <NAME>)
   - [Free sql server video tutorials for beginners](http://csharp-video-tutorials.blogspot.ru/p/free-sql-server-video-tutorials-for.html) (by PRAGIM Technologies)
   - [Midnight DBA Podcast](http://midnightdba.itbookworm.com/Show) (by Sean and <NAME>)
   - [Dear SQL DBA](https://www.littlekendra.com/dearsqldba/) (by <NAME>)
   - [GroupBy.org - Group By is a free online event for the community, by the community](https://groupby.org/) (by <NAME> team)
   - [DevopsCafe](http://devopscafe.org/) (by <NAME> and <NAME>)
   - [SQLDataPartners Podcast](http://sqldatapartners.com/podcast/)
   - [SQLPlayer](http://sqlplayer.net/) (by <NAME> and <NAME>)
   - [Data Driven](http://datadriven.tv/) (by <NAME> and <NAME>)
 - Courses
   - Free
     - [Learn SQL Server by solving problems](https://sqlworkbooks.com/courses-overview/) (by <NAME>)
     - [Codecademy Learn SQL](https://www.codecademy.com/learn/learn-sql)
     - [Codecademy SQL: Table Transformation](https://www.codecademy.com/learn/sql-table-transformation)
     - [Codecademy SQL: Analyzing Business Metrics](https://www.codecademy.com/learn/sql-analyzing-business-metrics)
     - [MVA SQL Server Courses](https://mva.microsoft.com/product-training/sql-server)
     - [How to Think Like the SQL Server Engine](https://learnfrom.brentozar.com/courses/how-to-think-like-the-engine-an-introduction-to-sql-server-internals/)
     - [Number and Date Tables](https://www.brentozar.com/archive/2016/01/video-free-training-of-the-week-number-and-date-tables/)
     - [Free SQL Tutorials](http://www.guru99.com/sql.html)
     - [OpenedX Microsoft Courses](https://openedx.microsoft.com/)
     - [SQLBolt - Learn SQL with simple, interactive exercises](https://sqlbolt.com/)
     - [SQL Tutorial](https://sqlzoo.net)
     - [HackerRank.com - SQL interactive exercises and many others languages](https://www.hackerrank.com/domains/sql)
     - [SQL-EX.ru - Practical skills of SQL language](http://www.sql-ex.ru) (Russian, English)
   - Paid
     - [Lynda Courses](http://www.lynda.com/SQL-Server-training-tutorials/456-0.html)
     - [Veeam Free Courses](https://go.veeam.com/microsoft-sql-series-webinars.html)
     - [SQLSkills Trainings](https://www.sqlskills.com/sql-server-training/online-training/)
     - [Brent Ozar Team Trainings](https://learnfrom.brentozar.com/)
     - [Pluralsight Courses](https://www.pluralsight.com/search?q=sql+server&categories=all)
     - [SolidQ Classes](https://training.solidq.com/classes/)
     - [JOOQ SQL Masterclass](http://www.jooq.org/training/)
     - [Learn SQL Server High Availability & Disaster Recovery](https://learnsqlserverhadr.com/) (by <NAME>)
     - [Madeira Data Solutions Academy](http://madeira-data-solutions.teachable.com/)
     - [SQLpassion Online Academy](http://www.sqlpassion.at/online-training/index.html) (by <NAME>)
 - SQL Server Backwards Compatibility
   - [2017 Backwards Compatibility](https://docs.microsoft.com/en-us/sql/database-engine/sql-server-database-engine-backward-compatibility)
   - [2016 Backwards Compatibility](https://docs.microsoft.com/en-us/sql/database-engine/sql-server-database-engine-backward-compatibility)
   - [2014 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc280407(v=sql.120).aspx)
   - [2012 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc707787(v=sql.110).aspx)
   - [2008 R2 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc707787(v=sql.105).aspx)
   - [2008 Backwards Compatibility](https://msdn.microsoft.com/en-us/library/cc707787(v=sql.100).aspx)
   - [2005 Backwards Compatibility](http://technet.microsoft.com/en-us/library/ms143532(v=sql.90).aspx)
 - SQL Server System Views Map
   - [SQL Server 2008 System Views Map](https://www.microsoft.com/en-us/download/details.aspx?id=9301)
   - [SQL Server 2012 System Views Map](https://www.microsoft.com/en-us/download/details.aspx?id=39083)
 - Microsoft Troubleshooting and security guides
   - [Solving Connectivity errors to SQL Server](https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server)
   - [Troubleshooting connectivity issues with Microsoft Azure SQL Database](https://support.microsoft.com/en-in/help/10085/troubleshooting-connectivity-issues-with-microsoft-azure-sql-database)
   - [Troubleshooting Always On Issues](https://support.microsoft.com/en-us/help/10179/troubleshooting-alwayson-issues)
   - [Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform](https://aka.ms/gdprsqlwhitepaper)
 - Social, Forum and Messenger SQL Server Groups <a id="sql-social"></a>
   - [SQLServerCentral Forum](http://www.sqlservercentral.com/Forums/) (more than 10^6 People)
   - [Slack #sqlhelp](https://sqlcommunity.slack.com/messages/sqlhelp/) (more than 700 People)
   - [Slack #firstresponderkit](https://sqlcommunity.slack.com/messages/firstresponderkit/) (more then 70 People)
   - [Twitter #sqlhelp](https://twitter.com/hashtag/sqlhelp) (more than 500 People)
   - [SQL.ru SQL Server Forum](http://www.sql.ru/forum/microsoft-sql-server) (more than 10^5 People, Russian)
   - [VK.com #sqlcom](https://vk.com/sqlcom) (more than 3600 People, Russian)
   - [SQL Server User Group Meetings](https://www.mssqltips.com/sql-server-user-groups/)
   - [Russian SQL Server User Group](https://www.facebook.com/groups/144858492215825/) (434 People, Russian)
   - [SQLcom.ru telegram channel](https://t.me/sqlcom) (284 People, Russian)
 - Open Source Projects <a id="open-source">
    - [Brent Ozar SQL Server First Responder Kit](https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit) (Github)
    - [SQL Server Maintenance Solution](https://github.com/olahallengren/sql-server-maintenance-solution) (by <NAME>) (Github)
    - [Statistic Parser](https://github.com/Jorriss/StatisticsParser) (by <NAME>) (Github)
    - [SQL Generator](https://github.com/Jorriss/sqlgenerator) (by <NAME>) (Github)
    - [Columnstore Indexes Scripts Library](https://github.com/NikoNeugebauer/CISL) (by <NAME>) (Github)
    - [MOSL - Memory Optimized Script Library](https://github.com/NikoNeugebauer/MOSL) (by <NAME>ugebauer) (Github)
    - [mssql-docker - Official Microsoft repository for SQL Server in Docker resources](https://github.com/ktaranov/mssql-docker) (by Microsoft) (Github)
    - [SQLCover - TSQL code coverage tool for SQL Server 2008+](https://github.com/GoEddie/SQLCover) (by <NAME>) (Github)
    - [tSQLt testing framework for Microsoft SQL Server](https://github.com/tSQLt-org/tSQLt) (Github)
    - [T-SQL SimMetrics string matching algorithms](https://github.com/GuerrillaAnalytics/similarity) (Github)
    - [Azure Blob Storage Backup](https://github.com/bornsql/azureblobstoragesync) (by <NAME>) (Github)
    - [StackExchange.DataExplorer - free tool for executing SQL queries against Stack Exchange databases](https://github.com/StackExchange/StackExchange.DataExplorer) (Github)
    - [Machine Learning Templates with SQL Server 2016 R Services](https://github.com/Microsoft/SQL-Server-R-Services-Samples) (by <NAME>) (Github)
    - [Campaign Optimization - Predicting How and When to Contact Leads Implemented on SQL Server 2016 R Services](https://github.com/Microsoft/r-server-campaign-optimization) (by <NAME>) (Github)
    - [SQL Server Performance Dashboards - contains all Microsoft based reports, custom built reports, modified reports and the TSQL setup](http://sqldashboards.codeplex.com/) (by <NAME>)
    - [tigertoolbox - Repository for Tiger team for "as-is" solutions and tools/scripts that the team publishes for SQL Server](https://github.com/Microsoft/tigertoolbox) (Github)
    - [SQL Server FineBuild - makes it easy for anyone to produce a best-practice installation and configuration of SQL Server](https://sqlserverfinebuild.codeplex.com/) (by <NAME>)
    - [Pssdiag/Sqldiag Manager - is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine](https://github.com/Microsoft/DiagManager) (Github)
    - [sql-xplat-cli - Repository for the new SQL cross-platform command line tools](https://github.com/Microsoft/sql-xplat-cli) (by Microsoft)
    - [dbfs - A tool for mounting MS SQL Server DMVs using FUSE](https://github.com/Microsoft/dbfs) (by Microsoft)
    - [Opserver - Stack Exchange's Monitoring System](https://github.com/opserver/Opserver) (by Stack Exchange)
    - [Bosum - Time Series Alerting Framework](https://github.com/bosun-monitor/bosun) (by Stack Exchange)
    - [BismNormalizer - is a free and open-source tool to manage Microsoft Analysis Services tabular models](https://github.com/christianwade/BismNormalizer) (by <NAME>)
    - [DbSharp - is a DAL Generator](https://www.codeproject.com/Articles/776811/DbSharp-DAL-generator-tool) (by Higty)
    - [YourSqlDba - Database maintenance solution as a single SQL script](https://github.com/pelsql/YourSqlDba) (by <NAME>)
    - [OpenQueryStore - collection of scripts that add Query Store like functionality to pre-SQL Server 2016 Instance](https://github.com/OpenQueryStore/OpenQueryStore)
    - [ssis-dashboard - HTML5 SQL Server Integration Services Dashboard](https://github.com/yorek/ssis-dashboard) (by <NAME>)
 - Other
    - [sp_whoisactive](http://whoisactive.com/) (by <NAME>)
    - [SQL# CLR functions](http://www.sqlsharp.com/) (by Sql Quantum Lift)
    - [SQL Server Latch Classes Library](https://www.sqlskills.com/help/latches/) (by <NAME>)
    - [SQL Server Wait Types Library](https://www.sqlskills.com/help/waits/) (by <NAME>)
    - [Waitopedia - is a comprehensive resource of information about SQL Server waits](https://www.spotlightessentials.com/waitopedia) (by Spotlight Essentials)
    - [SQL Server wait types](https://www.sqlshack.com/sql-server-wait-types/) (by SQLShack.com)
    - [SSIS Performance Benchmarks](http://ssisperformance.com/)
    - [Using Excel to parse Set Statistics IO output](http://vickyharp.com/2012/03/using-excel-to-parse-set-statistics-io-output/) (by <NAME>)
    - [Stackoverflow SQL Server](http://stackoverflow.com/questions/tagged/sql-server)
    - [DBA Stackexchange SQL Server](http://dba.stackexchange.com/questions/tagged/sql-server)
    - [Server Fault - is a question and answer site for system and network administrators](https://serverfault.com/)
    - [SQL Server Connection Strings](http://www.connectionstrings.com/sql-server/)
    - [SQL Injection Cheat Sheet](https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/) (by <NAME>)
    - [RSS Most Recent SQL Server KBs](https://support.microsoft.com/en-us/rss?rssid=1044)
    - [Stackoverflow SQL Anti Patterns](http://stackoverflow.com/questions/346659/what-are-the-most-common-sql-anti-patterns)
    - [Azure Speed](http://www.azurespeed.com/) (by <NAME>)
    - [SQLFiddle](http://sqlfiddle.com)
    - [Experts-Exchange.com MS SQL Server Topics](https://www.experts-exchange.com/topics/ms-sql-server/)
    - [Paste The Plan - share query plans quickly and easily](https://www.brentozar.com/pastetheplan/) (by <NAME>)
    - [StackExchange DataExplorer Query On line](http://data.stackexchange.com/stackoverflow/query/new)
    - [Dell Databases Wiki](http://en.community.dell.com/techcenter/storage/w/wiki/5018.sc-series-technical-documents) (by <NAME>)
    - [SDUTools - Free Tools for DBAs and Developers on pure TSQL](http://sqldownunder.azurewebsites.net/Resources/SDUTools) (by SQL Down Under)
    - [SqlServerSearcher - open source C# tool for searching SQL Server objects](https://github.com/CoderAllan/SqlServerSearcher) (by <NAME>)
    - [DbUp is a .NET library that helps you to deploy changes to SQL Server databases](https://github.com/DbUp/DbUp)
    - [SQL Server monitor - manages sql server performance](https://github.com/unruledboy/SQLMonitor) (by <NAME>)
    - [How's My Plan? - .SQLPLAN analyzer](http://www.howsmyplan.com/) (by <NAME>)
    - [Minion Backup - The new standard in SQL Server backups](http://minionware.net/backup/) (by Minionware)
    - [Minion CheckDB - completes the MinionWare maintenance and backups suite](http://minionware.net/checkdb/) (by Minionware)
    - [Minion Reindex - Index maintenance that is fully automated](http://minionware.net/reindex/) (by Minionware)

[*Back to top*](#header02)


## BIML Resources and Bloggers
BIML - [Business Intelligence Markup Language](https://varigence.com/biml)

BIML Resources
- [BimlScript.com](http://bimlscript.com/)
- [Varigence](https://varigence.com/Biml)
- [Biml Forum at Varigence](https://varigence.com/Forums?forumName=Biml)
- [SQLServerCentral.com](http://www.sqlservercentral.com/search/?q=Biml)
- [Stairway to Biml](http://www.sqlservercentral.com/stairway/100550/)
- [Biml User Group at LinkedIn](https://www.linkedin.com/groups/4640985)
- [Building Blocks of Biml (Pluralsight course by Stacia Misner Varga)](https://app.pluralsight.com/library/courses/building-blocks-biml/table-of-contents)
- [Biml-tagged posts on this blog](http://sqlblog.com/blogs/andy_leonard/archive/tags/BIML/default.aspx)

BIML Bloggers
- [<NAME>](https://www.solisyon.de/biml-blog-de/)
- [<NAME>](http://billfellows.blogspot.com/search/label/Biml)
- [<NAME>](http://borishristov.com/biml/)
- [<NAME>](http://www.bonk.dk/biml/)
- [<NAME>](http://www.cathrinewilhelmsen.net/biml/)
- [Datachix: <NAME> and <NAME>](http://datachix.com/)
- [<NAME>](http://www.made2mentor.com/category/biml/)
- [<NAME>](http://sqlblog.com/blogs/davide_mauri/archive/tags/BIML/default.aspx)
- [<NAME>](http://www.anexinet.com/blog/author/ehudzik/)
- [<NAME>](http://bifuture.blogspot.com/search/label/BIML)
- [<NAME>](http://agilebi.com/jwelch/tag/biml/)
- [<NAME>](http://microsoft-ssis.blogspot.com/search/label/BIML)
- [<NAME>](http://blogs.lessthandot.com/index.php/tag/biml/)
- [<NAME>](http://blog.in2bi.eu/biml/)
- [<NAME>](http://www.frysdisken.net/)
- [<NAME>](https://datasavvy.wordpress.com/category/biml/)
- [<NAME>](http://sorrell.github.io/)
- [<NAME>](https://paultebraak.wordpress.com/tag/biml/)
- [<NAME>](http://schottsql.blogspot.com/search/label/BIML)
- [<NAME>](https://reevessmith.wordpress.com/category/biml/)
- [<NAME>](http://roelantvos.com/blog/?tag=biml)
- [<NAME>](http://www.bi4all.pt/taxonomy/term/75)
- [<NAME>](http://samuelvanga.com/category/biml/)
- [<NAME>](http://www.imgroup.com/author/stephen-leach/)
- [<NAME>](https://www.timmitchell.net/post/tag/biml/)
- [<NAME>](http://www.sqlmastersconsulting.com.au/SQL-Server-Blog/PID/1675/mcat/1682/evl/0/nsw/t/EDNSearch/Biml)

[*Back to top*](#header020)


## SQL Server Sample Databases and Datasets
Alternative download link for some sample databases: http://bit.ly/ya-ssk

 - [AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3](https://www.microsoft.com/en-us/download/details.aspx?id=49502)
 - [Microsoft SQL Server Community Projects & Samples](http://sqlserversamples.codeplex.com/)
 - [Adventure Works 2014 Sample Databases](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2014)
{'fraction_non_alphanumeric': 0.15890396325178935, 'fraction_numerical': 0.01897945376206246, 'mean_word_length': 4.31130023640662, 'pattern_counts': {'":': 0, '<': 249, '<?xml version=': 0, '>': 249, 'https://': 256, 'lorem ipsum': 0, 'www.': 170, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 10, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6971376', 'n_tokens_mistral': 20282, 'n_tokens_neox': 18755, 'n_words': 3485}