SQL Server Updates and Lessons Learned

SQL announcements, guidance, and lessons learned from the field

SQL Updates Newsletter – April 2018

Recent Releases and Announcements Cumulative Update #6 for SQL Server 2017 RTM Starting with SQL...

Author: Fany Carolina Vargas [MSFT] Date: 04/30/2018

SQL Updates Newsletter - February 2018

Recent Releases and Announcements Gartner recognizes Microsoft as a leader in Analytics and BI...

Author: Fany Carolina Vargas [MSFT] Date: 03/01/2018

SQL Updates Newsletter – January 2018

Recent Releases and Announcements Cumulative Update #3 for SQL Server 2017 RTM...

Author: Fany Carolina Vargas [MSFT] Date: 02/05/2018

SQL Updates Newsletter – December 2017

Recent Releases and Announcements Cumulative Update #9 for SQL Server 2014 SP2...

Author: Fany Carolina Vargas [MSFT] Date: 12/29/2017

SQL Updates Newsletter – November 2017

Recent Releases and Announcements Cumulative Update #2 for SQL Server 2017 RTM...

Author: Fany Carolina Vargas [MSFT] Date: 11/29/2017

SQL Updates Newsletter – October 2017

Recent Releases and Announcements SQL Server 2012 Service Pack 4 (SP4) is now available...

Author: Fany Carolina Vargas [MSFT] Date: 11/02/2017

SQL Updates Newsletter – September 2017

Recent Releases and Announcements At Microsoft Ignite, we showcased our work in quantum computing....

Author: Fany Carolina Vargas [MSFT] Date: 09/30/2017

SQL Updates Newsletter – August 2017

Recent Releases and Announcements Our immediate response to Hurricane Harvey...

Author: Fany Carolina Vargas [MSFT] Date: 08/30/2017

SQL Updates Newsletter – July 2017

Recent Releases and Announcements First release candidate of SQL Server 2017 now available Linux...

Author: Fany Carolina Vargas [MSFT] Date: 07/31/2017

SQL Updates Newsletter – June 2017

Recent Releases and Announcements Announcing SQL Server 2012 Service Pack 4 SQL Server 2012 SP4 will...

Author: Fany Carolina Vargas [MSFT] Date: 07/01/2017

SQL Updates Newsletter – May 2017

Recent Releases and Announcements SQL Server 2017 CTP 2.1 now available The primary enhancement to...

Author: Fany Carolina Vargas [MSFT] Date: 05/31/2017

How to Use an Encrypted Password Within a SQL Agent job to Access a Fileshare in an Untrusted Domain

Scenario You have a SQL Server Agent job which needs to regularly access a remote file share in an...

Author: Fany Carolina Vargas [MSFT] Date: 04/26/2017

SQL Updates Newsletter – March 2017

Recent Releases and Announcements SQL Server next version CTP 1.4 now available The primary...

Author: Fany Carolina Vargas [MSFT] Date: 03/31/2017

SQL Updates Newsletter – February 2017

Recent Releases and Announcements Cumulative Update #4 for SQL Server 2014 SP2...

Author: Fany Carolina Vargas [MSFT] Date: 02/27/2017

SQL Updates Newsletter – January 2017

Recent Releases and Announcements Support for SQL Server 2012 SP2 ended on 1/10/2017. Please upgrade...

Author: Fany Carolina Vargas [MSFT] Date: 01/31/2017

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...

Author: Fany Carolina Vargas [MSFT] Date: 01/19/2017

SQL Updates Newsletter – December 2016

Recent Releases and Announcements GDR update package for SQL Server 2016 SP1...

Author: Fany Carolina Vargas [MSFT] Date: 01/03/2017

SQL Updates Newsletter – November 2016

Recent Releases and Announcements Microsoft Security Bulletin MS16-136 - Important Security Update...

Author: Fany Carolina Vargas [MSFT] Date: 12/01/2016

SQL Updates Newsletter – October 2016

Recent Releases and Announcements Cumulative Update #2 for SQL Server 2014 SP2...

Author: Fany Carolina Vargas [MSFT] Date: 10/28/2016

SQL Updates Newsletter – September 2016

Recent Releases and Announcements SQL Server 2016 – CU2...

Author: Fany Carolina Vargas [MSFT] Date: 09/30/2016

SQL Updates Newsletter – August 2016

Recent Releases and Announcements Critical Update for SQL Server 2016 Analysis Services (KB3179258)...

Author: Fany Carolina Vargas [MSFT] Date: 08/31/2016

SQL Updates Newsletter – July 2016

Recent Releases and Announcements Support for SQL Server 2014 RTM ended on 7/12/2016. Please upgrade...

Author: Fany Carolina Vargas [MSFT] Date: 07/30/2016

SQL Updates Newsletter - June 2016

