{"id":8037,"date":"2023-11-17T11:20:39","date_gmt":"2023-11-17T11:20:39","guid":{"rendered":"https:\/\/ricardomoinhos.com\/?p=8037"},"modified":"2023-11-20T10:26:52","modified_gmt":"2023-11-20T10:26:52","slug":"business-central-estimating-data-size-in-saas","status":"publish","type":"post","link":"https:\/\/ricardomoinhos.com\/pt\/business-central-estimating-data-size-in-saas\/","title":{"rendered":"Estimating the data size in your Business Central online tenant"},"content":{"rendered":"\n<p>Hi,<\/p>\n\n\n\n<p>Kudos to the Microsoft Dynamics 365 BC Cloud Migration team.<\/p>\n\n\n\n<p>A new page just have been added to the documentation on how to estimate the data size for your on-prem database after being migrated to a Business Central online tenant.<\/p>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/dynamics365\/business-central\/dev-itpro\/administration\/cloud-migration-estimate-compressed-data-size\">Estimating the data size in your Business Central online tenant &#8211; Business Central | Microsoft Learn<\/a><\/p>\n\n\n\n<p>This is just a &#8220;simple&#8221; stored procedure that uses an existing SQL stored procedure called <strong>sp_estimate_data_compression_savings<\/strong> that&#8217;s been there for a while, I&#8217;m sure sure about that.<\/p>\n\n\n\n<p>More info here: <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-stored-procedures\/sp-estimate-data-compression-savings-transact-sql?view=sql-server-ver16\">sp_estimate_data_compression_savings (Transact-SQL) &#8211; SQL Server | Microsoft Learn<\/a><\/p>\n\n\n\n<p>I was giving a quick test on this procedure and when I executed the <strong>EXEC estimate_page_compressed_table_sizes&nbsp;<\/strong>query, I was getting the following error:<code><br>\n<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"603\" height=\"125\" src=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655741e296f17.png\" alt=\"\" class=\"wp-image-8027\" srcset=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655741e296f17.png 603w, https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655741e296f17-300x62.png 300w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/figure>\n\n\n\n<p id=\"fKVVGvK\">&nbsp;<\/p>\n\n\n\n<p>I was able to quickly figure out that this is related to some fields name that includes an ampersand which are not properly being handled by the <strong>sp_estimate_data_compression_savings <\/strong>stored procedure.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"916\" height=\"406\" src=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655742bdc60a8.png\" alt=\"\" class=\"wp-image-8028\" srcset=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655742bdc60a8.png 916w, https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655742bdc60a8-300x133.png 300w, https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_655742bdc60a8-768x340.png 768w\" sizes=\"auto, (max-width: 916px) 100vw, 916px\" \/><\/figure>\n\n\n\n<p id=\"nfvOqEW\">&nbsp;<\/p>\n\n\n\n<p>It seems to be a bug and has not been fixed by Microsoft.<\/p>\n\n\n\n<p>This is not a problem for a vanilla BC database but it is an issue when using LS Central and might happen if you&#8217;re using other ISVs apps or custom fields.<\/p>\n\n\n\n<p>I was able to run the query by excluding some LS Central tables. To do that, a possible workaround is for you to apply the following changes on the query that creates the <strong>estimate_page_compressed_table_sizes<\/strong> stored procedure:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Change from:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE tables_cur cursor for\nSELECT name\nFROM sys.tables\n-- adjust this part if you want to restrict the tables in the calculation\n-- WHERE table_name in ('table name 1', 'table name 2', 'table name 3')\n;<\/code><\/pre>\n\n\n\n<p>To:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE tables_cur cursor for\nSELECT name\nFROM sys.tables\nWHERE name NOT LIKE '%$LSC POS Mix &amp; Match Entry$%'\nAND name NOT LIKE '%$LSC Activity Email Log$%'\nAND name NOT LIKE '%$LSC Activity Status Log$%'\n;<\/code><\/pre>\n\n\n\n<p>If you are using extensions from other ISVs, you can exclude all the tables that has ampersands in the field name.<\/p>\n\n\n\n<p><strong>EDITED: 2023-11-20<\/strong><\/p>\n\n\n\n<p>According to Microsoft (see: <a href=\"https:\/\/www.yammer.com\/dynamicsnavdev\/threads\/2531898564968448\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.yammer.com\/dynamicsnavdev\/threads\/2531898564968448<\/a>), the issue with the stored procedure is not related to the fields itself but with the indexes. So I have made a few changes on the recommended script to exclude the tables based not only on the fields that have ampersands but also based on if those fields are part of an active index.<\/p>\n\n\n\n<p>So you would need to change the stored procedure by replacing with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE tables_cur cursor for\nSELECT name\nFROM sys.tables\nWHERE name NOT IN\n(\n  SELECT TableName = t.name\r\n  FROM sys.indexes ind\r\n  INNER JOIN sys.index_columns ic ON  ind.object_id = ic.object_id and ind.index_id = ic.index_id\r\n  INNER JOIN sys.columns col ON ic.object_id = col.object_id and ic.column_id = col.column_id\r\n  INNER JOIN sys.tables t ON ind.object_id = t.object_id\r\n  WHERE col.name LIKE '%&amp;%'\r\n  GROUP BY t.name\n)\n;<\/code><\/pre>\n\n\n\n<p>To check which tables are being excluded you can run the following SQL query:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT TableName = t.name\r\nFROM sys.indexes ind\r\nINNER JOIN sys.index_columns ic ON  ind.object_id = ic.object_id and ind.index_id = ic.index_id\r\nINNER JOIN sys.columns col ON ic.object_id = col.object_id and ic.column_id = col.column_id\r\nINNER JOIN sys.tables t ON ind.object_id = t.object_id\r\nWHERE col.name LIKE '%&amp;%'\r\nGROUP BY t.name<\/code><\/pre>\n\n\n\n<p>I tested this using a LS Central Demo Data database as example and this was the outcome:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1487\" height=\"242\" src=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_65574397e5d55.png\" alt=\"\" class=\"wp-image-8029\" srcset=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_65574397e5d55.png 1487w, https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_65574397e5d55-300x49.png 300w, https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_65574397e5d55-1024x167.png 1024w, https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2023\/11\/img_65574397e5d55-768x125.png 768w\" sizes=\"auto, (max-width: 1487px) 100vw, 1487px\" \/><\/figure>\n\n\n\n<p id=\"TEzXADV\">&nbsp;Data size is around 42 Mb and when compressed will be around 29 Mb. So that&#8217;s nearly 30% of space saving.<\/p>\n\n\n\n<p>Please give it a try and share your numbers!<\/p>\n\n\n\n<p>This information will be available soon in the <strong>LS Central Implementation Guide<\/strong>, available online for LS Retail partners: <a href=\"https:\/\/help.lscentral.lsretail.com\/Content\/Implementation-Guide\/LS-Core\/Data-Migration.htm?tocpath=LS%20Central%20Implementation%20Guide%7CSaaS%20Implementation%7CData%20Migration%7C_____0\" target=\"_blank\" rel=\"noopener\">LS Central Implementation Guide &#8211; Data Migration<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, Kudos to the Microsoft Dynamics 365 BC Cloud Migration team. A new page just have been added to the documentation on how to estimate the data size for your on-prem database after being migrated to a Business Central online tenant. Estimating the data size in your Business Central online tenant &#8211; Business Central | [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1358,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[4],"tags":[59,70,71,72],"class_list":{"0":"post-8037","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-dynamics365bc","8":"tag-businesscentral","9":"tag-lscentral","10":"tag-saas","11":"tag-sql","13":"post-with-thumbnail","14":"post-with-thumbnail-icon"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Estimating the data size in your Business Central online tenant - Ricardo Paiva Moinhos<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Estimating the data size in your Business Central online tenant - Ricardo Paiva Moinhos\" \/>\n<meta property=\"og:description\" content=\"Hi, Kudos to the Microsoft Dynamics 365 BC Cloud Migration team. A new page just have been added to the documentation on how to estimate the data size for your on-prem database after being migrated to a Business Central online tenant. Estimating the data size in your Business Central online tenant &#8211; Business Central | [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/\" \/>\n<meta property=\"og:site_name\" content=\"Ricardo Paiva Moinhos\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-17T11:20:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-20T10:26:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"256\" \/>\n\t<meta property=\"og:image:height\" content=\"256\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ricardo Paiva Moinhos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ricardo Paiva Moinhos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/\"},\"author\":{\"name\":\"Ricardo Paiva Moinhos\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#\\\/schema\\\/person\\\/16dcfdd54ec1c46bd1941659739de4cc\"},\"headline\":\"Estimating the data size in your Business Central online tenant\",\"datePublished\":\"2023-11-17T11:20:39+00:00\",\"dateModified\":\"2023-11-20T10:26:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/\"},\"wordCount\":445,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/Microsoft-Dynamics-365-Business-Central-Logo.png\",\"keywords\":[\"\",\"lscentral\",\"saas\",\"sql\"],\"articleSection\":[\"Dynamics NAV\\\/365 BC\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/\",\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/\",\"name\":\"Estimating the data size in your Business Central online tenant - Ricardo Paiva Moinhos\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/Microsoft-Dynamics-365-Business-Central-Logo.png\",\"datePublished\":\"2023-11-17T11:20:39+00:00\",\"dateModified\":\"2023-11-20T10:26:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#\\\/schema\\\/person\\\/16dcfdd54ec1c46bd1941659739de4cc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/Microsoft-Dynamics-365-Business-Central-Logo.png\",\"contentUrl\":\"https:\\\/\\\/ricardomoinhos.com\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/Microsoft-Dynamics-365-Business-Central-Logo.png\",\"width\":256,\"height\":256},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/business-central-estimating-data-size-in-saas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ricardomoinhos.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estimating the data size in your Business Central online tenant\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#website\",\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/\",\"name\":\"Ricardo Paiva Moinhos\",\"description\":\"Welcome\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ricardomoinhos.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ricardomoinhos.com\\\/#\\\/schema\\\/person\\\/16dcfdd54ec1c46bd1941659739de4cc\",\"name\":\"Ricardo Paiva Moinhos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g\",\"caption\":\"Ricardo Paiva Moinhos\"},\"url\":\"https:\\\/\\\/ricardomoinhos.com\\\/pt\\\/author\\\/ricardopaiva\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Estimating the data size in your Business Central online tenant - Ricardo Paiva Moinhos","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:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/","og_locale":"pt_PT","og_type":"article","og_title":"Estimating the data size in your Business Central online tenant - Ricardo Paiva Moinhos","og_description":"Hi, Kudos to the Microsoft Dynamics 365 BC Cloud Migration team. A new page just have been added to the documentation on how to estimate the data size for your on-prem database after being migrated to a Business Central online tenant. Estimating the data size in your Business Central online tenant &#8211; Business Central | [&hellip;]","og_url":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/","og_site_name":"Ricardo Paiva Moinhos","article_published_time":"2023-11-17T11:20:39+00:00","article_modified_time":"2023-11-20T10:26:52+00:00","og_image":[{"width":256,"height":256,"url":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png","type":"image\/png"}],"author":"Ricardo Paiva Moinhos","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Ricardo Paiva Moinhos","Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#article","isPartOf":{"@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/"},"author":{"name":"Ricardo Paiva Moinhos","@id":"https:\/\/ricardomoinhos.com\/#\/schema\/person\/16dcfdd54ec1c46bd1941659739de4cc"},"headline":"Estimating the data size in your Business Central online tenant","datePublished":"2023-11-17T11:20:39+00:00","dateModified":"2023-11-20T10:26:52+00:00","mainEntityOfPage":{"@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/"},"wordCount":445,"commentCount":0,"image":{"@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#primaryimage"},"thumbnailUrl":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png","keywords":["","lscentral","saas","sql"],"articleSection":["Dynamics NAV\/365 BC"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/","url":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/","name":"Estimating the data size in your Business Central online tenant - Ricardo Paiva Moinhos","isPartOf":{"@id":"https:\/\/ricardomoinhos.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#primaryimage"},"image":{"@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#primaryimage"},"thumbnailUrl":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png","datePublished":"2023-11-17T11:20:39+00:00","dateModified":"2023-11-20T10:26:52+00:00","author":{"@id":"https:\/\/ricardomoinhos.com\/#\/schema\/person\/16dcfdd54ec1c46bd1941659739de4cc"},"breadcrumb":{"@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#primaryimage","url":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png","contentUrl":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png","width":256,"height":256},{"@type":"BreadcrumbList","@id":"https:\/\/ricardomoinhos.com\/business-central-estimating-data-size-in-saas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ricardomoinhos.com\/"},{"@type":"ListItem","position":2,"name":"Estimating the data size in your Business Central online tenant"}]},{"@type":"WebSite","@id":"https:\/\/ricardomoinhos.com\/#website","url":"https:\/\/ricardomoinhos.com\/","name":"Ricardo Paiva Moinhos","description":"Welcome","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ricardomoinhos.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/ricardomoinhos.com\/#\/schema\/person\/16dcfdd54ec1c46bd1941659739de4cc","name":"Ricardo Paiva Moinhos","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/248366f4e615e182964f85f799c6e33cbd541a6f4ca7ee948fc16d1c14030c76?s=96&d=mm&r=g","caption":"Ricardo Paiva Moinhos"},"url":"https:\/\/ricardomoinhos.com\/pt\/author\/ricardopaiva\/"}]}},"jetpack_featured_media_url":"https:\/\/ricardomoinhos.com\/wp-content\/uploads\/2020\/02\/Microsoft-Dynamics-365-Business-Central-Logo.png","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts\/8037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/comments?post=8037"}],"version-history":[{"count":21,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts\/8037\/revisions"}],"predecessor-version":[{"id":8097,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/posts\/8037\/revisions\/8097"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/media\/1358"}],"wp:attachment":[{"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/media?parent=8037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/categories?post=8037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ricardomoinhos.com\/pt\/wp-json\/wp\/v2\/tags?post=8037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}