{"id":611,"date":"2016-10-04T04:38:48","date_gmt":"2016-10-04T04:38:48","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=611"},"modified":"2016-10-05T01:03:13","modified_gmt":"2016-10-05T01:03:13","slug":"resources","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=611","title":{"rendered":"External resources"},"content":{"rendered":"
    \nHow to obtain the latest service pack for SQL Server: <\/strong>
    \nhttps:\/\/support.microsoft.com\/en-au\/kb\/2755533<\/a>\n<\/ol>\n
      \nHow to install a Service Pack at a SQL Server 2012 Failover Instance \u2013 Best Practice: <\/strong>
      \n      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\/<\/a>\n<\/ol>\n
        \nBest Practices for Applying Service Packs, Hotfixes and Security Patches<\/strong>
        \n        https:\/\/msdn.microsoft.com\/library\/cc750077.aspx<\/a>\n<\/ol>\n
          \nMicrosoft\u00ae SQL Server\u00ae 2012 Best Practices Analyzer<\/strong>
          \n          https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=29302<\/a>\n<\/ol>\n
            \nBest Practices for installing SQL Server service packs, hotfixes, cumulative updates<\/strong>
            \n            https:\/\/blogs.technet.microsoft.com\/beatrice\/2009\/02\/10\/best-practices-for-installing-sql-server-service-packs-hotfixes-cumulative-updates\/<\/a>\n<\/ol>\n
              \nFailover Cluster Instance Administration and Maintenance<\/strong>
              \n              https:\/\/msdn.microsoft.com\/en-us\/library\/ms178061(v=sql.110).aspx<\/a>\n<\/ol>\n
                \nDiagnostic queries:<\/strong>
                \n                https:\/\/sqlserverperformance.wordpress.com\/<\/a>\n<\/ol>\n
                  \nhttps:\/\/www.dropbox.com\/sh\/acejbwfeg552reb\/AADbU49FtyWsgn2jd93-YTRga?dl=0<\/a>\n<\/ol>\n
                    \nhttps:\/\/sqlserverperformance.wordpress.com\/2014\/09\/17\/sql-server-diagnostic-information-queries-for-september-2014\/<\/a>\n<\/ol>\n
                      \nLeveraging sys.dm_io_virtual_file_stats<\/strong>
                      \n                      https:\/\/blogs.msdn.microsoft.com\/dpless\/2010\/12\/01\/leveraging-sys-dm_io_virtual_file_stats\/<\/a>\n<\/ol>\n
                        \nOPTION (RECOMPILE)<\/strong>
                        \n                        http:\/\/www.sqlskills.com\/blogs\/kimberly\/using-the-option-recompile-option-for-a-statement\/<\/a>\n<\/ol>\n
                          \nSQL Server Documentation:<\/strong>
                          \n                          https:\/\/technet.microsoft.com\/library\/mt590198.aspx<\/a><\/ol>\n
                            \nSQL Server Database 2008 Documentation<\/strong>
                            \n                            https:\/\/technet.microsoft.com\/en-us\/library\/hh278312.aspx<\/a> <\/ol>\n
                              \nSQL Server Database 2008R2 Documentation<\/strong>
                              \n                              https:\/\/technet.microsoft.com\/en-us\/library\/dn197878.aspx<\/a><\/ol>\n
                                \nSQL Server Database 2012 Documentation<\/strong>
                                \n                                https:\/\/technet.microsoft.com\/en-us\/library\/hh278311.aspx<\/a><\/ol>\n
                                  \nSQL Server Database 2014 Documentation<\/strong>
                                  \n                                  https:\/\/technet.microsoft.com\/en-us\/library\/hh994726.aspx<\/a><\/ol>\n
                                    \nSQL Server Database 2016 Documentation<\/strong>
                                    \n                                    https:\/\/technet.microsoft.com\/en-us\/library\/hh278297.aspx<\/a><\/ol>\n
                                      \nTechNet troubleshooting and support<\/strong>
                                      \n                                      https:\/\/technet.microsoft.com\/en-gb\/ms772425<\/a><\/ol>\n
                                        \nMSDN forums
                                        \nhttps:\/\/social.msdn.microsoft.com\/Forums\/en-US\/home?forum=en-US<\/ol>\n
                                          \nMSSQL Transact-SQL reference
                                          \nhttps:\/\/technet.microsoft.com\/en-us\/library\/bb510741.aspx<\/ol>\n
                                            \nAlwaysOn troubleshooting and monitoring guide
                                            \nhttps:\/\/technet.microsoft.com\/en-us\/library\/dn135328.aspx<\/ol>\n
                                              \nMicrosoft SQL support lifecycle
                                              \nhttps:\/\/support.microsoft.com\/en-gb\/lifecycle?c2=1044<\/ol>\n
                                                \nHow to determine the version, edition and update level of SQL Server and its components
                                                \nhttps:\/\/support.microsoft.com\/en-us\/kb\/321185<\/ol>\n
                                                  \nCreate or Configure an Availability Group Listener (SQL Server)
                                                  \nhttps:\/\/msdn.microsoft.com\/en-AU\/library\/hh213080.aspx<\/ol>\n
                                                    \nAvailability Group Listeners, Client Connectivity, and Application Failover (SQL Server)
                                                    \nhttps:\/\/msdn.microsoft.com\/en-us\/library\/hh213417.aspx<\/ol>\n
                                                      \n== MSSQL Patching ==<\/strong><\/ol>\n
                                                        \nWhere to find information about the latest SQL Server builds and patches
                                                        \nhttps:\/\/support.microsoft.com\/en-us\/kb\/957826<\/ol>\n
                                                          \nMSSQL updates \/ patches<\/ol>\n
                                                            \nhttp:\/\/sqlserverbuilds.blogspot.com.au\/<\/ol>\n
                                                              \nhttps:\/\/technet.microsoft.com\/en-us\/library\/ff803383.aspx<\/ol>\n
                                                                \nhttps:\/\/support.microsoft.com\/en-au\/kb\/321185<\/ol>\n
                                                                  \nSQL Server failover cluster rolling patch and service pack process
                                                                  \nhttps:\/\/support.microsoft.com\/en-au\/kb\/958734<\/ol>\n
                                                                    \nBest Practise for Patching SQL Server
                                                                    \nhttps:\/\/blogs.msdn.microsoft.com\/glsmall\/2013\/11\/14\/best-practise-for-patching-sql-server\/<\/ol>\n
                                                                      \nUpgrading Always On Availability Group Replica Instances
                                                                      \nhttps:\/\/msdn.microsoft.com\/en-us\/library\/dn178483.aspx<\/ol>\n","protected":false},"excerpt":{"rendered":"

                                                                      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 \u2013 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\u00ae SQL Server\u00ae 2012 Best Practices Analyzer https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=29302 Best Practices for installing SQL Server service packs, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":574,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-611","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-9R","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=611"}],"version-history":[{"count":6,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/611\/revisions"}],"predecessor-version":[{"id":622,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/611\/revisions\/622"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/574"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}