{"id":661,"date":"2018-07-06T21:08:48","date_gmt":"2018-07-06T21:08:48","guid":{"rendered":"http:\/\/dbtut.com\/?p=661"},"modified":"2019-01-29T07:09:25","modified_gmt":"2019-01-29T07:09:25","slug":"always-on-availability-group-alert-system","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/","title":{"rendered":"Always On Availability Group Alert System"},"content":{"rendered":"<p>There are a few important things to check for SQL Server Always On Availability Group.<\/p>\n<h4><\/h4>\n<h4>Did the failover occur on any AG?<\/h4>\n<h4>Does the transfer to the Secondary Database not continue?<\/h4>\n<p>You can define an alert for the actions I have specified above, and you will be able to send an e-mail when it happens.<\/p>\n<p><span lang=\"en-US\">Before this article, I would recommend you to read the article titled &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/09\/sql-server-best-practices-and-configurations-that-need-to-be-made-after-installation\/\" target=\"_blank\" rel=\"noopener\">SQL Server Best Practices and Configurations that need to be made After Installation<\/a>&#8220;.<\/span><\/p>\n<p><span lang=\"tr\">This article will guide you through information about Alert and Database Mail.<\/span><\/p>\n<p>First, we will create an alert, it will be triggered when the availability group failed over and send us to mail.<\/p>\n<p>Right click on the Alert tab under SQL Server Agent and click on new alert as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png\" width=\"278\" height=\"362\" \/><\/p>\n<p><span lang=\"en-US\">As you can see in the screen below, we write <\/span><span lang=\"tr\">&#8220;<\/span><span lang=\"en-US\">Always ON Monitoring Role Change<\/span><span lang=\"tr\">&#8220;<\/span><span lang=\"en-US\"> in Name. We write 1480 by selecting Error Number from the &#8220;Alerts will be raised based on&#8221; section.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/737.png\" width=\"568\" height=\"263\" \/><\/p>\n<p><span lang=\"en-US\">Then, in order to send us an e-mail, we go to the Response tab which appears on the left. As shown in the following screen display, we select the Operator we have defined previously by selecting Notify operators and we mark the Email section. <\/span><\/p>\n<p><span lang=\"en-US\">I would recommend reading the &#8220;<\/span><a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/07\/how-to-configure-database-mail-on-sql-server\/\" target=\"_blank\" rel=\"noopener\"><span lang=\"tr\">How To Configure Database Mail On SQL Server<\/span><\/a><span lang=\"en-US\">&#8221; and &#8220;<\/span><a href=\"http:\/\/dbtut.com\/index.php\/2018\/07\/08\/how-to-create-an-operator-on-sql-server-and-what-is-it\/\" target=\"_blank\" rel=\"noopener\"><span lang=\"tr\">How To Create An Operator On SQL Server and What is It<\/span><\/a><span lang=\"en-US\">&#8221; named articles to ensure that these operations work correctly.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/780.png\" width=\"504\" height=\"223\" \/><\/p>\n<p><span lang=\"en-US\">And after these operations, <\/span><span lang=\"tr\">w<\/span><span lang=\"en-US\">e are doing the same things about the question<\/span> <span lang=\"en-US\">&#8220;Does the transfer to the Secondary Server not continue?&#8221;. We only write 35264 in the error number part.<\/span><\/p>\n<pre class=\"lang:default decode:true \">select * from sys.messages where\n--(language_id=xx or language_id=yy) AND \ntext like '%availability%'<\/pre>\n<p>First, we will create an alert, and then it will be triggered when the availability group failed over and send us to mail.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_661\" class=\"pvc_stats all  \" data-element-id=\"661\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>There are a few important things to check for SQL Server Always On Availability Group. Did the failover occur on any AG? Does the transfer to the Secondary Database not continue? You can define an alert for the actions I have specified above, and you will be able to send an e-mail when it happens. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_661\" class=\"pvc_stats all  \" data-element-id=\"661\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/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":[737,739,733,732,740,695,738,736,741,691,743,742,734,735],"class_list":["post-661","post","type-post","status-publish","format-standard","","category-mssql","tag-737","tag-ag","tag-always-on","tag-always-on-alert-system","tag-availability-group","tag-database-mail","tag-database-mail-configuration","tag-error-number","tag-faiilover","tag-new-alert","tag-primary-server","tag-secondary-server","tag-sql-server-alert","tag-sql-server-always-on"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":370,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Always On Availability Group Alert System - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Always On Alert System\" \/>\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\/2018\/07\/06\/always-on-availability-group-alert-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Always On Availability Group Alert System - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Always On Alert System\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-06T21:08:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-29T07:09:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Always On Availability Group Alert System\",\"datePublished\":\"2018-07-06T21:08:48+00:00\",\"dateModified\":\"2019-01-29T07:09:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\"},\"wordCount\":304,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png\",\"keywords\":[\"1480\",\"ag\",\"Always On\",\"Always On Alert System\",\"availability group\",\"database mail\",\"Database Mail Configuration\",\"Error Number\",\"faiilover\",\"New Alert\",\"primary server\",\"secondary server\",\"SQL Server Alert\",\"SQL Server Always On\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\",\"name\":\"Always On Availability Group Alert System - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png\",\"datePublished\":\"2018-07-06T21:08:48+00:00\",\"dateModified\":\"2019-01-29T07:09:25+00:00\",\"description\":\"Always On Alert System\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Always On Availability Group Alert System\"}]},{\"@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":"Always On Availability Group Alert System - Database Tutorials","description":"Always On Alert System","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\/2018\/07\/06\/always-on-availability-group-alert-system\/","og_locale":"en_US","og_type":"article","og_title":"Always On Availability Group Alert System - Database Tutorials","og_description":"Always On Alert System","og_url":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/","og_site_name":"Database Tutorials","article_published_time":"2018-07-06T21:08:48+00:00","article_modified_time":"2019-01-29T07:09:25+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Always On Availability Group Alert System","datePublished":"2018-07-06T21:08:48+00:00","dateModified":"2019-01-29T07:09:25+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/"},"wordCount":304,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png","keywords":["1480","ag","Always On","Always On Alert System","availability group","database mail","Database Mail Configuration","Error Number","faiilover","New Alert","primary server","secondary server","SQL Server Alert","SQL Server Always On"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/","url":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/","name":"Always On Availability Group Alert System - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png","datePublished":"2018-07-06T21:08:48+00:00","dateModified":"2019-01-29T07:09:25+00:00","description":"Always On Alert System","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/435.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Always On Availability Group Alert System"}]},{"@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\/661","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=661"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/661\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}