-
How to obtain the latest service pack for SQL Server:
https://support.microsoft.com/en-au/kb/2755533
-
How to install a Service Pack at a SQL Server 2012 Failover Instance – Best Practice:
https://blogs.msdn.microsoft.com/john_daskalakis/2014/09/05/how-to-install-a-service-pack-at-a-sql-server-2012-failover-instance-best-practices/
-
Best Practices for Applying Service Packs, Hotfixes and Security Patches
https://msdn.microsoft.com/library/cc750077.aspx
-
Microsoft® SQL Server® 2012 Best Practices Analyzer
https://www.microsoft.com/en-us/download/details.aspx?id=29302
-
Best Practices for installing SQL Server service packs, hotfixes, cumulative updates
https://blogs.technet.microsoft.com/beatrice/2009/02/10/best-practices-for-installing-sql-server-service-packs-hotfixes-cumulative-updates/
-
Failover Cluster Instance Administration and Maintenance
https://msdn.microsoft.com/en-us/library/ms178061(v=sql.110).aspx
-
Diagnostic queries:
https://sqlserverperformance.wordpress.com/
-
Leveraging sys.dm_io_virtual_file_stats
https://blogs.msdn.microsoft.com/dpless/2010/12/01/leveraging-sys-dm_io_virtual_file_stats/
-
OPTION (RECOMPILE)
http://www.sqlskills.com/blogs/kimberly/using-the-option-recompile-option-for-a-statement/
-
SQL Server Documentation:
https://technet.microsoft.com/library/mt590198.aspx
-
SQL Server Database 2008 Documentation
https://technet.microsoft.com/en-us/library/hh278312.aspx
-
SQL Server Database 2008R2 Documentation
https://technet.microsoft.com/en-us/library/dn197878.aspx
-
SQL Server Database 2012 Documentation
https://technet.microsoft.com/en-us/library/hh278311.aspx
-
SQL Server Database 2014 Documentation
https://technet.microsoft.com/en-us/library/hh994726.aspx
-
SQL Server Database 2016 Documentation
https://technet.microsoft.com/en-us/library/hh278297.aspx
-
TechNet troubleshooting and support
https://technet.microsoft.com/en-gb/ms772425
-
MSDN forums
https://social.msdn.microsoft.com/Forums/en-US/home?forum=en-US
-
MSSQL Transact-SQL reference
https://technet.microsoft.com/en-us/library/bb510741.aspx
-
AlwaysOn troubleshooting and monitoring guide
https://technet.microsoft.com/en-us/library/dn135328.aspx
-
Microsoft SQL support lifecycle
https://support.microsoft.com/en-gb/lifecycle?c2=1044
-
How to determine the version, edition and update level of SQL Server and its components
https://support.microsoft.com/en-us/kb/321185
-
Create or Configure an Availability Group Listener (SQL Server)
https://msdn.microsoft.com/en-AU/library/hh213080.aspx
-
Availability Group Listeners, Client Connectivity, and Application Failover (SQL Server)
https://msdn.microsoft.com/en-us/library/hh213417.aspx
-
== MSSQL Patching ==
-
Where to find information about the latest SQL Server builds and patches
https://support.microsoft.com/en-us/kb/957826
-
MSSQL updates / patches
-
http://sqlserverbuilds.blogspot.com.au/
-
https://technet.microsoft.com/en-us/library/ff803383.aspx
-
https://support.microsoft.com/en-au/kb/321185
-
SQL Server failover cluster rolling patch and service pack process
https://support.microsoft.com/en-au/kb/958734
-
Best Practise for Patching SQL Server
https://blogs.msdn.microsoft.com/glsmall/2013/11/14/best-practise-for-patching-sql-server/
-
Upgrading Always On Availability Group Replica Instances
https://msdn.microsoft.com/en-us/library/dn178483.aspx