SQL Updates Newsletter – October 2016

Recent Releases and Announcements

  • R Tools for Visual Studio 0.5 (Preview)
    • https://blogs.technet.microsoft.com/machinelearning/2016/10/18/r-tools-for-visual-studio-0-5/
    • R Tools for Visual Studio is a free extension for Visual Studio 2015 that brings the Visual Studio IDE experience to R users. This is a preview release, that is intended for early adopters who are eager to try out our new data science experience for R and Visual Studio users.
    • Key updates in this release include:
      • Integrated support for SQL and SQL Stored Procedures.
      • Multiple plot windows, plot history with plot thumbnails for navigation.
      • General improvements and bug fixes.


Recent Whitepapers/E-books/Training/Tutorials


Monthly Script Tips


Issue Alert

  • Critical: Do NOT delete files from the Windows Installer folder. C:\windows\Installer is not a temporary folder and files in it should not be deleted. If you do it on machines on which you have SQL Server installed you may have to rebuild the operating system and reinstall SQL Server.
  • Critical: Please be aware of a critical Microsoft Visual C++ 2013 runtime pre-requisite update that may be required on machines where SQL Server 2016 will be, or has been, installed.
    • https://blogs.msdn.microsoft.com/sqlcat/2016/07/28/installing-sql-server-2016-rtm-you-must-do-this/
    • If KB3164398 or KB3138367 are installed, then no further action is necessary. To check, run the following from a command prompt:
      • powershell get-hotfix KB3164398
      • powershell get-hotfix KB3138367
    • If the version of %SystemRoot%\system32\msvcr120.dll is 12.0.40649.5 or later, then no further action is necessary. To check, run the following from a command prompt:
      • powershell "get-item %systemroot%\system32\msvcr120.dll | select versioninfo | fl"
  • SQL Server 2014 SP2 – CU2 fixes
    • https://support.microsoft.com/en-us/kb/3188778
    • Includes the following fixes among others:
      • 3191487    Query performance improvement for some columnstore queries in SQL Server 2014
      • 3184099    SQL Server 2012 crashes with an access violation when you use the TRY…CATCH construct for bulk copy
      • 3181260    SQL Server Analysis Services crashes when you have multiple roles and run a CREATE SESSION CUBE statement in SQL Server 2014
      • 164104      Unable to run DBCC CHECKDB when the database files reside in Azure Premium Storage in SQL Server 2014
      • 3189033    FIX: Cannot uninstall service packs for SQL Server 2014 after a cumulative update is installed
      • 3174370    A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016


Recent Blog Posts and Articles


Recommended KB’s To Review Regularly

  • Recommended hotfixes and updates for Windows Server 2012 R2-based failover clusters
  • Recommended updates and configuration options for SQL Server 2012 and later versions with high-performance workloads
    • https://support.microsoft.com/en-gb/kb/2964518
    • Note for SQL Server 2016: You no longer have to enable these trace flags in SQL Server 2016 because the auto-detection of the associated logic for trace flags is already incorporated into the product.
  • Troubleshooting SQL Server backup and restore operations


Fany Carolina Vargas | SQL Dedicated Premier Field Engineer | Microsoft Services