Need help with sqlserver-kit?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

ktaranov
1.2K Stars 414 Forks MIT License 2.5K Commits 1 Opened issues

Description

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

Services available

!
?

Need anything else?

Contributors list

# 21,065
Visual ...
sql-ser...
R
tsql
2151 commits
# 223,147
sql-ser...
R
C#
tsql
70 commits
# 127,669
sql-ser...
R
tsql
SQL
28 commits
# 323,037
sql-ser...
HTML
C#
tsql
22 commits
# 375,895
sql-ser...
HTML
C#
tsql
7 commits
# 298,098
sqlserv...
C#
sql-ser...
microso...
7 commits
# 458,761
sql-ser...
HTML
C#
tsql
5 commits
# 50,956
sql-ser...
C#
microso...
stress-...
4 commits
# 205,631
sql-ser...
R
tsql
SQL
4 commits
# 525,250
sql-ser...
HTML
C#
tsql
2 commits
# 551,125
sql-ser...
HTML
C#
tsql
2 commits
# 52,078
Go
jQuery
sql-ser...
captcha...
1 commit
# 566,322
sql-ser...
HTML
C#
tsql
1 commit
# 69,598
sql-ser...
C#
tsql
sqlserv...
1 commit
# 165,096
Shell
sql-ser...
R
smime
1 commit
# 125,552
sql-ser...
HTML
C#
tsql
1 commit
# 616,395
sql-ser...
HTML
C#
tsql
1 commit
# 3,156
sass-fr...
splash
Socket....
pipelin...
1 commit
# 616,396
sql-ser...
HTML
C#
tsql
1 commit
# 596,865
sql-ser...
HTML
C#
tsql
1 commit

SQL Server KIT

license badge stars badge forks badge issues badge contributors_badge

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

Table of Contents

Repo Folders and Files

⬆ back to top

SQL Server Web Resources

⬆ back to top

BIML Resources and Bloggers

BIML - Business Intelligence Markup Language

BIML Resources - BimlScript.com - Varigence - Biml Forum at Varigence - SQLServerCentral.com - Stairway to Biml - Biml User Group at LinkedIn - Building Blocks of Biml (Pluralsight course by Stacia Misner Varga)

BIML Bloggers - Ben Weissman - Bill Fellows - Boris Hristov - Brian Bønk - Cathrine Wilhelmsen - Datachix: Julie Smith and Audrey Hammonds - Davide Mauri - Erik Hudzik - Hennie de Nooijer - John Welch - Joost van Rossum - Marco Schreuder - Meagan Longoria - Nicholas Sorrell - Paul Te Braak - Peter Schott - Reeves Smith - Roelant Vos - Rui Custódio - Tim Mitchell - Warwick Rudd

⬆ back to top

PowerShell and SQL Server

⬆ back to top

TSQL Format Code

  • http://sqlinform.com/
  • http://www.dpriver.com/pp/sqlformat.htm
  • http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio
  • http://www.apexsql.com/sqltoolsrefactor.aspx
  • http://poorsql.com/
  • http://www.architectshack.com/PoorMansTSqlFormatter.ashx
  • http://www.ssmstoolspack.com/
  • http://www.devart.com/dbforge/sql/sqlcomplete/
  • http://www.sql-format.com/

⬆ back to top

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://mockaroo.com
  • https://anonymize.strd.co/

⬆ back to top

Free SQL Server and R ebooks

SQL Server: - Awesome Red Gate ebooks - SQL Developers - Defensive Database Programming (by Alex Kuznetsov) - Inside the SQL Server Query Optimizer (by Benjamin Nevarez) - SQL Server Execution Plans, 3rd Edition (by Grant Fritchey) - SQL Server Source Control Basics (by Robert Sheldon, Rob Richardson & Tony Davis) - The Art of XSD (by Jacob Sebastian) - The Redgate Guide to SQL Server Team-based Development (by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić) - XML Stairway - 119 SQL Code Smells - High Performance Techniques for SQL Server (by SentryOne) - SQL DBA - SQL Server Internals: In-Memory OLTP (by Kalen Delaney) - Fundamentals Of SQL Server 2012 Replication (by Sebastian Meine) - Tribal SQL - SQL Server Transaction Log Management (by Tony Davis and Gail Shaw) - The Art of SQL Server FILESTREAM (by Jacob Sebastian and Sven Aelterman) - SQL Server Concurrency: Locking, Blocking and Row Versioning (by Kalen Delaney) - SQL Server Backup and Restore (by Shawn McGehee) - Troubleshooting SQL Server: A Guide for the Accidental DBA (by Jonathan Kehayias and Ted Krueger ) - SQL Server Hardware (by Glen Berry) - Microsoft huge collection - Microsoft large collection - Largest FREE Microsoft eBook Giveaway! - OnlineVideoLectures ebooks - Brent Ozar ebooks - E-books SQL Server Directory - Syncfusion Techportal - Modern Storage Strategies for SQL Server - Migrating SQL Server Databases to Azure - SQL Sentry Free eBooks - Microsoft Cloud Security for Enterprise Architects (PDF) - Brent Ozar SQL Server Setup Checklist eBook - Introducing Microsoft SQL Server 2016 - Giving away millions of free Microsoft Ebooks (by Eric Ligman) - Free Phil Factor eBook: Confessions of an IT Manager (by Phil Factor) - Power BI from Rookie to Rock Star book (by Reza Rad) - Online Book: Analytics with Power BI and R (by Leila Etaati) - Architecture of a Database System (by Joseph M. Hellerstein, Michael Stonebraker and James Hamilton) - Query Optimization with SentryOne Plan Explorer - Troubleshooting SQL Server Performance (by Kevin Kline) - Azure Machine Learning Studio: An Unleashed Guide (by Leila Etaati) - Nutanix Best Practices for SQL Server 2016 (by Nutanix, Inc.) - Cloud Analytics with Microsoft Azure (by Has Altaiar, Jack Lee, Michael Peña) - Snowflake for SQL Server Users Part 1 – Core Concepts (by Dr Greg Low) - The Fundamental Guide To Sql Query Optimization (by Janis Griffin) - An Expert Guide To Sql Server Performance Tuning (by Brent Ozar, Pinal Dave, Janis Griffin) - Microsoft® SQL Server® Notes for Professionals book (by GoalKicker Books)

R: - BookDown - Write HTML, PDF, ePub, and Kindle books with R Markdown - FreeComputerBooks R EBooks - Effective Graphs with Microsoft R Open - Little Book of R for Time Series (by Avril Coghlan) - Little Book of R for Biomedical Statistics (by Avril Coghlan) - Little Book of R for Multivariate Analysis (by Avril Coghlan) - Text Mining with R (by Julia Silge and David Robinson) - An Introduction to Statistical Learning with Applications in R (by Gareth James, Daniela Witten, Trevor Hastie and Robert Tibshirani)

⬆ back to top

SQL Server Paid Books

⬆ back to top

License

MIT

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.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.