SQL Server KIT

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

Headers:

• Repo Folders and Fles
• SQL Server Web Resources
• SQL Server Developer Edition Links
• SQL Server Express direct download links
• Microsoft Adventure Works Sample Databases download links
• Microsoft Transact-SQL Hints
• PowerShell and SQL Server
• TSQL Format Code
• Free SQL Server Ebooks
• License

Repo Folders and Files

• [SQL Server Data Types](/SQL Server Data Types.md)
• [SQL Server Edition](/SQL Server Edition.md)
• [SQL Server Name Convention and T-SQL Programming Style](/SQL Server Name Convention and T-SQL Programming Style.md)
• [SQL Server Licensing](/SQL Server Licensing.md)
• [SQL Server People](/SQL Server People.md 'Most Valuable SQL Server professionals')
• [SQL Server Trace Flag](/SQL Server Trace Flag.md 'Complete list - 303 Trace Flags') (Complete list - 303 trace flags)
• [SQL Server Version](/SQL Server Version.md 'List of all Microsoft SQL Sever versions') (Complete list - from SQL Server 1.0 to SQL Server 2016)
• Articles
• CLR procedures
  • SQL# free version - QUICKEST and EASIEST way to extending the power of T-SQL with C#
  • SplitterB_CLR
• Known Errors
• Solution
  • dbWarden a free SQL Server Monitoring Package (by Stevie Rounds and Michael Rounds)
  • Base line Collector script (by Robert Virag)
  • Ola Maintenance Solution (by Ola Hallengren)
  • SQLQueryStress (by Adam Machanic)
  • SysJobHistory (by David Wentzel)
• SSMS
  • SSMS addons (24 useful free and paid SSMS Addins)
  • SSMS Snippets
  • SSMS Shortcuts
• Scripts
  • Awesome SQL Server Diagnostic Information Queries (by Glenn Alan Berry)
    • [SQL Server 2016 Diagnostic Information Queries](/Scripts/SQL Server 2016 Diagnostic Information Queries.sql)
    • [SQL Server 2014 Diagnostic Information Queries](/Scripts/SQL Server 2014 Diagnostic Information Queries.sql)
    • [SQL Server 2012 Diagnostic Information Queries](/Scripts/SQL Server 2012 Diagnostic Information Queries.sql)
    • [SQL Server 2008 R2 Diagnostic Information Queries](/Scripts/SQL Server 2008 R2 Diagnostic Information Queries.sql)
    • [SQL Server 2008 Diagnostic Information Queries](/Scripts/SQL Server 2008 Diagnostic Information Queries.sql)
  • [Table count alternative](/Scripts/Table Count alternative.sql) (by Jes Schultz Borland)
  • [Foreign Key batch rename](/Scripts/Foreign Key batch rename.sql) (by Wes Henriksen)
  • [Count character matches](/Scripts/Count character matches.sql)
  • and many others...
• Stored Procedure
  • sp_DBPermissions (by Kenneth Fisher)
  • sp_SrvPermissions (by Kenneth Fisher)
  • sp_RestoreGene (by Paul Brewer)
  • usp_who5 (by Sean Smith)
  • usp_String_Search (by Sean Smith)
  • usp_BulkUpload
  • usp_TableUnpivot
  • usp_SSIS_ScriptEnvironment
  • and many others...
• User Defined Function
  • udf_parseJSON
  • udf_RenderXMLToString
  • udf_RTF2Text
  • udf_SplitStringByDelimiter
  • udf_Tally
  • and many others...
• Utilities (complete list of 124 SQL Server paid and free Utilities and Tools)

SQL Server Web Resources

• Blogs
  • SQL Central Blog Scripts
  • SQL Central Blog Articles
  • SQL Central Blog Stairways
  • MSSQLTips
  • BRENT OZAR scripts, videos and articles
  • Simple-talk Articles
  • SQLSentry Blog
  • Glenn Berry's SQL Server Performance
  • Kenneth Fisher SQLStudies Blog
  • Best SQL Server Perfomance Blog
  • Weblogs SQLTeam Blogs
  • SQLMag
  • SQLShack
  • SQLPass
  • Vertabelo Blog
  • Midnightdba Blog
  • Madeiradata Blog
  • SQL Server Performance Articles
  • SQL and more with KRUTI Blog
  • SQL Authority
  • TECHNET SQL Server Blog
  • SQL Server Database Engine Blog
  • SQL Server BI Blog
  • Andy Yun SQLBeck Blog
  • Curated SQL
  • Blog do Ezequiel
  • SQLHA Blog
  • SQLSecurity Blog
  • T-SQL.ru
