{"id":87157,"date":"2021-03-18T09:00:05","date_gmt":"2021-03-18T03:30:05","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=87157"},"modified":"2021-03-12T18:50:22","modified_gmt":"2021-03-12T13:20:22","slug":"microsoft-sql-version-history","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/","title":{"rendered":"Microsoft SQL Version History"},"content":{"rendered":"

In this tutorial, we will discuss the past and present versions of SQL.Let’s start!!!<\/p>\n

What is SQL and its Origin?<\/h3>\n

SQL, or what we know as Structured Query Language, is the most popular language being utilized to perform CRUD operations on the databases. It has been in use since the late \u201990s and is expanding with no limits.<\/p>\n

SQL was founded as an idea of two researchers at IBM in 1970 after they got their hands on a research paper by Edgar. His work was focusing on databases.<\/p>\n

It was the first time that someone referred to the data storing capacity of the database as relations. From here, the basic idea of SQL was born.<\/p>\n

Previously called SEQUEL and was meant to perform basic operations on System R of IBM.<\/p>\n

After years, SQL was put to open source to allow everyone to implement it successfully.<\/p>\n

In 1979 a company called Relational Software, which later became Oracle released their version of SQL which was initially known as Oracle V2.<\/p>\n

After sometime SQL was made the primary language for RDBMS. The maintenance and monitoring of SQL come under the American National Standards Institute (ANSI) and the International Standards Organization.<\/p>\n

They keep a check on the standards of SQL, i.e all the versions coming up follow the standards and the rule specifications.<\/p>\n

Version History of SQL<\/h3>\n

Below we have the versions of SQL Server right from the start in order.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Sr.No<\/b><\/td>\nVersion Name<\/b><\/td>\nCode Name<\/b><\/td>\nYear Released<\/b><\/td>\n<\/tr>\n
1<\/span><\/td>\nSQL Server 1.0<\/span><\/td>\nFilipi<\/span><\/td>\n1989<\/span><\/td>\n<\/tr>\n
2<\/span><\/td>\nSQL Server 1.1<\/span><\/td>\nPietro<\/span><\/td>\n1991<\/span><\/td>\n<\/tr>\n
3<\/span><\/td>\nSQL Server 4.2<\/span><\/td>\nSQLNT<\/span><\/td>\n1993<\/span><\/td>\n<\/tr>\n
4<\/span><\/td>\nSQL Server 6.0<\/span><\/td>\nSQL95<\/span><\/td>\n1995<\/span><\/td>\n<\/tr>\n
5<\/span><\/td>\nSQL Server 6.5<\/span><\/td>\nHydra<\/span><\/td>\n1996<\/span><\/td>\n<\/tr>\n
6<\/span><\/td>\nSQL Server 7.0<\/span><\/td>\nSphinx<\/span><\/td>\n1998<\/span><\/td>\n<\/tr>\n
7<\/span><\/td>\nSQL Server 2000<\/span><\/td>\nShiloh<\/span><\/td>\n2000<\/span><\/td>\n<\/tr>\n
8<\/span><\/td>\nSQL Server 2005<\/span><\/td>\nYukon<\/span><\/td>\n2005<\/span><\/td>\n<\/tr>\n
9<\/span><\/td>\nSQL Server 2008<\/span><\/td>\nKatmai<\/span><\/td>\n2008<\/span><\/td>\n<\/tr>\n
10<\/span><\/td>\nSQL Server 2012<\/span><\/td>\nDenalli<\/span><\/td>\n2012<\/span><\/td>\n<\/tr>\n
11<\/span><\/td>\nSQL Server 2014<\/span><\/td>\nHekaton<\/span><\/td>\n2014<\/span><\/td>\n<\/tr>\n
12<\/span><\/td>\nSQL Server 2016<\/span><\/td>\nSQL16<\/span><\/td>\n2016<\/span><\/td>\n<\/tr>\n
13<\/span><\/td>\nSQL Server 2017<\/span><\/td>\nHelenski<\/span><\/td>\n2017<\/span><\/td>\n<\/tr>\n
14<\/span><\/td>\nSQL Server 2019<\/span><\/td>\nSeattle<\/span><\/td>\n2019<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

SQL Server 2012:<\/strong><\/p>\n

This version of SQL focused on enhancing dynamic working. In the 2012 version, the performance improvements were done.<\/p>\n

ColumnStore Indexes improvements were also made in the OnLine and partition level operations. Security enhancements like provisioning during the setup and new permission assignments.<\/p>\n

The version also led to improved role management and the default schema assignment for groups.<\/p>\n

SQL Server 2014:<\/strong><\/p>\n

This version brought in the memory capacity to handle all the contents in the disk only. For the disk-based SQL applications, it brought in the usage of the SSD Buffer Pool Extension.<\/p>\n

This further improves the performance by accessing the cache between the RAM and the spinning media.<\/p>\n

SQL Server 2016:<\/strong><\/p>\n

This version was upgraded and was better at handling the memory.<\/p>\n

SQL 2016 version is supported on the x64 processors only and is no longer supported on the x86 processors.<\/p>\n

SQL Server 2017:<\/strong><\/p>\n

This version brought in support for the Linux operating system making it globally applicable.<\/p>\n

SQL Server 2019:<\/strong><\/p>\n

This SQL version brought in Big Data Clusters for server use. It also provides additional capability and improvements for the SQL Server.<\/p>\n

Various services were also introduced in this version.<\/p>\n

Some of the important services which were introduced are as follows:<\/p>\n

    \n
  • SQL Server Analysis Services<\/li>\n
  • Server Machine Learning Services in SQL<\/li>\n
  • SQL Server on Linux<\/li>\n
  • SQL Server Master Data Services<\/li>\n<\/ul>\n

    Summary<\/h3>\n

    In this tutorial, we have found all about the creation and development of SQL from scratch. When we dive deep, we find that SQL was born out of research work.<\/p>\n

    This later became the standard language of communication for Relational Databases.<\/p>\n

    At present, we have a variety of SQL versions available around us.<\/p>\n

    To keep those versions in check, we have a standardization authority that maintains and keeps a check on the standards and the rules which any SQL version needs to follow.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this tutorial, we will discuss the past and present versions of SQL.Let’s start!!! What is SQL and its Origin? SQL, or what we know as Structured Query Language, is the most popular language...<\/p>\n","protected":false},"author":1,"featured_media":87158,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[13464,23844],"class_list":["post-87157","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql-history","tag-sql-version-history"],"yoast_head":"\nMicrosoft SQL Version History - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn Microsoft SQL Version History. Check different years in which different versions of SQL were launched and features of these versions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Version History - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn Microsoft SQL Version History. Check different years in which different versions of SQL were launched and features of these versions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-18T03:30:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/03\/SQL-Version-History.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft SQL Version History - DataFlair","description":"Learn Microsoft SQL Version History. Check different years in which different versions of SQL were launched and features of these versions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft SQL Version History - DataFlair","og_description":"Learn Microsoft SQL Version History. Check different years in which different versions of SQL were launched and features of these versions.","og_url":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2021-03-18T03:30:05+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/03\/SQL-Version-History.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9"},"headline":"Microsoft SQL Version History","datePublished":"2021-03-18T03:30:05+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/"},"wordCount":593,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/03\/SQL-Version-History.jpg","keywords":["SQL History","SQL Version History"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/","url":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/","name":"Microsoft SQL Version History - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/03\/SQL-Version-History.jpg","datePublished":"2021-03-18T03:30:05+00:00","description":"Learn Microsoft SQL Version History. Check different years in which different versions of SQL were launched and features of these versions.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/03\/SQL-Version-History.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/03\/SQL-Version-History.jpg","width":1200,"height":628,"caption":"SQL Version History"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/microsoft-sql-version-history\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SQL Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sql\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Version History"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team is a group of passionate educators and industry experts dedicated to providing high-quality online learning resources on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. With years of experience in the field, the team aims to simplify complex topics and help learners advance their careers. At DataFlair, we believe in empowering students and professionals with the knowledge and skills needed to thrive in today\u2019s fast-paced tech industry. Follow us for Free courses, expert insights, tutorials, and practical tips to boost your learning journey.","url":"https:\/\/data-flair.training\/blogs\/author\/datafbdad\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/87157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=87157"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/87157\/revisions"}],"predecessor-version":[{"id":87160,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/87157\/revisions\/87160"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/87158"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=87157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=87157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=87157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}