| Skip to content | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#start-of-content |
|
| https://patch-diff.githubusercontent.com/ |
|
Sign in
| https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Findiraniv%2Fsqlserver-kit |
| GitHub CopilotWrite better code with AI | https://github.com/features/copilot |
| GitHub SparkBuild and deploy intelligent apps | https://github.com/features/spark |
| GitHub ModelsManage and compare prompts | https://github.com/features/models |
| MCP RegistryNewIntegrate external tools | https://github.com/mcp |
| ActionsAutomate any workflow | https://github.com/features/actions |
| CodespacesInstant dev environments | https://github.com/features/codespaces |
| IssuesPlan and track work | https://github.com/features/issues |
| Code ReviewManage code changes | https://github.com/features/code-review |
| GitHub Advanced SecurityFind and fix vulnerabilities | https://github.com/security/advanced-security |
| Code securitySecure your code as you build | https://github.com/security/advanced-security/code-security |
| Secret protectionStop leaks before they start | https://github.com/security/advanced-security/secret-protection |
| Why GitHub | https://github.com/why-github |
| Documentation | https://docs.github.com |
| Blog | https://github.blog |
| Changelog | https://github.blog/changelog |
| Marketplace | https://github.com/marketplace |
| View all features | https://github.com/features |
| Enterprises | https://github.com/enterprise |
| Small and medium teams | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| App Modernization | https://github.com/solutions/use-case/app-modernization |
| DevSecOps | https://github.com/solutions/use-case/devsecops |
| DevOps | https://github.com/solutions/use-case/devops |
| CI/CD | https://github.com/solutions/use-case/ci-cd |
| View all use cases | https://github.com/solutions/use-case |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| View all industries | https://github.com/solutions/industry |
| View all solutions | https://github.com/solutions |
| AI | https://github.com/resources/articles?topic=ai |
| Software Development | https://github.com/resources/articles?topic=software-development |
| DevOps | https://github.com/resources/articles?topic=devops |
| Security | https://github.com/resources/articles?topic=security |
| View all topics | https://github.com/resources/articles |
| Customer stories | https://github.com/customer-stories |
| Events & webinars | https://github.com/resources/events |
| Ebooks & reports | https://github.com/resources/whitepapers |
| Business insights | https://github.com/solutions/executive-insights |
| GitHub Skills | https://skills.github.com |
| Documentation | https://docs.github.com |
| Customer support | https://support.github.com |
| Community forum | https://github.com/orgs/community/discussions |
| Trust center | https://github.com/trust-center |
| Partners | https://github.com/partners |
| GitHub SponsorsFund open source developers | https://github.com/sponsors |
| Security Lab | https://securitylab.github.com |
| Maintainer Community | https://maintainers.github.com |
| Accelerator | https://github.com/accelerator |
| Archive Program | https://archiveprogram.github.com |
| Topics | https://github.com/topics |
| Trending | https://github.com/trending |
| Collections | https://github.com/collections |
| Enterprise platformAI-powered developer platform | https://github.com/enterprise |
| GitHub Advanced SecurityEnterprise-grade security features | https://github.com/security/advanced-security |
| Copilot for BusinessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/premium-support |
| Pricing | https://github.com/pricing |
| Search syntax tips | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
| documentation | https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax |
|
Sign in
| https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Findiraniv%2Fsqlserver-kit |
|
Sign up
| https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=indiraniv%2Fsqlserver-kit |
| Reload | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
| Reload | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
| Reload | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
|
indiraniv
| https://patch-diff.githubusercontent.com/indiraniv |
| sqlserver-kit | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
| ktaranov/sqlserver-kit | https://patch-diff.githubusercontent.com/ktaranov/sqlserver-kit |
|
Notifications
| https://patch-diff.githubusercontent.com/login?return_to=%2Findiraniv%2Fsqlserver-kit |
|
Fork
0
| https://patch-diff.githubusercontent.com/login?return_to=%2Findiraniv%2Fsqlserver-kit |
|
Star
0
| https://patch-diff.githubusercontent.com/login?return_to=%2Findiraniv%2Fsqlserver-kit |
| sqlserver-kit.org | http://sqlserver-kit.org |
|
MIT license
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/LICENSE.md |
|
0
stars
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/stargazers |
|
720
forks
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/forks |
|
Branches
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/branches |
|
Tags
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tags |
|
Activity
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/activity |
|
Star
| https://patch-diff.githubusercontent.com/login?return_to=%2Findiraniv%2Fsqlserver-kit |
|
Notifications
| https://patch-diff.githubusercontent.com/login?return_to=%2Findiraniv%2Fsqlserver-kit |
|
Code
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
|
Pull requests
0
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/pulls |
|
Actions
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/actions |
|
Projects
0
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/projects |
|
Wiki
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/wiki |
|
Security
0
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/security |
|
Insights
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/pulse |
|
Code
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
|
Pull requests
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/pulls |
|
Actions
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/actions |
|
Projects
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/projects |
|
Wiki
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/wiki |
|
Security
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/security |
|
Insights
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/pulse |
| Branches | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/branches |
| Tags | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tags |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/branches |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tags |
| 1,071 Commits | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/commits/master/ |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/commits/master/ |
| .github | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/.github |
| .github | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/.github |
| Articles | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Articles |
| Articles | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Articles |
| CLR | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/CLR |
| CLR | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/CLR |
| Errors | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Errors |
| Errors | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Errors |
| Extended_Events | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Extended_Events |
| Extended_Events | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Extended_Events |
| PowerShell | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/PowerShell |
| PowerShell | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/PowerShell |
| SSMS | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/SSMS |
| SSMS | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/SSMS |
| Scripts | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Scripts |
| Scripts | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Scripts |
| Solution | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Solution |
| Solution | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Solution |
| Stored_Procedure | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Stored_Procedure |
| Stored_Procedure | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Stored_Procedure |
| User_Defined_Function | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/User_Defined_Function |
| User_Defined_Function | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/User_Defined_Function |
| Utilities | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Utilities |
| Utilities | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/tree/master/Utilities |
| .gitattributes | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/.gitattributes |
| .gitattributes | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/.gitattributes |
| .gitignore | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/.gitignore |
| .gitignore | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/.gitignore |
| CONTRIBUTING.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/CONTRIBUTING.md |
| CONTRIBUTING.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/CONTRIBUTING.md |
| LICENSE.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/LICENSE.md |
| LICENSE.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/LICENSE.md |
| README.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/README.md |
| README.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/README.md |
| SQL Server DBCC List.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20DBCC%20List.md |
| SQL Server DBCC List.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20DBCC%20List.md |
| SQL Server Data Types.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Data%20Types.md |
| SQL Server Data Types.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Data%20Types.md |
| SQL Server Drivers.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Drivers.md |
| SQL Server Drivers.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Drivers.md |
| SQL Server Edition.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Edition.md |
| SQL Server Edition.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Edition.md |
| SQL Server Licensing.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Licensing.md |
| SQL Server Licensing.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Licensing.md |
| SQL Server Name Convention and T-SQL Programming Style.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md |
| SQL Server Name Convention and T-SQL Programming Style.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md |
| SQL Server People.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20People.md |
| SQL Server People.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20People.md |
| SQL Server Trace Flag.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md |
| SQL Server Trace Flag.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md |
| SQL Server Version.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Version.md |
| SQL Server Version.md | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Version.md |
| README | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
| Contributing | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
| MIT license | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-kit |
| https://github.com/ktaranov/sqlserver-kit/blob/master/LICENSE.md |
| https://github.com/ktaranov/sqlserver-kit/stargazers |
| https://github.com/ktaranov/sqlserver-kit/network |
| https://github.com/ktaranov/sqlserver-kit/issues |
| http://isitmaintained.com/project/ktaranov/sqlserver-kit |
| https://gitter.im/sqlserver-kit/Lobby?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge |
| https://github.com/ktaranov/sqlserver-kit/graphs/contributors |
| Repo Folders and Files | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#repo-folders-and-files |
| SQL Server Web Resources | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-web-resources |
| BIML Resources and Bloggers | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#biml-resources-and-bloggers |
| SQL Server Sample Databases and Datasets | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-sample-databases-and-datasets |
| Microsoft Transact-SQL Hints | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#microsoft-transact-sql-hints |
| PowerShell and SQL Server | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#powershell-and-sql-server |
| TSQL Format Code | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#tsql-format-code |
| SQL Server Test Data Generation | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-test-data-generation |
| Free SQL Server, R ebooks | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#free-ebooks |
| License | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#license |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#repo-folders-and-files |
| SQL Server Data Types | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Data%20Types.md |
| SQL Server Edition | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Edition.md |
| SQL Server Name Convention and T-SQL Programming Style | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Name%20Convention%20and%20T-SQL%20Programming%20Style.md |
| SQL Server Licensing | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Licensing.md |
| SQL Server People | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20People.md |
| SQL Server Trace Flag | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md |
| SQL Server Version | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SQL%20Server%20Version.md |
| Articles | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Articles |
| CLR procedures | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/CLR |
| SplitterB_CLR | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/CLR/SplitterB_CLR.sql |
| Extended Events | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Extended_Events |
| Known Errors | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Errors |
| Solution | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Solution |
| dbWarden | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Solution/dbWarden |
| Base line Collector script | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Solution/BaselineCollector |
| Ola Maintenance Solution | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Solution/Ola_Maintenance_Solution |
| SQLQueryStress | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Solution/SQLQueryStress |
| SysJobHistory | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Solution/SysJobHistory |
| SSMS | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SSMS |
| SSMS addins | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SSMS/SSMS_Addins.md |
| SSMS Snippets | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SSMS/SSMS_Snippets |
| SSMS Shortcuts | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SSMS/SSMS_Shortcuts.md |
| SSMS Tips | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/SSMS/SSMS_Tips.md |
| Scripts | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts |
| SQL Server 2017 Diagnostic Information Queries | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/SQL%20Server%202017%20Diagnostic%20Information%20Queries.sql |
| SQL Server 2016 Diagnostic Information Queries | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/SQL%20Server%202016%20Diagnostic%20Information%20Queries.sql |
| SQL Server 2014 Diagnostic Information Queries | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/SQL%20Server%202014%20Diagnostic%20Information%20Queries.sql |
| SQL Server 2012 Diagnostic Information Queries | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/SQL%20Server%202012%20Diagnostic%20Information%20Queries.sql |
| SQL Server 2008 R2 Diagnostic Information Queries | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/SQL%20Server%202008%20R2%20Diagnostic%20Information%20Queries.sql |
| SQL Server 2008 Diagnostic Information Queries | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/SQL%20Server%202008%20Diagnostic%20Information%20Queries.sql |
| Table count alternative | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/Table%20Count%20alternative.sql |
| Foreign Key batch rename | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/Foreign%20Key%20batch%20rename.sql |
| Count character matches | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql |
| Stored Procedure | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure |
| sp_DBPermissions | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/sp_DBPermissions.sql |
| sp_SrvPermissions | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/sp_SrvPermissions.sql |
| sp_RestoreGene | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/sp_RestoreGene.sql |
| usp_who5 | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/usp_who5.sql |
| usp_String_Search | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/usp_String_Search.sql |
| usp_BulkUpload | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql |
| usp_TableUnpivot | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Stored_Procedure/usp_TableUnpivot.sql |
| User Defined Function | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/User_Defined_Function |
| udf_parseJSON | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/User_Defined_Function/udf_parseJSON.sql |
| udf_RenderXMLToString | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/User_Defined_Function/udf_RenderXMLToString.sql |
| udf_RTF2Text | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/User_Defined_Function/udf_RTF2Text.sql |
| udf_SplitStringByDelimiter | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/User_Defined_Function/udf_SplitStringByDelimiter.sql |
| udf_Tally | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/User_Defined_Function/udf_Tally.sql |
| Utilities | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/Utilities |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header01 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-web-resources |
| 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/ |
| Simple-talk Articles | https://www.simple-talk.com/ |
| SQLSentry Blog | http://blogs.sqlsentry.com |
| 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/ |
| 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 |
| 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/ |
| Troy Hunt | https://www.troyhunt.com/troys-ultimate-list-of-security-links/ |
| sqlmap | http://sqlmap.org/ |
| Drupal 7 SQL injection flaw of 2014 | https://www.drupal.org/PSA-2014-003 |
| Ethical Hacking: SQL Injection | http://www.pluralsight.com/courses/ethical-hacking-sql-injection |
| seclists.org | http://seclists.org |
| Exploit Database | https://www.exploit-db.com/ |
| PunkSPIDER | https://www.punkspider.org/ |
| Data Loss DB | http://datalossdb.org/ |
| 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/ |
| SQL Server Database Engine Permission Posters | http://social.technet.microsoft.com/wiki/contents/articles/11842.sql-server-database-engine-permission-posters.aspx |
| Youtube Brent Ozar | 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 |
| Youtube russianVC | https://www.youtube.com/channel/UC0UA5gKnOq9TM1RNvMIArwg |
| 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/ |
| 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 |
| MVP: Data Platform | https://channel9.msdn.com/Blogs/MVP-Data-Platform |
| SQL Server Radio | http://www.sqlserverradio.com/ |
| SQL Data Partners | http://sqldatapartners.com/podcast/ |
| Away from the Keyboard | http://awayfromthekeyboard.com/ |
| RunAs Radio | http://runasradio.com/ |
| People Talking Tech | http://peopletalkingtech.com/ |
| NET Rocks! | http://www.dotnetrocks.com/ |
| SQL Down Under Podcast | http://www.sqldownunder.com/Podcasts |
| Free sql server video tutorials for beginners | http://csharp-video-tutorials.blogspot.ru/p/free-sql-server-video-tutorials-for.html |
| Midnight DBA Podcast | http://midnightdba.itbookworm.com/Show |
| Dear SQL DBA | https://www.littlekendra.com/dearsqldba/ |
| GroupBy.org - Group By is a free online event for the community, by the community | https://groupby.org/ |
| DevopsCafe | http://devopscafe.org/ |
| SQLDataPartners Podcast | http://sqldatapartners.com/podcast/ |
| SQLPlayer | http://sqlplayer.net/ |
| Data Driven | http://datadriven.tv/ |
| Learn SQL Server by solving problems | https://sqlworkbooks.com/courses-overview/ |
| 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 |
| 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/ |
| Madeira Data Solutions Academy | http://madeira-data-solutions.teachable.com/ |
| SQLpassion Online Academy | http://www.sqlpassion.at/online-training/index.html |
| VNext Backwards Compatibility | https://msdn.microsoft.com/en-us/library/cc280407(v=sql.140).aspx |
| 2016 Backwards Compatibility | https://msdn.microsoft.com/en-us/library/cc280407(v=sql.130).aspx |
| 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 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 |
| 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 |
| SQLServerCentral Forum | http://www.sqlservercentral.com/Forums/ |
| Slack #sqlhelp | https://sqlcommunity.slack.com/messages/sqlhelp/ |
| Slack #firstresponderkit | https://sqlcommunity.slack.com/messages/firstresponderkit/ |
| Twitter #sqlhelp | https://twitter.com/hashtag/sqlhelp |
| SQL.ru SQL Server Forum | http://www.sql.ru/forum/microsoft-sql-server |
| VK.com #sqlcom | https://vk.com/sqlcom |
| SQL Server User Group Meetings | https://www.mssqltips.com/sql-server-user-groups/ |
| Russian SQL Server User Group | https://www.facebook.com/groups/144858492215825/ |
| Brent Ozar SQL Server First Responder Kit | https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit |
| SQL Server Maintenance Solution | https://github.com/olahallengren/sql-server-maintenance-solution |
| Statistic Parser | https://github.com/Jorriss/StatisticsParser |
| SQL Generator | https://github.com/Jorriss/sqlgenerator |
| Columnstore Indexes Scripts Library | https://github.com/NikoNeugebauer/CISL |
| MOSL - Memory Optimized Script Library | https://github.com/NikoNeugebauer/MOSL |
| mssql-docker - Official Microsoft repository for SQL Server in Docker resources | https://github.com/ktaranov/mssql-docker |
| SQLCover - TSQL code coverage tool for SQL Server 2008+ | https://github.com/GoEddie/SQLCover |
| tSQLt testing framework for Microsoft SQL Server | https://github.com/tSQLt-org/tSQLt |
| T-SQL SimMetrics string matching algorithms | https://github.com/GuerrillaAnalytics/similarity |
| Azure Blob Storage Backup | https://github.com/bornsql/azureblobstoragesync |
| StackExchange.DataExplorer - free tool for executing SQL queries against Stack Exchange databases | https://github.com/StackExchange/StackExchange.DataExplorer |
| Machine Learning Templates with SQL Server 2016 R Services | https://github.com/Microsoft/SQL-Server-R-Services-Samples |
| Campaign Optimization - Predicting How and When to Contact Leads Implemented on SQL Server 2016 R Services | https://github.com/Microsoft/r-server-campaign-optimization |
| SQL Server Performance Dashboards - contains all Microsoft based reports, custom built reports, modified reports and the TSQL setup | http://sqldashboards.codeplex.com/ |
| tigertoolbox - Repository for Tiger team for "as-is" solutions and tools/scripts that the team publishes for SQL Server | https://github.com/Microsoft/tigertoolbox |
| SQL Server FineBuild - makes it easy for anyone to produce a best-practice installation and configuration of SQL Server | https://sqlserverfinebuild.codeplex.com/ |
| 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 |
| sql-xplat-cli - Repository for the new SQL cross-platform command line tools | https://github.com/Microsoft/sql-xplat-cli |
| dbfs - A tool for mounting MS SQL Server DMVs using FUSE | https://github.com/Microsoft/dbfs |
| Opserver - Stack Exchange's Monitoring System | https://github.com/opserver/Opserver |
| Bosum - Time Series Alerting Framework | https://github.com/bosun-monitor/bosun |
| BismNormalizer - is a free and open-source tool to manage Microsoft Analysis Services tabular models | https://github.com/christianwade/BismNormalizer |
| DbSharp - is a DAL Generator | https://www.codeproject.com/Articles/776811/DbSharp-DAL-generator-tool |
| YourSqlDba - Database maintenance solution as a single SQL script | https://github.com/pelsql/YourSqlDba |
| sp_whoisactive | http://whoisactive.com/ |
| SQL# CLR functions | http://www.sqlsharp.com/ |
| SQL Server Latch Classes Library | https://www.sqlskills.com/help/latches/ |
| SQL Server Wait Types Library | https://www.sqlskills.com/help/waits/ |
| Waitopedia - is a comprehensive resource of information about SQL Server waits | https://www.spotlightessentials.com/waitopedia |
| SQL Server wait types | https://www.sqlshack.com/sql-server-wait-types/ |
| 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/ |
| Stackoverflow SQL Server | http://stackoverflow.com/questions/tagged/sql-server |
| DBA Stackexchange SQL Server | http://dba.stackexchange.com/questions/tagged/sql-server |
| 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/ |
| 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/ |
| 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/ |
| 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 |
| SDUTools - Free Tools for DBAs and Developers on pure TSQL | http://sqldownunder.azurewebsites.net/Resources/SDUTools |
| SqlServerSearcher - open source C# tool for searching SQL Server objects | https://github.com/CoderAllan/SqlServerSearcher |
| 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 |
| How's My Plan? - .SQLPLAN analyzer | http://www.howsmyplan.com/ |
| Minion Backup - The new standard in SQL Server backups | http://minionware.net/backup/ |
| Minion CheckDB - completes the MinionWare maintenance and backups suite | http://minionware.net/checkdb/ |
| Minion Reindex - Index maintenance that is fully automated | http://minionware.net/reindex/ |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header02 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#biml-resources-and-bloggers |
| Business Intelligence Markup Language | https://varigence.com/biml |
| 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 |
| 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/ |
| David Stein | http://www.made2mentor.com/category/biml/ |
| Davide Mauri | http://sqlblog.com/blogs/davide_mauri/archive/tags/BIML/default.aspx |
| 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 |
| Koen Verbeeck | http://blogs.lessthandot.com/index.php/tag/biml/ |
| Marco Schreuder | http://blog.in2bi.eu/biml/ |
| Martin Andersson | http://www.frysdisken.net/ |
| 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 |
| Samuel Vanga | http://samuelvanga.com/category/biml/ |
| Stephen Leach | http://www.imgroup.com/author/stephen-leach/ |
| 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 | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header020 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-sample-databases-and-datasets |
| http://bit.ly/ya-ssk | 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 |
| Adventure Works 2012 Sample Databases | http://msftdbprodsamples.codeplex.com/releases/view/55330 |
| Microsoft SQL Server 2008 R2 SR1 Sample Databases | https://sqlserversamples.codeplex.com/releases/view/72278 |
| Thinking Big (Adventure) | http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx |
| WideWorldImporters Sample Database | https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers |
| WideWorldImporters Sample Database Download Files | https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 |
| IoT Smart Grid sample - demonstrates how SQL Server 2016 memory optimized databases could be used to ingest a very high input data rate | https://github.com/Microsoft/sql-server-samples/releases/tag/iot-smart-grid-v1.0 |
| In-Memory OLTP (WWI Sales Orders) | https://github.com/Microsoft/sql-server-samples/releases/tag/wwi-sales-orders-v0.5 |
| Bigger Fact Table for Wide World Importers | http://www.sqlservercentral.com/blogs/koen-verbeeck/2016/08/12/bigger-fact-table-for-wide-world-importers/ |
| Contoso Retail Data Warehose | https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/contoso-data-warehouse |
| How to Download the Stack Overflow Database via BitTorrent 2016-03 | https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/ |
| Updating the Stack Overflow Demo Database version 2016-12-15 | https://www.brentozar.com/archive/2017/01/updating-stack-overflow-demo-database/ |
| Amazon product data | http://jmcauley.ucsd.edu/data/amazon/ |
| Git repo for SQL Server Reporting Services samples and community projects | https://github.com/Microsoft/Reporting-Services |
| SQLSkills sample databases | https://www.sqlskills.com/sql-server-resources/sql-server-demos/ |
| SQLIndexWorkbook Sample Database | http://www.littlekendra.com/downloads/get-the-sqlindexworkbook-database/ |
| Data.gov | https://www.data.gov/ |
| Itzik Ben-Gan Sample Databases | http://tsql.solidq.com/books/source_code/ |
| Orders: Open Source Sample Database | https://www.brentozar.com/orders-open-source-sample-database/ |
| BabbyNames Database | https://github.com/LitKnd/BabbyNames |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header03 |
| Microsoft Transact-SQL Hints | https://msdn.microsoft.com/en-us/library/ms187713.aspx |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#microsoft-transact-sql-hints |
| Transact-SQL Join Hints | https://msdn.microsoft.com/en-us/library/ms173815.aspx |
| Transact-SQL Table Hints | https://msdn.microsoft.com/en-us/library/ms187373.aspx |
| Transact-SQL Query Hints | https://msdn.microsoft.com/en-us/library/ms181714.aspx |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header04 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#powershell-and-sql-server |
| SQL Server & Windows Documentation Using Windows PowerShell | https://sqlpowerdoc.codeplex.com/ |
| TSQL Code Smells Finder | https://tsqlsmells.codeplex.com/ |
| Stairway to SQL PowerShell | http://www.sqlservercentral.com/stairway/91327/ |
| SQL Server Health Check Script with Powershell | http://www.codeproject.com/Tips/848661/SQL-Server-Health-Check-Script-with-Powershell |
| Universal SQL Server Installation Scripts | https://github.com/ktaranov/Universal-SQL-Installation-Scripts |
| Powershell SQL Server Performance Health Check | https://github.com/SpeedySQL/HealthCheck |
| PSCI - Powershell Continuous Integration | https://github.com/ObjectivityBSS/PSCI |
| SQLTranscriptase - SQL Server Documentation in Powershell | https://github.com/vijaybandi/SQLTranscriptase |
| SQL Server PowerShell Extensions (SQLPSX) | https://github.com/MikeShepard/SQLPSX |
| PowerShell dbatools for SQL Server | https://github.com/ctrlbold/dbatools |
| 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/ |
| 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/ |
| Idera 89 Free SQL Server PowerShell Scripts | https://www.idera.com/productssolutions/freetools/sqlpowershellscripts |
| Performance Analysis of Logs (PAL) Tool | https://pal.codeplex.com/ |
| Powershell SQL Server Library (PSSQLLib) | https://github.com/sanderstad/PSSQLLib |
| 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 |
| PowerShell DBA Reports | https://github.com/SQLDBAWithABeard/dbareports |
| PowerShell sqlCheck | https://bitbucket.org/yardbirdsax/sqlcheck/src |
| PowerShell Enterprise Policy Management Framework | https://epmframework.codeplex.com/ |
| ReportingServicesTools - Reporting Services Powershell Tools | https://github.com/Microsoft/ReportingServicesTools |
| Powershell xSQLServer module contains DSC resources for deployment and configuration of SQL Server | https://github.com/PowerShell/xSQLServer |
| Export-DMVInformation - Export the resuts from Glenn Berry's DMV queries directly to Excel | https://github.com/sanderstad/Export-DMVInformation/ |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header05 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#tsql-format-code |
| http://sqlinform.com/ | http://sqlinform.com/ |
| http://www.dpriver.com/pp/sqlformat.htm | http://www.dpriver.com/pp/sqlformat.htm |
| http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio | http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio |
| http://www.apexsql.com/sql_tools_refactor.aspx | http://www.apexsql.com/sql_tools_refactor.aspx |
| http://poorsql.com/ | http://poorsql.com/ |
| http://www.architectshack.com/PoorMansTSqlFormatter.ashx | http://www.architectshack.com/PoorMansTSqlFormatter.ashx |
| http://www.ssmstoolspack.com/ | http://www.ssmstoolspack.com/ |
| http://www.devart.com/dbforge/sql/sqlcomplete/ | http://www.devart.com/dbforge/sql/sqlcomplete/ |
| http://www.sql-format.com/ | http://www.sql-format.com/ |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header06 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#sql-server-test-data-generation |
| https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/ | https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/ |
| http://www.yandataellan.com/ | http://www.yandataellan.com/ |
| https://github.com/benkeen/generatedata | https://github.com/benkeen/generatedata |
| https://sourceforge.net/projects/dbmonster/ | https://sourceforge.net/projects/dbmonster/ |
| https://sourceforge.net/projects/spawner/ | https://sourceforge.net/projects/spawner/ |
| http://databene.org/databene-benerator | http://databene.org/databene-benerator |
| http://stackoverflow.com/questions/591892/tools-for-generating-mock-data | http://stackoverflow.com/questions/591892/tools-for-generating-mock-data |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header07 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#free-sql-server-r-ebooks |
| Awesome Red Gate ebooks | http://www.red-gate.com/community/books/ |
| Defensive Database Programming | http://assets.red-gate.com/community/books/defensive-database-programming.pdf |
| Inside the SQL Server Query Optimizer | http://assets.red-gate.com/community/books/inside-the-sql-server-query-optimizer.pdf |
| SQL Server Execution Plans, 2nd Edition | http://assets.red-gate.com/community/books/sql-server-execution-plans-book.zip |
| SQL Server Source Control Basics | http://www.red-gate.com/products/sql-development/sql-source-control/entrypage/sql-server-source-control-basics |
| The Art of XSD | http://assets.red-gate.com/community/books/the-art-of-xsd.pdf |
| The Redgate Guide to SQL Server Team-based Development | http://assets.red-gate.com/products/sql-development/sql-source-control/entrypage/assets/RG_Guide_to_SQL_Server_Dev.pdf |
| XML Stairway | https://assets.red-gate.com/simple-talk/stairway-to-xml.pdf |
| 119 SQL Code Smells | http://assets.red-gate.com/community/books/sql-code-smells.pdf |
| SQL Server Internals: In-Memory OLTP | http://www.red-gate.com/library/sql-server-internals-in-memory-oltp |
| Fundamentals Of SQL Server 2012 Replication | http://assets.red-gate.com/community/books/fundamentals-of-sql-server-2012-replication.pdf |
| Tribal SQL | http://www.red-gate.com/library/tribal-sql |
| SQL Server Transaction Log Management | http://assets.red-gate.com/offerings/transaction-log-management.pdf |
| The Art of SQL Server FILESTREAM | http://assets.red-gate.com/community/books/art-of-ss-filestream.pdf |
| SQL Server Concurrency: Locking, Blocking and Row Versioning | http://www.red-gate.com/library/sql-server-concurrency-locking-blocking-and-row-versioning |
| SQL Server Backup and Restore | http://assets.red-gate.com/community/books/sql-server-backup-and-restore.pdf |
| Troubleshooting SQL Server: A Guide for the Accidental DBA | http://assets.red-gate.com/products/dba/assets/Accidental_DBA_EBook.zip |
| SQL Server Hardware | http://assets.red-gate.com/community/books/sql-server-hardware-ebook.pdf |
| 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/ |
| Microsoft MVA Free ebooks | https://mva.microsoft.com/ebooks |
| OnlineVideoLectures ebooks | http://onlinevideolecture.com/ebooks/?subject=SQL-Server |
| Brent Ozar ebooks | http://www.brentozar.com/first-aid/free-database-books-pdfs-download/ |
| E-books SQL Server Directory | http://www.e-booksdirectory.com/listing.php?category=569 |
| TOAD SQL Server ebooks | https://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/06/21/huge-collection-of-free-microsoft-sql-server-ebooks |
| 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/ |
| SQL Sentry Free eBooks | https://www.sqlsentry.com/sql-server-books |
| 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/ |
| 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/ |
| Power BI from Rookie to Rock Star book | http://radacad.com/download-free-power-bi-book-pdf-format |
| Online Book: Analytics with Power BI and R | http://radacad.com/online-book-analytics-with-power-bi-and-r |
| Architecture of a Database System | http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf |
| 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 |
| Little Book of R for Biomedical Statistics | http://a-little-book-of-r-for-biomedical-statistics.readthedocs.io/en/latest/index.html |
| Little Book of R for Multivariate Analysis | http://little-book-of-r-for-multivariate-analysis.readthedocs.io/en/latest/index.html |
| Text Mining with R | http://tidytextmining.com/ |
| An Introduction to Statistical Learning with Applications in R | http://www-bcf.usc.edu/~gareth/ISL/ |
| Back to top | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#header08 |
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#license |
| MIT | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/blob/master/LICENSE.md |
| sqlserver-kit.org | http://sqlserver-kit.org |
|
Readme
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#readme-ov-file |
|
MIT license
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#MIT-1-ov-file |
|
Contributing
| https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit#contributing-ov-file |
| Please reload this page | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit |
|
Activity | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/activity |
|
0
stars | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/stargazers |
|
0
watching | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/watchers |
|
0
forks | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/forks |
|
Report repository
| https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Findiraniv%2Fsqlserver-kit&report=indiraniv+%28user%29 |
| Releases | https://patch-diff.githubusercontent.com/indiraniv/sqlserver-kit/releases |
| Packages
0 | https://patch-diff.githubusercontent.com/users/indiraniv/packages?repo_name=sqlserver-kit |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |