SQL Updates Newsletter – August 2016

Recent Releases and Announcements


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.
  • Important: You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server
  • Challenges running continuous Merge agents
  • SQL Server 2014 SP2 – CU #1 fixes
    • https://support.microsoft.com/en-us/kb/3178925
    • Includes the following fixes among others:
      • FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name
      • FIX: SQL Server 2012 failover cluster diagnostic log doesn't accurately reflect the failure_condition_level setting
      • FIX: Incorrect results when you use a LIKE operator and an "ss" wildcard in SQL Server 2014 or 2016
      • FIX: A valid derived column expression may fail in SSIS 2012, 2014 and 2016
    • SQL Server 2014 SP1 – CU #8 fixes
      • https://support.microsoft.com/en-us/kb/3174038
      • Includes the following fixes among others:
        • An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014
        • An error occurs when you use ODBC driver to retrieve sql_variant data in SQL Server 2014
        • SQL Server 2014 crashes because of an access violation error that occurs while it reads data from an event file target
        • Operating system error 32 when you restore a database in SQL Server 2014
        • FIX: Deadlock occurs when you acquire a SCH-M lock and ALTER PARTITION in SQL Server 2014
        • FIX: "Cannot alter column" error after a database is restored to SQL Server
        • FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan
        • Decrease in performance and "non-yielding scheduler" errors caused by unnecessary spinlocks in SQL Server
      • Merge publication snapshot fails with "Script failed" error in SQL Server

Recent Blog Posts and Articles



Windows Server 2016 – Get Started


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