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...
Date: 04/30/2018
SQL Updates Newsletter - February 2018
Recent Releases and Announcements Gartner recognizes Microsoft as a leader in Analytics and BI...
Date: 03/01/2018
SQL Updates Newsletter – January 2018
Recent Releases and Announcements Cumulative Update #3 for SQL Server 2017 RTM...
Date: 02/05/2018
SQL Updates Newsletter – December 2017
Recent Releases and Announcements Cumulative Update #9 for SQL Server 2014 SP2...
Date: 12/29/2017
SQL Updates Newsletter – November 2017
Recent Releases and Announcements Cumulative Update #2 for SQL Server 2017 RTM...
Date: 11/29/2017
SQL Updates Newsletter – October 2017
Recent Releases and Announcements SQL Server 2012 Service Pack 4 (SP4) is now available...
Date: 11/02/2017
SQL Updates Newsletter – September 2017
Recent Releases and Announcements At Microsoft Ignite, we showcased our work in quantum computing....
Date: 09/30/2017
SQL Updates Newsletter – August 2017
Recent Releases and Announcements Our immediate response to Hurricane Harvey...
Date: 08/30/2017
SQL Updates Newsletter – July 2017
Recent Releases and Announcements First release candidate of SQL Server 2017 now available Linux...
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...
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...
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...
Date: 04/26/2017
SQL Updates Newsletter – March 2017
Recent Releases and Announcements SQL Server next version CTP 1.4 now available The primary...
Date: 03/31/2017
SQL Updates Newsletter – February 2017
Recent Releases and Announcements Cumulative Update #4 for SQL Server 2014 SP2...
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...
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...
Date: 01/19/2017
SQL Updates Newsletter – December 2016
Recent Releases and Announcements GDR update package for SQL Server 2016 SP1...
Date: 01/03/2017
SQL Updates Newsletter – November 2016
Recent Releases and Announcements Microsoft Security Bulletin MS16-136 - Important Security Update...
Date: 12/01/2016
SQL Updates Newsletter – October 2016
Recent Releases and Announcements Cumulative Update #2 for SQL Server 2014 SP2...
Date: 10/28/2016
SQL Updates Newsletter – September 2016
Recent Releases and Announcements SQL Server 2016 – CU2...
Date: 09/30/2016
SQL Updates Newsletter – August 2016
Recent Releases and Announcements Critical Update for SQL Server 2016 Analysis Services (KB3179258)...
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...
Date: 07/30/2016
SQL Updates Newsletter - June 2016
Recent Releases and Announcements SQL Server 2016 became generally available starting June 1st,...
Date: 07/01/2016
SQL Updates Newsletter - May 2016
Recent Releases and Announcements Cumulative update package 2 for SQL Server 2012 SP3...
Date: 05/31/2016
SQL Updates Newsletter - April 2016
Recent Releases and Announcements SQL Server 2016 will be generally available on June 1, 2016....
Date: 04/30/2016
SQL Updates Newsletter – March 2016
Recent Releases and Announcements Cumulative update package 2 for SQL Server 2012 SP3...
Date: 03/31/2016
SQL Updates Newsletter - February 2016
Recent Releases and Announcements Cumulative Update 12 for SQL Server 2014 RTM...
Date: 02/28/2016
SQL Updates Newsletter - January 2016
Recent Releases and Announcements Changes to SQL cumulative update download process: SQL cumulative...
Date: 01/31/2016
SQL Updates Newsletter - December 2015
Recent Releases and Announcements SQL Server 2014 RTM CU11...
Date: 12/31/2015
SQL Updates Newsletter - October/November 2015
Recent Releases and Announcements SQL Server 2016 CTP 3 Preview...
Date: 11/13/2015
SQL Updates Newsletter - September 2015
Recent Releases and Announcements SQL Server 2016 Community Technology Preview 2.4 is here!...
Date: 09/30/2015
SQL Updates Newsletter - July/August 2015
Recent Releases and Announcements SQL 2016 CTP 2.3 has been released...
Date: 08/31/2015
SQL Updates Newsletter - June 2015
Recent Releases and Announcements Cumulative Update #1 for SQL Server 2014 SP1...
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...
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...
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...
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...
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...
Date: 05/14/2015
SQL Updates Newsletter - April 2015
Recent Releases and Announcements Microsoft Disaster Response - Nepal Earthquake...
Date: 04/30/2015
SQL Updates Newsletter - March 2015
Recent Releases and Announcements · SQL 2012...
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...
Date: 03/02/2015
SQL Updates Newsletter - February 2015
Recent Releases and Announcements · An on-demand hotfix update package is available for SQL...
Date: 02/28/2015
SQL Updates Newsletter - January 2015
Recent Releases and Announcements · Cumulative Update #14 for SQL Server 2012 SP1 o...
Date: 01/31/2015
SQL Updates Newsletter - December 2014
Recent Releases and Announcements · SQL Server 2014 CU5 o...
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)...
Date: 12/09/2014