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
- SSMS addons
- 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...
- Awesome SQL Server Diagnostic Information Queries (by Glenn Alan Berry)
- 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
- Free Database Podcasts
- 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:
Here's just SQL Server 2014 Management Studio:
SQL Server 2014 Express with Advanced Services:
You likely just want SQL Server 2012 Express with Tools. This download includes SQL Management Studio:
Here's just SQL Server 2012 Management Studio:
You likely just want SQL Server 2008 Express with Tools. This download includes SQL Management Studio:
Here's just SQL Server 2008 Management Studio:
- 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
- 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
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.