Skip to main content

What is SQL Server?


Microsoft SQL Server Logo
SQL Server

SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL.


Why SQL Server?

Microsoft SQL Server is a comprehensive database server and information platform offering a complete set of enterprise-ready technologies and tools that help people derive the most value from information at the lowest total-cost-of-ownership. Enjoy high levels of performance, availability, and security; employ more productive management and development tools; and deliver pervasive insight with self-service business intelligence (BI).

A complete and integrated platform, Microsoft SQL Server brings it all together to get more value out of existing IT skills and assets, increase the productivity and agility of IT departments, and quickly build flexible, innovative applications.

SQL Server works exclusively on Windows environment for more than 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in October 2016 that ran on both Windows and Linux.

SQL Server Architecture

SQL Server Architecture


SQL Server Architecture

The diagram above gives you an overview of what the SQL Server architecture looks like. There are 3 important items here:

  1. Database Engine: Performs the storage and query processing tasks
  2. SQL Operating System: Works on I/O and other higher level management tasks
  3. Interfaces: The External Protocols and SQL Operating System API connect the dots

The Database engine is the heart of Microsoft SQL Server. Think of it as the engine of a motorcycle, it is the part where the real stuff happens. It contains 2 major components:

  • Query processor: Parses, optimizes and executes the query
  • Storage engine: Manages buffer and access methods


SQL Server Editions

Free editions

Express

Express edition is a free lightweight/lite edition of SQL Server with some limitations, which can be used in production environment.
Limitations:
• Limited to lesser of 1 physical CPU or 4 cores.
• No single database (.MDF file) can be over 10 GB.
Download SQL2019 Express Edition
Download SQL2017 Express Edition

Developer

Developer edition is a fully-functional Enterprise Edition of SQL Server, licensed for use as a development and test database in a non-production environment.
Download SQL2019 Developer Edition
Download SQL2017 Developer Edition

Evaluation

Evaluation edition is a fully-functional trial Enterprise Edition of SQL Server but is limited to 180 days, after which the tools will continue to run, but the server services will stop.
Download SQL2019 Evaluation Edition
Download SQL2017 Evaluation Edition

Paid Editions

Enterprise

Enterprise edition is the top-end edition with a full feature set.

Enterprise Core

Enterprise edition with the Core-based Licensing. The plain Enterprise one is limited to just 20 CPU cores.

Standard

Standard edition has less features than Enterprise, when there is no requirement of advanced features.

Azure SQL Database

Azure SQL Database is the cloud-based version of SQL Server, presented as a platform as a service (PaaS) offering on Microsoft Azure.

Specialized Editions

Web

Web edition is a low total-cost-of-ownership option for Web hosters.

Business Intelligence

Business Intelligence edition includes the Standard Edition capabilities and Business Intelligence tools.

Analytics Platform System (APS)

Formerly Parallel Data Warehouse (PDW). A massively parallel processing (MPP) SQL Server appliance optimized for large-scale data warehousing such as hundreds of terabytes.

Big Data Clusters (BDC)

Starting with SQL Server 2019, SQL Server Big Data Clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS (Hadoop Distributed File System) containers running on Kubernetes.

LocalDB

SQL Server Express LocalDB is a lightweight version of Express that has all of its programmability features, runs in user mode and has a fast, zero-configuration installation and a short list of prerequisites.

Discontinued Editions

MSDE

Microsoft Data Engine or Microsoft Desktop Engine. Express edition predecessor.

Personal

Express edition predecessor.

Compact

Embedded database.

Workgroup

Cheaper version of the Standard edition with some limitations.

Datacenter

Datacenter edition was a full-featured edition of SQL Server and was designed for datacentre’s that need high levels of application support and scalability.


SQL Server Version List

SQL Server Version

Version No.

Latest CU

CU Released Date

SQL Server 2019
SQL Server 15
Codename: Seattle
Support end date: 07-Jan-2025
Ext. end date: 08-Jan-2030

15.0.2000.5

CU7 

(15.0.4063.15, September 2020)

 

SQL Server 2017
SQL Server 14
Codename: Helsinki
Support end date: 11-Oct-2022
Ext. end date: 12-Oct-2027

14.0.1000.169

CU21 

(14.0.3335.7, July 2020)

 

*Starting from SQL Server 2017 Service Packs will no longer be released

SQL Server Version

Version No.

SP1

SP2

SP3

SP4

SQL Server 2016
SQL Server 13
Codename: SQL16
Support end date: 13-Jul-2021
Ext. end date: 14-Jul-2026

13.0.1601.5

13.0.4001.0
or 13.1.4001.0
+ CU15

13.0.5026.0
or 13.2.5026.0
+ CU14

 

 

SQL Server 2014
SQL Server 12
Codename: SQL14
Support end date: 09-Jul-2019
Ext. end date: 09-Jul-2024

12.0.2000.8

12.0.4100.1
or 12.1.4100.1
+ CU13

12.0.5000.0
or 12.2.5000.0
+ CU18

12.0.6024.0
or 12.3.6024.0
+ CU4

 

SQL Server 2012
SQL Server 11
Codename: Denali
Support end date: 11-Jul-2017
Ext. end date: 12-Jul-2022

11.0.2100.60

11.0.3000.0
or 11.1.3000.0
+ CU16

11.0.5058.0
or 11.2.5058.0
+ CU16

11.0.6020.0
or 11.3.6020.0
+ CU10

11.0.7001.0
or 11.4.7001.0

Following Versions are Out of Support

SQL Server 2008 R2
SQL Server 10.5
Codename: Kilimanjaro
Support end date: 08-Jul-2014
Ext. end date: 09-Jul-2019

10.50.1600.1

10.50.2500.0
or 10.51.2500.0

10.50.4000.0
or 10.52.4000.0

10.50.6000.34
or 10.53.6000.34

 

SQL Server 2008
SQL Server 10
Codename: Katmai
Support end date: 08-Jul-2014
Ext. end date: 09-Jul-2019

10.0.1600.22

10.0.2531.0
or 10.1.2531.0

10.0.4000.0
or 10.2.4000.0

10.0.5500.0
or 10.3.5500.0

10.0.6000.29
or 10.4.6000.29

SQL Server 2005
SQL Server 9
Codename: Yukon
Support end date: 12-Apr-2011
Ext. end date: 12-Apr-2016

9.0.1399.06

9.0.2047

9.0.3042

9.0.4035

9.0.5000

SQL Server 2000
SQL Server 8
Codename: Shiloh
Support end date: 08-Apr-2008
Ext. end date: 09-Apr-2013

8.0.194

8.0.384

8.0.532

8.0.760

8.0.2039

SQL Server 7.0
SQL Server 7
Codename: Sphinx
Support end date: 31-Dec-2005
Ext. end date: 11-Jan-2011

7.0.623

7.0.699

7.0.842

7.0.961

7.0.1063

SQL Server 6.5
SQL Server 6.50
Codename: Hydra
Support end date: 01-Jan-2002

6.50.201

6.50.213

 6.50.240

6.50.258

SP4 6.50.281
SP5 6.50.416

SQL Server 6.0
SQL Server 6
Codename: SQL95
Support end date: 31-Mar-1999

6.00.121

6.00.124

6.00.139

6.00.151

 


SQL Server Builds

Build

File version

KB / Description

Release Date

Microsoft SQL Server 2019 Builds

15.0.4063.15

2019.150.4063.15

4570012 Cumulative update 7 (CU7) for SQL Server 2019  Latest CU

02-Sep-20

15.0.4053.23

2019.150.4053.23

4563110 Cumulative update 6 (CU6) for SQL Server 2019

04-Aug-20

15.0.4043.16

2019.150.4043.16

4552255 Cumulative update 5 (CU5) for SQL Server 2019

22-Jun-20

15.0.4033.1

2019.150.4033.1

4548597 Cumulative update 4 (CU4) for SQL Server 2019

31-Mar-20

