Category : SQL Server Builds - SentryOne Team Blog

Category: SQL Server Builds

Latest Builds of SQL Server 2017

Latest Builds of SQL Server 2017

Find out the build number of each SQL Server 2017 CTP as it is released, discover where to download, and how to get details on new fixes and features.

Latest Builds of SQL Server 2016

Latest Builds of SQL Server 2016

See updated downloads, security fixes, release notes, and observed changes for builds of SQL Server 2016.

Latest Builds of SQL Server 2012

Latest Builds of SQL Server 2012

SQL Server 2012 is now at Service Pack 3. Read this post to see what you should know before deploying.

Latest Builds of SQL Server 2014

Latest Builds of SQL Server 2014

SQL Server 2014 is now at Service Pack 2, with plenty of enhancements back-ported from recent SQL Server 2016 updates.

Pre-Release Builds of SQL Server 2016

We've separated out the now-static info about pre-release SQL Server 2016 builds into its own post, primarily to make maintenance easier and the RTM page lighter.

New SERVERPROPERTY Options to Help Phase Out @@VERSION

Aaron Bertrand (@AaronBertrand) talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).

I have an aversion to @@VERSION

Aaron Bertrand (@AaronBertrand) suggests a different approach to providing more data about service packs and cumulative updates than messing with @@VERSION.

New Vulnerability Affecting SQL Server 2008, 2008 R2, 2012, and 2014

There is a fix to address a remote code execution vulnerability for all supported SQL Server versions. @AaronBertrand shows which build you should install.

Patching Error: No room is available to display rows

Aaron Bertrand (@AaronBertrand) shows a workaround for an obscure error you might receive while patching SQL Server: "No room is available to display rows."

Information about the SQL Server 2014 Service Pack 1 snafu

Updated April 17, 2015 : SQL Server 2014 Service Pack 1 has been released, but was quickly pulled. This post explains why and shows how to fix any affected instances.

Hotfixes for SQL Server 2008 & 2008 R2

The SQL Server Release Services team has released out-of-band hotfixes for SQL Server 2008 SP4 and SQL Server 2008 R2 SP3.

Critical Fixes for 2012 & 2014 Online Index Rebuilds

Over on SQLPerformance.com, Aaron Bertrand (@AaronBertrand) warns about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds, and offers guidance on what to do depending on your current edition and build level.