{"id":9248,"date":"2019-02-08T08:46:00","date_gmt":"2019-02-08T08:46:00","guid":{"rendered":"https:\/\/dbtut.com\/?p=9248"},"modified":"2019-02-08T08:46:00","modified_gmt":"2019-02-08T08:46:00","slug":"how-to-find-total-size-of-all-databases-in-all-instance","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/","title":{"rendered":"How To Find Total Size of All Databases in All Instance"},"content":{"rendered":"

 <\/p>\n

Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes your manager can want to information from you about the total size of sql server databases.<\/p>\n

In this case, if you have a few number of instance and you are not using one of the high availability solutions, you can find the database sizes by running the following query in each instance using the following script.<\/p>\n

I will give the script that find total size of all databases at the end of the article.<\/p>\n

Database Sizes in a Standalone Instance:<\/strong><\/p>\n

WITH X\r\nAS\r\n(\r\n\u00a0\u00a0\u00a0 select database_id, type, size * 8.0 \/ 1024\/1024 size\r\n\u00a0\u00a0\u00a0 from sys.master_files\r\n)\r\nSELECT\r\n\u00a0\u00a0\u00a0 NAME AS Database_Name,\r\n\u00a0\u00a0\u00a0 (SELECT SUM(size) from X where type = 0 and X.database_id = db.database_id) +\r\n\u00a0\u00a0\u00a0 (SELECT SUM(size) from X where type = 1 and X.database_id = db.database_id) Database_Size_GB\r\nFROM sys.databases db\r\nWHERE (SELECT SUM(size) from X where type = 1 and X.database_id = db.database_id) is not null\r\nORDER BY Database_Size_GB desc<\/pre>\n
\"\"<\/p>\n
Some systems that use availability group also have databases that are not included in the availability group. That’s why we need to modify the script a little.<\/p>\n
When we change the script as follows, it lists the names and sizes of all active databases on that instance.<\/p>\n
A database included in the Availability Group is listed if it is a primary. Standalone databases are also included in the list.<\/p>\n
WITH X\r\nAS\r\n(\r\n\u00a0\u00a0\u00a0 SELECT database_id, type, size * 8.0 \/ 1024\/1024 size\r\n\u00a0\u00a0\u00a0 FROM sys.master_files where database_id IN\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT DISTINCT\r\nDB_ID(dbcs.database_name) AS database_id\r\nFROM master.sys.availability_groups AS AG\r\nLEFT OUTER JOIN master.sys.dm_hadr_availability_group_states as agstates\r\n\u00a0\u00a0 ON AG.group_id = agstates.group_id\r\nINNER JOIN master.sys.availability_replicas AS AR\r\n\u00a0\u00a0 ON AG.group_id = AR.group_id\r\nINNER JOIN master.sys.dm_hadr_availability_replica_states AS arstates\r\n\u00a0\u00a0 ON AR.replica_id = arstates.replica_id AND arstates.is_local = 1\r\nINNER JOIN master.sys.dm_hadr_database_replica_cluster_states AS dbcs\r\n\u00a0\u00a0 ON arstates.replica_id = dbcs.replica_id\r\nLEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs\r\n\u00a0\u00a0 ON dbcs.replica_id = dbrs.replica_id AND dbcs.group_database_id = dbrs.group_database_id\r\nWHERE ISNULL(arstates.role, 3) = 1\r\nUNION ALL\r\nSELECT DB_ID(name) database_id from sys.databases WHERE replica_id is null and database_id >4\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n)\r\nSELECT\r\n\u00a0\u00a0\u00a0 NAME,\r\n\u00a0\u00a0\u00a0 (SELECT SUM(size) from X where type = 0 and X.database_id = db.database_id) +\r\n\u00a0\u00a0\u00a0 (select SUM(size) from X where type = 1 and X.database_id = db.database_id) Database_Size_GB\r\nFROM sys.databases db\r\nWHERE (select SUM(size) from X where type = 1 and X.database_id = db.database_id) is not null\r\nORDER BY Database_Size_GB DESC<\/pre>\n
You must run this script in both the primary and secondary instance in instances that use availability group, and you must sum the result.<\/p>\n
Let’s make our work a little easier. Instead of calculating the total database size on that instance manually, calculate it with the cursor. The following script gives the total size of all databases on an instance.<\/p>\n
DECLARE @size int\r\nDECLARE @total_size int\r\nset @total_size=0\r\nDECLARE MyCursor CURSOR FOR\u00a0\r\nwith X\r\nas\r\n(\r\n\u00a0\u00a0\u00a0 SELECT database_id, type, size * 8.0 \/ 1024\/1024 size\r\n\u00a0\u00a0\u00a0 FROM sys.master_files WHERE database_id IN\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT DISTINCT\r\nDB_ID(dbcs.database_name) AS database_id\r\nFROM master.sys.availability_groups AS AG\r\nLEFT OUTER JOIN master.sys.dm_hadr_availability_group_states as agstates\r\n\u00a0\u00a0 ON AG.group_id = agstates.group_id\r\nINNER JOIN master.sys.availability_replicas AS AR\r\n\u00a0\u00a0 ON AG.group_id = AR.group_id\r\nINNER JOIN master.sys.dm_hadr_availability_replica_states AS arstates\r\n\u00a0\u00a0 ON AR.replica_id = arstates.replica_id AND arstates.is_local = 1\r\nINNER JOIN master.sys.dm_hadr_database_replica_cluster_states AS dbcs\r\n\u00a0\u00a0 ON arstates.replica_id = dbcs.replica_id\r\nLEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs\r\n\u00a0\u00a0 ON dbcs.replica_id = dbrs.replica_id AND dbcs.group_database_id = dbrs.group_database_id\r\nWHERE ISNULL(arstates.role, 3) = 1\r\nunion all\r\nSELECT DB_ID(name) database_id FROM sys.databases WHERE replica_id is null and database_id >4\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 )\r\n)\r\nSELECT\u00a0\u00a0\u00a0\u00a0\r\n\u00a0\u00a0\u00a0 (SELECT SUM(size) FROM X WHERE type = 0 and X.database_id = db.database_id) +\r\n\u00a0\u00a0\u00a0 (SELECT SUM(size) FROM X WHERE type = 1 and X.database_id = db.database_id) Database_Size_GB\r\nFROM sys.databases db\r\nWHERE (SELECT SUM(size) FROM X WHERE type = 1 and X.database_id = db.database_id) is not null\r\nORDER BY Database_Size_GB DESC\r\nOPEN MyCursor\u00a0\u00a0\r\nFETCH NEXT FROM MyCursor INTO @size\u00a0\u00a0\r\nWHILE @@FETCH_STATUS = 0\u00a0\u00a0\r\nBEGIN\u00a0\u00a0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SET @total_size= @total_size+@size\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0FETCH NEXT FROM MyCursor INTO @size\u00a0\u00a0\r\nEND\u00a0\u00a0\r\nCLOSE MyCursor\u00a0\u00a0\r\nDEALLOCATE MyCursor\r\nSELECT @total_size AS Total_Database_Size_GB<\/pre>\n
You can see the screen output of the result of the above script in the screenshot below. By calculating the sum of the results from the previous script, the total size on that instance is returned as a result.<\/p>\n
\"\"<\/p>\n
If you have more instances, you can use the Registered Server instead of running this script by connecting to each instance. You can find the article about the Registered Server below.<\/p>\n
“How To Execute a Script on Multiple Instance with Registered Server<\/a>”<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes your manager can want to information from you about the total size of sql server databases. In this case, if you have a few number of instance and you are …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"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":[1964,1966,1965],"class_list":["post-9248","post","type-post","status-publish","format-standard","","category-mssql","tag-database-sizes-in-an-instance","tag-total-database-size-in-all-instances","tag-total-database-size-in-an-instance"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":4430,"today_views":0},"yoast_head":"\nHow To Find Total Size of All Databases in All Instance - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find Total Size of All Databases in All Instance\" \/>\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\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find Total Size of All Databases in All Instance - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find Total Size of All Databases in All Instance\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-08T08:46:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.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\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Find Total Size of All Databases in All Instance\",\"datePublished\":\"2019-02-08T08:46:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\"},\"wordCount\":329,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png\",\"keywords\":[\"Database Sizes in an instance\",\"total database size in all instances\",\"Total database size in an instance\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\",\"name\":\"How To Find Total Size of All Databases in All Instance - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png\",\"datePublished\":\"2019-02-08T08:46:00+00:00\",\"description\":\"How To Find Total Size of All Databases in All Instance\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png\",\"width\":1173,\"height\":850},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find Total Size of All Databases in All Instance\"}]},{\"@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":"How To Find Total Size of All Databases in All Instance - Database Tutorials","description":"How To Find Total Size of All Databases in All Instance","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\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/","og_locale":"en_US","og_type":"article","og_title":"How To Find Total Size of All Databases in All Instance - Database Tutorials","og_description":"How To Find Total Size of All Databases in All Instance","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-08T08:46:00+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png","type":"","width":"","height":""}],"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\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Find Total Size of All Databases in All Instance","datePublished":"2019-02-08T08:46:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/"},"wordCount":329,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png","keywords":["Database Sizes in an instance","total database size in all instances","Total database size in an instance"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/","name":"How To Find Total Size of All Databases in All Instance - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png","datePublished":"2019-02-08T08:46:00+00:00","description":"How To Find Total Size of All Databases in All Instance","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c5d40666cf58.png","width":1173,"height":850},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/08\/how-to-find-total-size-of-all-databases-in-all-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Find Total Size of All Databases in All Instance"}]},{"@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\/9248","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=9248"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9248\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}