Recent Releases and Announcements SQL Server 2016 became generally available starting June 1st,...

Author: Fany Carolina Vargas [MSFT] Date: 07/01/2016

SQL Updates Newsletter - May 2016

Recent Releases and Announcements Cumulative update package 2 for SQL Server 2012 SP3...

Author: Fany Carolina Vargas [MSFT] Date: 05/31/2016

SQL Updates Newsletter - April 2016

Recent Releases and Announcements SQL Server 2016 will be generally available on June 1, 2016....

Author: Fany Carolina Vargas [MSFT] Date: 04/30/2016

SQL Updates Newsletter – March 2016

Recent Releases and Announcements Cumulative update package 2 for SQL Server 2012 SP3...

Author: Fany Carolina Vargas [MSFT] Date: 03/31/2016

SQL Updates Newsletter - February 2016

Recent Releases and Announcements Cumulative Update 12 for SQL Server 2014 RTM...

Author: Fany Carolina Vargas [MSFT] Date: 02/28/2016

SQL Updates Newsletter - January 2016

Recent Releases and Announcements Changes to SQL cumulative update download process: SQL cumulative...

Author: Fany Carolina Vargas [MSFT] Date: 01/31/2016

SQL Updates Newsletter - December 2015

Recent Releases and Announcements SQL Server 2014 RTM CU11...

Author: Fany Carolina Vargas [MSFT] Date: 12/31/2015

SQL Updates Newsletter - October/November 2015

Recent Releases and Announcements SQL Server 2016 CTP 3 Preview...

Author: Fany Carolina Vargas [MSFT] Date: 11/13/2015

SQL Updates Newsletter - September 2015

Recent Releases and Announcements SQL Server 2016 Community Technology Preview 2.4 is here!...

Author: Fany Carolina Vargas [MSFT] Date: 09/30/2015

SQL Updates Newsletter - July/August 2015

Recent Releases and Announcements SQL 2016 CTP 2.3 has been released...

Author: Fany Carolina Vargas [MSFT] Date: 08/31/2015

SQL Updates Newsletter - June 2015

Recent Releases and Announcements Cumulative Update #1 for SQL Server 2014 SP1...

Author: Fany Carolina Vargas [MSFT] Date: 06/30/2015

Duplicate SPN: What is it really?

If you look at many of the references regarding Kerberos troubleshooting, one of the common...

Author: Fany Carolina Vargas [MSFT] Date: 06/23/2015

Understanding User Account Control (UAC), A Brief Summary

Below are some notes I took while troubleshooting a UAC issue. I found it useful to understand the...

Author: Fany Carolina Vargas [MSFT] Date: 05/20/2015

Troubleshoot Runaway Queries in SQL 2014 Using sys.dm_exec_query_profiles

Scenario You are tasked to identify the bottleneck of a slow or problematic T-SQL query which either...

Author: Fany Carolina Vargas [MSFT] Date: 05/18/2015

How to Start or Stop SQL Services without OS Admin Rights

Scenario You wish to grant users who do NOT have OS administrative rights the ability to start/stop...

Author: Fany Carolina Vargas [MSFT] Date: 05/15/2015

How to Start or Stop SQL Services without UAC Prompts

Scenario You have OS administrative rights and would like to start/stop SQL Server & SQL Agent...

Author: Fany Carolina Vargas [MSFT] Date: 05/14/2015

SQL Updates Newsletter - April 2015

Recent Releases and Announcements Microsoft Disaster Response - Nepal Earthquake...

Author: Fany Carolina Vargas [MSFT] Date: 04/30/2015

SQL Updates Newsletter - March 2015

Recent Releases and Announcements   ·         SQL 2012...

Author: Fany Carolina Vargas [MSFT] Date: 03/31/2015

PowerShell Lessons Learned from Building an Automated SQL Installation and Patch Management Implementation

Attached are the PowerPoint slides from the recent presentation I gave for the SQL Server User’s...

Author: Fany Carolina Vargas [MSFT] Date: 03/02/2015

SQL Updates Newsletter - February 2015

Recent Releases and Announcements ·         An on-demand hotfix update package is available for SQL...

Author: Fany Carolina Vargas [MSFT] Date: 02/28/2015

SQL Updates Newsletter - January 2015

Recent Releases and Announcements ·         Cumulative Update #14 for SQL Server 2012 SP1 o...

Author: Fany Carolina Vargas [MSFT] Date: 01/31/2015

SQL Updates Newsletter - December 2014

Recent Releases and Announcements    ·         SQL Server 2014 CU5 o...

Author: Fany Carolina Vargas [MSFT] Date: 12/31/2014

Guidelines for Setting SQL Permissions on Mount Point Folders

You can use Windows Disk Management to assign a mount-point folder path (rather than a drive letter)...

Author: Fany Carolina Vargas [MSFT] Date: 12/09/2014

Next>