15.0.4023.6

2019.150.4023.6

4538853 Cumulative update 3 (CU3) for SQL Server 2019

12-Mar-20

15.0.4013.40

2019.150.4013.40

Withdrawn 4536075 Cumulative update 2 (CU2) for SQL Server 2019

13-Feb-20

15.0.4003.23

2019.150.4003.23

4527376 Cumulative update 1 (CU1) for SQL Server 2019

07-Jan-20

15.0.2070.41

2019.150.2070.41

4517790 Servicing Update (GDR1) for SQL Server 2019 RTM

04-Nov-19

15.0.2000.5

2019.150.2000.5

Microsoft SQL Server 2019 RTM  RTM

04-Nov-19

Microsoft SQL Server 2017 Builds

14.0.3356.20

2017.140.3356.20

4577467 Cumulative update 22 (CU22) for SQL Server 2017  Preparing

Sep-20

14.0.3335.7

2017.140.3335.7

4557397 Cumulative update 21 (CU21) for SQL Server 2017  Latest CU

01-Jul-20

14.0.3294.2

2017.140.3294.2

4541283 Cumulative update 20 (CU20) for SQL Server 2017

07-Apr-20

14.0.3281.6

2017.140.3281.6

4535007 Cumulative update 19 (CU19) for SQL Server 2017

05-Feb-20

14.0.3257.3

2017.140.3257.3

4527377 Cumulative update 18 (CU18) for SQL Server 2017

09-Dec-19

14.0.3238.1

2017.140.3238.1

4515579 Cumulative update 17 (CU17) for SQL Server 2017

08-Oct-19

14.0.3223.3

2017.140.3223.3

4508218 Cumulative update 16 (CU16) for SQL Server 2017

01-Aug-19

14.0.3208.1

2017.140.3208.1

4510083 On-demand hotfix update package 2 for SQL Server 2017 Cumulative update 15 (CU15)

09-Jul-19

14.0.3192.2

2017.140.3192.2

4505225 Security update for SQL Server 2017 CU15 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

14.0.3164.1

2017.140.3164.1

4506633 On-demand hotfix update package for SQL Server 2017 Cumulative update 15 (CU15)

20-Jun-19

14.0.3162.1

2017.140.3162.1

4498951 Cumulative update 15 (CU15) for SQL Server 2017

24-May-19

14.0.3103.1

2017.140.3103.1

4494352 Security update for SQL Server 2017 Cumulative update 14 (CU14): May 14, 2019  CVE-2019-0819

14-May-19

14.0.3076.1

2017.140.3076.1

4484710 Cumulative update 14 (CU14) for SQL Server 2017

25-Mar-19

14.0.3049.1

2017.140.3049.1

4483666 On-demand hotfix update package for SQL Server 2017 Cumulative update 13 (CU13)

08-Jan-19

14.0.3048.4

2017.140.3048.4

4466404 Cumulative update 13 (CU13) for SQL Server 2017

18-Dec-18

14.0.3045.24

2017.140.3045.24

4464082 Cumulative update 12 (CU12) for SQL Server 2017

24-Oct-18

14.0.3038.14

2017.140.3038.14

4462262 Cumulative update 11 (CU11) for SQL Server 2017

21-Sep-18

14.0.3037.1

2017.140.3037.1

4342123 Cumulative update 10 (CU10) for SQL Server 2017

27-Aug-18

14.0.3035.2

2017.140.3035.2

4293805 Security update for the Remote Code Execution vulnerability in SQL Server 2017 CU: August 14, 2018  CVE-2018-8273

14-Aug-18

14.0.3030.27

2017.140.3030.27

4341265 Cumulative update 9 (CU9) for SQL Server 2017

18-Jul-18

14.0.3029.16

2017.140.3029.16

4338363 Cumulative update 8 (CU8) for SQL Server 2017

21-Jun-18

14.0.3026.27

2017.140.3026.27

4229789 Cumulative update 7 (CU7) for SQL Server 2017

23-May-18

14.0.3025.34

2017.140.3025.34

4101464 Cumulative update 6 (CU6) for SQL Server 2017

19-Apr-18

14.0.3023.8

2017.140.3023.8

4092643 Cumulative update 5 (CU5) for SQL Server 2017

20-Mar-18

14.0.3022.28

2017.140.3022.28

4056498 Cumulative update 4 (CU4) for SQL Server 2017

17-Feb-18

14.0.3015.40

2017.140.3015.40

4052987 Cumulative update 3 (CU3) for SQL Server 2017 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

04-Jan-18

14.0.3008.27

2017.140.3008.27

4052574 Cumulative update 2 (CU2) for SQL Server 2017

28-Nov-17

14.0.3006.16

2017.140.3006.16

4038634 Cumulative update 1 (CU1) for SQL Server 2017

23-Oct-17

14.0.2027.2

2017.140.2027.2

4505224 Security update for SQL Server 2017 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

14.0.2014.14

2017.140.2014.14

4494351 Security update for SQL Server 2017 GDR: May 14, 2019  CVE-2019-0819

14-May-19

14.0.2002.14

2017.140.2002.14

4293803 Security update for the Remote Code Execution vulnerability in SQL Server 2017 GDR: August 14, 2018  CVE-2018-8273

14-Aug-18

14.0.2000.63

2017.140.2000.63

4057122 Security update for SQL Server 2017 GDR: January 3, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

03-Jan-18

14.0.1000.169

2017.140.1000.169

Microsoft SQL Server 2017 RTM  RTM

02-Oct-17

Microsoft SQL Server 2016 Builds

13.0.5830.85

2015.131.5830.85

4564903 Cumulative update 14 (CU14) for SQL Server 2016 Service Pack 2  Latest CU

06-Aug-20

13.0.5820.21

2015.131.5820.21

4549825 Cumulative update 13 (CU13) for SQL Server 2016 Service Pack 2

28-May-20

13.0.5698.0

2015.131.5698.0

4536648 Cumulative update 12 (CU12) for SQL Server 2016 Service Pack 2

25-Feb-20

13.0.5622.0

2015.131.5622.0

4535706 Security update for SQL Server 2016 SP2 CU11: February 11, 2020  CVE-2019-1332 CVE-2020-0618

11-Feb-20

13.0.5598.27

2015.131.5598.27

4527378 Cumulative update 11 (CU11) for SQL Server 2016 Service Pack 2

09-Dec-19

13.0.5492.2

2015.131.5492.2

4524334 Cumulative update 10 (CU10) for SQL Server 2016 Service Pack 2

08-Oct-19

13.0.5479.0

2015.131.5479.0

4515435 Cumulative update 9 (CU9) for SQL Server 2016 Service Pack 2 (Withdrawn)

30-Sep-19

13.0.5426.0

2015.131.5426.0

4505830 Cumulative update 8 (CU8) for SQL Server 2016 Service Pack 2

31-Jul-19

13.0.5382.0

2015.131.5382.0

4510807 On-demand hotfix update package 2 for SQL Server 2016 Service Pack 2 (SP2) Cumulative update 7 (CU7)

09-Jul-19

13.0.5366.0

2015.131.5366.0

4505222 Security update for SQL Server 2016 SP2 CU7 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

13.0.5343.1

2015.131.5343.1

4508636 On-demand hotfix update package for SQL Server 2016 Service Pack 2 (SP2) Cumulative update 7 (CU7)

24-Jun-19

13.0.5337.0

2015.131.5337.0

4495256 Cumulative update 7 (CU7) for SQL Server 2016 Service Pack 2

22-May-19

13.0.5292.0

2015.131.5292.0

4488536 Cumulative update 6 (CU6) for SQL Server 2016 Service Pack 2

19-Mar-19

13.0.5270.0

2015.131.5270.0

4490133 On-demand hotfix update package for SQL Server 2016 SP2 CU5

14-Feb-19

13.0.5264.1

2015.131.5264.1

4475776 Cumulative update 5 (CU5) for SQL Server 2016 Service Pack 2

23-Jan-19

13.0.5239.0

2015.131.5239.0

4482972 On-demand hotfix update package 2 for SQL Server 2016 SP2 CU4

21-Dec-18

13.0.5233.0

2015.131.5233.0

4464106 Cumulative update 4 (CU4) for SQL Server 2016 Service Pack 2

13-Nov-18

13.0.5221.0

2015.131.5221.0

4466793 FIX: Assertion error occurs when you restart the SQL Server 2016 database

09-Oct-18

13.0.5221.0

2015.131.5221.0

4466994 FIX: "3414" and "9003" errors and a .pmm log file grows large in SQL Server 2016

09-Oct-18

13.0.5216.0

2015.131.5216.0

4458871 Cumulative update 3 (CU3) for SQL Server 2016 Service Pack 2

21-Sep-18

13.0.5201.2

2015.131.5201.2

4458621 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 CU: August 19, 2018  CVE-2018-8273

19-Aug-18

13.0.5161.0

2015.131.5161.0

Withdrawn 4293807 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 CU: August 14, 2018  CVE-2018-8273

14-Aug-18

13.0.5153.0

2015.131.5153.0

4340355 Cumulative update 2 (CU2) for SQL Server 2016 Service Pack 2

17-Jul-18

13.0.5149.0

2015.131.5149.0

4135048 Cumulative update 1 (CU1) for SQL Server 2016 Service Pack 2

30-May-18

13.0.5102.14

2015.131.5102.14

4532097 Security update for SQL Server 2016 SP2 GDR: February 11, 2020  CVE-2019-1332 CVE-2020-0618

11-Feb-20

13.0.5101.9

2015.131.5101.9

4505220 Security update for SQL Server 2016 SP2 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

13.0.5081.1

2015.131.5081.1

4293802 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP2 GDR: August 14, 2018  CVE-2018-8273

14-Aug-18

13.0.5026.0

2015.131.5026.0

Microsoft SQL Server 2016 Service Pack 2 (SP2)  Latest SP

24-Apr-18

13.0.4604.0

2015.130.4604.0

4505221 Security update for SQL Server 2016 SP1 CU15 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

13.0.4577.0

2015.130.4577.0

4508471 On-demand hotfix update package for SQL Server 2016 Service Pack 1 (SP1) Cumulative update 15 (CU15)

20-Jun-19

13.0.4574.0

2015.130.4574.0

4495257 Cumulative update 15 (CU15) for SQL Server 2016 Service Pack 1

16-May-19

13.0.4560.0

2015.130.4560.0

4488535 Cumulative update 14 (CU14) for SQL Server 2016 Service Pack 1

19-Mar-19

13.0.4550.1

2015.130.4550.1

4475775 Cumulative update 13 (CU13) for SQL Server 2016 Service Pack 1

23-Jan-19

13.0.4541.0

2015.130.4541.0

4464343 Cumulative update 12 (CU12) for SQL Server 2016 Service Pack 1

13-Nov-18

13.0.4531.0

2015.130.4531.0

4465443 FIX: The "modification_counter" in DMV sys.dm_db_stats_properties shows incorrect value when partitions are merged through ALTER PARTITION in SQL Server 2016

27-Sep-18

13.0.4528.0

2015.130.4528.0

4459676 Cumulative update 11 (CU11) for SQL Server 2016 Service Pack 1

18-Sep-18

13.0.4522.0

2015.130.4522.0

4293808 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP1 CU: August 14, 2018  CVE-2018-8273

14-Aug-18

13.0.4514.0

2015.130.4514.0

4341569 Cumulative update 10 (CU10) for SQL Server 2016 Service Pack 1

16-Jul-18

13.0.4502.0

2015.130.4502.0

4100997 Cumulative update 9 (CU9) for SQL Server 2016 Service Pack 1

30-May-18

13.0.4474.0

2015.130.4474.0

4077064 Cumulative update 8 (CU8) for SQL Server 2016 Service Pack 1

19-Mar-18

13.0.4466.4

2015.130.4466.4

4057119 Cumulative update 7 (CU7) for SQL Server 2016 Service Pack 1 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

04-Jan-18

13.0.4457.0

2015.130.4457.0

4037354 Cumulative update 6 (CU6) for SQL Server 2016 Service Pack 1

21-Nov-17

13.0.4451.0

2015.130.4451.0

4040714 Cumulative update 5 (CU5) for SQL Server 2016 Service Pack 1

18-Sep-17

13.0.4446.0

2015.130.4446.0

4024305 Cumulative update 4 (CU4) for SQL Server 2016 Service Pack 1  CVE-2017-8516

08-Aug-17

13.0.4435.0

2015.130.4435.0

4019916 Cumulative update 3 (CU3) for SQL Server 2016 Service Pack 1

15-May-17

13.0.4422.0

2015.130.4422.0

4013106 Cumulative update 2 (CU2) for SQL Server 2016 Service Pack 1

22-Mar-17

13.0.4411.0

2015.130.4411.0

3208177 Cumulative update 1 (CU1) for SQL Server 2016 Service Pack 1

18-Jan-17

13.0.4259.0

2015.130.4259.0

4505219 Security update for SQL Server 2016 SP1 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

13.0.4224.16

2015.130.4224.16

4458842 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP1 GDR: August 22, 2018  CVE-2018-8273

22-Aug-18

13.0.4223.10

2015.130.4223.10

Withdrawn 4293801 Security update for the Remote Code Execution vulnerability in SQL Server 2016 SP1 GDR: August 14, 2018  CVE-2018-8273

14-Aug-18

13.0.4210.6

2015.130.4210.6

4057118 Description of the security update for SQL Server 2016 SP1 GDR: January 3, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

03-Jan-18

13.0.4206.0

2015.130.4206.0

4019089 Security update for SQL Server 2016 Service Pack 1 GDR: August 8, 2017  CVE-2017-8516

08-Aug-17

13.0.4202.2

2015.130.4202.2

3210089 GDR update package for SQL Server 2016 SP1

16-Dec-16

13.0.4199.0

2015.130.4199.0

3207512 Important update for SQL Server 2016 SP1 Reporting Services

23-Nov-16

13.0.4001.0

2015.130.4001.0

Microsoft SQL Server 2016 Service Pack 1 (SP1)

16-Nov-16

13.0.2218.0

2015.130.2218.0

4058559 Description of the security update for SQL Server 2016 CU: January 6, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

06-Jan-18

13.0.2216.0

2015.130.2216.0

4037357 Cumulative update 9 (CU9) for SQL Server 2016

21-Nov-17

13.0.2213.0

2015.130.2213.0

4040713 Cumulative update 8 (CU8) for SQL Server 2016

18-Sep-17

13.0.2210.0

2015.130.2210.0

4024304 Cumulative update 7 (CU7) for SQL Server 2016  CVE-2017-8516

08-Aug-17

13.0.2204.0

2015.130.2204.0

4019914 Cumulative update 6 (CU6) for SQL Server 2016

15-May-17

13.0.2197.0

2015.130.2197.0

4013105 Cumulative update 5 (CU5) for SQL Server 2016

21-Mar-17

13.0.2193.0

2015.130.2193.0

3205052 Cumulative update 4 (CU4) for SQL Server 2016

18-Jan-17

13.0.2190.2

2015.130.2190.2

3210110 On-demand hotfix update package for SQL Server 2016 CU3

16-Dec-16

13.0.2186.6

2015.130.2186.6

3205413 Cumulative update 3 (CU3) for SQL Server 2016

08-Nov-16

13.0.2186.6

2015.130.2186.6

3194717 MS16-136: Description of the security update for SQL Server 2016 CU: November 8, 2016

08-Nov-16

13.0.2170.0

2015.130.2170.0

3199171 On-demand hotfix update package for SQL Server 2016 CU2

01-Nov-16

13.0.2169.0

2015.130.2169.0

3195813 On-demand hotfix update package for SQL Server 2016 CU2

26-Oct-16

13.0.2164.0

2015.130.2164.0

3182270 Cumulative update 2 (CU2) for SQL Server 2016

22-Sep-16

13.0.2149.0

2015.130.2149.0

3164674 Cumulative update 1 (CU1) for SQL Server 2016

26-Jul-16

13.0.1745.2

2015.130.1745.2

4058560 Description of the security update for SQL Server 2016 GDR: January 6, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

06-Jan-18

13.0.1742.0

2015.130.1742.0

4019088 Security update for SQL Server 2016 RTM GDR: August 8, 2017  CVE-2017-8516

08-Aug-17

13.0.1728.2

2015.130.1728.2

3210111 GDR update package for SQL Server 2016 RTM

16-Dec-16

13.0.1722.0

2015.130.1722.0

3194716 MS16-136: Description of the security update for SQL Server 2016 GDR: November 8, 2016

08-Nov-16

13.0.1711.0

2015.130.1711.0

3179258 Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200)

17-Aug-16

13.0.1708.0

2015.130.1708.0

3164398 Critical update for SQL Server 2016 MSVCRT prerequisites

03-Jun-16

13.0.1601.5

2015.130.1601.5

Microsoft SQL Server 2016 RTM  RTM

01-Jun-16

Microsoft SQL Server 2014 Builds

12.0.6372.1

2014.120.6372.1

4535288 Security update for SQL Server 2014 SP3 CU4: February 11, 2020  CVE-2020-0618

11-Feb-20

12.0.6329.1

2014.120.6329.1

4500181 Cumulative update package 4 (CU4) for SQL Server 2014 Service Pack 3  Latest CU

29-Jul-19

12.0.6293.0

2014.120.6293.0

4505422 Security update for SQL Server 2014 SP3 CU3 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

12.0.6259.0

2014.120.6259.0

4491539 Cumulative update package 3 (CU3) for SQL Server 2014 Service Pack 3

16-Apr-19

12.0.6214.1

2014.120.6214.1

4482960 Cumulative update package 2 (CU2) for SQL Server 2014 Service Pack 3

19-Feb-19

12.0.6205.1

2014.120.6205.1

4470220 Cumulative update package 1 (CU1) for SQL Server 2014 Service Pack 3

12-Dec-18

12.0.6118.4

2014.120.6118.4

4532095 Security update for SQL Server 2014 SP3 GDR: February 11, 2020  CVE-2020-0618

11-Feb-20

12.0.6108.1

2014.120.6108.1

4505218 Security update for SQL Server 2014 SP3 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

12.0.6024.0

2014.120.6024.0

4022619 SQL Server 2014 Service Pack 3 (SP3)  Latest SP

30-Oct-18

12.0.5687.1

2014.120.5687.1

4500180 Cumulative update package 18 (CU18) for SQL Server 2014 Service Pack 2

29-Jul-19

12.0.5659.1

2014.120.5659.1

4505419 Security update for SQL Server 2014 SP2 CU17 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

12.0.5632.1

2014.120.5632.1

4491540 Cumulative update package 17 (CU17) for SQL Server 2014 Service Pack 2

16-Apr-19

12.0.5626.1

2014.120.5626.1

4482967 Cumulative update package 16 (CU16) for SQL Server 2014 Service Pack 2

19-Feb-19

12.0.5605.1

2014.120.5605.1

4469137 Cumulative update package 15 (CU15) for SQL Server 2014 Service Pack 2

12-Dec-18

12.0.5600.1

2014.120.5600.1

4459860 Cumulative update package 14 (CU14) for SQL Server 2014 Service Pack 2

15-Oct-18

12.0.5590.1

2014.120.5590.1

4456287 Cumulative update package 13 (CU13) for SQL Server 2014 Service Pack 2

27-Aug-18

12.0.5589.7

2014.120.5589.7

4130489 Cumulative update package 12 (CU12) for SQL Server 2014 Service Pack 2

18-Jun-18

12.0.5579.0

2014.120.5579.0

4077063 Cumulative update package 11 (CU11) for SQL Server 2014 Service Pack 2

19-Mar-18

12.0.5571.0

2014.120.5571.0

4052725 Cumulative update package 10 (CU10) for SQL Server 2014 Service Pack 2 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

16-Jan-18

12.0.5563.0

2014.120.5563.0

4055557 Cumulative update package 9 (CU9) for SQL Server 2014 Service Pack 2

19-Dec-17

12.0.5557.0

2014.120.5557.0

4037356 Cumulative update package 8 (CU8) for SQL Server 2014 Service Pack 2

17-Oct-17

12.0.5556.0

2014.120.5556.0

4032541 Cumulative update package 7 (CU7) for SQL Server 2014 Service Pack 2

29-Aug-17

12.0.5553.0

2014.120.5553.0

4019094 Cumulative update package 6 (CU6) for SQL Server 2014 Service Pack 2

08-Aug-17

12.0.5546.0

2014.120.5546.0

4013098 Cumulative update package 5 (CU5) for SQL Server 2014 Service Pack 2

18-Apr-17

12.0.5540.0

2014.120.5540.0

4010394 Cumulative update package 4 (CU4) for SQL Server 2014 Service Pack 2

21-Feb-17

12.0.5538.0

2014.120.5538.0

3204388 Cumulative update package 3 (CU3) for SQL Server 2014 Service Pack 2 - The article incorrectly says it's version 12.0.5537

28-Dec-16

12.0.5532.0

2014.120.5532.0

3194718 MS16-136: Description of the security update for SQL Server 2014 Service Pack 2 CU: November 8, 2016

08-Nov-16

12.0.5522.0

2014.120.5522.0

3188778 Cumulative update package 2 (CU2) for SQL Server 2014 Service Pack 2

18-Oct-16

12.0.5511.0

2014.120.5511.0

3178925 Cumulative update package 1 (CU1) for SQL Server 2014 Service Pack 2

26-Aug-16

12.0.5223.6

2014.120.5223.6

4505217 Security update for SQL Server 2014 SP2 GDR: July 9, 2019  CVE-2019-1068

09-Jul-19

12.0.5214.6

2014.120.5214.6

4057120 Security update for SQL Server 2014 Service Pack 2 GDR: January 16, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

16-Jan-18

12.0.5207.0

2014.120.5207.0

4019093 Security update for SQL Server 2014 Service Pack 2 GDR: August 8, 2017

08-Aug-17

12.0.5203.0

2014.120.5203.0

3194714 MS16-136: Description of the security update for SQL Server 2014 Service Pack 2 GDR: November 8, 2016

08-Nov-16

12.0.5000.0

2014.120.5000.0

SQL Server 2014 Service Pack 2 (SP2)

11-Jul-16

12.0.4522.0

2014.120.4522.0

4019099 Cumulative update package 13 (CU13) for SQL Server 2014 Service Pack 1

08-Aug-17

12.0.4511.0

2014.120.4511.0

4017793 Cumulative update package 12 (CU12) for SQL Server 2014 Service Pack 1

18-Apr-17

12.0.4502.0

2014.120.4502.0

4010392 Cumulative update package 11 (CU11) for SQL Server 2014 Service Pack 1

21-Feb-17

12.0.4491.0

2014.120.4491.0

3204399 Cumulative update package 10 (CU10) for SQL Server 2014 Service Pack 1

28-Dec-16

12.0.4487.0

2014.120.4487.0

3194722 MS16-136: Description of the security update for SQL Server 2014 Service Pack 1 CU: November 8, 2016

08-Nov-16

12.0.4474.0

2014.120.4474.0

3186964 Cumulative update package 9 (CU9) for SQL Server 2014 Service Pack 1

18-Oct-16

12.0.4468.0

2014.120.4468.0

3174038 Cumulative update package 8 (CU8) for SQL Server 2014 Service Pack 1

15-Aug-16

12.0.4463.0

2014.120.4463.0

