SQL Updates Newsletter – December 2015

  Recent Releases and Announcements SQL Server 2014 RTM CU11 https://support.microsoft.com/en-us/kb/3106659 SQL Server 2014 SP1 CU4 https://support.microsoft.com/en-us/kb/3106660 SQL Server 2012 SP3 https://support.microsoft.com/en-us/kb/3072779 SQL Server 2012 SP2 CU9 https://support.microsoft.com/en-us/kb/3098512 Windows Server 2016 Technical Preview 4 https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-technical-preview System Center 2016 Technical Preview 4Evaluations https://www.microsoft.com/en-us/evalcenter/evaluate-system-center-technical-preview Announcing SQL Server Management Studio – December 2015 Release http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/12/17/announcing-sql-server-management-studio-december-2015-release.aspx SQL Server Data…


SQL Updates Newsletter – October/November 2015

Recent Releases and Announcements SQL Server 2016 CTP 3 Preview https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/28/sql-server-2016-community-technology-preview-3-0-is-available.aspx Revolution R integration included in SQL Server 2016 CTP 3.0: http://blogs.technet.com/b/stbnewsbytes/archive/2015/10/28/cloud-platform-release-announcements-for-october-28-2015.aspx SQL Server 2014 SP1 CU3 released http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/10/22/cumulative-update-3-for-sql-server-2014-sp1.aspx https://support.microsoft.com/en-us/kb/3094221 Gartner positions Microsoft as a leader in the Magic Quadrant for Operational Database Management Systems http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/15/gartner-positions-microsoft-as-a-leader-in-the-magic-quadrant-for-operational-database-management-systems.aspx Azure Data Platform Announcements Azure Data Lake: Analytic…


SQL Updates Newsletter – June 2018

Recent Releases and Announcements Cumulative Update #8 for SQL Server 2017 RTM https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-8-for-sql-server-2017-rtm/ Cumulative Update #12 for SQL Server 2014 SP2 https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-12-for-sql-server-2014-sp2/ Microsoft releases the latest update of Analytics Platform System Microsoft is pleased to announce that the Analytics Platform System (APS) appliance update 7 (AU7) is now generally available. APS is Microsoft’s scale-out Massively…


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) to a volume. In this manner you can access a new volume via a child folder path of a different volume’s drive letter. For example, say you have three 100GB volumes Vol1, Vol2, Vol3. We can initially mount…


SQL Updates Newsletter – January 2015

Recent Releases and Announcements ·         Cumulative Update #14 for SQL Server 2012 SP1 o        http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/01/21/cumulative-update-14-for-sql-server-2012-sp1.aspx ·         Cumulative Update #4 for SQL Server 2012 SP2 o        http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/01/20/cumulative-update-4-for-sql-server-2012-sp2.aspx ·          SQL Release Services Blog o        http://blogs.msdn.com/b/sqlreleaseservices/ ·         Microsoft Security Bulletin Summary for January 2015 o        There is a critical Telnet update for this month: o        https://technet.microsoft.com/library/security/ms15-jan ·         Windows…


SQL Updates Newsletter – May 2015

Recent Releases and Announcements  SQL Server 2014 Service Pack 1 is now available http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/05/15/sql-server-2014-service-pack-1-is-now-available.aspx Cumulative Update #16 for SQL Server 2012 SP1 http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/05/18/cumulative-update-16-for-sql-server-2012-sp1.aspx NOTE: This is the final Cumulative Update for SQL Server 2012 Service Pack 1.  SQL Server 2012 SP1 exits service pack support on July 14, 2015. Upcoming end of support for SQL…


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 difference between Rights and Permissions, as well as how to identify when UAC was coming into play. What is the Difference Between Permissions and Rights (Privileges)? Permissions apply to Objects A permission is an authorization to perform…


SQL Updates Newsletter – February 2015

Recent Releases and Announcements ·         An on-demand hotfix update package is available for SQL Server 2008 R2 SP3 o        http://support.microsoft.com/kb/3033860/en-us ·         An on-demand hotfix update package is available for SQL Server 2008 SP4 o        http://support.microsoft.com/kb/3034373/en-us ·         Cumulative Update #6 for SQL Server 2014 RTM o        http://support.microsoft.com/kb/3031047 ·         SQL Release Services Blog o        http://blogs.msdn.com/b/sqlreleaseservices/ ·         Downloadable…


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 Group meeting.  Thank you all for attending! Download the presentation here. <Extracted Slide Text> PowerShell Lessons Learned from Building an Automated SQL Installation and Patch Management Implementation Presented by: Fany Carolina Vargas, Microsoft Corp., Sr. PFE, SQL Dedicated Support…


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 services via a script without getting any UAC elevation prompts in an environment where UAC is enabled. Please review this related blog post for steps to grant non-admin users permissions to stop/start SQL Services: http://blogs.msdn.com/b/sqlupdates/archive/2015/05/14/how-to-start-or-stop-sql-services-without-os-admin-rights.aspx. For an overview of…