{"id":1853,"date":"2013-10-17T13:00:00","date_gmt":"2013-10-17T20:00:00","guid":{"rendered":""},"modified":"2024-01-22T22:49:07","modified_gmt":"2024-01-23T06:49:07","slug":"cloud-data-warehousing-the-fastest-time-to-value","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/","title":{"rendered":"Cloud Data Warehousing \u2013 The Fastest Time To Value"},"content":{"rendered":"<p>In the past, deploying a data warehouse has been a costly affair.\u00a0 IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I\/O perspective) as well as install software that is tuned for optimal performance.\u00a0 Prior to even loading data into the system, you could already be months into the project and hundreds of thousands of dollars into your infrastructure investment, not to mention the resources needed to maintain these servers and run them at peak performance levels.<\/p>\n<p>To address these challenges, Microsoft announced at the <a href=\"http:\/\/www.sqlpass.org\/summit\/2013\/Live.aspx\">PASS Summit conference<\/a> the ability to deploy a tuned SQL Server Enterprise image for data warehousing in the cloud on Windows Azure.\u00a0 We now deliver a pre-tuned version of SQL Server Enterprise specifically for data warehousing and host this in a Windows Azure Virtual Machine. This image leverages the Microsoft best practices from the on-premise <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/solutions-technologies\/data-warehousing\/reference-architecture.aspx\">Fast Track reference architecture<\/a> certification to tune SQL Server for data warehousing in Windows Azure. Users can provision a highly tuned data warehouse image within minutes without any knowledge of Azure storage configurations nor needing expertise on how to optimize SQL Server for data warehousing workloads. This is an ideal solution for customers who want a data warehouse quickly without managing a hardware infrastructure.<\/p>\n<p>Microsoft has built strong momentum in the cloud with <a href=\"http:\/\/blogs.msdn.com\/b\/windowsazure\/archive\/2013\/06\/14\/50-percent-of-fortune-500s-using-windows-azure.aspx\">50% of the Fortune 500<\/a> and <a href=\"http:\/\/www.zdnet.com\/microsoft-were-adding-7000-azure-iaas-users-per-week-7000016550\/\">adding 7,000 new Azure IaaS customers a week<\/a>. \u00a0<a href=\"http:\/\/www.microsoft.com\/casestudies\/Case_Study_Detail.aspx?CaseStudyID=710000003318\">HarperCollins Publishers<\/a> was one of these customers who deployed SQL Server 2012 Enterprise solution in Azure within two weeks ultimately saving them more than 6 months of deployment time and over $200,000 in development costs. Deploying SQL Server for data warehousing in Windows Azure Virtual Machines gives customers the fastest time to value at the lowest cost.<\/p>\n<p>With this cloud data warehouse solution, Microsoft rounds out a suite of existing data warehouse offerings that already includes <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/solutions-technologies\/data-warehousing\/reference-architecture.aspx?WT.mc_id=Blog_SQL_PASS_SQL2014\">reference architectures<\/a> and <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/solutions-technologies\/data-warehousing\/pdw.aspx?WT.mc_id=Blog_SQL_PASS_SQL2014\">appliances<\/a>. Customers now have an unprecedented number of options to deploy a data warehouse on-premise, in the cloud, or hybrid (both on-premise and cloud).<\/p>\n<p>We are excited to enable you to deploy SQL Server for data warehousing in Windows Azure Virtual Machines and invite you to learn more through the following resources:<\/p>\n<ul>\n<li>\n<a href=\"http:\/\/www.windowsazure.com\/en-us\/pricing\/details\/virtual-machines\/\">MSDN Technical Article<\/a> on SQL Server for data warehousing in Windows Azure VMs<\/li>\n<li>Learn more about deploying <a href=\"http:\/\/www.windowsazure.com\/en-us\/services\/data-management\/?WT.mc_id=Blog_SQL_PASS_SQL2014\">Windows Azure Virtual Machines<\/a>\n<\/li>\n<li>Learn more about this <a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/solutions-technologies\/data-warehousing\/cloud.aspx?WT.mc_id=Blog_SQL_PASS_SQL2014\">cloud data warehouse offer<\/a> from Microsoft<\/li>\n<li>Get your <a href=\"http:\/\/www.windowsazure.com\/en-us\/pricing\/free-trial\/?WT.mc_id=Blog_SQL_PASS_SQL2014\">free trial<\/a> to Windows Azure<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In the past, deploying a data warehouse has been a costly affair.\u00a0 IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I\/O perspective) as well as install software that is tuned for optimal performance.<\/p>\n","protected":false},"author":1457,"featured_media":0,"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":[2463],"coauthors":[2487],"class_list":["post-1853","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership","topic-data-warehousing"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cloud Data Warehousing \u2013 The Fastest Time To Value - 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\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cloud Data Warehousing \u2013 The Fastest Time To Value - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In the past, deploying a data warehouse has been a costly affair.\u00a0 IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I\/O perspective) as well as install software that is tuned for optimal performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\" \/>\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=\"2013-10-17T20:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"2 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\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Cloud Data Warehousing \u2013 The Fastest Time To Value\",\"datePublished\":\"2013-10-17T20:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\"},\"wordCount\":410,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\",\"name\":\"Cloud Data Warehousing \u2013 The Fastest Time To Value - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2013-10-17T20:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cloud Data Warehousing \u2013 The Fastest Time To Value\"}]},{\"@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":"Cloud Data Warehousing \u2013 The Fastest Time To Value - 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\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/","og_locale":"en_US","og_type":"article","og_title":"Cloud Data Warehousing \u2013 The Fastest Time To Value - Microsoft SQL Server Blog","og_description":"In the past, deploying a data warehouse has been a costly affair.\u00a0 IT departments required expertise to procure and build state-of-the-art hardware servers (that are optimally balanced from a CPU, storage and I\/O perspective) as well as install software that is tuned for optimal performance.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-10-17T20:00:00+00:00","article_modified_time":"2024-01-23T06:49:07+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Cloud Data Warehousing \u2013 The Fastest Time To Value","datePublished":"2013-10-17T20:00:00+00:00","dateModified":"2024-01-23T06:49:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/"},"wordCount":410,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/","name":"Cloud Data Warehousing \u2013 The Fastest Time To Value - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2013-10-17T20:00:00+00:00","dateModified":"2024-01-23T06:49:07+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/10\/17\/cloud-data-warehousing-the-fastest-time-to-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Cloud Data Warehousing \u2013 The Fastest Time To Value"}]},{"@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\/1853","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=1853"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/1853\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=1853"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=1853"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=1853"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=1853"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=1853"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=1853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}