3174370 A memory leak occurs when you use Azure Storage in SQL Server 2014

04-Aug-16

12.0.4459.0

2014.120.4459.0

3162659 Cumulative update package 7 (CU7) for SQL Server 2014 Service Pack 1

20-Jun-16

12.0.4457.1

2014.120.4457.1

3167392 REFRESHED Cumulative update package 6 (CU6) for SQL Server 2014 Service Pack 1

31-May-16

12.0.4449.1

2014.120.4449.1

3144524 DEPRECATED Cumulative update package 6 (CU6) for SQL Server 2014 Service Pack 1

19-Apr-16

12.0.4439.1

2014.120.4439.1

3130926 Cumulative update package 5 (CU5) for SQL Server 2014 Service Pack 1

22-Feb-16

12.0.4437.0

2014.120.4437.0

3130999 On-demand hotfix update package for SQL Server 2014 Service Pack 1 Cumulative Update 4

05-Feb-16

12.0.4436.0

2014.120.4436.0

3106660 Cumulative update package 4 (CU4) for SQL Server 2014 Service Pack 1

22-Dec-15

12.0.4433.0

2014.120.4433.0

3119148 FIX: Error 3203 and a SQL Server 2014 backup job can't restart when a network failure occurs

09-Dec-15

12.0.4432.0

2014.120.4432.0

3097972 FIX: Error when your stored procedure calls another stored procedure on linked server in SQL Server 2014

19-Nov-15

12.0.4237.0

2014.120.4237.0

4019091 Security update for SQL Server 2014 Service Pack 1 GDR: August 8, 2017

08-Aug-17

12.0.4232.0

2014.120.4232.0

3194720 MS16-136: Description of the security update for SQL Server 2014 Service Pack 1 GDR: November 8, 2016

08-Nov-16

12.0.4427.24

2014.120.4427.24

3094221 Cumulative update package 3 (CU3) for SQL Server 2014 Service Pack 1

21-Oct-15

12.0.4422.0

2014.120.4422.0

3075950 Cumulative update package 2 (CU2) for SQL Server 2014 Service Pack 1

17-Aug-15

12.0.4419.0

2014.120.4419.0

3078973 An on-demand hotfix update package is available for SQL Server 2014 SP1

24-Jul-15

12.0.4416.0

2014.120.4416.0

3067839 Cumulative update package 1 (CU1) for SQL Server 2014 Service Pack 1

22-Jun-15

12.0.4219.0

2014.120.4219.0

3098852 TLS 1.2 support for SQL Server 2014 SP1

27-Jan-16

12.0.4213.0

2014.120.4213.0

3070446 MS15-058: Description of the nonsecurity update for SQL Server 2014 Service Pack 1 GDR: July 14, 2015

14-Jul-15

12.0.4100.1

2014.120.4100.1

SQL Server 2014 Service Pack 1 (SP1)

14-May-15

12.0.4050.0

2014.120.4050.0

SQL Server 2014 Service Pack 1 (SP1) (Withdrawn)

15-Apr-15

12.0.2569.0

2014.120.2569.0

3158271 Cumulative update package 14 (CU14) for SQL Server 2014

20-Jun-16

12.0.2568.0

2014.120.2568.0

3144517 Cumulative update package 13 (CU13) for SQL Server 2014

18-Apr-16

12.0.2564.0

2014.120.2564.0

3130923 Cumulative update package 12 (CU12) for SQL Server 2014

22-Feb-16

12.0.2560.0

2014.120.2560.0

3106659 Cumulative update package 11 (CU11) for SQL Server 2014

22-Dec-15

12.0.2556.4

2014.120.2556.4

3094220 Cumulative update package 10 (CU10) for SQL Server 2014

20-Oct-15

12.0.2553.0

2014.120.2553.0

3075949 Cumulative update package 9 (CU9) for SQL Server 2014

17-Aug-15

12.0.2548.0

2014.120.2548.0

3045323 MS15-058: Description of the security update for SQL Server 2014 QFE: July 14, 2015

14-Jul-15

12.0.2546.0

2014.120.2546.0

3067836 Cumulative update package 8 (CU8) for SQL Server 2014

22-Jun-15

12.0.2506.0

2014.120.2506.0

3063054 Update enables Premium Storage support for Data files on Azure Storage and resolves backup failures

19-May-15

12.0.2505.0

2014.120.2505.0

3052167 FIX: Error 1205 when you execute parallel query that contains outer join operators in SQL Server 2014

19-May-15

12.0.2504.0

2014.120.2504.0

2999809 FIX: Poor performance when a query contains table joins in SQL Server 2014

05-May-15

12.0.2504.0

2014.120.2504.0

3058512 FIX: Unpivot Transformation task changes null to zero or empty strings in SSIS 2014

05-May-15

12.0.2495.0

2014.120.2495.0

3046038 Cumulative update package 7 (CU7) for SQL Server 2014

23-Apr-15

12.0.2488.0

2014.120.2488.0

3048751 FIX: Deadlock cannot be resolved automatically when you run a SELECT query that can result in a parallel batch-mode scan

01-Apr-15

12.0.2485.0

2014.120.2485.0

3043788 An on-demand hotfix update package is available for SQL Server 2014

16-Mar-15

12.0.2480.0

2014.120.2480.0

3031047 Cumulative update package 6 (CU6) for SQL Server 2014

16-Feb-15

12.0.2474.0

2014.120.2474.0

3034679 FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING

15-May-15

12.0.2472.0

2014.120.2472.0

3032087 FIX: Cannot show requested dialog after you connect to the latest SQL Database Update V12 (preview) with SQL Server 2014

28-Jan-15

12.0.2464.0

2014.120.2464.0

3024815 Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014

05-Jan-15

12.0.2456.0

2014.120.2456.0

3011055 Cumulative update package 5 (CU5) for SQL Server 2014

18-Dec-14

12.0.2436.0

2014.120.2436.0

3014867 FIX: "Remote hardening failure" exception cannot be caught and a potential data loss when you use SQL Server 2014

27-Nov-14

12.0.2430.0

2014.120.2430.0

2999197 Cumulative update package 4 (CU4) for SQL Server 2014

21-Oct-14

12.0.2423.0

2014.120.2423.0

3007050 FIX: RTDATA_LIST waits when you run natively stored procedures that encounter expected failures in SQL Server 2014

22-Oct-14

12.0.2405.0

2014.120.2405.0

2999809 FIX: Poor performance when a query contains table joins in SQL Server 2014

25-Sep-14

12.0.2402.0

2014.120.2402.0

2984923 Cumulative update package 3 (CU3) for SQL Server 2014

18-Aug-14

12.0.2381.0

2014.120.2381.0

2977316 MS14-044: Description of the security update for SQL Server 2014 (QFE)

12-Aug-14

12.0.2370.0

2014.120.2370.0

2967546 Cumulative update package 2 (CU2) for SQL Server 2014

27-Jun-14

12.0.2342.0

2014.120.2342.0

2931693 Cumulative update package 1 (CU1) for SQL Server 2014

21-Apr-14

12.0.2271.0

2014.120.2271.0

3098856 TLS 1.2 support for SQL Server 2014 RTM

27-Jan-16

12.0.2269.0

2014.120.2269.0

3045324 MS15-058: Description of the security update for SQL Server 2014 GDR: July 14, 2015

14-Jul-15

12.0.2254.0

2014.120.2254.0

2977315 MS14-044: Description of the security update for SQL Server 2014 (GDR)

12-Aug-14

12.0.2000.8

2014.120.2000.8

SQL Server 2014 RTM  RTM

01-Apr-14

Microsoft SQL Server 2012 Builds

11.0.7493.4

2011.110.7493.4

4532098 Security update for SQL Server 2012 SP4 GDR: February 11, 2020  CVE-2020-0618

11-Feb-20

11.0.7469.6

2011.110.7469.6

4091266 On-demand hotfix update package for SQL Server 2012 SP4

