SQL Updates Newsletter – August 2017

Recent Releases and Announcements Our immediate response to Hurricane Harvey https://blogs.microsoft.com/blog/2017/08/29/immediate-response-hurricane-harvey/ Power BI Report Server August 2017 Preview now available https://powerbi.microsoft.com/en-us/blog/power-bi-report-server-august-2017-preview-now-available/ Cumulative Update #7 for SQL Server 2014 SP2 https://support.microsoft.com/en-us/help/4032541/cumulative-update-7-for-sql-server-2014-sp2 SQL Server 2017 Release Candidate 2 (RC2) is now available https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/02/sql-server-2017-release-candidate-2-rc2-is-now-available/ Cumulative Update #4 for SQL Server 2016 SP1 Cumulative Update 4 (CU4) for Microsoft SQL Server 2016 Service Pack…

0

SQL Updates Newsletter – July 2017

Recent Releases and Announcements First release candidate of SQL Server 2017 now available Linux support for tier-1, mission-critical workloads; Note that with RC1, SQL Server on Linux supports Active Directory Authentication SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of…

3

SQL Updates Newsletter – June 2017

Recent Releases and Announcements Announcing SQL Server 2012 Service Pack 4 SQL Server 2012 SP4 will be released in September 2017 (note the date has changed from previous announcement) A release announcement with detailed information on improvements will be shared at the time of the release. https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-sql-server-2012-service-pack-4/ Petya Ransomware Prevention & Detection in Azure Security…

0

SQL Updates Newsletter – May 2017

Recent Releases and Announcements SQL Server 2017 CTP 2.1 now available The primary enhancement to SQL Server 2017 in this release is the ability to configure SQL Server configuration settings through environment variables passed in as parameters to Docker run. This enables many of the SQL Server configuration scenarios in Docker containers such as setting…

1

SQL Updates Newsletter – April 2017

Recent Releases and Announcements Reminder: Latest Improvements to the Simplified Servicing for Windows 7 and Windows 8.1 Beginning with March 2017, the Security Only Quality Update will no longer include updates for Internet Explorer. The cumulative Internet Explorer update will again be available as a separate update. If you’re currently deploying the Security Only Quality…

0

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…

0

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