• Security (great thanks to Troy Hunt)
  • SQL injection
    • sqlmap – The tool for mounting SQL injection attacks tests against a running site
    • Drupal 7 SQL injection flaw of 2014 – great example of how impactful it still is (patch it within 7 hours or you’re owned)
    • Ethical Hacking: SQL Injection – If you really want to go deep, here’s five and a half hours worth of Pluralsight content
  • Exploit databases and breach coverage
    • seclists.org – Heaps of exploits consolidated from various bug tracking lists
    • Exploit Database – Very comprehensive list of vulnerabilities
    • PunkSPIDER – Lots of vulnerabilities of all kinds all over the web (about 90M sites scanned with over 3M vulns at present)
    • Data Loss DB – Good list of breaches including stats on number of records compromised
    • Information is Beautiful: World’s Biggest Data Breaches – Fantastic visualisation of incidents that give a great indication of scale
• Free Videos
  • IDERA Resource Center
  • MSSQLTips SQL Server Webcasts and Videos
  • SQL Server Videos
  • TECHNET How do I Videos
  • Veeam Learn Microsoft SQL Server
  • MidnightDBA ITBookWorm Video
  • SQL Server Hangouts (by Boris Hristov, Cathrine Wilhelmsen)
• Free Database Podcasts
  • SQL Server Radio (by Guy Glantser and Matan Yungman)
  • SQL Data Partners (by Carlos L Chacon, César Oviedo and Adrian Miranda)
  • Away from the Keyboard (by Cecil Phillip and Richie Rump)
  • RunAs Radio (by Richard Campbell and Greg Hughes)
  • People Talking Tech (by Denny Cherry)
  • NET Rocks! (by Richard Campbell and Carl Franklin)
  • SQL Down Under Podcast (by Greg Low)
  • Free sql server video tutorials for beginners (by PRAGIM Technologies)
• Courses
  • MVA SQL Server Courses
  • Lynda Courses
  • Veeam Free Courses
  • SQLSkills Trainings
  • Brent Ozar Team Trainings
  • Pluralsight Courses
• SQL Server Backwards Compatibility
  • 2014 Backwards Compatibility
  • 2012 Backwards Compatibility
  • 2008 R2 Backwards Compatibility
  • 2008 Backwards Compatibility
  • 2005 Backwards Compatibility
• Other
  • SQL Server Management Studio installation download link
  • Best backup and index maintenance solution Ola Maintenance Solution
  • SQL# CLR functions (by Sql Quantum Leap)
  • SSIS Performance Benchmarks
  • Statistic Parser (by Richie Rump)
  • Using Excel to parse Set Statistics IO output (by Vicky Harp)
  • SQL Generator (by Richie Rump)
  • Columnstore Indexes Scripts Library (by Niko Neugebauer)
  • Stackoverflow SQL Server
  • DBA Stackexchange SQL Server
  • BIMLScript Learn resource
  • SQL Server Connection Strings
  • SQL Injection Cheat Sheet (by Ferruh Mavituna)
  • RSS Most Recent SQL Server KBs
  • Stackoverflow SQL Anti Patterns
  • SQL Server Latch Classes Library (by Paul S. Randal)
  • Azure Speed (by Blair Chen)

SQL Server Developer Edition Links

Now it is free!!! SQL Server Developer Edition Download page

For downloading your copy SQL Server Developer Edition you just need to join the Visual Studio Dev Essentials program

Important Note: SQL Server 2016 has a critical pre-requisite for updated Visual Studio VC++ 2013 Runtime Libraries. To install or check if this update is required on your system, please see KB316398.

Edition\Direct Download Link	Release Date	File name	Size, Mb	SHA1
SQL Server 2016 Developer (x64) - DVD (English)	2016-06-01	en_sql_server_2016_developer_x64_dvd_8777069.iso	2103	1B23982FE56DF3BFE0456BDF0702612EB72ABF75
SQL Server 2014 Developer Edition with Service Pack 1 (x64) - DVD (English)	2015-05-21	en_sql_server_2014_developer_edition_with_service_pack_1_x64_dvd_6668542.iso	3025	BFEE1F300C39638DA0D2CD594636698C6207C852
SQL Server 2014 Developer Edition with Service Pack 1 (x86) - DVD (English)	2015-05-21	en_sql_server_2014_developer_edition_with_service_pack_1_x86_dvd_6668541.iso	2462	ED3C70507A73BCC63D67CFA272CD849B9418A18E
SQL Server 2014 Developer Edition (x64) - DVD (English)	2014-04-01	en_sql_server_2014_developer_edition_x64_dvd_3940406.iso	2486	F73F430F55A71DA219FC7257A3A28E8FC142530F
SQL Server 2014 Developer Edition (x86) - DVD (English)	2014-04-01	en_sql_server_2014_developer_edition_x86_dvd_3938200.iso	2039	395B35FD80AA959B02B0C399DA1BB0C020DB6310

