{"id":5573,"date":"2015-09-16T16:21:57","date_gmt":"2015-09-16T14:21:57","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/"},"modified":"2015-09-16T16:21:57","modified_gmt":"2015-09-16T14:21:57","slug":"sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/","title":{"rendered":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog"},"content":{"rendered":"<p>During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here:<\/p>\n<p>&gt; <a href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssisdb-support\/\">SQL Server 2016 : availability groups and the new SSISDB support<\/a><\/p>\n<p>Just as a reminder, for those who have dealt with the SSISDB catalog in the previous version, some extra works were mandatory to be \u201cAlwaysOn\u201d compliant. Fortunately, the new version of SSIDB catalog will make easier the DBA job.<\/p>\n<p>In this blog post, I will talk about a new (little) discovery that concerns the SSIDB catalog. In fact, I found out two new roles in this last CTP 2.3 as shown below:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3874\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles.jpg\" alt=\"blog 62- 1 - new ssisdb roles\" width=\"300\" height=\"186\" \/><\/a><\/p>\n<p>Among these two roles, the ssis_monitor role raised my awareness and I wonder which tasks are performed across this role.<\/p>\n<p>Let\u2019s begin by looking at this role and its members:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select \n\tdp.principal_id as role_p_id,\n\tdp.name as role_name,\n\tdp2.principal_id as member_p_id,\n\tdp2.name as member_name\nfrom sys.database_role_members as drm\njoin sys.database_principals as dp\n\ton dp.principal_id = drm.role_principal_id\njoin sys.database_principals as dp2\n\ton dp2.principal_id = drm.member_principal_id\nwhere dp.name = 'ssis_monitor'\n\tand dp.type_desc = 'DATABASE_ROLE'<\/pre>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-2-ssis-monitor-members.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3875\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-2-ssis-monitor-members.jpg\" alt=\"blog 62- 2 - ssis monitor members\" width=\"445\" height=\"42\" \/><\/a><\/p>\n<p>##MS_SSISServerCleanupJobUser## is a special user that already exists on the SQL Server 2014. This user is the owner of the SSIS Server Maintenance job but what\u2019s the purpose to add it to this new role? To get a response we have to move directly on the related permissions:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select \n\tp.name as principal_name,\n\ts.name as [schema_name],\n\tdp.type,\n\tdp.[permission_name],\n\tdp.state_desc,\n\to.name as [object_name],\n\to.type_desc as object_type\nfrom sys.database_permissions as dp\njoin sys.database_principals as p\n\ton p.principal_id = dp.grantee_principal_id\njoin sys.objects as o\n\ton dp.major_id = o.object_id\njoin sys.schemas as s\n\ton s.schema_id = o.schema_id\nwhere grantee_principal_id in (6)\norder by p.name<\/pre>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-3-ssis-monitor-permssions.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3876\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-3-ssis-monitor-permssions.jpg\" alt=\"blog 62- 3 - ssis monitor permssions\" width=\"655\" height=\"42\" \/><\/a><\/p>\n<p>We can notice that the new <em>ssis_monitor<\/em> role is granted to execute the <em>catalog.startup <\/em>stored procedure. As a reminder, only the <em>ssis_admin<\/em> role had these permissions on the previous SQL Server version.<\/p>\n<p>In fact, this role has been introduced on SQL Server 2016 to allow the new <em>SSIS Failover Monitor<\/em> agent job (AlwaysOn feature) to update the operation table\u2019s status after failover (thanks to Jimmy Wong &#8211; Principal Lead Program Manager &#8211; for this tip). We can confirm this point by looking at the SSIS Failover Monitor Job directly. The first step of this job consists in refreshing the current replicas configuration after a failover event. The second step concerns the execution of the <em>catalog.startup<\/em> procedure in order to fix the status of any packages there were running if and when the SSIS server instance goes down. That makes sense after a failover! Note that the job\u2019s owner is also the special user ##MS_SSISServerCleanupJobUser##.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-4-ssis-failover-job.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3878\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-4-ssis-failover-job.jpg\" alt=\"blog 62- 4 - ssis failover job\" width=\"500\" height=\"149\" \/><\/a><\/p>\n<p>Hope this helps<\/p>\n<p>By David Barbarin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>During my investigation about the new AlwaysOn features, I wrote a blog post about the new SSISDB support for AlwaysOn. You can find it here: &gt; SQL Server 2016 : availability groups and the new SSISDB support Just as a reminder, for those who have dealt with the SSISDB catalog in the previous version, some [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":5578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[466,84,25,566,592,655],"type_dbi":[],"class_list":["post-5573","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-alwayson","tag-high-availability","tag-security","tag-sql-server-2016","tag-ssis","tag-ssisdb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\" \/>\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\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-16T14:21:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"490\" \/>\n\t<meta property=\"og:image:height\" content=\"304\" \/>\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\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\",\"datePublished\":\"2015-09-16T14:21:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\"},\"wordCount\":369,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg\",\"keywords\":[\"AlwaysOn\",\"High availability\",\"Security\",\"SQL Server 2016\",\"SSIS\",\"SSISDB\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\",\"name\":\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg\",\"datePublished\":\"2015-09-16T14:21:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"description\":\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg\",\"width\":490,\"height\":304},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog\"}]},{\"@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":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","description":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","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\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","og_description":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/","og_site_name":"dbi Blog","article_published_time":"2015-09-16T14:21:57+00:00","og_image":[{"width":490,"height":304,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.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\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","datePublished":"2015-09-16T14:21:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/"},"wordCount":369,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg","keywords":["AlwaysOn","High availability","Security","SQL Server 2016","SSIS","SSISDB"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/","name":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg","datePublished":"2015-09-16T14:21:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"description":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-62-1-new-ssisdb-roles-1.jpg","width":490,"height":304},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-ssis_monitor-role-for-ssidbb-catalog\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 : availability groups and the new ssis_monitor role for SSIDBB catalog"}]},{"@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\/5573","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=5573"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5573\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5578"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5573"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}