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

• [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 - 300 Trace Flags') (Complete list - 300 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
    • 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
    • TSQL Code Smells Finder
    • SQLTreeo
    • ApexSQL Complete
    • ApexSQL Refactor
    • ApexSQL Search
    • Spotlight Developer
    • dbForge Source Control
    • dbForge Unit Test
    • dbForge Data Pump
    • dbForge Index Manager
    • dbForge Object Search
  • 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
  • GraphView (Microsoft)
  • tablediff Utility (Microsoft)
  • Microsoft Log Parser (Microsoft)
  • Diskspd (Microsoft)
  • HammerDB (Open Source)
  • dta Utility (Microsoft)
  • osql Utility (Microsoft)
  • sqldiag Utility (Microsoft)
  • sqldumper Utility (Microsoft)
  • SqlLocalDB Utility (Microsoft)
  • sqllogship Utility (Microsoft)
  • sqlservr Application (Microsoft)
  • sqlps Utility (Microsoft)
  • sqlmaint Utility (Microsoft)
  • Ssms Utility (Microsoft)
  • dtexec Utility (Microsoft)
  • SQL Server 2000 Best Practices Analyzer (Microsoft)
  • SQL Server 2005 Best Practices Analyzer (Microsoft)
  • SQL Server 2008 R2 Best Practices Analyzer (Microsoft)
  • SQL Server 2012 Best Practices Analyzer (Microsoft)
  • DLM Dashboard (Red Gate)
  • SQL DBA Bundle (Red Gate)
  • ReadyRoll (Red Gate)
  • SQL XEvent Profiler (Idera)
  • SQL Check (Idera)
  • SQL Fragmentation Analyzer (Idera)
  • SQL Heat Map (Idera)
  • SQL Hekaton Memory Check (Idera)
  • SQL Page Viewer (Idera)
  • SQL Update Statistics (Idera)
  • SQL Statistics Aggregator (Idera)
  • SQL Backup Status Reporter (Idera)
  • SQL Integrity Check (Idera)
  • SQL Job Manager (Idera)
  • Azure SQL Database Backup (Idera)
  • SQL Column Search (Idera)
  • SQL Permissions Extractor (Idera)
  • dbForge Schema Compare (Devart)
  • dbForge Data Compare (Devart)
  • dbForge Data Generator (Devart)
  • dbForge Query Builder (Devart)
  • dbForge Event Profiler (Devart)
  • dbForge SQL Decryptor (Devart)
  • Minion Enterprise (MinionWare)

• Blogs
  • 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 SQL Server Perfomance Blog
  • Best backup and index maintenance solution Ola Maintenance Solution
  • Weblogs SQLTeam Blogs
  • SQLMag
• 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
• Free Database Podcasts
  • SQL Server Radio
  • SQL Data Partners
  • Away from the Keyboard
• Courses
  • MVA SQL Server Courses
  • Lynda Courses
  • Veeam Free Courses
  • SQLSkills Trainings
  • Brent Ozar Team Trainings
  • Pluralsight Courses
• Other
  • SQL Server Management Studio installation download link
  • SQL# CLR functions (by Sql Quantum Leap)
  • SSIS Performance Benchmarks
  • Statistic Parser (by Richie Rump)
  • SQL Generator (by Richie Rump)
  • Columnstore Indexes Scripts Library (by Niko Neugebauer)
  • Stackoverflow SQL Server
  • DBA Stackexchange SQL Server

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

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

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

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

• 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

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

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

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

• Avesome Red Gate ebooks
• Microsoft huge collection
• Microsoft large collection
• Microsoft MVA Free ebooks
• OnlineVideoLectures ebooks
• Brent Ozar ebooks
• E-books Directory
• TOAD SQL Server ebooks
• Syncfusion Techportal

MIT

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