{"id":3855,"date":"2018-10-17T07:02:26","date_gmt":"2018-10-17T07:02:26","guid":{"rendered":"https:\/\/dbtut.com\/?p=3855"},"modified":"2018-11-26T11:14:38","modified_gmt":"2018-11-26T11:14:38","slug":"how-to-execute-a-script-on-multiple-instance-with-registered-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/","title":{"rendered":"How To Execute a Script on Multiple Instance with Registered Server"},"content":{"rendered":"

 <\/p>\n

Sometimes you may want to execute a script in more than one instance.<\/p>\n

It is a solution to connect to each instance individually, but with Registered Server it is possible to do this job in one click.<\/p>\n

In the next section of the article, we will create the Registered Server step by step.<\/p>\n

And with the help of the Registered Server, we will run a script on more than one instance.<\/p>\n

First, we click Registered Servers from View on SSMS as below.<\/p>\n

<\/p>\n

 <\/p>\n

Then we click on New Server Group via Local Server Group.<\/p>\n

<\/p>\n

 <\/p>\n

We give a name for the server group that we create in Group name. I’ve written something like this.<\/p>\n

Sunucu1\\Instance1,Sunucu2\\Instance1<\/p>\n

You can give the name you want. You can also write something in the Group description section.<\/p>\n

<\/p>\n

 <\/p>\n

Then, right-click the server group we created and click New Server Registration.<\/p>\n

<\/p>\n

 <\/p>\n

Then, in the Server name section, we write the name of the instance to which we will connect as shown in the following screen.<\/p>\n

And we also make the necessary selection from the authentication part. I mentioned the types of Authentication in my article “How To Install SQL Server<\/a>“.<\/p>\n

<\/p>\n

 <\/p>\n

I’m adding all the servers I want to run my script at once, and I’m running my script at the same time by clicking new query as follows.<\/p>\n

<\/p>\n

 <\/p>\n

For example, I have 2 servers running Always On. One is primary and the other is secondary. I need to restart one of the servers.<\/p>\n

I must failover all the ag (availability group) ‘s in the server to the other server. I explained this process in my article “SQL Server Availability Group Failover Process<\/a>“.<\/p>\n

But before failover, I need to see the synchronization status of all the availability groups on these two servers. I explained the details of this process in my article “SQL Server Availability Group Databases Synchronization Status<\/a>“.<\/p>\n

If you read these two articles, the process will be clearer in your mind. I used the following script in my article “SQL Server Availability Group Databases Synchronization Status<\/a>“.<\/p>\n

SELECT\r\nAG.name AS [AvailabilityGroupName],\r\ndbcs.database_name AS [DatabaseName],\r\n\u00a0 CASE\r\nWHEN dbrs.synchronization_state =0 THEN 'Not synchronizing'\r\nWHEN dbrs.synchronization_state =1 THEN 'Synchronizing'\r\nWHEN dbrs.synchronization_state =2 THEN 'Synchronized'\r\nWHEN dbrs.synchronization_state =3 THEN 'Reverting'\r\nWHEN dbrs.synchronization_state =4 THEN 'Initializing'\r\n\u00a0 END AS AGState,\r\n\u00a0 ar.failover_mode_desc,\r\n\u00a0 ar.availability_mode_desc,\r\nISNULL(dbrs.is_suspended, 0) AS [IsSuspended]\r\nFROM master.sys.availability_groups AS AG\r\nLEFT OUTER JOIN master.sys.dm_hadr_availability_group_states as agstates\r\nON AG.group_id = agstates.group_id\r\nINNER JOIN master.sys.availability_replicas AS AR\r\nON AG.group_id = AR.group_id\r\nINNER JOIN master.sys.dm_hadr_availability_replica_states AS arstates\r\nON 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\nON arstates.replica_id = dbcs.replica_id\r\nLEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs\r\nON dbcs.replica_id = dbrs.replica_id AND dbcs.group_database_id = dbrs.group_database_id\r\nwhere dbcs.is_database_joined=1\r\nORDER BY AG.name ASC, dbcs.database_name<\/pre>\n
 <\/p>\n
This script gives the synchronization status of all databases in an instance.<\/p>\n
Assume that there are 10 instances in these two servers. In this case, I need to run the above scripts for each instance individually.<\/p>\n
However, with the help of registered server, we can get the result we want by running this script at once.<\/p>\n
If you run the script above with a registered server, you can see a long screen. You can modify the script so that it returns only the problematic databases.<\/p>\n
 <\/p>\n
The following query returns the following values:<\/strong><\/p>\n
databases that are not synchronized yet,<\/p>\n
databases that failover mode are not automatic,<\/p>\n
databases that availability mode are not synchronous<\/p>\n
 <\/p>\n
If the result is not coming, you are ready for failover.<\/p>\n
SELECT\r\nAG.name AS [AvailabilityGroupName],\r\ndbcs.database_name AS [DatabaseName],\r\n\u00a0 CASE\r\nWHEN dbrs.synchronization_state =0 THEN 'Not synchronizing'\r\nWHEN dbrs.synchronization_state =1 THEN 'Synchronizing'\r\nWHEN dbrs.synchronization_state =2 THEN 'Synchronized'\r\nWHEN dbrs.synchronization_state =3 THEN 'Reverting'\r\nWHEN dbrs.synchronization_state =4 THEN 'Initializing'\r\n\u00a0 END AS AGState,\r\n\u00a0 ar.failover_mode_desc,\r\n\u00a0 ar.availability_mode_desc,\r\nISNULL(dbrs.is_suspended, 0) AS [IsSuspended]\r\nFROM master.sys.availability_groups AS AG\r\nLEFT OUTER JOIN master.sys.dm_hadr_availability_group_states as agstates\r\nON AG.group_id = agstates.group_id\r\nINNER JOIN master.sys.availability_replicas AS AR\r\nON AG.group_id = AR.group_id\r\nINNER JOIN master.sys.dm_hadr_availability_replica_states AS arstates\r\nON 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\nON arstates.replica_id = dbcs.replica_id\r\nLEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs\r\nON dbcs.replica_id = dbrs.replica_id AND dbcs.group_database_id = dbrs.group_database_id\r\nwhere (dbcs.is_database_joined=1) and (ar.failover_mode_desc<>'AUTOMATIC' \r\nor ar.availability_mode_desc<>'SYNCHRONOUS_COMMIT' or\r\ndbrs.synchronization_state<>2)\r\nORDER BY AG.name ASC, dbcs.database_name<\/pre>\n
\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but with Registered Server it is possible to do this job in one click. In the next section of the article, we will create the Registered Server step by step. And …<\/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":[],"class_list":["post-3855","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"yoast_head":"\nHow To Execute a Script on Multiple Instance with Registered Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Execute a Script on Multiple Instance with Registered Server\" \/>\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\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Execute a Script on Multiple Instance with Registered Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Execute a Script on Multiple Instance with Registered Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-17T07:02:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-26T11:14:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.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\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Execute a Script on Multiple Instance with Registered Server\",\"datePublished\":\"2018-10-17T07:02:26+00:00\",\"dateModified\":\"2018-11-26T11:14:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\"},\"wordCount\":486,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\",\"name\":\"How To Execute a Script on Multiple Instance with Registered Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png\",\"datePublished\":\"2018-10-17T07:02:26+00:00\",\"dateModified\":\"2018-11-26T11:14:38+00:00\",\"description\":\"How To Execute a Script on Multiple Instance with Registered Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png\",\"width\":468,\"height\":280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Execute a Script on Multiple Instance with Registered Server\"}]},{\"@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 Execute a Script on Multiple Instance with Registered Server - Database Tutorials","description":"How To Execute a Script on Multiple Instance with Registered Server","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\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Execute a Script on Multiple Instance with Registered Server - Database Tutorials","og_description":"How To Execute a Script on Multiple Instance with Registered Server","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-17T07:02:26+00:00","article_modified_time":"2018-11-26T11:14:38+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.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\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Execute a Script on Multiple Instance with Registered Server","datePublished":"2018-10-17T07:02:26+00:00","dateModified":"2018-11-26T11:14:38+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/"},"wordCount":486,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/","name":"How To Execute a Script on Multiple Instance with Registered Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png","datePublished":"2018-10-17T07:02:26+00:00","dateModified":"2018-11-26T11:14:38+00:00","description":"How To Execute a Script on Multiple Instance with Registered Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/10\/667.png","width":468,"height":280},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/how-to-execute-a-script-on-multiple-instance-with-registered-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Execute a Script on Multiple Instance with Registered Server"}]},{"@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\/3855","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=3855"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3855\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}