{"id":4475,"date":"2015-03-30T19:11:17","date_gmt":"2015-03-30T17:11:17","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/"},"modified":"2015-03-30T19:11:17","modified_gmt":"2015-03-30T17:11:17","slug":"weird-issue-with-sysfnhadrbackupispreferredreplica-function","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/","title":{"rendered":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function"},"content":{"rendered":"

A couple of days ago, I faced a weird backup issue with SQL Server AlwaysOn and availability groups at one of my customer (thank to him to point out this issue \ud83d\ude42 ). After installing our DMK<\/a> tool (Database Management Kit) about database maintenance for AlwaysOn, my customer noticed that their databases have not backed up. Ouch \u2026 what\u2019s going on? I never ran into this issue before… Do the problem comes from our tool?<\/p>\n

In fact, our DMK uses the useful DMF sys.fn_hadr_backup_is_preferred_replica()<\/em> to know which databases are candidate for backup operations on replicas at a given time and this is where our issue starts. Indeed, in a specific situation that includes both a case sensitive server collation and entering the name of replicas in lower case, we found that the result of this function is inconsistent. Let me show with an example.<\/p>\n

In my customer\u2019s context, the replica names have been filled out from a PowerShell script form in lower case as follows:<\/p>\n

 <\/p>\n

\"blog_37_-_powershell_script\"<\/p>\n

 <\/p>\n

Let\u2019s take a look at the system view to check the availability group configuration:<\/p>\n

 <\/p>\n

SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 replica_server_name,<\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 availability_mode_desc,<\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 failover_mode_desc<\/span><\/div>\n
FROM sys.availability_replicas<\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_37_-_availability_replicas_name\"<\/p>\n

 <\/p>\n

Let\u2019s verify that the collation of the SQL Server instance is case sensitive \u2026<\/p>\n

 <\/p>\n

SELECT SERVERPROPERTY(‘Collation’) AS ServerCollation;<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_37_-_server_collation\"<\/p>\n

 <\/p>\n

\u2026 and the backup preference policy is configured to \u201cprimary\u201d<\/p>\n

 <\/p>\n

SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 name AS group_name,<\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 automated_backup_preference_desc as backup_preference<\/span><\/span><\/div>\n
FROM sys.availability_groups<\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_37_-_backup_preference\"<\/p>\n

 <\/p>\n

Finally, let\u2019s verify the database inside the availability group:<\/p>\n

 <\/p>\n

SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 g.name AS group_name, <\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 r.replica_server_name AS replica_name,<\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dcs.database_name,<\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 drs.database_.state_desc AS db_state<\/span><\/span><\/span><\/div>\n
FROM sys.dm_hadr_database_replica_states AS drs<\/span><\/span><\/span><\/span><\/span><\/div>\n
JOIN sys.availability_replicas AS r<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON drs.replica_id = r.replica_id<\/span><\/span><\/span><\/span><\/span><\/div>\n
JOIN sys.availability_groups AS g<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON g.group_id = drs.group_id<\/span><\/span><\/span><\/span><\/span><\/div>\n
JOIN sys.dm_hadr_database_replica_cluster_states AS dcs<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON dcs.group_database_id = drs.group_database_id<\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AND dcs.replica_id = drs.replica_id<\/span><\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

\"blog_37_-_dummy_database\"<\/p>\n

 <\/p>\n

Ok now let\u2019s take a look at the result of the DMF sys.fn_hadr_backup_is_preferred_replica() in this context. I put here a simplified sample portion of the TSQL code used in our DMK:<\/p>\n

 <\/p>\n

USE master;<\/span><\/span><\/span><\/span><\/div>\n
GO<\/span><\/div>\n
\u00a0<\/span><\/div>\n
DECLARE @db_name SYSNAME;<\/span><\/span><\/span><\/span><\/div>\n
\u00a0<\/span><\/div>\n
SELECT @db_name = name <\/span><\/span><\/span><\/div>\n
FROM sys.databases WHERE name = N’DUMMY’;<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n
\u00a0<\/span><\/div>\n
SELECT<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @@SERVERNAME AS server_name,<\/span><\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 @db_name AS database_name, <\/span><\/span><\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sys.fn_hadr_backup_is_preferred_replica(@db_name) AS fn_result;<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/div>\n

 <\/p>\n

Concerning the primary:<\/p>\n

 <\/p>\n

\"blog_37_-_backup_function_result_primaryjpg\"<\/p>\n

 <\/p>\n

Concerning the secondary\u00a0:<\/p>\n

 <\/p>\n

\"blog_37_-_backup_function_result_secondary\"<\/p>\n

 <\/p>\n

 <\/p>\n

If you perform the same by configuring this time the replica names in upper case, you will notice that the issue will disappear. When I think about this issue, it’s true that in almost cases customers prefer to use the assistant wizard to configure availability groups and in this case do you notice that the replica names are always switched in upper case?<\/p>\n

There also exists a Microsoft connect item<\/a> about this problem but unfortunately it seems that it will not be solved by Microsoft \u2026 so be careful when you implement availability groups by script.<\/p>\n

See you on the next availability group ventury!<\/p>\n

By David Barbarin<\/p>\n

 <\/p>\n

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

A couple of days ago, I faced a weird backup issue with SQL Server AlwaysOn and availability groups at one of my customer (thank to him to point out this issue \ud83d\ude42 ). After installing our DMK tool (Database Management Kit) about database maintenance for AlwaysOn, my customer noticed that their databases have not backed […]<\/p>\n","protected":false},"author":26,"featured_media":4476,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[297,84,51],"type_dbi":[],"class_list":["post-4475","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hardware-storage","tag-availability-groups","tag-high-availability","tag-sql-server"],"acf":[],"yoast_head":"\nWeird issue with sys.fn_hadr_backup_is_preferred_replica() function - dbi Blog<\/title>\n<meta name=\"description\" content=\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function\" \/>\n<meta property=\"og:description\" content=\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-03-30T17:11:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_37_-_powershell_script.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"575\" \/>\n\t<meta property=\"og:image:height\" content=\"245\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function\",\"datePublished\":\"2015-03-30T17:11:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/\"},\"wordCount\":563,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog_37_-_powershell_script.jpg\",\"keywords\":[\"Availability groups\",\"High availability\",\"SQL Server\"],\"articleSection\":[\"Hardware & Storage\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/\",\"name\":\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog_37_-_powershell_script.jpg\",\"datePublished\":\"2015-03-30T17:11:17+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog_37_-_powershell_script.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog_37_-_powershell_script.jpg\",\"width\":575,\"height\":245},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/microsoft-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function - dbi Blog","description":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function","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:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/","og_locale":"en_US","og_type":"article","og_title":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function","og_description":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function","og_url":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/","og_site_name":"dbi Blog","article_published_time":"2015-03-30T17:11:17+00:00","og_image":[{"width":575,"height":245,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_37_-_powershell_script.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function","datePublished":"2015-03-30T17:11:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/"},"wordCount":563,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_37_-_powershell_script.jpg","keywords":["Availability groups","High availability","SQL Server"],"articleSection":["Hardware & Storage"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/","url":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/","name":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_37_-_powershell_script.jpg","datePublished":"2015-03-30T17:11:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_37_-_powershell_script.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog_37_-_powershell_script.jpg","width":575,"height":245},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/weird-issue-with-sysfnhadrbackupispreferredreplica-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Weird issue with sys.fn_hadr_backup_is_preferred_replica() function"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4475"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4475\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4476"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4475"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}