Useful links, scripts, tools and best practice for Microsoft SQL Server Database
- [SQL Server Trace Flag](/SQL Server Trace Flag.md 'Complete list from many resources - 161 Trace Flag')
- [SQL Server Version](/SQL Server Version.md 'List of all version Microsoft SQL Sever')
- Base line Collector script (Written by Robert Virag)
- CLR procedures
- SQL# free - QUICKEST and EASIEST way to extending the power of T-SQL
- SplitterB_CLR
- Known Errors
- Ola Maintenance Solution (Written by Ola Hallengren)
- SSMS addons
- Useful scripts
- Awesome SQL Server Diagnostic Information Queries (Written by Glenn Alan Berry)
- Table count alternative (Written by Jes Schultz Borland)
- Foreign Key batch rename (Written by Wes Henriksen)
- SSMS snippets
- Stored Procedure
- sp_DBPermissions (Written by Kenneth Fisher)
- sp_SrvPermissions (Written by Kenneth Fisher)
- usp_who5 (Written by Sean Smith)
- usp_String_Search (Written by Sean Smith)
- and many others...
- User Defined Function
- dbWarden - A Free SQL Server Monitoring Package (Written by Stevie Rounds and Michael Rounds)
- Microsoft SQL Server Version List
- SQL Central blog Scripts
- SQL Central blog Articles
- Awesome BRENT OZAR scripts and articles
- Glenn Berry's SQL Server Performance
- Best backup and index maintenance solution Ola Hallengren
- SQL Server Management Studio installation download link
- SQL# CLR functions
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
- http://technet.microsoft.com/en-us/library/jj835095.aspx
- http://msdn.microsoft.com/en-us/library/ms190806.aspx
- 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/