28-Mar-18

11.0.7462.6

2011.110.7462.6

4057116 Description of the security update for SQL Server 2012 SP4 GDR: January 12, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

12-Jan-18

11.0.7001.0

2011.110.7001.0

SQL Server 2012 Service Pack 4 (SP4)  Latest SP

05-Oct-17

11.0.6615.2

2012.110.6615.2

4057121 Description of the security update for SQL Server 2012 SP3 CU: January 16, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

16-Jan-18

11.0.6607.3

2011.110.6607.3

4025925 Cumulative update package 10 (CU10) for SQL Server 2012 Service Pack 3  CVE-2017-8516

08-Aug-17

11.0.6607.3

2011.110.6607.3

4019090 Security update for SQL Server 2012 Service Pack 3 CU: August 8, 2017  CVE-2017-8516

08-Aug-17

11.0.6598.0

2011.110.6598.0

4016762 Cumulative update package 9 (CU9) for SQL Server 2012 Service Pack 3

15-May-17

11.0.6594.0

2011.110.6594.0

4013104 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 3

21-Mar-17

11.0.6579.0

2011.110.6579.0

3205051 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 3

17-Jan-17

11.0.6567.0

2011.110.6567.0

3194992 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 3

17-Nov-16

11.0.6567.0

2012.110.6567.0

3194724 MS16-136: Description of the security update for SQL Server 2012 Service Pack 3 CU: November 8, 2016

08-Nov-16

11.0.6544.0

2011.110.6544.0

3180915 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 3

21-Sep-16

11.0.6540.0

2011.110.6540.0

3165264 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 3

19-Jul-16

11.0.6537.0

2011.110.6537.0

3152635 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 3

17-May-16

11.0.6523.0

2011.110.6523.0

3137746 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 3

22-Mar-16

11.0.6518.0

2011.110.6518.0

3123299 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 3

19-Jan-16

11.0.6260.1

2011.110.6260.1

4057115 Description of the security update for SQL Server 2012 SP3 GDR: January 16, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

16-Jan-18

11.0.6251.0

2012.110.6251.0

4019092 Description of the security update for SQL Server 2012 Service Pack 3 GDR: August 8, 2017

08-Aug-17

11.0.6248.0

2012.110.6248.0

3194721 MS16-136: Description of the security update for SQL Server 2012 Service Pack 3 GDR: November 8, 2016

08-Nov-16

11.0.6216.27

2012.110.6216.27

3135244 TLS 1.2 support for SQL Server 2012 SP3 GDR

27-Jan-16

11.0.6020.0

2011.110.6020.0

SQL Server 2012 Service Pack 3 (SP3)

23-Nov-15

11.0.5678.0

2011.110.5678.0

3205054 Cumulative update package 16 (CU16) for SQL Server 2012 Service Pack 2

18-Jan-17

11.0.5676.0

2011.110.5676.0

3205416 Cumulative update package 15 (CU15) for SQL Server 2012 Service Pack 2

17-Nov-16

11.0.5676.0

2012.110.5676.0

3194725 MS16-136: Description of the security update for SQL Server 2012 Service Pack 2 CU: November 8, 2016

08-Nov-16

11.0.5657.0

2011.110.5657.0

3180914 Cumulative update package 14 (CU14) for SQL Server 2012 Service Pack 2

20-Sep-16

11.0.5655.0

2011.110.5655.0

3165266 Cumulative update package 13 (CU13) for SQL Server 2012 Service Pack 2

19-Jul-16

11.0.5649.0

2011.110.5649.0

3152637 Cumulative update package 12 (CU12) for SQL Server 2012 Service Pack 2

16-May-16

11.0.5646.0

2011.110.5646.0

3137745 Cumulative update package 11 (CU11) for SQL Server 2012 Service Pack 2

22-Mar-16

11.0.5644.0

2011.110.5644.0

3120313 Cumulative update package 10 (CU10) for SQL Server 2012 Service Pack 2

20-Jan-16

11.0.5641.0

2011.110.5641.0

3098512 Cumulative update package 9 (CU9) for SQL Server 2012 Service Pack 2

18-Nov-15

11.0.5636.3

2011.110.5636.3

3097636 FIX: Performance decrease when application with connection pooling frequently connects or disconnects in SQL Server

22-Sep-15

11.0.5634.0

2011.110.5634.0

3082561 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 2

21-Sep-15

11.0.5629.0

2011.110.5629.0

3087872 FIX: Access violations when you use the FileTable feature in SQL Server 2012

31-Aug-15

11.0.5623.0

2011.110.5623.0

3072100 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 2

20-Jul-15

11.0.5613.0

2011.110.5613.0

3045319 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 QFE: July 14, 2015

14-Jul-15

11.0.5592.0

2011.110.5592.0

3052468 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 2

19-May-15

11.0.5582.0

2011.110.5582.0

3037255 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 2

16-Mar-15

11.0.5571.0

2011.110.5571.0

3034679 FIX: AlwaysOn availability groups are reported as NOT SYNCHRONIZING

15-May-15

11.0.5569.0

2011.110.5569.0

3007556 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 2

20-Jan-15

11.0.5556.0

2011.110.5556.0

3002049 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 2

17-Nov-14

11.0.5548.0

2011.110.5548.0

2983175 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 2

15-Sep-14

11.0.5532.0

2011.110.5532.0

2976982 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 2

24-Jul-14

11.0.5522.0

2011.110.5522.0

2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP2)

20-Jun-14

11.0.5388.0

2012.110.5388.0

3194719 MS16-136: Description of the security update for SQL Server 2012 Service Pack 2 GDR: November 8, 2016

08-Nov-16

11.0.5352.0

2012.110.5352.0

3135244 TLS 1.2 support for SQL Server 2012 SP2 GDR

27-Jan-16

11.0.5343.0

2011.110.5343.0

3045321 MS15-058: Description of the security update for SQL Server 2012 Service Pack 2 GDR: July 14, 2015

14-Jul-15

11.0.5058.0

2011.110.5058.0

SQL Server 2012 Service Pack 2 (SP2)

10-Jun-14

11.0.3513.0

2011.110.3513.0

3045317 MS15-058: Description of the security update for SQL Server 2012 SP1 QFE: July 14, 2015

14-Jul-15

11.0.3492.0

2011.110.3492.0

3052476 Cumulative update package 16 (CU16) for SQL Server 2012 Service Pack 1

18-May-15

11.0.3487.0

2011.110.3487.0

3038001 Cumulative update package 15 (CU15) for SQL Server 2012 Service Pack 1

16-Mar-15

11.0.3486.0

2011.110.3486.0

3023636 Cumulative update package 14 (CU14) for SQL Server 2012 Service Pack 1

19-Jan-15

11.0.3460.0

2011.110.3460.0

2977325 MS14-044: Description of the security update for SQL Server 2012 Service Pack 1 (QFE)

12-Aug-14

11.0.3482.0

2011.110.3482.0

3002044 Cumulative update package 13 (CU13) for SQL Server 2012 Service Pack 1

17-Nov-14

11.0.3470.0

2011.110.3470.0

2991533 Cumulative update package 12 (CU12) for SQL Server 2012 Service Pack 1

15-Sep-14

11.0.3449.0

2011.110.3449.0

2975396 Cumulative update package 11 (CU11) for SQL Server 2012 Service Pack 1

21-Jul-14

11.0.3437.0

2011.110.3437.0

2969896 FIX: Data loss in clustered index occurs when you run online build index in SQL Server 2012 (Hotfix for SQL2012 SP1)

10-Jun-14

11.0.3431.0

2011.110.3431.0

2954099 Cumulative update package 10 (CU10) for SQL Server 2012 Service Pack 1

19-May-14

11.0.3412.0

2011.110.3412.0

2931078 Cumulative update package 9 (CU9) for SQL Server 2012 Service Pack 1

18-Mar-14

11.0.3401.0

