Latest Builds of SQL Server 2016 - SentryOne Team Blog

Latest Builds of SQL Server 2016

Service Pack 1 Branch

Service Pack 1 was released on November 16th, 2016, with a build number of 13.0.4001.0, and 33 total fixes and enhancements publicized in KB #3182545.

Download Service Pack 1 here

The Big News
  1. Many Enterprise Edition features have been opened up across all editions, creating a more consistent programming surface area. See A Big Deal : SQL Server 2016 Service Pack 1.
     
  2. More than a dozen new features have been added, including CREATE OR ALTER, USE HINT syntax, and many new diagnostic capabilities. See New Features in SQL Server 2016 Service Pack 1.
A few questions

The following questions have come up since SP1 was released:

  • Does it include the MSVCRT fix from post-RTM? Yes. If you apply SP1 after installation or using slipstream, you do not have to apply the MSVCRT update separately.
  • Does it include MS16-136? Yes. The security bulletin from earlier this month is in SP1, even if the bulletin and the SP1 article don't say so explicitly.
  • Does it include everything in RTM Cumulative Update #3? Yes.
A few words of warning

A couple of observations you'll want to keep in mind:

  • SP1 produces a new ShowPlan schema, so trying to open plans by double-clicking an XML column in a grid result might lead to an XML document as opposed to a graphical plan. To work around this, you can install the SSMS 17.0 RC1 and either (a) use the RC for your cache-diving or (b) copy the ShowPlanXML.XSD from the 17.0 installation path into the 16.x path. These paths are typically going to be:
    New (17.0)
    %Program Files%\Microsoft SQL Server\140\Tools\Binn\schemas\sqlserver\2004\07\showplan\

    Old (16.x)
    %Program Files%\Microsoft SQL Server\130\Tools\Binn\schemas\sqlserver\2004\07\showplan\

  • In their blog post, Microsoft recommends planning for a reboot after the SP1 installation (this likely depends on which features and components you have installed).

Finally, you can always download the latest Cumulative Update for SP1 from the Download Center. If you want older updates, check the Microsoft Update Catalog.

Builds
Label Build # Release Date Build Date Fixes (Public)
Cumulative Update #4    13.0.4446.0       2017-08-08    2017-07-16 63 (49)
Cumulative Update #3    13.0.4435.0       2017-05-15    2017-04-27 70 (57)
Cumulative Update #2    13.0.4422.0       2017-03-20    2017-03-06 117 (100)
Cumulative Update #1    13.0.4411.0       2017-01-18    2017-01-06 63 (55)
SP1 GDR builds below – for non-CU path
Security Bulletin CVE-2017-8516
KB #4019089 (GDR)
   13.0.4206.0       2017-07-16    ? 1 (1)
COD Hotfix 3210089
(GDR – MDS Update)
   13.0.4202       2016-12-16    2016-12-13 3 (3)
COD Hotfix 3207512
(GDR – SSRS Update)
   13.0.4199       2016-11-23    2016-11-18 2 (2)
Service Pack 1    13.0.4001       2016-11-16    2016-10-28 33 (33)

Here are the latest results of PRINT @@VERSION;:

Microsoft SQL Server 2016 (SP1-CU4) (KB4024305) – 13.0.4446.0 (X64)
    Jul 16 2017 18:08:49
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows …
Other articles

Other articles about this exciting release:

 

RTM Branch

SQL Server 2016 RTM was released on June 1st, 2016, with a build number of 13.0.1601.5.

See the announcement posts here and here, a 10-minute Channel 9 video here, and the updated edition feature comparison here.

The latest Cumulative Update can always be obtained from the Download Center (older builds can be obtained from the Microsoft Update Catalog).

