External resources

October 5th, 2016
    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/
    https://www.dropbox.com/sh/acejbwfeg552reb/AADbU49FtyWsgn2jd93-YTRga?dl=0
    https://sqlserverperformance.wordpress.com/2014/09/17/sql-server-diagnostic-information-queries-for-september-2014/
    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
Comments are closed.