2011.110.3401.0

2917531 Cumulative update package 8 (CU8) for SQL Server 2012 Service Pack 1

20-Jan-14

11.0.3393.0

2011.110.3393.0

2894115 Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 1

18-Nov-13

11.0.3381.0

2011.110.3381.0

2874879 Cumulative update package 6 (CU6) for SQL Server 2012 Service Pack 1

16-Sep-13

11.0.3373.0

2011.110.3373.0

2861107 Cumulative update package 5 (CU5) for SQL Server 2012 Service Pack 1

16-Jul-13

11.0.3368.0

2011.110.3368.0

2833645 Cumulative update package 4 (CU4) for SQL Server 2012 Service Pack 1

31-May-13

11.0.3350.0

2011.110.3350.0

2832017 FIX: You can’t create or open SSIS projects or maintenance plans after you apply Cumulative Update 3 for SQL Server 2012 SP1

17-Apr-13

11.0.3349.0

2011.110.3349.0

2812412 Cumulative update package 3 (CU3) for SQL Server 2012 Service Pack 1

18-Mar-13

11.0.3339.0

2011.110.3339.0

2790947 Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1

25-Jan-13

11.0.3335.0

2011.110.3335.0

2800050 FIX: Component installation process fails after you install SQL Server 2012 SP1

14-Jan-13

11.0.3321.0

2011.110.3321.0

2765331 Cumulative update package 1 (CU1) for SQL Server 2012 Service Pack 1

20-Nov-12

11.0.3156.0

2011.110.3156.0

3045318 MS15-058: Description of the security update for SQL Server 2012 SP1 GDR: July 14, 2015

14-Jul-15

11.0.3153.0

2011.110.3153.0

2977326 MS14-044: Description of the security update for SQL Server 2012 Service Pack 1 (GDR)

12-Aug-14

11.0.3128.0

2011.110.3128.0

2793634 Windows Installer starts repeatedly after you install SQL Server 2012 SP1

03-Jan-13

11.0.3000.0

2011.110.3000.0

SQL Server 2012 Service Pack 1 (SP1)

06-Nov-12

11.0.2845.0

2011.110.2845.0

SQL Server 2012 Service Pack 1 Customer Technology Preview 4 (CTP4)  Beta

20-Sep-12

11.0.2809.24

2011.110.2809.24

SQL Server 2012 Service Pack 1 Customer Technology Preview 3 (CTP3)  Beta

05-Jul-12

11.0.2424.0

2011.110.2424.0

2908007 Cumulative update package 11 (CU11) for SQL Server 2012

17-Dec-13

11.0.2420.0

2011.110.2420.0

2891666 Cumulative update package 10 (CU10) for SQL Server 2012

21-Oct-13

11.0.2419.0

2011.110.2419.0

2867319 Cumulative update package 9 (CU9) for SQL Server 2012

21-Aug-13

11.0.2410.0

2011.110.2410.0

2844205 Cumulative update package 8 (CU8) for SQL Server 2012

18-Jun-13

11.0.2405.0

2011.110.2405.0

2823247 Cumulative update package 7 (CU7) for SQL Server 2012

15-Apr-13

11.0.2401.0

2011.110.2401.0

2728897 Cumulative update package 6 (CU6) for SQL Server 2012

18-Feb-13

11.0.2395.0

2011.110.2395.0

2777772 Cumulative update package 5 (CU5) for SQL Server 2012

18-Dec-12

11.0.9000.5

2011.110.9000.5

Microsoft SQL Server 2012 With Power View For Multidimensional Models Customer Technology Preview (CTP3)  Beta

27-Nov-12

11.0.2383.0

2011.110.2383.0

2758687 Cumulative update package 4 (CU4) for SQL Server 2012

18-Oct-12

11.0.2376.0

2011.110.2376.0

Microsoft Security Bulletin MS12-070

09-Oct-12

11.0.2332.0

2011.110.2332.0

2723749 Cumulative update package 3 (CU3) for SQL Server 2012

29-Aug-12

11.0.2325.0

2011.110.2325.0

2703275 Cumulative update package 2 (CU2) for SQL Server 2012

18-Jun-12

11.0.2318.0

2011.110.2318.0

SQL Server 2012 Express LocalDB  - RTM

19-Apr-12

11.0.2316.0

2011.110.2316.0

2679368 Cumulative update package 1 (CU1) for SQL Server 2012

12-Apr-12

11.0.2218.0

2011.110.2218.0

Microsoft Security Bulletin MS12-070

09-Oct-12

11.0.2214.0

2011.110.2214.0

2685308 FIX: SSAS uses only 20 cores in SQL Server 2012 Business Intelligence

06-Apr-12

11.0.2100.60

2011.110.2100.60

SQL Server 2012 - RTM

06-Mar-12

Microsoft SQL Server 2008 R2 Builds

10.50.6560.0

2009.100.6560.0

4057113 Description of the security update for SQL Server 2008 R2 SP3 GDR: January 6, 2018 – Security Advisory ADV180002  CVE-2017-5715 CVE-2017-5753 CVE-2017-5754

06-Jan-18

10.50.6542.0

2009.100.6542.0

3146034 Intermittent service terminations occur after you install any SQL Server 2008 or SQL Server 2008 R2 versions from KB3135244

03-Mar-16

10.50.6537.0

2009.100.6537.0

3135244 TLS 1.2 support for SQL Server 2008 R2 SP3

27-Jan-16

10.50.6529.0

2009.100.6529.0

3045314 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 3 QFE: July 14, 2015

14-Jul-15

10.50.6525.0

2009.100.6525.0

3033860 An on-demand hotfix update package is available for SQL Server 2008 R2 Service Pack 3 (SP3)

09-Feb-15

10.50.6220.0

2009.100.6220.0

3045316 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 3 GDR: July 14, 2015

14-Jul-15

10.50.6000.34

2009.100.6000.34

SQL Server 2008 R2 Service Pack 3 (SP3)  Latest SP

26-Sep-14

10.50.4343.0

2009.100.4343.0

3135244 TLS 1.2 support for SQL Server 2008 R2 SP2 (IA-64 only)

27-Jan-16

10.50.4339.0

2009.100.4339.0

3045312 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 2 QFE: July 14, 2015

14-Jul-15

10.50.4331.0

2009.100.4331.0

2987585 Restore Log with Standby Mode on an Advanced Format disk may cause a 9004 error in SQL Server 2008 R2 or SQL Server 2012

27-Aug-14

10.50.4321.0

2009.100.4321.0

2977319 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (QFE)

12-Aug-14

10.50.4319.0

2009.100.4319.0

2967540 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 2

30-Jun-14

10.50.4305.0

2009.100.4305.0

2938478 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 2

21-Apr-14

10.50.4302.0

2009.100.4302.0

2926028 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 2

18-Feb-14

10.50.4297.0

2009.100.4297.0

2908087 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 2

16-Dec-13

10.50.4295.0

2009.100.4295.0

2887606 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 2

29-Oct-13

10.50.4290.0

2009.100.4290.0

2871401 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 2

30-Aug-13

10.50.4286.0

2009.100.4286.0

2844090 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 2

17-Jun-13

10.50.4285.0

2009.100.4285.0

2830140 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (updated)

13-Jun-13

10.50.4279.0

2009.100.4279.0

Withdrawn Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 2 (replaced)

15-Apr-13

10.50.4276.0

2009.100.4276.0

2797460 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 2

18-Feb-13

10.50.4270.0

2009.100.4270.0

2777358 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 2

17-Dec-12

10.50.4266.0

2009.100.4266.0

2754552 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 2

15-Oct-12

10.50.4263.0

2009.100.4263.0

2740411 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 2

29-Aug-12

10.50.4260.0

2009.100.4260.0

2720425 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 2

01-Aug-12

10.50.4046.0

2009.100.4046.0

3135244 TLS 1.2 support for SQL Server 2008 R2 SP2 GDR (IA-64 only)

