{"id":717,"date":"2018-07-30T22:06:42","date_gmt":"2018-07-30T15:06:42","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=717"},"modified":"2024-03-02T10:24:41","modified_gmt":"2024-03-02T03:24:41","slug":"what-is-sql-server","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/","title":{"rendered":"What is SQL Server"},"content":{"rendered":"\n<p>SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft.<\/p>\n\n\n\n<p>Similar to other RDBMS software, SQL Server is built on top of <a href=\"https:\/\/www.sqltutorial.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL<\/a>, a standard programming language for interacting with relational databases. SQL Server is tied to Transact-SQL, or T-SQL, Microsoft&#8217;s implementation of SQL, which includes a set of proprietary programming constructs.<\/p>\n\n\n\n<p>SQL Server has been exclusively available on the Windows environment for over 20 years. In 2016, Microsoft made it available on Linux. SQL Server 2017 became generally available in October 2016 and was compatible with both Windows and Linux.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='sql-server-architecture'>SQL Server Architecture <a href=\"#sql-server-architecture\" class=\"anchor\" id=\"sql-server-architecture\" title=\"Anchor for SQL Server Architecture\">#<\/a><\/h2>\n\n\n\n<p>The following diagram illustrates the architecture of the SQL Server:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"768\" src=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png\" alt=\"What is SQL Server - SQL Server Architecture \" class=\"wp-image-719\" srcset=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png 985w, https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture-300x234.png 300w, https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture-768x599.png 768w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/figure>\n\n\n\n<p>SQL Server consists of two main components:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database Engine<\/li>\n\n\n\n<li>SQLOS<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id='database-engine'>Database Engine <a href=\"#database-engine\" class=\"anchor\" id=\"database-engine\" title=\"Anchor for Database Engine\">#<\/a><\/h3>\n\n\n\n<p>The core component of the SQL Server is the Database Engine, which comprises a relational engine that processes queries and a storage engine that manages database files, pages, indexes, etc.<\/p>\n\n\n\n<p>Additionally, the database engine creates database objects such as <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-stored-procedures\/basic-sql-server-stored-procedures\/\">stored procedures<\/a>, <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-views\/\">views<\/a>, and <a href=\"https:\/\/www.sqlservertutorial.net\/sql-server-triggers\/\">triggers<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id='relational-engine'>Relational Engine <a href=\"#relational-engine\" class=\"anchor\" id=\"relational-engine\" title=\"Anchor for Relational Engine\">#<\/a><\/h4>\n\n\n\n<p>The Relational Engine contains the components that determine the optimal method for executing a query. It is also known as the query processor.<\/p>\n\n\n\n<p>The relational engine requests data from the storage engine based on the input query and processes the results.<\/p>\n\n\n\n<p>Some tasks of the relational engine include querying processing, memory management, thread and task management, buffer management, and distributed query processing.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id='storage-engine'>Storage Engine <a href=\"#storage-engine\" class=\"anchor\" id=\"storage-engine\" title=\"Anchor for Storage Engine\">#<\/a><\/h4>\n\n\n\n<p>The storage engine is responsible for storing and retrieving data from the storage systems such as disks and SAN.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id='sqlos'>SQLOS <a href=\"#sqlos\" class=\"anchor\" id=\"sqlos\" title=\"Anchor for SQLOS\">#<\/a><\/h3>\n\n\n\n<p>Under the relational engine and storage engine lies the SQL Server Operating System, or SQLOS.<\/p>\n\n\n\n<p>SQLOS provides various operating system services such as memory and I\/O management, as well as exception handling and synchronization services.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='sql-server-services-and-tools'>SQL Server Services and Tools <a href=\"#sql-server-services-and-tools\" class=\"anchor\" id=\"sql-server-services-and-tools\" title=\"Anchor for SQL Server Services and Tools\">#<\/a><\/h2>\n\n\n\n<p>Microsoft offers both data management and business intelligence (BI) tools and services alongside SQL Server.<\/p>\n\n\n\n<p>For data management, SQL Server includes SQL Server Integration Services (SSIS), SQL Server Data Quality Service, and SQL Server Master Data Services.<\/p>\n\n\n\n<p>For database development, SQL Server provides SQL Server Data tools; and for managing, deploying, and monitoring databases, SQL Server has the SQL Server Management Studio (SSMS).<\/p>\n\n\n\n<p>For data analysis, SQL Server offers SQL Server Analysis Services (SSAS). SQL Server Reporting Services (SSRS) provides reports and data visualization. The Machine Learning Services technology first appeared first in SQL Server 2016, originally known as the R Services.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='sql-server-editions'>SQL Server Editions <a href=\"#sql-server-editions\" class=\"anchor\" id=\"sql-server-editions\" title=\"Anchor for SQL Server Editions\">#<\/a><\/h2>\n\n\n\n<p>SQL Server has four primary editions, each offering different bundled services and tools. Two editions are available free of charge:<\/p>\n\n\n\n<p><strong>SQL Server Developer Edition<\/strong> is intended for database development and testing purposes.<\/p>\n\n\n\n<p><strong>SQL Server Express Edition<\/strong> is suitable for small databases with a storage capacity of up to 10 GB.<\/p>\n\n\n\n<p>For larger and more critical applications, SQL Server offers the <strong>Enterprise edition<\/strong>, which includes all SQL Server&#8217;s features.<\/p>\n\n\n\n<p><strong>SQL Server Standard Edition<\/strong> has a subset of features available in the Enterprise Edition and imposes limitations on the server, including restrictions on the number of processor cores and memory configurations.<\/p>\n\n\n\n<p><strong>SQL Server Web Edition<\/strong> is a good option for web hosting companies due to its low total cost of ownership.<\/p>\n\n\n\n<p>For detailed information on the SQL Server Editions, check out the available <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/editions-and-components-of-sql-server-2022?view=sql-server-ver16#sql-server-editions\" target=\"_blank\" rel=\"noreferrer noopener\">Server Server 2022 Editions<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id='summary'>Summary <a href=\"#summary\" class=\"anchor\" id=\"summary\" title=\"Anchor for Summary\">#<\/a><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL server architecture includes a database engine and SQL server operation system (SQLOS)<\/li>\n\n\n\n<li>SQL server offers a set of tools for working with data effectively.<\/li>\n\n\n\n<li>SQL server has different editions including developer edition, expression, enterprise, and standard.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"717\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/\"\n\t\t\t\tdata-post-title=\"What is SQL Server\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"717\"\n\t\t\t\tdata-post-url=\"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/\"\n\t\t\t\tdata-post-title=\"What is SQL Server\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server is a relational database management system (RDBMS) developed and marketed by Microsoft. Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with relational databases. SQL Server is tied to Transact-SQL, or T-SQL, Microsoft&#8217;s implementation of SQL, which includes a set of proprietary programming [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":394,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-717","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is SQL Server<\/title>\n<meta name=\"description\" content=\"SQL Server is a relational database management system (RDBMS) developed by Microsoft, which allows you to manage databases effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is SQL Server\" \/>\n<meta property=\"og:description\" content=\"SQL Server is a relational database management system (RDBMS) developed by Microsoft, which allows you to manage databases effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-02T03:24:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/\",\"name\":\"What is SQL Server\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/What-is-SQL-Server-SQL-Server-Architecture.png\",\"datePublished\":\"2018-07-30T15:06:42+00:00\",\"dateModified\":\"2024-03-02T03:24:41+00:00\",\"description\":\"SQL Server is a relational database management system (RDBMS) developed by Microsoft, which allows you to manage databases effectively.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/What-is-SQL-Server-SQL-Server-Architecture.png\",\"contentUrl\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/wp-content\\\/uploads\\\/What-is-SQL-Server-SQL-Server-Architecture.png\",\"width\":985,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/what-is-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started with SQL Server\",\"item\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/getting-started\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"What is SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/\",\"name\":\"SQL Server Tutorial\",\"description\":\"The Practical SQL Server Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlservertutorial.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is SQL Server","description":"SQL Server is a relational database management system (RDBMS) developed by Microsoft, which allows you to manage databases effectively.","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:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"What is SQL Server","og_description":"SQL Server is a relational database management system (RDBMS) developed by Microsoft, which allows you to manage databases effectively.","og_url":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/","og_site_name":"SQL Server Tutorial","article_modified_time":"2024-03-02T03:24:41+00:00","og_image":[{"url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/","url":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/","name":"What is SQL Server","isPartOf":{"@id":"https:\/\/www.sqlservertutorial.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png","datePublished":"2018-07-30T15:06:42+00:00","dateModified":"2024-03-02T03:24:41+00:00","description":"SQL Server is a relational database management system (RDBMS) developed by Microsoft, which allows you to manage databases effectively.","breadcrumb":{"@id":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/#primaryimage","url":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png","contentUrl":"https:\/\/www.sqlservertutorial.net\/wp-content\/uploads\/What-is-SQL-Server-SQL-Server-Architecture.png","width":985,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlservertutorial.net\/getting-started\/what-is-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlservertutorial.net\/"},{"@type":"ListItem","position":2,"name":"Getting Started with SQL Server","item":"https:\/\/www.sqlservertutorial.net\/getting-started\/"},{"@type":"ListItem","position":3,"name":"What is SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlservertutorial.net\/#website","url":"https:\/\/www.sqlservertutorial.net\/","name":"SQL Server Tutorial","description":"The Practical SQL Server Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlservertutorial.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":4,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/717\/revisions"}],"predecessor-version":[{"id":3382,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/717\/revisions\/3382"}],"up":[{"embeddable":true,"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/pages\/394"}],"wp:attachment":[{"href":"https:\/\/www.sqlservertutorial.net\/wp-json\/wp\/v2\/media?parent=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}