{"id":7250,"date":"2010-05-05T00:00:00","date_gmt":"2010-05-05T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/uniqueidentifier-and-clustered-indexes"},"modified":"2025-09-10T10:18:54","modified_gmt":"2025-09-10T17:18:54","slug":"uniqueidentifier-and-clustered-indexes","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/","title":{"rendered":"Uniqueidentifier and Clustered Indexes"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">[This article was contributed by the SQL Azure team.]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I love GUIDs &#8212; the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms190215.aspx\"><b>uniqueidentifier<\/b><\/a> data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys in my database tables, etc\u2026 &#8212; don\u2019t get me started. About two years ago, I started using <b>uniqueidentifier<\/b> for primary keys because of their unique ability to merge.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"merging\">Merging<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you create a GUID in SQL Server using the NewId() command you are guaranteed that it will be unique across the whole universe. Which means if you have two databases (with the same schema) completely disconnected adding rows to the same table, using a primary key of <b>uniqueidentifier<\/b> will ensure that they primary keys don\u2019t conflict. In comparison, if the two databases had an identity integer column as the primary key for their tables, they would be very likely to insert the same primary key in both tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">What does this have to do with merging? It is ridiculously easy to merge the tables of our disconnected databases with each other if they are using uniqueidentifier as their primary keys. On the other hand, it is much harder to resolve conflicts when merging between the identity integer primary keys and updating the foreign key references to those primary keys.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"clustering-and-uniqueidentifier\">Clustering and uniqueidentifier<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It isn\u2019t a good idea to create a clustered index on a <b>uniqueidentifier<\/b> column and generate your GUIDs with <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms190348.aspx\">NEWID()<\/a>. The reason for this is that <b>NEWID() <\/b>generates GUIDs in non-sequential order and SQL Server orders a clustered index sequentially. It will work \u2013 SQL Server will let you build a clustered index around a uniqueidentifier column, however it will cause the SQL Server to do unnecessary work and cause performance slowdowns. The reason for this is that to insert data into the middle of a clustered index (out of sequential order) causes SQL Server to make room for the data by rearranging the cluster.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So if it isn\u2019t a good idea then why do people do it? Well, in SQL Server, if I assign a column as the primary key in SQL Server Management Studio it automatically generates a clustered index for you regardless of the data type of that column. Therefore, if you want a table with a uniqueidentifier data type as a primary key you need to change that index to a non-clustered index.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Non-clustered indexes don\u2019t reorder the data as rows are inserted to the table, so they don\u2019t have the performance impact of a clustered index on inserts of non-sequential data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"along-comes-sql-azure\">Along comes SQL Azure<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you love <b>uniqueidentifier<\/b> data types for primary keys like I love them and you are creating non-clustered indexes on your primary keys then you need to pick a clustered index for the table also. The reason is that SQL Azure requires one (and only one) clustered index on all tables. However, just because SQL Azure requires a clustered index doesn\u2019t mean it should be the primary key column.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"picking-a-clustered-index\">Picking a Clustered Index<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">There are a couple of strategies for picking your clustered indexes; one of the easiest and best is to add another column of data type <b>datetime<\/b> and use that column for your clustered index. Here is what you need to do:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1. Add the column as data type <b>datetime<\/b><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. I usually call it <b>Date<\/b><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. Set the Default Value to GetDate().<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Make it non-null.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5. Create your clustered index on it before you insert data into you.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Adding a default value of <b>GetDate()<\/b> to the column writes the date and time that the row was inserted into the column automatically. This insures that the data for the row is inserted at the end of the table data \u2013 there is no rearranging of the cluster. Adding the data to the end ensures the best performance for inserts.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another good choice for a clustered index is a column that reflects the ordering of the table in the majority of the select statements. For example, if you have a table called categories and you have an integer column called <b>ordervalue<\/b> and you always call the table with an <b>SELECT \u2026 ORDER BY [ordervalue]<\/b> then making <b>ordervalue<\/b> the clustered index makes sense. Here is why: even though it hinders performance to insert a non-sequential <b>ordervalue<\/b> into the cluster you will get a performance benefit when you call your data, since the rows will be read sequential from the cluster, that it depending on your workload characteristics.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"newsequentialid\">NEWSEQUENTIALID()<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I would be remise if I didn\u2019t mention the <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms189786.aspx\"><b>NEWSEQUENTIALID()<\/b><\/a> function which not supported in SQL Azure. If the <b>NEWID()<\/b> function generates unique non-sequential <b>uniqueidentifier<\/b> than <b>NEWSEQUENTIALID()<\/b> function generates unique sequential <b>uniqueidentifier<\/b>. The only trick to <b>NEWSEQUENTIALID()<\/b> function is that the GUIDs are generated partial based on the network card of the computer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This means that you can successfully have a <strong>uniqueidentifier<\/strong> as a primary key column and use that primary key column the required clustered index for SQL Server. As long as you use the <b>NEWSEQUENTIALID()<\/b> function column to fill that column.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If privacy is a concern, do not use this function. It is possible to guess the value of the next generated GUID and, therefore, access data associated with that GUID. For example if you are passing the primary key to the table in a query string on a web browser. See <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms189786.aspx\">MSDN<\/a> for more information.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, <b>NEWSEQUENTIALID()<\/b> function isn\u2019t support for SQL Azure. If you try to use it you will get this error:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Msg 40511, Level 15, State 1, Line 1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Built-in function &#8216;NEWSEQUENTIALID&#8217; is not supported in this version of SQL Server.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"migration\">Migration<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">If you are migrating an existing SQL Server database to SQL Azure you need to do these things to work successfully with <b>uniqueidentifier<\/b> data type as your primary key.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Convert the generation of GUIDs from <b>NEWSEQUENTIALID() <\/b>to <b>NEWID()<\/b><\/li>\n\n\n\n<li class=\"wp-block-list-item\">Remove all clustered indexes from <b>uniqueidentifier<\/b> data type columns \u2013 this will not prevent you from migrating, however it will give you better performance.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Pick a column (or add a column) to build your clustered index around (see the recommendations above).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Do you have questions, concerns, comments? Post them below and we will try to address them.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[This article was contributed by the SQL Azure team.]I love GUIDs &#8212; the uniqueidentifier data type in SQL Server.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1473],"tags":[],"audience":[],"content-type":[1511],"product":[],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-7250","post","type-post","status-publish","format-standard","hentry","category-databases","content-type-best-practices","review-flag-1-1680286581-825","review-flag-2-1680286581-601","review-flag-3-1680286581-173","review-flag-4-1680286581-250","review-flag-5-1680286581-950","review-flag-alway-1680286580-106"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Uniqueidentifier and Clustered Indexes | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uniqueidentifier and Clustered Indexes | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2010-05-05T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-10T17:18:54+00:00\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Uniqueidentifier and Clustered Indexes\",\"datePublished\":\"2010-05-05T00:00:00+00:00\",\"dateModified\":\"2025-09-10T17:18:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\"},\"wordCount\":1028,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\",\"name\":\"Uniqueidentifier and Clustered Indexes | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"datePublished\":\"2010-05-05T00:00:00+00:00\",\"dateModified\":\"2025-09-10T17:18:54+00:00\",\"description\":\"I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Uniqueidentifier and Clustered Indexes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Uniqueidentifier and Clustered Indexes | Microsoft Azure Blog","description":"I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys\u2026","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:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/","og_locale":"en_US","og_type":"article","og_title":"Uniqueidentifier and Clustered Indexes | Microsoft Azure Blog","og_description":"I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys\u2026","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2010-05-05T00:00:00+00:00","article_modified_time":"2025-09-10T17:18:54+00:00","author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Uniqueidentifier and Clustered Indexes","datePublished":"2010-05-05T00:00:00+00:00","dateModified":"2025-09-10T17:18:54+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/"},"wordCount":1028,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/","name":"Uniqueidentifier and Clustered Indexes | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"datePublished":"2010-05-05T00:00:00+00:00","dateModified":"2025-09-10T17:18:54+00:00","description":"I love GUIDs -- the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys\u2026","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/uniqueidentifier-and-clustered-indexes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Uniqueidentifier and Clustered Indexes"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7250","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=7250"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7250\/revisions"}],"predecessor-version":[{"id":46040,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/7250\/revisions\/46040"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=7250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=7250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=7250"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=7250"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=7250"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=7250"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=7250"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=7250"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=7250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}