SQL Updates Newsletter – January 2017

Recent Releases and Announcements Support for SQL Server 2012 SP2 ended on 1/10/2017. Please upgrade to the latest service pack. http://www.microsoft.com/lifecycle Cumulative Update #1 for SQL Server 2016 SP1 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-1-for-sql-server-2016-sp1/ Cumulative Update #4 for SQL Server 2016 RTM https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-4-for-sql-server-2016-rtm/ Cumulative Update #7 for SQL Server 2012 SP3 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-7-for-sql-server-2012-sp3/ Cumulative Update #16 for SQL Server 2012…

1

How to dynamically determine the correct Process\Working Set performance counter instance

The Process performance counter object uses the following #1, #2 naming scheme whenever multiple instances of a process with the same executable name are running. \Process(sqlservr)\Working Set: this may be a default or named instance of SQL \Process(sqlservr#1)\Working Set: this may be a default or named instance of SQL \Process(sqlservr#2)\Working Set: this may be a…

0

SQL Updates Newsletter – December 2016

Recent Releases and Announcements GDR update package for SQL Server 2016 SP1 https://support.microsoft.com/en-us/kb/3210089 GDR update package for SQL Server 2016 RTM https://support.microsoft.com/en-us/kb/3210111 On-demand hotfix update package for SQL Server 2016 CU3 https://support.microsoft.com/en-us/kb/3210110 Cumulative Update #10 for SQL Server 2014 SP1 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-10-for-sql-server-2014-sp1/ Cumulative Update #3 for SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-3-for-sql-server-2014-sp2/ SQL Server v.Next CTP 1.1…

1

SQL Updates Newsletter – November 2016

Recent Releases and Announcements Microsoft Security Bulletin MS16-136 – Important Security Update for SQL Server (3199641) https://technet.microsoft.com/en-us/library/security/MS16-136 SQL Server 2016 Service Pack 1 generally available https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/ https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/16/sql-server-2016-service-pack-1-generally-available/ https://blogs.msdn.microsoft.com/sqlrsteamblog/2016/11/16/whats-new-in-sql-server-2016-sp1-for-reporting-services/ Cumulative Update #3 for SQL Server 2016 RTM https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-3-for-sql-server-2016-rtm/ Cumulative Update #6 for SQL Server 2012 SP3 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-6-for-sql-server-2012-sp3/ Cumulative Update #15 for SQL Server 2012 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-15-for-sql-server-2012-sp2/…

0

SQL Updates Newsletter – October 2016

Recent Releases and Announcements Cumulative Update #2 for SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-2-for-sql-server-2014-sp2/ We recommend ongoing, proactive installation of CUs as they become available. Cumulative Update #9 for SQL Server 2014 SP1 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-9-for-sql-server-2014-sp1/ Latest 2016 Gartner Magic quadrant recognitions Gartner has recognized Microsoft as a Leader — for the ninth year in a row —…

0

SQL Updates Newsletter – September 2016

Recent Releases and Announcements SQL Server 2016 – CU2 https://support.microsoft.com/en-us/kb/3182270 SQL Server 2012 SP3 – CU5 https://support.microsoft.com/en-us/kb/3180915 SQL Server 2012 SP2 – CU14 https://support.microsoft.com/en-us/kb/3180914 Azure SQL Database v12 has landed in Azure Government https://blogs.msdn.microsoft.com/azuregov/2016/09/27/azure-sql-database-v12-generally-available-in-azure-government/ Announcing the launch of Windows Server 2016 At our Ignite conference in Atlanta we launched the newest release of our server…

1

SQL Updates Newsletter – August 2016

Recent Releases and Announcements Critical Update for SQL Server 2016 Analysis Services (KB3179258) https://www.microsoft.com/en-us/download/details.aspx?id=53583 A possibility of data-loss has been identified in the SQL Server 2016 Analysis Services after partial processing of tabular model. Processing a partition causes data loss on other partitions after the database is restored or attached. After you install this item,…

0

SQL Updates Newsletter – July 2016

Recent Releases and Announcements Support for SQL Server 2014 RTM ended on 7/12/2016. Please upgrade to the latest service pack as soon as possible. https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=Microsoft%20SQL%20Server%202014&Filter=FilterSP&spdate=0  Cumulative Update 1 for SQL Server 2016 https://support.microsoft.com/en-us/kb/3164674 SQL Server 2014 Service Pack 2 is now available Improvements include: Automatic Soft NUMA partitioning, Dynamic Memory Object Scaling, MAXDOP hint for…

0

SQL Updates Newsletter – June 2016

Recent Releases and Announcements SQL Server 2016 became generally available starting June 1st, 2016. https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/23/powering-mission-critical-performance-with-sql-server-2016/ Announcing SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-2014-sp2/ SQL Server 2014 SP2 will be released next month and a release announcement with detailed information on improvements will be shared at the time of the release. Last Cumulative Update #14 for SQL…

0

SQL Updates Newsletter – May 2016

Recent Releases and Announcements Cumulative update package 2 for SQL Server 2012 SP3 https://support.microsoft.com/en-au/kb/3137746 Cumulative Update 3 for SQL Server 2012 SP3 https://support.microsoft.com/en-us/kb/3152635 Cumulative Update 12 for SQL Server 2012 SP2 https://support.microsoft.com/en-us/kb/3152637 SQL Server 2016 will be generally available on June 1, 2016. https://blogs.technet.microsoft.com/dataplatforminsider/2016/05/02/get-ready-sql-server-2016-coming-on-june-1st/ In March, we announced that the SQL Server 2016 Developer edition…

0