SQL Server KIT

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

Headers:

• Repo folders and files
• SQL Server Web Resources
• 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

Repo folders and files

• [SQL Server Name Convention](/SQL Server Name Convention.md)
• [SQL Server Edition](/SQL Server Edition.md)
• [SQL Server Trace Flag](/SQL Server Trace Flag.md 'Complete list from many resources - 162 Trace Flags') (Complete list - 162 trace flags)
• [SQL Server Version](/SQL Server Version.md 'List of all version Microsoft SQL Sever') (Complete list - from SQL Server 1.0 to SQL Server 2016)
• Articles
• Base line Collector script (by Robert Virag)
• CLR procedures
  • SQL# free version - QUICKEST and EASIEST way to extending the power of T-SQL with C#
  • SplitterB_CLR
• dbWarden a free SQL Server Monitoring Package (by Stevie Rounds and Michael Rounds)
• Known Errors
• Ola Maintenance Solution (by Ola Hallengren)
• SSMS addons
  • SSMSBoost add-in
  • SQL Code Guard
  • SQL Search
  • SQL Scripts Manager
  • Supratimas
  • dbForge SQL Complete
  • SSMS Tools Pack
  • SQL Pretty Printer
  • SQL Sentry Plan Explorer
• Useful 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/FK Rename.sql) (by Wes Henriksen)
  • [Count character matches](/Scripts/Count character matches.sql)
  • and many others...
• SSMS snippets
• Stored Procedure
  • sp_DBPermissions (by Kenneth Fisher)
  • sp_SrvPermissions (by Kenneth Fisher)
  • usp_who5 (by Sean Smith)
  • usp_String_Search (by Sean Smith)
  • usp_BulkUpload
  • [usp_TableUnpivot](/Stored_Procedure/ usp_TableUnpivot.sql)
  • and many others...
• User Defined Function
• Utilities

SQL Server Web Resources

• SQL Central Blog Scripts
• SQL Central Blog Articles
• SQL Central Blog Stairways
• MSSQLTips
• Awesome BRENT OZAR scripts, videos and articles
• Glenn Berry's SQL Server Performance
• Kenneth Fisher SQLStudies Blog
• Best backup and index maintenance solution Ola Maintenance Solution
• SQL Server Management Studio installation download link
• SQL# CLR functions
• Free Videos
  • IDERA Resource Center
  • MSSQLTips SQL Server Webcasts and Videos
  • SQL Server Videos
  • TECHNET How do I Videos
  • Veeam Learn Microsoft SQL Server
• Free Database Podcasts
  • SQL Server Radio
  • SQL Data Partners
  • Away from the Keyboard

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

• 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

• Microsoft SQL Server Community Projects & Samples
• Adventure Works Sample Databases and Scripts for SQL Server 2016 CTP3
• 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)

TSQL format code

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

Free SQL Server ebooks

• Avesome Red Gate ebooks
• Microsoft large collection
• OnlineVideoLectures ebooks
• Brent Ozar ebooks
• E-books Directory
• TOAD SQL Server ebooks