Label Build # Release Date Build Date Fixes (Public)
Cumulative Update #7    13.0.2210.0       2017-08-08    2017-07-16 33 (30)
Cumulative Update #6    13.0.2204.0       2017-05-15    2017-04-20 28 (22)
Cumulative Update #5    13.0.2197.0       2017-03-20    2017-02-25 56 (47)
Cumulative Update #4    13.0.2193.0       2017-01-18    2017-01-06 65 (57)
COD Hotfix for CU3 (MDS)    13.0.2190.2       2016-12-16    2016-12-13 3 (3)
Cumulative Update #3
Security Bulletin MS16-136
KB #3194717
   13.0.2186.6       2016-11-08    2016-10-31 31 (31)
To try to explain here, CU3 was officially released on November 16th, but the security update that was released on November 8th actually already included all of the fixes in the CU. So it doesn't really matter where you get this build, it will update you to the latest. Trying to install CU3 over MS16-136 won't work.
COD Hotfix 3199171    13.0.2170.0       2016-11-01    2016-10-11 4 (4)
COD Hotfix 3195813    13.0.2169.0       2016-10-26    2016-10-05 4 (4)
Cumulative Update #2    13.0.2164.0       2016-09-22    2016-09-09 68 (64)
Cumulative Update #1    13.0.2149.0       2016-07-25    2016-07-11 192 (146)
Three big questions come from this CU release.

  1. Does it include the MSVCRT GDR fix?
    Yes, I have confirmation from the SQL Server team that the GDR fix from KB #3164398 is included, even though it is not currently listed in the KB article.
     
  2. Why are there fixes that seem to apply to SSMS?
    Right, SSMS is separate, so updates to it shouldn't be included in an engine CU. However, keep in mind that the CU applies to other parts of the system besides the engine, like shared components. Some fixes, for example, apply to underlying SSIS components and other binaries used by things like maintenance plans, and may need to be maintained independent of a local copy of SSMS (if one even exists).
     
  3. Why are there both x64 and x86 packages?
    As above, while there is no x86 engine, fixes can apply to a variety of shared components on the machine (including from the feature pack), and I suppose it's possible that those could be installed in isolation on an x86 machine. It is almost certainly the case that if you have installed SQL Server 2016, you should be applying the x64 CU, and only the x64 CU. I will update this space if I get further clarification about this.

Also, some people seem to have an issue getting their browser to properly display the download overlay, where they can choose the x64 and/or the x86 file; instead they get redirected to the confirmation page with no prompt to download. I suggest either using a different browser or a direct link: x64 | x86

RTM & GDR builds below – for non-CU path
Security Bulletin CVE-2017-8516
KB #4019088 (GDR)
   13.0.1742.0       2017-07-16    ? 1 (1)
GDR Update (MDS)    13.0.1728.2       2016-12-16    2016-12-13 3 (3)
Security Bulletin MS16-136
KB #3194716
   13.0.1722.0       2016-11-08    2016-10-31 1 (1)