SQL Server Express direct download links

Original post written by Scott Hanselman: http://www.hanselman.com/blog/DownloadSQLServerExpress.aspx
Official Microsoft SQL Server Express page: https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

Download SQL Server 2014 Express

Download SQL Server 2014 Express

You likely just want SQL Server 2014 Express with Tools. This download includes SQL Management Studio:

• SQL Server 2014 Express x64
• SQL Server 2014 Express x86

Here's just SQL Server 2014 Management Studio:

• SQL Management Studio x64
• SQL Management Studio x86

SQL Server 2014 Express with Advanced Services:

• Advanced Services x64
• Advanced Services x86

Download SQL Server 2012 Express

You likely just want SQL Server 2012 Express with Tools. This download includes SQL Management Studio:

• SQL Server 2012 Express x64

Here's just SQL Server 2012 Management Studio:

• SQL Management Studio x64
• SQL Management Studio x86

Download SQL Server 2008 Express R2 SP2

You likely just want SQL Server 2008 Express with Tools. This download includes SQL Management Studio:

• SQL Server 2008 Express x64
• SQL Server 2008 Express x86

Here's just SQL Server 2008 Management Studio:

• SQL Management Studio x64
• SQL Management Studio x86

Download SQL Server 2005 Express

Microsoft Adventure Works Sample Databases download links

• AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3
• Microsoft SQL Server Community Projects & Samples
• Adventure Works 2014 Sample Databases
• Adventure Works 2012 Sample Databases
• Microsoft SQL Server 2008 R2 SR1 Sample Databases

Microsoft Transact-SQL Hints

• Transact-SQL Join Hints
• Transact-SQL Table Hints
• Transact-SQL Query Hints

PowerShell and SQL Server

• SQL Server & Windows Documentation Using Windows PowerShell (by Kendal Vandyke)
• TSQL Code Smells Finder (by Dave Ballantyne)
• Stairway to SQL PowerShell (by Ben Miller)
• SQL Server Health Check Script with Powershell (by Atul Kapoor)
• Universal SQL Server Installation Scripts (by Prakash Heda)
• Powershell SQL Server Performance Health Check (by Omid Afzalalghom)
• Performance Analysis of Logs (PAL) Tool (by svenhau and mikelag)
• PSCI - Powershell Continuous Integration (by Objectivity Bespoke Software Specialists)
• SQLTranscriptase - SQL Server Documentation in Powershell (by Vijay Bandi)
• SQL Server PowerShell Extensions (SQLPSX) (by Mike Shepard)
• PowerShell dbatools for SQL Server (by Chrissy LeMaire)
• Create a Monitoring Server for SQL Server with PowerShell (by Laerte Junior)
• PowerShell SQLPass articles and video
• PowerShell Blog NetNerds
• QS Config (by Derik Hammer)
• Idera 89 Free SQL Server PowerShell Scripts
• Performance Analysis of Logs (PAL) Tool (by Clint Huffman)
• Powershell SQL Server Library (PSSQLLib) (by Sander Stad)

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/sql_tools_refactor.aspx
• http://poorsql.com/
• http://www.architectshack.com/PoorMansTSqlFormatter.ashx
• http://www.ssmstoolspack.com/
• http://www.devart.com/dbforge/sql/sqlcomplete/
• http://www.sql-format.com/

SQL Server Test Data Generation

• https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/
• http://www.yandataellan.com/
• https://github.com/benkeen/generatedata
• https://sourceforge.net/projects/dbmonster/
• https://sourceforge.net/projects/spawner/
• http://databene.org/databene-benerator
• http://stackoverflow.com/questions/591892/tools-for-generating-mock-data

Free SQL Server and R ebooks

SQL Server:

• Avesome Red Gate ebooks
• Microsoft huge collection
• Microsoft large collection
• Microsoft MVA Free ebooks
• OnlineVideoLectures ebooks
• Brent Ozar ebooks
• E-books SQL Server Directory
• TOAD SQL Server ebooks
• Syncfusion Techportal
• Modern Storage Strategies for SQL Server
• Migrating SQL Server Databases to Azure

R:

• 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)

License

MIT

If some procedures or scripts are restricted due to ELUA (or we can not find original author), please email or add issue - we remove/update it immediately. Thanks for understanding and patience.