Introduction of SQL Server

-
"The SQL Server is a relational database management system from Microsoft. The system is designed and built is to manage and store information."

As of now Microsoft has launched many versions of SQL servers. the first version SQL server was introduced in year 1989. the detailed history of SQL Server can be found here.

We will more focus on latest and running SQL versions. Microsoft have released interesting features of SQL server in every release. I will share them all time to time. 

Just for information below are the Microsoft version release till date.

Version
Year
Release
1.0 (OS/2)
1989
SQL Server 1.0 (16-bit)
1.1 (OS/2)
1990
SQL Server 1.1 (16-bit)
4.2A (OS/2)
1992
SQL Server 4.2A
4.2B (OS/2)
1993
SQL Server 4.2B (16-bit)
4.21a (WinNT)
1993
SQL Server 4.21a
6
1995
SQL Server 6.0
6.5
1996
SQL Server 6.5
7
1998
SQL Server 7.0
-
1999
SQL Server 7.0 OLAP Tools
8
2000
SQL Server 2000
8
2003
SQL Server 2000 64-bit Edition
9
2005
SQL Server 2005
10
2008
SQL Server 2008
10.25
2010
Azure SQL database
10.5
2010
SQL Server 2008 R2
11
2012
SQL Server 2012
12
2014
Azure SQL database
12
2014
SQL Server 2014
13
2016
SQL Server 2016
14
2017
SQL Server 2017
15
2019
SQL Server 2019

Comments

Post a Comment

Popular posts from this blog

What is DACPAC and how to use it?

-
Image
Few days before someone asked me a question about DACPAC and BACPAC. To be honest I was really not aware of it and I replied that I have heard these terms for the first time. That person replied DACPAC is used for deploying and upgrading database objects. Even after the clear statement, my reply was like developers would answer this better. Even though DBAs are responsible for migration and deployments. After few days, I got a requirement to migrate database schema (Only Schema) to another instance. In such a case most of us would have used the traditional way to script out the database objects and run the script on another instance. But what if there are many objects? I was exploring the easiest way to migrate the objects and got to know about DAC. After reading about DAC, I felt very sorry myself that I was not aware of such a simplest way of migrating and deploying database objects. I went to my friends who are senior developers and asked this question. None of them was aware ...
Read more

What’s the difference between a hotfix, cumulative update, Service Pack, and Feature Pack?

-
Hotfixes: A hotfix is created to address a specific issue, problem, or customer scenario. A hotfix can address either a single issue or a cumulative set of issues. Hotfixes are distributed only to those customers, partners, and organizations that Microsoft technical support personnel determine can benefit from the changes that are made to the code. Each hotfix includes documentation that indicates what files, tables, code, or functions are changed by the hotfix. Cumulative updates: A cumulative update (CU) is an update that contains all previous hotfixes to date. Additionally, a CU contains fixes for issues that meet the criteria for hotfix acceptance. These criteria may include the availability of a workaround, the effect on the customer, the reproducibility of the problem, and the complexity of the code that must be changed.           Note: Any hotfixes that you previously applied are not included i...
Read more

Always on setup end to end - Part 1 || Pre-requisites

-
Image
Hello readers,  Welcome to the new blog after a long time. In this blog I would like to discuss complete end to end always on setup guide for beginners. I will be posting couple of blogs regarding always on in SQL server. I believe that would be helpful to understand Always on in SQL server in easy way. Always on setup involved multiple steps. Hence one may find it difficult. However, if you could plan it well then you may find that always on is much easier to configure and handle. So, without wasting the time lets proceed further. Firstly, we will see what is Always on in SQL Server ? Always on is the high availability and disaster recovery solution introduced in SQL server 2012. As the name suggest, Always on means availability of database all the time even in case of disaster. We can say it is the alternative of mirroring. Only thing is windows failover cluster service also required to be configured as a pre-requisite for always on. In this blog, we will only d...
Read more