SQL Server uses a rather unconventional way to show you its version. If you open SQL Server Management Studio and connect to your database server, you will see something like the number 14.0.3015.40. This is the build number of your SQL Server version, but how do you translate this into a SQL Server version like SQL Server 2017 Cumulative update 15 (CU15)?
The site Microsoft SQL Server Versions List by @SqlServerBuilds collected a very extensive list of all versions of SQL Server. This site will answer all your questions about those build numbers and how they relate to SQL Server versions. It is an unofficial site, but it offers the most comprehensive collection I know about.
The next time you need to know what version you run, you should directly go to SqlServerBuilds and skip the attempt to find this information on Microsoft.com.
1 thought on “Little SQL Server Tricks: What Does This Build Number Mean?”