27-Jan-16

10.50.4042.0

2009.100.4042.0

3045313 MS15-058: Description of the security update for SQL Server 2008 R2 Service Pack 2 GDR: July 14, 2015

14-Jul-15

10.50.4033.0

2009.100.4033.0

2977320 MS14-044: Description of the security update for SQL Server 2008 R2 Service Pack 2 (GDR)

12-Aug-14

10.50.4000.0

2009.100.4000.0

SQL Server 2008 R2 Service Pack 2 (SP2)

26-Jul-12

10.50.3720.0

2009.100.3720.0

SQL Server 2008 R2 Service Pack 2 Community Technology Preview (CTP)  Beta

13-May-12

10.50.2881.0

2009.100.2881.0

2868244 An on-demand hotfix update package for SQL Server 2008 R2 Service Pack 1

12-Aug-13

10.50.2876.0

2009.100.2876.0

2855792 Cumulative update package 13 (CU13) for SQL Server 2008 R2 Service Pack 1

17-Jun-13

10.50.2875.0

2009.100.2875.0

2828727 Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (updated)

13-Jun-13

10.50.2874.0

2009.100.2874.0

Cumulative update package 12 (CU12) for SQL Server 2008 R2 Service Pack 1 (replaced) Withdrawn

15-Apr-13

10.50.2861.0

2009.100.2861.0

Microsoft Security Bulletin MS12-070

09-Oct-12

10.50.2869.0

2009.100.2869.0

2812683 Cumulative update package 11 (CU11) for SQL Server 2008 R2 Service Pack 1

18-Feb-13

10.50.2868.0

2009.100.2868.0

2783135 Cumulative update package 10 (CU10) for SQL Server 2008 R2 Service Pack 1

17-Dec-12

10.50.2866.0

2009.100.2866.0

2756574 Cumulative update package 9 (CU9) for SQL Server 2008 R2 Service Pack 1

06-Nov-12

10.50.2861.0

2009.100.2861.0

2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012

09-Oct-12

10.50.2822.0

2009.100.2822.0

2723743 Cumulative update package 8 (CU8) for SQL Server 2008 R2 Service Pack 1

29-Aug-12

10.50.2817.0

2009.100.2817.0

2703282 Cumulative update package 7 (CU7) for SQL Server 2008 R2 Service Pack 1

18-Jun-12

10.50.2811.0

2009.100.2811.0

2679367 Cumulative update package 6 (CU6) for SQL Server 2008 R2 Service Pack 1

16-Apr-12

10.50.2807.0

2009.100.2807.0

2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2

12-Mar-12

10.50.2806.0

2009.100.2806.0

2659694 Cumulative update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1

22-Feb-12

10.50.2799.0

2009.100.2799.0

2633357 FIX: "Non-yielding Scheduler" error might occur when you run a query that uses the CHARINDEX function in SQL Server 2008 R2

22-Feb-12

10.50.2796.0

2009.100.2796.0

2633146 Cumulative update package 4 (CU4) for SQL Server 2008 R2 Service Pack 1

20-Dec-11

10.50.2789.0

2009.100.2789.0

2591748 Cumulative update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1

17-Oct-11

10.50.2776.0

2009.100.2776.0

2606883 FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2

18-Oct-11

10.50.2772.0

2009.100.2772.0

2567714 Cumulative update package 2 (CU2) for SQL Server 2008 R2 Service Pack 1

15-Aug-11

10.50.2769.0

2009.100.2769.0

2544793 Cumulative update package 1 (CU1) for SQL Server 2008 R2 Service Pack 1

18-Jul-11

10.50.2550.0

2009.100.2550.0

Microsoft Security Bulletin MS12-070

09-Oct-12

10.50.2500.0

2009.100.2500.0

SQL Server 2008 R2 Service Pack 1 (SP1)

11-Jul-11

10.50.1817.0

2009.100.1817.0

2703280 Cumulative update package 14 (CU14) for SQL Server 2008 R2

18-Jun-12

10.50.1815.0

2009.100.1815.0

2679366 Cumulative update package 13 (CU13) for SQL Server 2008 R2

17-Apr-12

10.50.1810.0

2009.100.1810.0

2659692 Cumulative update package 12 (CU12) for SQL Server 2008 R2

21-Feb-12

10.50.1809.0

2009.100.1809.0

2633145 Cumulative update package 11 (CU11) for SQL Server 2008 R2

09-Jan-12

10.50.1807.0

2009.100.1807.0

2591746 Cumulative update package 10 (CU10) for SQL Server 2008 R2

19-Oct-11

10.50.1804.0

2009.100.1804.0

2567713 Cumulative update package 9 (CU9) for SQL Server 2008 R2

16-Aug-11

10.50.1800.0

2009.100.1800.0

2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system

18-Oct-11

10.50.1797.0

2009.100.1797.0

2534352 Cumulative update package 8 (CU8) for SQL Server 2008 R2

20-Jun-11

10.50.1790.0

2009.100.1790.0

2494086 MS11-049: Description of the security update for SQL Server 2008 R2 QFE: June 14, 2011

17-Jun-11

10.50.1777.0

2009.100.1777.0

2507770 Cumulative update package 7 (CU7) for SQL Server 2008 R2

16-Jun-11

10.50.1769.0

2009.100.1769.0

2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used

18-Apr-11

10.50.1765.0

2009.100.1765.0

2489376 Cumulative update package 6 (CU6) for SQL Server 2008 R2

21-Feb-11

10.50.1753.0

2009.100.1753.0

2438347 Cumulative update package 5 (CU5) for SQL Server 2008 R2

23-Dec-10

10.50.1746.0

2009.100.1746.0

2345451 Cumulative update package 4 (CU4) for SQL Server 2008 R2

18-Oct-10

10.50.1734.0

2009.100.1734.0

2261464 Cumulative update package 3 (CU3) for SQL Server 2008 R2

20-Aug-10

10.50.1720.0

2009.100.1720.0

2072493 Cumulative update package 2 (CU2) for SQL Server 2008 R2

25-Jun-10

10.50.1702.0

2009.100.1702.0

981355 Cumulative update package 1 (CU1) for SQL Server 2008 R2

18-May-10

10.50.1617.0

2009.100.1617.0

2494088 MS11-049: Description of the security update for SQL Server 2008 R2 GDR: June 14, 2011

14-Jun-11

10.50.1600.1

2009.100.1600.1

SQL Server 2008 R2 - RTM

21-Apr-10

Popular posts from this blog

Download SQL Server Management Studio (SSMS)

Summary:  In this post, you will learn &  able to download  SSMS. About  SQL Server Management Studio ( SSMS ):  SSMS is Free!! SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to query, design and manage your databases and data warehouses, wherever they are - on your local computer, or in the cloud.   SSMS -  Prerequisites for Installation: SSMS supports the following 64-bit platforms when used with the latest available service pack: Supported Operating Systems: Windows 10 (64-bit) version 1607 (10.0.14393) or later Windows 8.1 (64-bit) Windows Server 2019 (64-bit) Windows Server 2016 (64-bit) Windows Server 2012 R2 (64-bit) Windows Server 2012 (64-bit) Windows Ser

Mastering Common Table Expression or CTE in SQL Server

WITH common_table_expression (Transact-SQL) Summary:  From this post you will learn about Common Table Expression or   CTE  in SQL Server using the with Clause.  About  CTE  Statement:  Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT , INSERT , UPDATE , DELETE or MERGE statement. A common table expression can include references to itself. This is referred to as a recursive common table expression.  Syntax: [ WITH <common_table_expression> [ ,...n ] ]   <common_table_expression>::=       expression_name [ ( column_name [ ,...n ] ) ]       AS       ( CTE_query_definition )   Arguments expression_name Is a valid identifier for the common table expression. expression_name must be different from the name of any other common table expression defined in the same WITH <common_table_expression> clause, but expression_name can be the same as the name