{"id":14291,"date":"2019-12-20T06:31:07","date_gmt":"2019-12-20T06:31:07","guid":{"rendered":"https:\/\/dbtut.com\/?p=14291"},"modified":"2019-12-20T06:42:04","modified_gmt":"2019-12-20T06:42:04","slug":"how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/","title":{"rendered":"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017"},"content":{"rendered":"

New Dmw sys.dm_db_log_stats in SQL Server 2017<\/h2>\n

To understand SQL Server architecture, you must understand the architecture of the SQL Server Transaction Log file. Transaction Log file is also one of the most important components in terms of performance. To understand the architecture of the Transaction Log file, I recommend reading “What is SQL Server Transaction Log”<\/p>\n

With SQL Server 2017, a dmv has been announced to query the transaction log file. We could access transaction log informations in other ways instead of using this dmw. But in my opinion, such a dmw was needed for easier access.<\/p>\n

Using this dmw, we can easily find databases with high vlf count or databases without log backups.<\/p>\n

I recommend you to read the article “Vlf (Virtual Log File) Count” to learn detailed information about Vlf. As an important note, vlf count is very important for database performance.<\/p>\n

Find VLF Count by using sys.dm_db_log_stats<\/h2>\n

Below you can find the query that shows the vlf count of databases if vlf count of database is more than 100.<\/p>\n

SELECT name AS 'DBName', total_vlf_count AS 'VLF Count' \nFROM sys.databases AS db\nCROSS APPLY sys.dm_db_log_stats(db.database_id) \nWHERE total_vlf_count  > 100;<\/pre>\n
Find Last Log Backup Date by using sys.dm_db_log_stats<\/h2>\n
Below you can find the query that shows the last log backup date of the databases.<\/p>\n
SELECT name AS 'DBName', log_backup_time AS 'LastLogBackupDate' \nFROM sys.databases AS db\nCROSS APPLY sys.dm_db_log_stats(db.database_id);<\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
New Dmw sys.dm_db_log_stats in SQL Server 2017 To understand SQL Server architecture, you must understand the architecture of the SQL Server Transaction Log file. Transaction Log file is also one of the most important components in terms of performance. To understand the architecture of the Transaction Log file, I recommend reading “What is SQL Server …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":14292,"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":[6737,6740,6739,6738,6733,6732,5526,6731,6742,6743,6744,6745,6734,6736,6735,6741],"class_list":["post-14291","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-dmv-for-log-statistics-in-sql-server","tag-dmv-for-sql-server-transaction-log","tag-dmv-for-transaction-log","tag-dmv-for-transaction-log-in-sql-server","tag-find-last-log-backup-date","tag-find-last-log-backup-date-by-using-sys-dm_db_log_stats","tag-find-vlf-count","tag-find-vlf-count-by-using-sys-dm_db_log_stats","tag-gather-transaction-log-info","tag-gather-transaction-log-information","tag-how-big-is-your-transaction-log","tag-monitoring-virtual-log-file-information","tag-new-dmw-sys-dm_db_log_stats-in-sql-server-2017","tag-sql-server-transaction-log-file-information","tag-sys-dm_db_log_stats","tag-transaction-log-information-gathering"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":309,"today_views":0},"yoast_head":"\nHow To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Access SQL Server Transaction Log File Information with sys.dm_db_log_stats\" \/>\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\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Access SQL Server Transaction Log File Information with sys.dm_db_log_stats\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-20T06:31:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-20T06:42:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"319\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017\",\"datePublished\":\"2019-12-20T06:31:07+00:00\",\"dateModified\":\"2019-12-20T06:42:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\"},\"wordCount\":229,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png\",\"keywords\":[\"DMV for Log Statistics in SQL Server\",\"DMV for SQL Server Transaction Log\",\"DMV for Transaction Log\",\"DMV for Transaction Log in SQL Server\",\"Find Last Log Backup Date\",\"Find Last Log Backup Date by using sys.dm_db_log_stats\",\"Find VLF Count\",\"Find VLF Count by using sys.dm_db_log_stats\",\"gather transaction log info\",\"gather transaction log information\",\"How Big is Your Transaction Log?\",\"Monitoring Virtual Log File Information\",\"New Dmw sys.dm_db_log_stats in SQL Server 2017\",\"SQL Server Transaction Log File Information\",\"sys.dm_db_log_stats\",\"Transaction log Information gathering\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\",\"name\":\"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png\",\"datePublished\":\"2019-12-20T06:31:07+00:00\",\"dateModified\":\"2019-12-20T06:42:04+00:00\",\"description\":\"How To Access SQL Server Transaction Log File Information with sys.dm_db_log_stats\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png\",\"width\":550,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017\"}]},{\"@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 Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017 - Database Tutorials","description":"How To Access SQL Server Transaction Log File Information with sys.dm_db_log_stats","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\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/","og_locale":"en_US","og_type":"article","og_title":"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017 - Database Tutorials","og_description":"How To Access SQL Server Transaction Log File Information with sys.dm_db_log_stats","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-20T06:31:07+00:00","article_modified_time":"2019-12-20T06:42:04+00:00","og_image":[{"width":550,"height":319,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017","datePublished":"2019-12-20T06:31:07+00:00","dateModified":"2019-12-20T06:42:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/"},"wordCount":229,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png","keywords":["DMV for Log Statistics in SQL Server","DMV for SQL Server Transaction Log","DMV for Transaction Log","DMV for Transaction Log in SQL Server","Find Last Log Backup Date","Find Last Log Backup Date by using sys.dm_db_log_stats","Find VLF Count","Find VLF Count by using sys.dm_db_log_stats","gather transaction log info","gather transaction log information","How Big is Your Transaction Log?","Monitoring Virtual Log File Information","New Dmw sys.dm_db_log_stats in SQL Server 2017","SQL Server Transaction Log File Information","sys.dm_db_log_stats","Transaction log Information gathering"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/","name":"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png","datePublished":"2019-12-20T06:31:07+00:00","dateModified":"2019-12-20T06:42:04+00:00","description":"How To Access SQL Server Transaction Log File Information with sys.dm_db_log_stats","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-11.png","width":550,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/20\/how-to-access-sql-server-transaction-log-file-information-with-new-dmw-sys-dm_db_log_stats-in-sql-server-2017\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Access SQL Server Transaction Log File Information with New Dmw sys.dm_db_log_stats in SQL Server 2017"}]},{"@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\/14291","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=14291"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14291\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14292"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}