# SQL Server KIT [![license badge]][license] [![stars badge]][stars] [![forks badge]][forks] [![issues badge]][issues] [![contributors_badge]][contributors] [license 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 [license]:https://github.com/ktaranov/sqlserver-kit/blob/master/LICENSE [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 ## Table of Contents - [Repo Folders and Files](#repo-folders-and-files) - [SQL Server Web Resources](#sql-server-web-resources) - [SQL Server Blogs](#blogs) - [Security Resources](#security) - [SQL Server Free Videos](#free-videos) - [Free Database Podcasts](#podcasts) - [SQL Courses](#courses) - [SQL Server Backwards Compatibility](#backwards-compatibility) - [Social, Forum and Messenger SQL Server Groups](#social) - [SQL Server Open Source Projects](#open-source) - [BIML Resources and Bloggers](#biml-resources-and-bloggers) - [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 and R ebooks](#free-ebooks) - [Paid SQL Server ebooks](#paid-ebooks) - [License](#license) ## Repo Folders and Files - [SQL Server Data Types](/SQL%20Server%20Data%20Types.md) - [SQL Server Drivers](/SQL%20Server%20Drivers.md) - [SQL Server Edition](/SQL%20Server%20Edition.md) - [SQL Server Hints](/SQL%20Server%20Hints.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 - 613 Trace Flags') (**Complete list - 620 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 2019**) - [Articles](/Articles) - [CLR procedures](/CLR) - [SplitterB_CLR](/CLR/SplitterB_CLR.sql) - [Extended Events](/Extended_Events) - [Known Errors](/Errors) - [SQL Server Sample Databases and Datasets](/Sample_Databases) - [Scripts](/Scripts) - **Awesome SQL Server Diagnostic Information Queries** (by Glenn Alan Berry) - [SQL Managed Instance Diagnostic Information Queries](/Scripts/SQL%20Managed%20Instance%20Diagnostic%20Information%20Queries.sql) - [Azure SQL Database Diagnostic Information Queries](/Scripts/Azure%20SQL%20Database%20Diagnostic%20Information%20Queries.sql) - [SQL Server 2019 Diagnostic Information Queries](/Scripts/SQL%20Server%202019%20Diagnostic%20Information%20Queries.sql) - [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) - [SQL Server 2005 Diagnostic Information Queries](/Scripts/SQL%20Server%202005%20Diagnostic%20Information%20Queries.sql) - [Table count alternative](/Scripts/Table%20Count%20alternative.sql) (by Jes Schultz Borland) - [Foreign Key batch rename](/Scripts/Foreign%20Key%20batch%20rename.sql) (by Wes Henriksen) - [Count character matches](/Scripts/Count%20character%20matches.sql) - and many others... - [Solution](/Solution) - [dbWarden](/Solution/dbWarden) a free SQL Server Monitoring Package (by Stevie Rounds and Michael Rounds) - [Base line Collector script](/Solution/BaselineCollector) (by Robert Virag) - [SysJobHistory](/Solution/SysJobHistory) (by David Wentzel) - [SSMS](/SSMS) - [SSMS addins](/SSMS/SSMS_Addins.md) (**37 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**) - [Stored Procedure](/Stored_Procedure) - [sp_RestoreGene](/Stored_Procedure/dbo.sp_RestoreGene.sql) (by Paul Brewer) - [usp_who5](/Stored_Procedure/dbo.usp_who5.sql) (by Sean Smith) - [usp_String_Search](/Stored_Procedure/dbo.usp_String_Search.sql) (by Sean Smith) - [usp_BulkUpload](/Stored_Procedure/dbo.usp_BulkUpload.sql) - [usp_TableUnpivot](/Stored_Procedure/dbo.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 395 SQL Server paid and free Utilities and Tools**) **[⬆ back to top](#table-of-contents)** ## SQL Server Web Resources - Blogs - [Brent Ozar feedly reading list](https://github.com/BrentOzar/sqlblogs) - [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/) - [SentryOne Blog](https://www.sentryone.com/blog) - [Glenn Berry's SQL Server Performance](http://sqlserverperformance.wordpress.com/) - [Kenneth Fisher SQLStudies Blog](http://sqlstudies.com/) - [Best SQL Server Perfomance Blog](http://sqlperformance.com/) - [Weblogs SQLTeam Blogs](http://weblogs.sqlteam.com/) - [SQLShack](https://www.sqlshack.com/) - [SQL Kiwi by Paul White](https://www.sql.kiwi/) - [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](https://blog.toadworld.com/tag/sql-server) - [SQL-Articles](http://sql-articles.com/articles/) - [DallasDBAs Blog](http://dallasdbas.com/blog/) - [UpSearch Blog](https://upsearch.com/blog/) - [SQL tutorial](https://www.scaler.com/topics/sql) - [ProData Blog](http://blogs.prodata.ie/) - [DallasDBAs.com Blog](http://dallasdbas.com/blog/) - [SQLBI Blog](http://www.sqlbi.com) - [RDX Blog](http://blog.rdx.com) - [Codingsight](http://codingsight.com/) - [Solomon Rutzky's SQL Quantum Leap Blog](https://SqlQuantumLeap.com/) - [Niels Berglund Blog](https://nielsberglund.com) - [BornSQL Blog](https://bornsql.ca/blog/) - [Kevin Chant Blog](https://www.kevinrchant.com/) - [SQLBlog.org](https://sqlblog.org) - [Idera SQL Server Blog](https://community.idera.com/tags/SQL%2bServer) - [SQL Server Science Blog](https://www.sqlserverscience.com/) (by Max Vernon) - [Kohera SQL Server Blog](https://kohera.be/blog/category/sql-server/) - [SQL Queries Cheat Sheet](https://helpercodes.com/sql-query-cheatsheet-tutorial/) - Security (great thanks to [Troy Hunt](https://www.troyhunt.com/troys-ultimate-list-of-security-links/)) - SQL injection - [sqlmap - The tool for mounting SQL injection attacks tests against a running site](http://sqlmap.org/) - [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 are owned) - [Ethical Hacking: SQL Injection](http://www.pluralsight.com/courses/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](http://seclists.org) – Heaps of exploits consolidated from various bug tracking lists - [Exploit Database](https://www.exploit-db.com/) – Very comprehensive list of vulnerabilities - [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/) - [Biggest data breaches in history](https://www.comparitech.com/blog/information-security/biggest-data-breaches-in-history/) (by Dave Albaugh) - [Microsoft SQL Server Permissions Posters](https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/security/permissions-posters) - [Module Signing Info](https://modulesigning.info/) - Info and resources related to module signing (i.e. Certificates, Asymmetric Keys, \`ADD SIGNATURE\`, etc) in T-SQL and SQLCLR - [SQL Server security best practices](https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-server-security-best-practices) (by Microsoft) - Free Videos - [Youtube Brent Ozar](https://www.youtube.com/user/BrentOzar/videos) - [Youtube Free SQL Server Statisctics Class](https://www.youtube.com/playlist?list=PLDYqU5RH_aX05ajDAH-6sYXr4i1Mjh9lT) - [SQLPASSTV videos](https://www.youtube.com/user/SQLPASSTV/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/Minion/Reindex) - [SQL Server Hangouts](https://www.youtube.com/playlist?list=PLvcGRPk71pmRi2UZHKfyruJKu_zHZ0ROc) (by Boris Hristov, Cathrine Wilhelmsen) - [Youtube russianVC](https://www.youtube.com/channel/UC0UA5gKnOq9TM1RNvMIArwg) (Russian) - [Youtube SSMSBoost tutorials](https://www.youtube.com/channel/UCkm2ETlBDjs5V-kKb6j86zQ) - [Youtube Redgate Videos](https://www.youtube.com/redgate) - [User Group.tv](http://usergroup.tv/) (by Shawn Weisfeld) - [SQLPass Virtual Chapters](http://www.sqlpass.org/passchapters/virtualchapters.aspx) - [Youtube SQLpassion](https://www.youtube.com/channel/UCkrUQVPrv36Musorn0K4KoA) - [SQLBits Video](https://sqlbits.com/content/) - [Pragmatic Works Free Training Webinars](http://pragmaticworks.com/Training/FreeTrainingWebinars) - [Youtube Pragmatic Works Video](https://www.youtube.com/user/PragmaticWorks) (by Devin Knight and Manuel Quintana) - [TechEd SQL Server Videos](https://channel9.msdn.com/Search?term=sql%20server&lang-en=true) - [Build 2018 conference](http://sqlservercode.blogspot.ru/2018/05/azure-sql-data-warehouse-azure-sql.html) - [New Stars of Data SQL Server Video](https://www.youtube.com/playlist?list=PLLq_tkpMFDU5ibrnqn6I8CZxZ2-zYWG9m) - [Youtube Community 1nn0va](https://www.youtube.com/c/Community1nn0va/videos) (by Community 1nn0va) - Free Database Podcasts - [SQL Server Radio](http://www.sqlserverradio.com/) (by Guy Glantser and Matan Yungman) - [SQL Data Partners](http://sqldatapartners.com/podcast/) (by Carlos L Chacon, César Oviedo and Adrian Miranda) - [Away from the Keyboard](http://awayfromthekeyboard.com/) (by Cecil Phillip and Richie Rump) - [RunAs Radio](http://runasradio.com/) (by Richard Campbell and Greg Hughes) - [People Talking Tech](http://peopletalkingtech.com/) (by Denny Cherry) - [NET Rocks!](http://www.dotnetrocks.com/) (by Richard Campbell and Carl Franklin) - [SQL Down Under Podcast](https://sqldownunder.com/pages/sql-down-under-podcast) (by Greg Low) - [Free sql server video tutorials for beginners](http://csharp-video-tutorials.blogspot.ru/p/free-sql-server-video-tutorials-for.html) (by PRAGIM Technologies) - [Dear SQL DBA](https://www.littlekendra.com/dearsqldba/) (by Kendra Little) - [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 John Willis and Damon Edwards) - [SQLPlayer](http://sqlplayer.net/) (by Kamil Nowinski and Damian Widera) - [Data Driven](http://datadriven.tv/) (by Frank La Vigne and Andy Leonard) - [SQL Undercover Podcast](https://sqlundercover.com/category/podcast/) (by David Fowler and Adrian Buckman) - [Dallas DBAs](https://dallasdbas.com/) (by Kevin Hill) - [SQL Server Pain Relief: Office Hours](https://www.stitcher.com/podcast/sql-server-pain-relief-office-hours-with-brent-ozar-unlimitedr) (by Brent Ozar) - [Azure DevOps Podcast](http://azuredevopspodcast.clear-measure.com/) (by Microsoft) - [Mixed Extents](https://youtu.be/hBgMadT9fuU) (by EightKB) - Courses - Free - [SQLBolt - Learn SQL with simple, interactive exercises](https://sqlbolt.com/) - [Learning Extended Events in 60 Days](https://jasonbrimhall.info/2015/09/08/learning-extended-events-in-60-days/) and new [link](http://sqlxevents.com/) (by Jason Brimhall) - [Learn SQL Server by solving problems](https://littlekendra.com/courses-overview/) (by Little Kendra) - [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://www.brentozar.com/training/think-like-sql-server-engine/) - [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) - [Free Azure certification training courses](https://rlevchenko.com/2019/01/11/free-azure-certification-training-courses/) - [SQL Server Tutorial](https://www.tutorialgateway.org/sql/) (by Tutorial Gateway) - [Intro to SQL: Querying and managing data](https://www.khanacademy.org/computing/computer-programming/sql) - [T-SQL Tutorial](https://www.tutorialspoint.com/t_sql/index.htm) (by TutorialSpoint) - [T-SQL Tutorial and examples](https://www.tsql.info/sql-tutorial.php) (by tsql.info) - [Red Gate Data Platform courses](https://www.red-gate.com/hub/university/courses/data-platform) (by Red Gate) - [SQLZoo tutorial](https://sqlzoo.net/) - [edX SQL Courses](https://www.edx.org/learn/sql) (by edX) - [SQL Murder Mystery](https://github.com/NUKnightLab/sql-mysteries) (by NUKnightLab) - [SQL Murder Mystery with answers](https://github.com/erika-e/sql-mysteries) (by Erika Pullum) - [SQL Problems and solutions](http://www.sql-tutorial.ru/en) (by S. I. Moiseenko) - [Advanced T-SQL Puzzles](https://github.com/smpetersgithub/AdvancedSQLPuzzles) (by Scott Peters) - [Leetcode SQL Problems](https://leetcode.com/problemset/database/) - 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://www.brentozar.com/training/) - [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 Edwin M Sarmiento) - [Madeira Data Solutions Academy](http://madeira-data-solutions.teachable.com/) - [SQLpassion Online Academy](http://www.sqlpassion.at/online-training/index.html) (by Klaus Aschenbrenner) - [Vertabelo Academy](https://academy.vertabelo.com/) - [Darling Data - The Best SQL Server Training On The Internet?](https://learn.erikdarlingdata.com/) (by Erik Darling) - [W3Resource SQL Exercises, Practice, Solution](https://www.w3resource.com/sql-exercises/) (by w3resource) - [LinkedIn SQL Server cources](https://www.linkedin.com/learning/search?entityType=COURSE&keywords=sql%20server) (by LinkedIn) - SQL Server Deprecated database engine features and Backwards Compatibility - [Deprecated Features in SQL Server Replication](https://learn.microsoft.com/en-us/sql/relational-databases/replication/deprecated-features-in-sql-server-replication?view=sql-server-ver16) - [Deprecated database engine features in SQL Server 2022](https://learn.microsoft.com/sql/database-engine/discontinued-database-engine-functionality-in-sql-server?view=sql-server-ver16) - [Deprecated database engine features in SQL Server 2019](https://learn.microsoft.com/sql/database-engine/deprecated-database-engine-features-in-sql-server-2019?view=sql-server-ver16) - [Deprecated database engine features in SQL Server 2017](https://learn.microsoft.com/sql/database-engine/deprecated-database-engine-features-in-sql-server-2017?view=sql-server-ver16) - [Deprecated database engine features in SQL Server 2016](https://learn.microsoft.com/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016?view=sql-server-ver16) - [2014 Backwards Compatibility](https://docs.microsoft.com/en-us/sql/getting-started/backward-compatibility?view=sql-server-2014) - [2012 Backwards Compatibility](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms143532(v=sql.110)) - [2008 R2 Backwards Compatibility](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc707787(v=sql.105)) - [2008 Backwards Compatibility](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/cc707787(v=sql.100)) - [2005 Backwards Compatibility](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms143532(v=sql.90)) - 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) - SQL Server feedbacks - [SQL Server help and feedback](https://docs.microsoft.com/en-us/sql/sql-server/sql-server-get-help) - [Azure Data Studio feedback](https://github.com/Microsoft/azuredatastudio/issues) - [Azure SQL DB feedback](https://feedback.azure.com/forums/217321-sql-database) - [Azure SQL DB Managed Instances feedback](https://feedback.azure.com/forums/915676-sql-managed-instance) - [Power BI feedback](https://ideas.powerbi.com/forums/265200-power-bi-ideas) - [SSMS feedback](https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqltools) - [SQL Server Data Tools feedback](https://social.msdn.microsoft.com/Forums/en-US/home?forum=ssdt&filter=alltypes&sort=lastpostdesc) - Social, Forum and Messenger SQL Server Groups - [SQLServerCentral Forum](http://www.sqlservercentral.com/Forums/) (more than 10^6 People) - [Slack #sqlhelp](https://sqlcommunity.slack.com/messages/sqlhelp/) (more than 900 People) - [Slack #firstresponderkit](https://sqlcommunity.slack.com/messages/firstresponderkit/) (more then 90 People) - [Twitter #SQLServer](https://twitter.com/hashtag/SQLServer), [Twitter #SQLFamily](https://twitter.com/hashtag/SQLFamily), [Twitter #sqlhelp](https://twitter.com/hashtag/sqlhelp) (more than 500 People) - Reddit – [\`/r/sqlserver\`](https://www.reddit.com/r/SQLServer/), [\`/r/sql\`](https://www.reddit.com/r/SQL/), and [\`/r/database\`](https://www.reddit.com/r/Database/) - [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/) (900 People, Russian) - [SQLcom.ru telegram chat](https://t.me/sqlcom) (1900 People, Russian) - [PowerBI telegram chat](https://t.me/PBI_Rus) (295 People, Russian) - [PostgesSQL telegram chat](https://t.me/pgsql) (2823 People, Russian) - [DBA telegram chat](https://t.me/dba_ru) (1389 People, Russian) - [SQLTeam SQL Server Forum](https://forums.sqlteam.com/) - [Red Gate SQL Server Forum](https://forum.red-gate.com/) - [Microsoft SQL Server on Q&A](https://docs.microsoft.com/en-us/answers/products/sql-server) - SQL Server Conferences - [SQL Saturdays](https://sqlsaturday.com/) - [Pass Sumit - Red Gate](https://passdatacommunitysummit.com) - [SQLBits](https://sqlbits.com/) - [Microsoft Ignite](https://myignite.microsoft.com/home) - [Microsoft Build](https://mybuild.microsoft.com/home) - [Devintersection](https://devintersection.com/) - [SentryOne SQL Server Virtual Conference](https://info.sentryone.com/accelerate-2020) - [Red Gate SQL Server Online Events](https://www.red-gate.com/hub/events/online-events/) - [EigthKB Sql Server Internals Conference](https://eightkb.online/) - [DataWeekender](https://www.dataweekender.com/schedule) - [Dativerse](https://sessionize.com/dativerse) - [Future Data Driven](https://datadrivencommunity.com/) - [DataMinds Connect](https://datamindsconnect.be/) - [New Stars of Data ](https://www.newstarsofdata.com/) - [Data Weekender](https://www.dataweekender.com/) - [Data Toboggan](http://www.datatoboggan.co.uk/) - [The SQL Server & Azure SQL Conference](https://www.mssqlconf.com/#!/) - [Microsoft Build](https://mybuild.microsoft.com/home) - [Microsoft Ignite](https://myignite.microsoft.com/home) - [Microsoft Inspire](https://myinspire.microsoft.com/home) - [DataMinutes](https://datagrillen.com/dataminutes/) - [Data & AI Summit](https://databricks.com/dataaisummit) - Open Source Projects - [SQLFluff - A SQL linter and auto-formatter for Humans](https://github.com/sqlfluff/sqlfluff) - [sp_whoisactive](http://whoisactive.com/) (documentation) and github repo for it [sp_WhoIsActive](https://github.com/amachanic/sp_whoisactive) (by Adam Machanic) - [Brent Ozar SQL Server First Responder Kit](https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit) (Github) - [SQL Server Ola Hallengren's Maintenance Solution](https://github.com/olahallengren/sql-server-maintenance-solution) (by Ola Hallengren) (Github) - [Standby restore script output for Ola Hallengren's Maintenance Solution](https://github.com/jzagelbaum/OlaHallengrenRestoreScript) (by jzagelbaum) (Github) - [SqlQueryStress - SQL query stress simulator for SQL Server](https://github.com/ErikEJ/SqlQueryStress) (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](https://github.com/spaghettidba/WorkloadTools) (by Gianluca Sartori) - [Statistic Parser](https://github.com/Jorriss/StatisticsParser) (by Richie Rump) (Github) - [SQL Generator](https://github.com/Jorriss/sqlgenerator) (by Richie Rump) (Github) - [Columnstore Indexes Scripts Library](https://github.com/NikoNeugebauer/CISL) (by Niko Neugebauer) (Github) - [MOSL - Memory Optimized Script Library](https://github.com/NikoNeugebauer/MOSL) (by Niko Neugebauer) (Github) - [sp_SrvPermissions - stored procedure for list Server permissions](https://github.com/sqlstudent144/SQL-Server-Scripts/blob/master/sp_SrvPermissions.sql) (by Kenneth Fisher) - [sp_DBPermissions - stored procedure for list database permissions](https://github.com/sqlstudent144/SQL-Server-Scripts/blob/master/sp_DBPermissions.sql) (by Kenneth Fisher) - [stpChecklist_Seguranca - stored procedure with more than 70 security items to validate your SQL Server database](https://github.com/dirceuresende/checklist_seguranca) (by Dirceu Resende) - [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 Ed Elliott) (Github) - [tSQLt - testing framework for Microsoft SQL Server](https://github.com/tSQLt-org/tSQLt) (Github) - [SQLCop - tSQLt tests to highlight potential problems in your database](https://github.com/red-gate/SQLCop) (Red Gate) - [T-SQL SimMetrics string matching algorithms](https://github.com/GuerrillaAnalytics/similarity) (Github) - [Azure Blob Storage Backup](https://github.com/bornsql/azureblobstoragesync) (by Randolph West) (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 Sheri Gilley) (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 Sheri Gilley) (Github) - [SQL Server Performance Dashboards - contains all Microsoft based reports, custom built reports, modified reports and the TSQL setup](http://sqldashboards.codeplex.com/) (by Arun Sirpal) - [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 Brian Davis) - [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 Christian Wade) - [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 Maurice Pelchat) - [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 Davide Mauri) - [SQL Server Regex - run regular expressions in SQL Server](https://github.com/DevNambi/sql-server-regex) (by Dev Nambi) - [Binary Formatter - format binary files (e.g. DLL / CER / PVK) into hex bytes string for SQL script](https://github.com/SqlQuantumLeap/BinaryFormatter) (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](https://github.com/spaghettidba/ExtendedTSQLCollector) (by Gianluca Sartori) - [XESmartTarget - configurable target for SQL Server Extended Events](https://github.com/spaghettidba/XESmartTarget) (by Gianluca Sartori) - [Schemazen - script and create SQL Server objects quickly](https://github.com/sethreno/schemazen) (by Seth Reno) - [soddi - StackOverflow Data Dump Importer](https://github.com/BrentOzarULTD/soddi) (by Brent Ozar team) - [Automatically fix high VLF counts in SQL Server 2012+](https://github.com/tboggiano/autofix-vlfs) (by Tracy Boggiano) - [splittinglargefiles - Process for splitting large files in a filegroup that has grown out of control.](https://github.com/tboggiano/splittinglargefiles) (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](https://github.com/tboggiano/olamaintconfigtables) (by Tracy Boggiano) - [SQL Undercover Toolbox - A collection of cool and useful tools, procedures and scripts for the discerning DBA](https://github.com/SQLUndercover/UndercoverToolbox) (by SQL Undercover) - [dba-database - Database containing DBA helper code and open source software](https://github.com/amtwo/dba-database) (by Andy Mallon) - [SQLServerSpaceAnalysis PowerBI](https://github.com/SQLJana/SQLServerSpaceAnalysis) (by Jana Sattainathan) - [SQL Server Telegram Bot](https://github.com/ionflux/mssql-telegram-bot/) - [ZabbixMSSQL - Zabbix Template and tools for Microsoft SQL Server](https://github.com/dreik/ZabbixMSSQL) (by Sergey Kolesnik) - [AGLatency - analyze AG log block movement latency between replicas and create report accordingly](https://github.com/suyouquan/AGLatency) (by Simon Su) - [SQLSetupTools - FixMissingMSI, Product Browser, SQL Registry Viewer](https://github.com/suyouquan/SQLSetupTools) (by Simon Su) - [tsql-parser - Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net](https://github.com/bruce-dunwiddie/tsql-parser) (by Bruce Dunwiddie) - [tsqllint - Configurable linting for TSQL](https://github.com/tsqllint/tsqllint) (by tsqllint) - [Rezoom.SQL - F# ORM for SQL databases](https://github.com/rspeele/Rezoom.SQL) (by Robert Peele) - [SQLtoExcel - Exports the output of one or more TSQL script queries to Excel](https://github.com/BeginTry/SQLtoExcel) (by Dave Mason) - [Analysis Services - Analysis Services samples and community projects](https://github.com/Microsoft/Analysis-Services) (by Microsoft) - [ms-sql-express-replication - replication library written for MS SQL Sever Express edition](https://github.com/janhalama/ms-sql-express-replication) (by Jan Halama) - [SQL query builder, written in C#](https://github.com/sqlkata/querybuilder) - [php-crud-api - Single file PHP script that adds a REST API to a SQL database](https://github.com/mevdschee/php-crud-api) (by Maurits van der Schee) - [sql2xls - SQL to Excel Export Tool](https://github.com/bornsql/sql2xls) (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](https://github.com/bornsql/azureblobstoragesync) (by Randolph West) - [sql_profiler - Microsoft SQL-Server Profiler (command-line) for Linux/Mac/Windows](https://github.com/ststeiger/sql_profiler) (by Stefan Steiger) - [dbops - Powershell module that provides continuous database deployments on any scale](https://github.com/sqlcollaborative/dbops) (by Kirill Kravtsov) - [TabularTranslator - allow create translations for a translation file generated by SSDT for tabular models with the compatibility level 1200 and up](https://github.com/Kjonge/TabularTranslator) (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](https://github.com/JSuder-xx/TSqlStrong) (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](https://github.com/kendalvandyke/sqlpowerdoc) (by Kendal Van Dyke) - [rsqlserver - Sql Server driver database interface (DBI) driver for R](https://github.com/agstudy/rsqlserver) - [DBA MultiTool - T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.](https://github.com/LowlyDBA/dba-multitool) (by John McCall) - [language-extensions-sqlserver - SQL Server Language Extensions project](https://github.com/microsoft/sql-server-language-extensions) (by Microsoft) - [AzureRMR - R package for interacting with Azure Resource Manager](https://github.com/Azure/AzureRMR) (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](https://github.com/MikaelEliasson/EntityFramework.Utilities) (by Mikael Eliasson) - [EFCore.BulkExtensions - Entity Framework Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD) operations on SQL Server and SQLite](https://github.com/borisdj/EFCore.BulkExtensions) (by Boris Djurdjevic) - [Performance Analysis of Logs (PAL) Tool](https://github.com/clinthuffman/PAL) (by Clint Huffman) - [SQL-Server-Permissions-Manager - a set of scripts for managing logins and permissions on SQL Server databases](https://github.com/ericcobb/SQL-Server-Permissions-Manager) (by Eric Cobb) - [AwesomeSQLServer - collection of SQL Server Queries and documentations to fix your SQL Server's bottle neck](https://github.com/SQLadmin/AwesomeSQLServer) (by SqlAdmin) - [databases_scripts - SQL Server useful scripts](https://github.com/dgavrikov/databases_scripts/tree/master/SQL%20Server) (by Dmitriy Gavrikov) - [sp_PressureDetector - stored procedure for quickly detecting CPU and Memory pressure on a SQL Server](https://github.com/erikdarlingdata/DarlingData/tree/main/sp_PressureDetector) (by Erik Darling) - [sp_HumanEvents - make Extended Events easier and more approachable for the average admin to troubleshoot common scenarios](https://www.erikdarlingdata.com/sp_humanevents/) (by Erik Darling) - [Export Prometheus metrics from SQL queries](https://github.com/albertodonato/query-exporter) (by Alberto Donato) - [homebrew-mssql-release - brew formulae for Microsoft ODBC Driver for SQL Server and SQL Server Command Line Utilities](https://github.com/microsoft/homebrew-mssql-release) (by Microsoft) - [ASSP - Analysis Services Stored Procedure Project](https://asstoredprocedures.github.io/ASStoredProcedures/) (by Darren Gosbell) - [Data-Blogger-Resource-Kit - Includes resources for use by bloggers, microbloggers, vloggers, and origami enthusiasts who focus on SQL Server](https://github.com/amtwo/Data-Blogger-Resource-Kit) (by Andy Andy Mallon) - [SQL-Server-Multi-Thread - a framework to do multi-threading in T-SQL using SQL Server Agent jobs.](https://github.com/jobbish-sql/SQL-Server-Multi-Thread) (by ) - [SQL Server and Azure SQL Labs and Workshops](https://microsoft.github.io/sqlworkshops/) (by Microsoft) - [MsSqlDependencyBrowser - Simple tool to browse between dependent objects on MS SQL Server](https://github.com/usharik/MsSqlDependencyBrowser) (by Aleksej Usharovskij) - [\`Projects-MS-SQL-Server-DBA\` - Utilities and Scripts for SQL Server dba](https://github.com/jobgemws/Projects-MS-SQL-Server-DBA) (by Evgeniy Gribkov) - [\`sp_alter_column\` stored procedure is able to alter a column with dependencies](https://github.com/segovoni/sp_alter_column) (by Sergio Govoni) - [Toolbox repository for Madeira's consultant team](https://github.com/MadeiraData/MadeiraToolbox) (by Madeira) - [\`mssql-jobs-hadr\` - maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring](https://github.com/MadeiraData/mssql-jobs-hadr) (by Eitan Blumin) - [Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations](https://github.com/fluentmigrator/fluentmigrator) (by Eivind Gussiås Løksetheloekset, Mark Junker, Tom Marien) - [SQL Server in Docker](https://github.com/microsoft/mssql-docker) (by Microsoft) - [ActiveRecord SQL Server Adapter - SQL Server Adapter For Rails](https://github.com/rails-sqlserver/activerecord-sqlserver-adapter) (by rails-sqlserver) - [EFCorePowerTools - Reverse engineering, model visualization and migrations UI for EF Core](https://github.com/ErikEJ/EFCorePowerTools) (by Erik Ejlskov Jensen) - [SqlTableDependency - a high-level C# component used to audit, monitor and receive notifications on SQL Server's record table changes](https://github.com/christiandelbianco/monitor-table-change-with-sqltabledependency) (by Christian Del Bianco) - [EFSecondLevelCache.Core - Entity Framework Core Second Level Caching Library (Redis)](https://github.com/VahidN/EFSecondLevelCache.Core) (by Vahid Nasiri) - [Dotmim.Sync - a brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard 2.0](https://github.com/Mimetis/Dotmim.Sync) - [Hekaton-based shock absorber pattern for SQL Server](https://github.com/sqlsunday/shock-absorber) (by Daniel Hutmacher) - [HammerDBBenchmark - Swarchy T101 Wilson HammerDb Benchmark Setup Scripts for SQL Server](https://github.com/swarchy/HammerDBBenchmark) (by Swarchy T101 Wilson) - [sqlblockedprocesses - SQL Server Blocked Process Report Viewer](https://github.com/mjswart/sqlblockedprocesses) (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](https://github.com/kevinmartintech/sp_CRUDGen) (by Kevin Martin) - [sp_Develop - can be used by database developers, software developers and for performing database code (smell) reviews.s](https://github.com/EmergentSoftware/SQL-Server-Development-Assessment) (by Kevin Martin) - [DBA Dash - Performance monitoring tool for SQL Server](https://github.com/trimble-oss/dba-dash) (by Trimble) - [lowlydba.sqlserver - A cross-platform Ansible collection using PowerShell to configure and maintain SQL Server](https://github.com/lowlydba/lowlydba.sqlserver) - (by John McCall) - [SQLWatch - SQLWATCH is an Open Source and completely free SQL Server Monitoring project](https://sqlwatch.io/) (by Marcin Gminski) - [Azure_Synapse_Toolbox - Repository of tools/queries for managing and monitoring Azure Synapse](https://github.com/microsoft/Azure_Synapse_Toolbox) (by Microsoft) - Other - [SQL# SQLCLR functions](https://sqlsharp.com/) (by Sql Quantum Lift) - [SQL Server Latch Classes Library](https://www.sqlskills.com/help/latches/) (by Paul S. Randal) - [SQL Server Wait Types Library](https://www.sqlskills.com/help/waits/) (by Paul S. Randal) - [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 Vicky Harp) - [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](https://www.connectionstrings.com/sql-server/) - [SQL Connection String Generator for .NET](https://aireforge.com/Tools/ConnectionStringGenerator) - [SQL Injection Cheat Sheet](https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/) (by Ferruh Mavituna) - [Stackoverflow SQL Anti Patterns](http://stackoverflow.com/questions/346659/what-are-the-most-common-sql-anti-patterns) - [Azure Speed](http://www.azurespeed.com/) (by Blair Chen) - [DBFiddle - test your queries online](https://dbfiddle.uk/?rdbms=sqlserver_2019) - [SQLize Online - is a free online SQL environment for quickly running, experimenting with and sharing SQL code](https://sqlize.online/sql/mssql2019/) - [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 Doug Bernhardt) - [SqlServerSearcher - open source C# tool for searching SQL Server objects](https://github.com/CoderAllan/SqlServerSearcher) (by Allan Simonsen) - [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 Wilson Chen) - [How's My Plan? - .SQLPLAN analyzer](http://www.howsmyplan.com/) (by Daniel Janik) - [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) - [OrcaMDF - C# parser for MDF files](https://github.com/improvedk/OrcaMDF) (by Mark S. Rasmussen) - [Microsoft SQL Server Zabbix templates](https://share.zabbix.com/databases/microsoft-sql-server) - [Telegraf SQL Server Plugin](https://github.com/influxdata/telegraf/tree/master/plugins/inputs/sqlserver) (by influxdata) - [SDU Tools - pure TSQL functions Toolkit](https://sqldownunder.com/pages/sdu-tools) (by SQLDownUnder) - [Microsoft SQL Server Publications](https://www.microsoft.com/en-us/research/search/?q=sql+server&content-type=publications) - [SQL Server Feedback](https://feedback.azure.com/forums/908035-sql-server) - [Docs Overview SQL Tools](https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools) - [SQL ConstantCare®: clear, personal advice for your SQL Server](https://www.brentozar.com/sql-constantcare/) (by Brent Ozar) - [The SQL Server Execution Plan Reference](https://sqlserverfast.com/epr/) (by Hugo Kornelis) - [EC2 Instance Calculator](https://ec2instances.info/) - [AWS Calculator](https://calculator.aws/#/) - [Azure Instance Calculator](http://www.azureinstances.info/) - [PowerBI Premium Calculator](https://powerbi.microsoft.com/en-us/calculator/) - [Nuodb Oracle and SQL Server Calculator ](https://www.nuodb.com/product/license-cost-calculator) - [Github SQL Trending](https://github.com/trending/sql) - [SQLCallStackResolver - Utility to resolve SQL Server callstacks to their correct symbolic form](https://github.com/arvindshmicrosoft/SQLCallStackResolver) (by Arvind Shyamsundar) - [Azure updates](https://azure.microsoft.com/en-us/updates/?status=all) - [Guides for Microsoft SQL Server Express](https://expressdb.io/) (by John McCall) - [SQL Server Diagrams](http://www.e-squillace.com/tech/techdiagrams/#SQL_Server) - [SQL Cheat Sheet for MySQL](https://websitesetup.org/sql-cheat-sheet/) (by Luke Harrison) - [Azure Database Migration Guide](https://datamigration.microsoft.com/) (by Microsoft) - [Hermitage: Testing transaction isolation levels in relation databases](https://github.com/ept/hermitage) (by Martin Kleppmann) - [csv to INSERT online converter - translates your tab-delimited data into a T-SQL INSERT statement](https://table.strd.co/) (by Structured Concepts AB) - [SQL Server Diagrams](http://www.e-squillace.com/techdiagrams-sqlserver/) (by George Squillace) - [New Stars of Data 2020 Presentations](https://github.com/SQLGrillen/NSOD-1) (by SQLGrillen) - [Get Your ColumnScore](https://columnscore.com) (by ColumnScore) - [SQL Assessment API rules in .csv format](https://github.com/microsoft/sql-server-samples/blob/master/samples/manage/sql-assessment-api/DefaultRuleset.csv) (by Microsoft) - [SQL cheat sheet for PostgreSQL and Oracle](https://www.pcwdld.com/sql-cheat-sheet) (by Marc Wilson) - [Bllitz Excel UI](https://1pro.bi/blitz-excel-ui/) (by Alex) - [Industry-specific Data Models - cover Subject Areas and are used to create Enterprise Data Models](https://web.archive.org/web/20220330034214/http://databaseanswers.org/data_models/) - [Library of Database Schemas](https://dbschemalibrary.com/) - [SQLFacts - A powerful suite of FREE TSQL tools for SQL Server database professionals](https://www.sqlfacts.com) - [sql-log-shipping-service - provides a solution for automatically restoring SQL Server transaction log backups](https://github.com/trimble-oss/sql-log-shipping-service) (by Trimble Online Source Store) **[⬆ back to top](#table-of-contents)** ## 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) - [SQL Reserved Words](https://modern-sql.com/reserved-words-empirical-list) (by Markus Winand) BIML Bloggers - [Ben Weissman](https://www.solisyon.de/biml-blog-de/) - [Bill Fellows](http://billfellows.blogspot.com/search/label/Biml) - [Boris Hristov](http://borishristov.com/biml/) - [Brian Bønk](http://www.bonk.dk/biml/) - [Cathrine Wilhelmsen](http://www.cathrinewilhelmsen.net/biml/) - [Datachix: Julie Smith and Audrey Hammonds](http://datachix.com/) - [Davide Mauri](http://blog.davidemauri.it/) - [Erik Hudzik](http://www.anexinet.com/blog/author/ehudzik/) - [Hennie de Nooijer](http://bifuture.blogspot.com/search/label/BIML) - [John Welch](http://agilebi.com/jwelch/tag/biml/) - [Joost van Rossum](http://microsoft-ssis.blogspot.com/search/label/BIML) - [Marco Schreuder](http://blog.in2bi.eu/biml/) - [Meagan Longoria](https://datasavvy.wordpress.com/category/biml/) - [Nicholas Sorrell](http://sorrell.github.io/) - [Paul Te Braak](https://paultebraak.wordpress.com/tag/biml/) - [Peter Schott](http://schottsql.blogspot.com/search/label/BIML) - [Reeves Smith](https://reevessmith.wordpress.com/category/biml/) - [Roelant Vos](http://roelantvos.com/blog/?tag=biml) - [Rui Custódio](http://www.bi4all.pt/taxonomy/term/75) - [Tim Mitchell](https://www.timmitchell.net/post/tag/biml/) - [Warwick Rudd](http://www.sqlmastersconsulting.com.au/SQL-Server-Blog/PID/1675/mcat/1682/evl/0/nsw/t/EDNSearch/Biml) **[⬆ back to top](#table-of-contents)** ## PowerShell and SQL Server - [SQL Server & Windows Documentation Using Windows PowerShell](https://sqlpowerdoc.codeplex.com/) (by Kendal Vandyke) - [Stairway to SQL PowerShell](http://www.sqlservercentral.com/stairway/91327/) (by Ben Miller) - [SQL Server Health Check Script with Powershell](http://www.codeproject.com/Tips/848661/SQL-Server-Health-Check-Script-with-Powershell) (by Atul Kapoor) - [Universal SQL Server Installation Scripts](https://github.com/ktaranov/Universal-SQL-Installation-Scripts) (by Prakash Heda) (Github) - [Powershell SQL Server Performance Health Check](https://github.com/SpeedySQL/HealthCheck) (by Omid Afzalalghom) (Github) - [PSCI - Powershell Continuous Integration](https://github.com/ObjectivityBSS/PSCI) (by Objectivity Bespoke Software Specialists) (Github) - [SQLTranscriptase - SQL Server Documentation in Powershell](https://github.com/vijaybandi/SQLTranscriptase) (by Vijay Bandi) (Github) - [SQL Server PowerShell Extensions (SQLPSX)](https://github.com/MikeShepard/SQLPSX) (by Mike Shepard) (Github) - [PowerShell dbatools for SQL Server](https://github.com/ctrlbold/dbatools) (by Chrissy LeMaire) (Github) - [Create a Monitoring Server for SQL Server with PowerShell](https://www.simple-talk.com/sql/database-administration/create-a-monitoring-server-for-sql-server-with-powershell/) (by Laerte Junior) - [PowerShell SQLPass articles and video](http://powershell.sqlpass.org/default.aspx) - [PowerShell Blog NetNerds](https://blog.netnerds.net/) - [QS Config](http://www.sqlhammer.com/qs-config/) (by Derik Hammer) - [Idera 89 Free SQL Server PowerShell Scripts](https://www.idera.com/productssolutions/freetools/sqlpowershellscripts) - [Powershell SQL Server Library (PSSQLLib)](https://github.com/sanderstad/PSSQLLib) (by Sander Stad) (Github) - [Trello Board: Powershell and SQL Client Tools](https://trello.com/b/NEerYXUU/powershell-sql-client-tools-sqlps-ssms) - [PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server](https://github.com/NetSPI/PowerUpSQL) (Github) - [PowerShell DBA Reports](https://github.com/SQLDBAWithABeard/dbareports) (Github) - [PowerShell sqlCheck](https://bitbucket.org/yardbirdsax/sqlcheck/src) (Bitbucket) (by Josh Feierman) - [ReportingServicesTools - Reporting Services Powershell Tools](https://github.com/Microsoft/ReportingServicesTools) (by Microsoft) - [Powershell xSQLServer module contains DSC resources for deployment and configuration of SQL Server](https://github.com/PowerShell/xSQLServer) (Github by Microsoft) - [Export-DMVInformation - Export the resuts from Glenn Berry's DMV queries directly to Excel](https://github.com/sanderstad/Export-DMVInformation/) (Github) (by Sander Stad) - [Export-QueryToSQLTable - Export one or more query results run against one or more instances/databases to table](https://github.com/SQLJana/Export-QueryToSQLTable) (by Jana Sattainathan) (Github) - [PowerBIETL - a developer tool to quickly load a SQL Database using PowerBIDesktop queries](https://www.powershellgallery.com/packages/PowerBIETL/) (by DevScope) **[⬆ back to top](#table-of-contents)** ## TSQL Format Code - [SQLinform Online Web](https://sqlinform.azurewebsites.net) - [SQLinform Online Utility](https://www.sqlinform.com) - [Instant SQL Formatter](http://www.dpriver.com/pp/sqlformat.htm) - 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 **[⬆ back to top](#table-of-contents)** ## SQL Server Test Data Generation - 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://stackoverflow.com/q/591892) - https://mockaroo.com - https://anonymize.strd.co/ **[⬆ back to top](#table-of-contents)** ## Free SQL Server and R ebooks SQL Server: - [Awesome Red Gate ebooks](https://www.red-gate.com/hub/books/) - SQL Developers - [Defensive Database Programming](https://assets.red-gate.com/community/books/defensive-database-programming.pdf) (by Alex Kuznetsov) - [Inside the SQL Server Query Optimizer](https://assets.red-gate.com/community/books/inside-the-sql-server-query-optimizer.pdf) (by Benjamin Nevarez) - [SQL Server Execution Plans, 3rd Edition](https://www.red-gate.com/products/dba/sql-monitor/entrypage/execution-plans) (by Grant Fritchey) - [SQL Server Source Control Basics](https://www.red-gate.com/products/sql-development/sql-source-control/entrypage/sql-server-source-control-basics) (by Robert Sheldon, Rob Richardson & Tony Davis) - [The Art of XSD](https://assets.red-gate.com/community/books/the-art-of-xsd.pdf) (by Jacob Sebastian) - [The Redgate Guide to SQL Server Team-based Development](https://assets.red-gate.com/products/sql-development/sql-source-control/entrypage/assets/RG_Guide_to_SQL_Server_Dev.pdf) (by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić) - [XML Stairway](https://assets.red-gate.com/simple-talk/stairway-to-xml.pdf) - [119 SQL Code Smells](https://assets.red-gate.com/community/books/sql-code-smells.pdf) - [High Performance Techniques for SQL Server](https://www.sentryone.com/sql-server-books) (by SentryOne) - SQL DBA - [SQL Server Internals: In-Memory OLTP](https://www.red-gate.com/library/sql-server-internals-in-memory-oltp) (by Kalen Delaney) - [Fundamentals Of SQL Server 2012 Replication](https://assets.red-gate.com/community/books/fundamentals-of-sql-server-2012-replication.pdf) (by Sebastian Meine) - [Tribal SQL](https://www.red-gate.com/library/tribal-sql) - [SQL Server Transaction Log Management](https://www.red-gate.com/library/sql-server-transaction-log-management) (by Tony Davis and Gail Shaw) - [The Art of SQL Server FILESTREAM](https://assets.red-gate.com/community/books/art-of-ss-filestream.pdf) (by Jacob Sebastian and Sven Aelterman) - [SQL Server Concurrency: Locking, Blocking and Row Versioning](https://www.red-gate.com/library/sql-server-concurrency-locking-blocking-and-row-versioning) (by Kalen Delaney) - [SQL Server Backup and Restore](https://assets.red-gate.com/community/books/sql-server-backup-and-restore.pdf) (by Shawn McGehee) - [Troubleshooting SQL Server: A Guide for the Accidental DBA](https://www.red-gate.com/library/troubleshooting-sql-server-a-guide-for-accidental-dbas) (by Jonathan Kehayias and Ted Krueger ) - [SQL Server Hardware](http://assets.red-gate.com/community/books/sql-server-hardware-ebook.pdf) (by Glen Berry) - [Microsoft huge collection](https://blogs.msdn.microsoft.com/mssmallbiz/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server/) - [Microsoft large collection](https://blogs.msdn.microsoft.com/mssmallbiz/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more/) - [Largest FREE Microsoft eBook Giveaway!](https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/) - [OnlineVideoLectures ebooks](http://onlinevideolecture.com/ebooks/?subject=SQL-Server) - [Brent Ozar ebooks](https://www.brentozar.com/first-aid/) - [E-books SQL Server Directory](http://www.e-booksdirectory.com/listing.php?category=569) - [Syncfusion Techportal](http://syncfusion.com/resources/techportal) - [Modern Storage Strategies for SQL Server](http://www.actualtech.io/gg-modern-storage/) - [Migrating SQL Server Databases to Azure](https://blogs.msdn.microsoft.com/microsoft_press/2016/05/11/free-ebook-microsoft-azure-essentials-migrating-sql-server-databases-to-azure/) - [SentryOne Free eBooks](https://www.sentryone.com/resources#filter=.ebook) - [Microsoft Cloud Security for Enterprise Architects (PDF)](http://download.microsoft.com/download/6/d/f/6dfd7614-bbcf-4572-a871-e446b8cf5d79/msft_cloud_architecture_security.pdf) - [Brent Ozar SQL Server Setup Checklist eBook](http://u.brentozar.com/eBook_SQL_Server_Setup_Checklist.pdf) - [Introducing Microsoft SQL Server 2016](https://info.microsoft.com/Introducing-SQL-Server-2016-eBook.html) - [Giving away millions of free Microsoft Ebooks](https://blogs.msdn.microsoft.com/mssmallbiz/2016/07/10/free-thats-right-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepoint-2016-sha/) (by Eric Ligman) - [Free Phil Factor eBook: Confessions of an IT Manager](https://www.simple-talk.com/opinion/opinion-pieces/free-phil-factor-ebook-confessions-of-an-it-manager/) (by Phil Factor) - [Power BI from Rookie to Rock Star book](http://radacad.com/download-free-power-bi-book-pdf-format) (by Reza Rad) - [Online Book: Analytics with Power BI and R](http://radacad.com/online-book-analytics-with-power-bi-and-r) (by Leila Etaati) - [Architecture of a Database System](http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf) (by Joseph M. Hellerstein, Michael Stonebraker and James Hamilton) - [Query Optimization with SentryOne Plan Explorer](https://info.sentryone.com/ebook-query-optimization-plan-explorer) - [Troubleshooting SQL Server Performance](https://info.sentryone.com/ebook-troubleshooting-sql-server-performance) (by Kevin Kline) - [Azure Machine Learning Studio: An Unleashed Guide](http://radacad.com/book-azure-machine-learning-studio-an-unleashed-guide) (by Leila Etaati) - [Nutanix Best Practices for SQL Server 2016](https://www.nutanix.com/viewer.html?type=pdf&lpurl=virtualize-microsoft-sql-server-hyperconverged-infrastructure.php&fromCampaign=true) (by Nutanix, Inc.) - [Cloud Analytics with Microsoft Azure](https://azure.microsoft.com/en-us/resources/cloud-analytics-with-microsoft-azure/) (by Has Altaiar, Jack Lee, Michael Peña) - [Snowflake for SQL Server Users Part 1 – Core Concepts](https://sqldownunder.blob.core.windows.net/public/SnowflakeForSQLServerUsers_Part_1_CoreConcepts%20-%20for%20SDU%20Insiders.pdf) (by Dr Greg Low) - [The Fundamental Guide To Sql Query Optimization](https://www.quest.com/whitepapert/the-fundamental-guide-to-sql-query-optimization8143740/) (by Janis Griffin) - [An Expert Guide To Sql Server Performance Tuning](https://www.quest.com/whitepaper/an-expert-guide-to-sql-server-performance-tuning8143874/) (by Brent Ozar, Pinal Dave, Janis Griffin) - [Microsoft® SQL Server® Notes for Professionals book](https://books.goalkicker.com/MicrosoftSQLServerBook/) (by GoalKicker Books) R: - [BookDown - Write HTML, PDF, ePub, and Kindle books with R Markdown](https://bookdown.org) - [FreeComputerBooks R EBooks](http://freecomputerbooks.com/langRBooks.html) - [Effective Graphs with Microsoft R Open](http://blog.revolutionanalytics.com/2016/05/e-book-effective-graphs.html) - [Little Book of R for Time Series](http://a-little-book-of-r-for-time-series.readthedocs.io/en/latest/index.html) (by Avril Coghlan) - [Little Book of R for Biomedical Statistics](http://a-little-book-of-r-for-biomedical-statistics.readthedocs.io/en/latest/index.html) (by Avril Coghlan) - [Little Book of R for Multivariate Analysis](http://little-book-of-r-for-multivariate-analysis.readthedocs.io/en/latest/index.html) (by Avril Coghlan) - [Text Mining with R](http://tidytextmining.com/) (by Julia Silge and David Robinson) - [An Introduction to Statistical Learning with Applications in R](http://www-bcf.usc.edu/~gareth/ISL/) (by Gareth James, Daniela Witten, Trevor Hastie and Robert Tibshirani) **[⬆ back to top](#table-of-contents)** ## SQL Server Paid Books - [T-SQL Fundamentals](https://amzn.to/39CLxSN) 361 pages (by Itzik Ben-Gan) - [T-SQL Querying (Developer Reference)](https://amzn.to/3bGxVIa) 803 pages (by Itzik Ben-Gan) - [Great Post, Erik](https://amzn.to/3bMtgUY) 342 pages (by Erik Darling) - [Learn T-SQL Querying](https://amzn.to/39Ia7BX) 450 pages (by Pedro Lopes, Pam Lahoud) - [SQL Server 2017 Query Performance Tuning](https://amzn.to/2UW3s2E) 823 pages (by Grant Fritchey) - [Query Store for SQL Server 2019](https://amzn.to/2OZAzPp) 236 pages (by Tracy Boggiano, Grant Fritchey) - [SQL Server 2019 Revealed](https://amzn.to/2OZSiWS) 444 pages (by Bob Ward) - [Pro SQL Server Internals](https://www.amazon.co.uk/dp/1484219635/) 840 pages (by Dmitri Korotkevitch) - [Pro SQL Server Always On Availability Groups](https://www.amazon.co.uk/dp/B01M3U6WRM/) 332 pages (by Uttam Parui, Vivek Sanil) - [Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server](https://www.amazon.co.uk/dp/1484255801/) 260 pages (by Lisa Bohm) - [Hands-On SQL Server 2019 Analysis Services](https://www.packtpub.com/product/hands-on-sql-server-2019-analysis-services/9781800204768) (by Steve Hughes) **[⬆ back to top](#table-of-contents)** ## License [MIT](/LICENSE) 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.