{"id":12977,"date":"2019-08-20T17:27:51","date_gmt":"2019-08-20T17:27:51","guid":{"rendered":"https:\/\/dbtut.com\/?p=12977"},"modified":"2019-08-20T17:27:53","modified_gmt":"2019-08-20T17:27:53","slug":"sql-server-architecture","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/","title":{"rendered":"SQL Server Architecture"},"content":{"rendered":"

In this article I will describe SQL Server Architecture. In the article, I will proceed through the following image that I received from wikipedia. And I will briefly discuss what these layers do.<\/p>\n

\"\"<\/p>\n

As you can see, SQL Server Architecture consists of 3 main layers.<\/p>\n

Layer 1: SQL Server Network Interface (SNI)<\/h4>\n

The components in the External Protocols section that you see in the top are called SQL Server Network Interface (SNI).<\/p>\n

Layer 2: Database Engine<\/h4>\n

Database Engine includes Storage Engine, Query Processor and other components.<\/p>\n

Layer 3: SQLOS API<\/h4>\n

After this part of the article we will detail these layers.<\/p>\n

Layer 1: SQL Server Network Interface (SNI)<\/h1>\n

SNI is the protocol layer that provides the connection between client and server. SQL Server supports the following 4 protocols.<\/p>\n

You can configure these protocols on SQL Server Configuration Manager. As you can see below, there are different protocol configurations for each instance. In the picture below, the Shared Memory and TCP \/ IP protocol is active.<\/p>\n

For other SQL Server Configuration Manager settings, I recommend that you read the article “SQL Server Configuration Manager Settings<\/a>“.<\/p>\n

\"\"<\/p>\n

Shared Memory<\/h3>\n

The protocol used when the Client and Server are on the same machine. You cannot configure. You can only disable it. If you are using the server where the sql server is installed as a client, by default the sql server attempts to connect to the instance using this protocol.<\/p>\n

Named Pipes<\/h3>\n

This protocol is used when Client and Server are on the same LAN. It uses the TCP 445 port. It can be used in environments where there is no TCP \/ IP protocol.<\/p>\n

TCP \/ IP<\/h3>\n

The most widely used and accepted protocol all over the world. When a client connecting to a sql server, it uses an IP or server name and port (eg 10.56.43.23,1433<\/strong>). The default tcp port of SQL Server is 1433.<\/p>\n

Virtual Interface Adapter (VIA)<\/h3>\n

You cannot see this protocol in SQL Server Configuration Manager. Although it is a high performance protocol, it is not preferred because it requires additional hardware in client and server.<\/p>\n

Layer 2: Database Engine<\/h1>\n

We will examine the Database Engine as Relational Engine(Query Processor) and Storage Engine.<\/p>\n

Relational Engine(Query Processor)<\/h3>\n

Relational Engine is responsible for running queries in the most optimized way. It consists of the following components.<\/p>\n

SQL Manager:<\/strong> Manages the procedure cache. It responsible for the execution of Stored Procedures and automatic parameterization of ad hoc queries. When a query is run, SQL Manager first searches for the query in the cache. If the query is not in the cache, it determines that the query must be compiled. Then the Parse process starts.<\/p>\n

Parser:<\/strong> Converts the query to be processed more easily by a computer. It also checks for typos.<\/p>\n

Optimizer:<\/strong> There are many ways to run the query to transfer data to the end-user. For example, index seek + key lookup or Clustered Index Scan can produce a query result. The optimizer prepares the execution plan to run the query in the most optimized way by using the statistics. You may be interested in the following articles.<\/p>\n

“Statistic Concept and Performance Effect on SQL Server<\/a>“,<\/p>\n

“Index Concept and Performance Effect on SQL Server<\/a>”<\/p>\n

Query Executor:<\/strong> This is the part where the query is executed step by step using the execution plan created by the optimizer.<\/p>\n

It also contacts with the Storage Engine.<\/p>\n

Storage Engine<\/h3>\n

As the name implies, it is responsible for storing data. You can find its subcomponents below.<\/p>\n

Buffer Manager:<\/strong> The process of transferring data that is not in memory from disk to memory and rewriting the changed data from memory to disk is managed here.<\/p>\n

Transaction Services:<\/strong><\/p>\n

\u2022 Ensures that transactions meet ACID rules. You may want to read the article “SQL Server ACID Rules<\/a>“.
\n\u2022 Write Ahead Logging (WAL) is managed here. I recommend that you read the article “What is Database Checkpoint<\/a>” for WAL.
\n\u2022 Concurrency controls are managed here. I recommend you to read “Optimistic and Pessimistic Concurrency Control<\/a>“.<\/p>\n

Lock Manager:<\/strong> All lock types are managed here. In the article “SQL Server Lock Types<\/a>” you will find the lock types and their descriptions.<\/p>\n

File Manager:<\/strong> Responsible for allocating space for data in the database.<\/p>\n

You can find information about storage concepts in the article “SQL Server Storage Concepts (Page, Extents, GAM, SGAM, PFS, IAM, BCM, DCM)<\/a>“.<\/p>\n

Layer 3: SQLOS API<\/h1>\n

SQLOS is the layer that manages all operating system resources specific to SQL Server. Announced with SQL Server 2005. Prior to 2005, operating system resources were managed by different parts of the SQL Server Engine. You can see the components managed by SQLOS in the image I shared at the beginning of the article.<\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In this article I will describe SQL Server Architecture. In the article, I will proceed through the following image that I received from wikipedia. And I will briefly discuss what these layers do. As you can see, SQL Server Architecture consists of 3 main layers. Layer 1: SQL Server Network Interface (SNI) The components in …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":12986,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[4751,4755,4756,4747,4745,4735,4737,4732,4733,2783,4739,791,4743,4742,4741,4752,4750,4748,4746,4736,4753,4734,4754,4738,4740,4749,4744],"class_list":["post-12977","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-buffer-manager","tag-detailed-description-of-sql-server-architecture","tag-detailed-explanation-of-sql-server-architecture","tag-file-manager","tag-lock-manager","tag-named-pipes","tag-named-pipes-protocol","tag-shared-memory","tag-shared-memory-protocol","tag-sql-server-architecture","tag-tcp-ip-protocol","tag-tcp-ip","tag-via","tag-virtual-interface-adapter","tag-virtual-interface-adapter-via","tag-what-is-buffer-manager","tag-what-is-buffer-manager-in-sql-server","tag-what-is-file-manager","tag-what-is-lock-manager","tag-what-is-named-pipes","tag-what-is-query-executor","tag-what-is-shared-memory-in-sql-server","tag-what-is-storage-engine-in-sql-server-architecture","tag-what-is-tcp-ip","tag-what-is-tcp-ip-protocol","tag-what-is-transaction-services","tag-what-is-virtual-interface-adapter"],"aioseo_notices":[],"yoast_head":"\nSQL Server Architecture - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Server Architecture\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Architecture - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Server Architecture\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-20T17:27:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-20T17:27:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"602\" \/>\n\t<meta property=\"og:image:height\" content=\"364\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"SQL Server Architecture\",\"datePublished\":\"2019-08-20T17:27:51+00:00\",\"dateModified\":\"2019-08-20T17:27:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\"},\"wordCount\":768,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png\",\"keywords\":[\"Buffer Manager\",\"Detailed description of SQL Server Architecture\",\"Detailed explanation of SQL Server Architecture\",\"File Manager\",\"Lock Manager\",\"Named Pipes\",\"Named Pipes protocol\",\"Shared Memory\",\"Shared Memory protocol\",\"sql server architecture\",\"TCP \/ IP protocol\",\"TCP\/IP\",\"VIA\",\"Virtual Interface Adapter\",\"Virtual Interface Adapter (VIA)\",\"What is Buffer Manager\",\"What is Buffer Manager in sql server\",\"What is File Manager\",\"what is Lock Manager\",\"what is Named Pipes\",\"What is Query Executor\",\"What is Shared Memory in sql server\",\"What is Storage Engine in SQL Server Architecture\",\"What is TCP \/ IP\",\"what is TCP \/ IP protocol\",\"What is Transaction Services\",\"what is Virtual Interface Adapter\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\",\"name\":\"SQL Server Architecture - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png\",\"datePublished\":\"2019-08-20T17:27:51+00:00\",\"dateModified\":\"2019-08-20T17:27:53+00:00\",\"description\":\"SQL Server Architecture\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png\",\"width\":602,\"height\":364},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Architecture\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Architecture - Database Tutorials","description":"SQL Server Architecture","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:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Architecture - Database Tutorials","og_description":"SQL Server Architecture","og_url":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/","og_site_name":"Database Tutorials","article_published_time":"2019-08-20T17:27:51+00:00","article_modified_time":"2019-08-20T17:27:53+00:00","og_image":[{"width":602,"height":364,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"SQL Server Architecture","datePublished":"2019-08-20T17:27:51+00:00","dateModified":"2019-08-20T17:27:53+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/"},"wordCount":768,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png","keywords":["Buffer Manager","Detailed description of SQL Server Architecture","Detailed explanation of SQL Server Architecture","File Manager","Lock Manager","Named Pipes","Named Pipes protocol","Shared Memory","Shared Memory protocol","sql server architecture","TCP \/ IP protocol","TCP\/IP","VIA","Virtual Interface Adapter","Virtual Interface Adapter (VIA)","What is Buffer Manager","What is Buffer Manager in sql server","What is File Manager","what is Lock Manager","what is Named Pipes","What is Query Executor","What is Shared Memory in sql server","What is Storage Engine in SQL Server Architecture","What is TCP \/ IP","what is TCP \/ IP protocol","What is Transaction Services","what is Virtual Interface Adapter"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/","url":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/","name":"SQL Server Architecture - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png","datePublished":"2019-08-20T17:27:51+00:00","dateModified":"2019-08-20T17:27:53+00:00","description":"SQL Server Architecture","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/08\/Ads\u0131z-5.png","width":602,"height":364},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/08\/20\/sql-server-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Architecture"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=12977"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/12977\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/12986"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=12977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=12977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=12977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}