SQL Updates Newsletter – March 2017

Recent Releases and Announcements SQL Server next version CTP 1.4 now available The primary enhancement to SQL Server v.Next on Linux in this release is the ability to schedule jobs using SQL Server Agent. The mssql-server-linux container image on Docker Hub now includes the sqlcmd and bcp command line utilities to make it easier to…

0

SQL Updates Newsletter – February 2017

Recent Releases and Announcements Cumulative Update #4 for SQL Server 2014 SP2 https://support.microsoft.com/en-us/help/4010394/cumulative-update-4-for-sql-server-2014-sp2 Cumulative Update #11 for SQL Server 2014 SP1 https://support.microsoft.com/en-us/help/4010392/cumulative-update-11-for-sql-server-2014-sp1 SQL Server vNext CTP 1.3 now available Always On Availability Groups on Linux Resumable online index rebuilds enables users to recover more easily from interruption of index builds, or split an index build…

1

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