SQL Server build and update nomenclature

SQL Server build and update nomenclature

SQL Server build and update nomenclature is more complex than anyone would like.

Release Candidate (RC) is the Beta version of a release and should not be used in production.

Release to Manufacture (RTM) is the Initial production release after RC (Beta) version.

General Distribution Release (GDR) is a kind of hotfix or patch that contains specific fixes and is intended for installation on all SQL instances. It addresses an issue that has a broad customer impact, security implications, or both. If you want to apply only security updates, stay on GDR releases. If you want to get additional fixes, use CU releases.

Service Packs (SP) Prior to SQL Server 2017 Microsoft distributed fixes in Service Packs. Service Packs include hotfixes and fixes to issues that are reported through the Microsoft SQL Server community. Service Packs may also include issues that Microsoft’s? support organization feels must be addressed. SQL Server 2017 and later versions no longer receive Service Packs.

Cumulative Update (CU) is a collection of hot fixes released after Service Pack (prior to SQL Server 2017). Starting with SQL Server 2017 all updates are addressed by CUs or GDRs. A CU contains all previous hotfixes to date and includes both security fixes and functional fixes.

要查看或添加评论,请登录

Robert Cantor的更多文章

  • What Should Your Maxdop Setting Be?

    What Should Your Maxdop Setting Be?

    /* "max degree of parallelism" Starting with SQL Server 2016 (13.x) https://learn.

  • The Trouble with Tribbles if Tribbles were Heap Tables

    The Trouble with Tribbles if Tribbles were Heap Tables

    A Heap is a table without a clustered index and because of that is generally more optimized for inserts and so, are…

  • Database Roles Users and Permissions

    Database Roles Users and Permissions

    There are lots of scripts to display Database Users Roles and Permissions but this is a script that I like: /* Roles…

  • Are these the Backups we are looking for?

    Are these the Backups we are looking for?

    If you have ever been a Contractor or Consultant you may have been in the situation where SQL Server can access the…

  • How Healthy is my Replication?

    How Healthy is my Replication?

    How Healthy is my Replication? SQL Server Replication is a technology increasingly falling out of favor especially with…

  • Porting Legacy Code to SQL 2017

    Porting Legacy Code to SQL 2017

    Not too long ago I migrated a client from SQL Server 2012 to 2017. As part of that task I had to port a lot of legacy…

    7 条评论
  • MaxDop Recommendations and Initial Settings

    MaxDop Recommendations and Initial Settings

    * Note: This was written in 2019 and Microsoft guidance on MaxDop changes over time and especially with major version…

  • Common TSQL Problems

    Common TSQL Problems

    Common TSQL Problems, a couple of which are, why do people think it is easy to write performant TSQL code. And, why do…

  • DB Mirroring

    DB Mirroring

    SQL Browser being started is an undocumented prerequisite for DB Mirroring particularly if you use named instances; who…

社区洞察

其他会员也浏览了