MSVCRT GDR
(KB #3164398)
   13.0.1708.0       2016-06-04    2016-06-02  
RTM    13.0.1601.5       2016-06-01    2016-04-29 N/A

Most recent @@VERSION:

Microsoft SQL Server 2016 (RTM-CU7) (KB4024304) – 13.0.2210.0 (X64)
    Jul 16 2017 17:56:09
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows …

 

Where to Download

You can download SQL Server 2016 from TechNet Evaluation Center, MSDN Subscriber Downloads, Visual Studio Dev Essentials, or your own Volume License server(s). If you are looking for the now free Developer Edition specifically, see this recent post, "Where do I get Developer Edition?"

 

SQL Server Management Studio

In the spirit of the separate release of Management Studio, we've moved information about new builds (along with SSDT) to a separate page.

 

Feature Pack

There is an updated build of the SQL Server 2016 Feature Pack for Service Pack 1, available here.

 

Pre-Release Builds

Looking for information about the betas (CTPs and RCs)? We've moved that information, too.

Comments ( 36 )

                          • Federico P. says:

                            Probably a mix of all of that !! :)
                            But only one thing is important at the end of the story: a lot of improvements with this release !! :)

                          • Federico P. says:

                            SP1 only five months later RTM release ?!?
                            At least unusual, what's happened ?

                          • Aaron Bertrand says:

                            I guess you missed the Connect() keynote,, all the new features they added, and the change they made to how SKUs work for many programmability features?

                            You're right, typically, Service Packs come out roughly a year after initial release, give or take. You could speculate a number of reasons behind this fast-tracked release.

                            • They wanted to announce this SKU change and the new features along with other exciting announcements, like the first public CTP of v.Next, to get maximum eyeballs during Connect().
                            • They got sick of people complaining for a year after previous releases that service pack 1 isn't out yet.
                            • They wanted to eliminate the argument people make that they won't upgrade to a new release until SP1 is out (a lame argument in general, IMHO).
                            • Standard Edition sales may be slumping – why not do something dramatic that will punch it in the gut this year instead of waiting until next June?
                          • Federico P. says:

                            I found a new hotfix, KB3199171 (https://support.microsoft.com/en-us/kb/3199171), dated 1 november, that contains other 4 fixes and reported as elevating to version 13.0.2170 …

                            Take a look!

                          • Aaron Bertrand says:

                            Thanks, I've updated that info too. Looks like they're cleaning it up, though KB 3197952 still has an out-of-place download button.

                          • Federico P. says:

                            No Aaron, i read it on Microsoft's KB pages like you, i didn't download it. The only one i had personally downloaded (via microsoft email) is KB3195813 (13.0.2169).

                            Actually, as far as i understand, the situation is:

                            KB3195813: Only one effectively downlodable, contains 4 fix (KB3195901, KB3189855, KB3195825, KB3197952) and raise version to 13.0.2169

                            KB3195901 / KB3189855: Microsoft says that "After you apply this hotfix, the SQL Server version is 13.0.2170.0" but there is no download button, only a link to KB3195813

                            KB3195825: Microsoft don't say anything about version level, and provide only a link to KB3195813

                            KB3197952: Microsoft says that "After you apply this hotfix, the SQL Server version is 13.0.2170.0", provide a non-working download button AND a link to KB3195813

                            Weird and ugly!!

                            Anyway, at the end of the story, i think that the right (and actually only) choice is to install KB3195813 (13.0.2169) and ignore anything else, or even better wait for CU3.

                            If you can get some clarification from MS please share with us, i'm curious! :)
                            Thank you, also for this useful blog!! :)

                          • Federico P. says:

                            Hi.. someone knows why hotfix 3195813 elevate version level at 13.0.2169, but three of four fix included (3195901, 3189855 and the only one listed above 3197952) elevate version level at 13.0.2170 ?

                            Is not a little bit confusing ?

                            (for example if i install only one of these fix i see an higher version -13.0.2170- , but i have online only one of these 3-4 fix)

                          • Aaron Bertrand says:

                            I've actually already got in a request about this and hope to provide an update soon.

                            But, which hotfix were you able to download to get you to 2170? This one *says* there is a download available, but if you click through, you can't get to it. The other three fixes didn't even have a download button when I checked.

                          • Craig says:

                            Any idea where the CU2 R install files are? For offline patching.

                          • Aaron Bertrand says:

                            Hmm, I don't know that there are separate files for that. Are you sure there were updates that affected any of the R components specifically?

                          • Salvador Lancaster says:

                            We use Event Notifications to collect DDL events in a centralized server using the service broker on the audited servers. It all exploded as soon as I installed CU2.

                            The error message that is thrown to the incoming connection is:
                            "An error occurred while receiving data: '24(The program issued a command but the command length is incorrect.)'."

                            The remote server generates a logs entry with:
                            "An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8474, State: 11. (Near endpoint role: Initiator, far endpoint address: '0.0.0.0')" (IP address changed).

                            I went ahead and uninstalled the CU and it all went back to normal right away.

                          • Selvaraju Uthirapathy says:

                            I know Datazen is been implemented in 2016 Reporting services. One of challenge in Datazen, it doesnt give a feature to download KPI in Excel or PDF. Can you please confirm 2016 has this feature to download KPI dashboard in excel or PDF. One of the Microsoft resource mentioned that it will be getting added in a post-RTM release of the product. But, still now this feature is not available.

                          • Aaron Bertrand says:

                            Sorry Selvaraju, I don't know anything about Datazen, and wouldn't know who to ask. I didn't see anything about it explicitly in either of these Cumulative Updates, but I wasn't watching for it, either…

                          • marisk says:

                            SSMS restore database task doesn't work. Moving a .bak file to different locations generates different errors : ranging from permission denied exceptions to 'cannot find Table 0' to simply not appearing in the GUI selector for the file.

                            The SSMS version is the latest July 2016 Hotfix.

                            SSMS is run as Administrator on both a Win Server 2012 R2 and Win 8.1. Owner of the .bak files is Adminstrator with Full Control.

                            Please advise.

                            marisk

                          • Chris Wood says:

                            A small bug that I raised connect incident 2979531 on. If you install R services it creates number of local Windows accounts. If you uninstall R services and try and re-install it will complain over the fact the account already exist. In my case I was taking a server from RC2, I uninstalled SQL2016, to RTM to CU1. I had to remove in my case the 20 local accounts created before I could install R services.

                          • Jonathan Jones says:

                            Did Intellisence get fixed in SSMS 2016?

                            What bugs me most day-to-day in 2012/2014 is how messed up Intellisense got. It stopped working across VPN's and no longer showed field lengths/properties with the Data Types (for example in 2012/2014 it will say "NVARCHAR" but not "NVARCHAR(70)") I hope 2016 has brought back Intellisense Sanity.

                          • Aaron Bertrand says:

                            Hi Jonathan, if you have a slow VPN then, yeah, as IntelliSense tries to pull more data, I would expect it to behave erratically (perhaps more data for internal reasons, perhaps more data because your metadata got larger, perhaps because they tightened up the timeouts, perhaps a combination).

                            I'm not sure I understand your second comment. Could you show an example of this nvarchar vs. nvarchar(50)? Where exactly are you seeing this difference? Some of that may not be IntelliSense's fault directly – much of the information is derived from elsewhere, e.g. how it describes/defines a function. SERVERPROPERTY, for example, says property_name is varchar(1), but we all know that's incorrect.

                          • Richard Chambers says:

                            I've created a simple visual guide – with links to more technical topics – all about SQL Server 2016 here:
                            http://www.xynomix.com/microsoft-sql-server-2016-what-are-new-features

                          • Heiko says:

                            What is with backup and restore, can we use DPM 2012 R2 ?

                          • Aaron Bertrand says:

                            Not sure I understand the question in the context of this post. Are you asking if you can use DPM to backup a database and restore it to SQL Server 2016?

                          • Peter says:

                            Update Rollup 4 for System Center 2012 R2 Data Protection Manager came with suport for SQL Server 2014 but I can't find any new on the status for DPM support for SQL Server 2016. Is there support for it?

                          • Edmond says:

                            Hello, I know this question might be a little uncertain but I you were to gamble when in the future do you think would be the RTM release date. How much time longer would be good to wait. The reason for this question is that I am about to migrate around 70 production SQL databases to new servers and since is needed to make a downtime. I was thinking it would be a good idea to install and migrate everything to SQL Server 2016 RTM at once instead of using SQL Server 2014 SP1 and upgrading later sometime in the future, that's only if the release date is no longer than three weeks from now.

                          • Aaron Bertrand says:

                            My guess is it will be sooner than that, but please, do not make business decisions based on guesses. Ever.

                          • Jacob Golden says:

                            Have you gotten any feedback from them when we might expect the Power BI on-premise integrations with SSRS to be released? Whether that is something on the roadmap for a future SP or whatever the case may be?

                          • Aaron Bertrand says:

                            Have not heard anything about that, sorry.

                          • Jacob Golden says:

                            I'm having a bit of an issue trying to upgrade CTP 3.2 to CTP 3.3. I open the setup program, go to Installation, select "Upgrade from a previous version…" and run through the rules, selecting the default instance. All of the features get auto checked, which his good…but when I click next and it goes to the Instance Configuration page, it greys out the top options and automatically puts in a new Instance ID of MSSQLSERVER1000 and puts that into a new C:\ path instead of using the currently installed path. So even doing the upgrade, it seems to want to install a side by side version instead of doing an in-place upgrade. Did I miss any documentation saying that you can't do in-place upgrades on the CTP versions or is there something I need to do to make this work?

                          • Aaron Bertrand says:

                            Jacob, sorry, I haven't come across that issue, my upgrades have been smooth. However, in almost every case, I have performed a side-by-side install. I just find that it's easier and cleaner to do it that way; I don't really gain anything by upgrading a test evaluation instance.

                          • Matt Johnson says:

                            Regarding AT TIME ZONE and your notes "… So, it is still an incomplete solution, because you need to know whether to declare the destination time zone as standard or daylight… "

                            That is incorrect. The time zone string specified such as "Pacific Standard Time" is the ID for the time zone. It applies to the entire Pacific time zone, including PST and PDT. In other words, you do not need to pre-determine if DST is in effect and pass "Pacific Daylight Time". That actually wouldn't work, since "Pacific Daylight Time" is not a Windows time zone ID.

                            Basically, these are the same IDs used by .NET's TimeZoneInfo object, and can also be found in the registry or via tzutil.exe.

                            Windows time zone names are a common source of confusion. Read the section titled "The Microsoft Time Zone Database" in this article: http://stackoverflow.com/tags/timezone/info

                          • Aaron Bertrand says:

                            Thanks Matt, I stand corrected. I knew that the daylight variations were not Windows time zones, but I didn't test the output for both a date in DST and a date outside of it. I only played with it for a few minutes before posting, it just seemed from the DMV that is_currently_dst would somehow be used to determine whether to apply a DST shift. I'm quite happy to learn it's more intelligent than that.

                          • Aaron Bertrand says:

                            I think you may be over-reacting about one isolated case, two months ago, where a user somehow managed to install CTP 2.1 on an operating system that SQL Server 2016 does not officially support, and should have installed on a VM or test machine rather than his primary workstation (which is what most people do with betas anyway). If you contrast all of those facts with the number of people who can't uninstall official Evaluation Edition releases (see the comments on this post), I don't think there is any need for widespread panic about a beta.

                          • Jon R says:

                            Well, it's a beta. If you install ANY beta software on a server that matters, more the fool you. You can't blame Microsoft or any other company for a product that is clearly labelled as such. So panic away, but don't tell anyone what a dimwit you are :)

                          • Manish says:

                            I have found a quick workaround for the same and you can read more about it at
                            http://manishku.blogspot.co.uk/2015/08/master-data-services-2016-ctp-22.html

                          • Manish says:

                            There is a problem in SQL Server 2016 CTP 2.2 with Master Data Services. Explorer is deactivated. You can create a model and entity but you can't explore data. Also in home page I am able to select the model but not the Version as it is always appears to be empty. The strange thing is that I am able to select the Versions through Version Management as well as from Integration Management.

                          • Chris Wood says:

                            The 2.2 problem appears to be fixed.

                            UPDATE: The issue with the initial release SQL Server 2016 CTP 2.2 that caused downtime during rolling upgrades across an AlwaysOn Availability Group has been corrected, and the download replaced. The download link now points to an updated build of 13.0.407.1 or higher. An upgrade to this build is recommended for all users of SQL Server 2016, including AlwaysOn users. For more information, visit the CTP 2.2 Release Note.

                          • Chris Wood says:

                            From the SQL Server Blog http://blogs.technet.com/b/dataplatforminsider/archive/2015/07/22/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available.aspx

                            UPDATE: There is an issue with the SQL Server 2016 CTP 2.2 release that causes downtime during rolling upgrades across an AlwaysOn Availability Group. If you are not using AlwaysOn, you will not experience the issue. We recommend that AlwaysOn users not upgrade to CTP 2.2 at this time. A replacement build of SQL Server 2016 CTP 2.2 is in process and will be available soon. For more information, visit the CTP 2.2 Release Note.

                            Chris

                          Leave A Comment

                          Your email address will not be published.