{"id":4703,"date":"2011-01-18T21:11:00","date_gmt":"2011-01-19T05:11:00","guid":{"rendered":""},"modified":"2024-01-22T22:50:07","modified_gmt":"2024-01-23T06:50:07","slug":"sql-server-appliances-a-workload-based-appliance-design-philosophy","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/","title":{"rendered":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy"},"content":{"rendered":"
\n

I run the Appliance Engineering team for SQL Server.\u00a0 One of the questions I get asked most often about building appliances, is how do we go about designing a new appliance.\u00a0\u00a0 We don\u2019t start with a cool piece of hardware and figure out what we might be able to build out of it, rather we start by understanding what an appliance needs to do and work our way to choosing the right hardware.\u00a0\u00a0\u00a0 Our general approach is what I like to call \u201cworkload-based appliance design\u201d and I thought I would share some of the thinking we have developed as part of engineering some of the new SQL Server appliances you may have heard about already such as the HP Enterprise Data Warehouse (HPEDW), the HP Business Decision Appliance (HPBDA) and others you may not know about that we are just starting to talk about.\u00a0\u00a0 This is not rocket science, but it is good engineering and allows us to work with our key hardware partners to build general purpose appliances at a lower total cost that you might expect given their capabilities.<\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
W is for Workload: <\/span><\/span><\/b>Let\u2019s assume that we know we want to build an appliance for a specific workload and identified that workload.\u00a0 For this discussion let\u2019s choose the \u201cSelf-service BI\u201d or SSBI workload targeting a small to medium business or enterprise departments that want to use PowerPivot.\u00a0\u00a0 From this starting point our engineering effort kicks off by gaining a deep understanding of the workload specifics.\u00a0\u00a0 We run the workload as we understand it on real hardware \u2013 we call a design proxy – varying many parameters to understand workload variability.\u00a0 We talk with customers, consultants, MVPs, our own SQL CAT experts and the developers of the products are thinking about using.\u00a0\u00a0 From that collected expert knowledge we build a specific model for the workload \u2013 and in the case of SSBI that evolved into an automated workload we could run and measure.\u00a0\u00a0 It can be tough to agree on general workload characteristics, but it is critical to gain that level of understanding so specific tools can be built for performance and testing work needed later.<\/span><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
A is for Architecture:\u00a0 <\/span><\/span><\/b>After a workload is understood, a survey is done to understand for the target workload what approaches or system architectures are appropriate.\u00a0\u00a0 You can imagine for SSBI we looked at best practices related to PowerPivot, SharePoint, and SQL Server.\u00a0 We explored running the workload on the metal in different mixes of physical servers and in VMs – splitting up into multiple virtual servers.\u00a0\u00a0\u00a0 We also talked with customers about what capabilities they expected to find in a complete solution and that led us to take an \u201cecosystem\u201d approach, bringing all the components together into a single server. We ran an extensive battery of tests to see if we could really get the architecture to work well to narrow our approach.<\/span><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
S is for Software:\u00a0\u00a0 <\/span><\/span><\/b>Once we have an approach we believe is sound we start looking at how to build the solution, the required software components.\u00a0 There are many software components required for a SSBI workload as we have defined beyond the basic products, determining exactly how to combine those together takes some effort.\u00a0\u00a0 Making decisions on what to enable by default, how to configure all the components so they work well together takes a great deal of iteration.\u00a0 I like to think of this process as learning how to set the 10,000 knobs that exist in the software \u2013 at least establishing an initial setting.\u00a0\u00a0 Reviewing those decisions with workload experts is a key activity at this stage of the process and often we find that the \u201cbest solution\u201d is not necessarily consistent with common \u201cbest practice\u201d.\u00a0\u00a0 At this point we are starting to add considerable value to the solution \u2013 value that is difficult for any single IT organization to create since we are working directly with the world\u2019s leading experts on all the components being utilized,.<\/span><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
H is for Hardware: <\/span><\/span><\/b>\u00a0 The final step, selecting specific hardware, is an iterative process.\u00a0 For example the SSBI workload is especially memory intensive, so selecting the proper amount of RAM for the system was an important decision.\u00a0\u00a0 We bought our engineering prototype hardware with the max amount of available RAM, but through performance tuning and optimization we were able to reduce the total memory to 96GB without impacting overall performance of our workload.\u00a0\u00a0 Again the resulting appliance hardware contains the knowledge of many experts – for example we review the configuration of our DIMMs with the engineers who designed the mainboard we are using, we reviewed the RAID configuration with the team that built the RAID controller.\u00a0\u00a0 This final stage is marked by rapid iteration of both hardware and software configuration, extensive performance and reliability testing to reach a final configuration \u2013 that configuration we capture and deliver with our hardware partners as an appliance.<\/span><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
When you think about the SQL Server appliance products, hopefully this will provide some context for how we create those products \u2013 our workload-centric engineering approach is important in making sure we can deliver a compelling product at a low total cost.\u00a0\u00a0\u00a0 And when you need to explain why you think a specific SQL Server appliance might be a good solution for your organization\u2019s workload needs, remember:\u00a0 SQL Server Appliances have nothing to do with laundry, but we do use Workload, Architecture, Software, Hardware (WASH) as the basis for our engineering design process.<\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
Britt Johnston<\/span><\/span><\/div>\n
Principal Group Manager<\/span><\/span><\/div>\n
SQL Server Appliance Engineering Team<\/span><\/span><\/div>\n
Twitter: www.twitter.com\/brittjohnston<\/a> <\/p>\n

<\/span><\/span><\/div>\n

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

I run the Appliance Engineering team for SQL Server.\u00a0 One of the questions I get asked most often about building appliances, is how do we go about designing a new appliance.<\/p>\n","protected":false},"author":1457,"featured_media":49966,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-4703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-thought-leadership"],"yoast_head":"\nSQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy - Microsoft SQL Server Blog<\/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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"I run the Appliance Engineering team for SQL Server.\u00a0 One of the questions I get asked most often about building appliances, is how do we go about designing a new appliance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2011-01-19T05:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy\",\"datePublished\":\"2011-01-19T05:11:00+00:00\",\"dateModified\":\"2024-01-23T06:50:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\"},\"wordCount\":929,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\",\"name\":\"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg\",\"datePublished\":\"2011-01-19T05:11:00+00:00\",\"dateModified\":\"2024-01-23T06:50:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg\",\"width\":1280,\"height\":720,\"caption\":\"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy - Microsoft SQL Server Blog","og_description":"I run the Appliance Engineering team for SQL Server.\u00a0 One of the questions I get asked most often about building appliances, is how do we go about designing a new appliance.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-01-19T05:11:00+00:00","article_modified_time":"2024-01-23T06:50:07+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg","type":"image\/jpeg"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy","datePublished":"2011-01-19T05:11:00+00:00","dateModified":"2024-01-23T06:50:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/"},"wordCount":929,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/","name":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg","datePublished":"2011-01-19T05:11:00+00:00","dateModified":"2024-01-23T06:50:07+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-appliances-a-workload.jpg","width":1280,"height":720,"caption":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/01\/18\/sql-server-appliances-a-workload-based-appliance-design-philosophy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Appliances \u2013 A Workload-based Appliance Design Philosophy"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4703"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4703\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/49966"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4703"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4703"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4703"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4703"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4703"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}