{"id":4115,"date":"2013-05-01T10:42:27","date_gmt":"2013-05-01T17:42:27","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4115"},"modified":"2013-05-01T12:00:57","modified_gmt":"2013-05-01T19:00:57","slug":"more-businesses-than-you-think-are-on-the-cutting-edge","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/","title":{"rendered":"More businesses than you think are on the cutting edge"},"content":{"rendered":"<p>As a counterpart to my recent survey on what the oldest version of SQL Server you have in production (see the results <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-still-using-sql-server-2000\/\" target=\"_blank\">here<\/a>), I kicked off a survey last week asking what the newest version of SQL Server is that you have in production.<\/p>\n<p>Here are the results:<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4116\" alt=\"newestversion\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg\" width=\"576\" height=\"212\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg 576w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion-300x110.jpg 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/a><\/p>\n<p>I&#8217;m not surprised by these results, and they reflect the straw-polls I do at the start of each class we teach. We&#8217;re seeing a ton of people putting 2012 into production and there&#8217;s a lot of interest in AlwaysOn Availability Groups because of the ability to have multiple copies of the primary, and direct reads on secondaries without having to use clunky database snapshots (like you have to do with database mirroring).<\/p>\n<p>One thing I couldn&#8217;t get from the two surveys was the average spread of versions in production. What I can tell you from my class straw-polls is that most of attendees who are using 2012 also have older versions in production too. My impression is that more people are kicking the tires of 2012 by having it in production in some way, rather than having it in a test environment and then doing a comprehensive roll-out.<\/p>\n<p>Anyway, glad to see a strong adoption rate for 2012!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As a counterpart to my recent survey on what the oldest version of SQL Server you have in production (see the results here), I kicked off a survey last week asking what the newest version of SQL Server is that you have in production. Here are the results: I&#8217;m not surprised by these results, and [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[],"class_list":["post-4115","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>More businesses than you think are on the cutting edge - Paul S. Randal<\/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.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"More businesses than you think are on the cutting edge - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"As a counterpart to my recent survey on what the oldest version of SQL Server you have in production (see the results here), I kicked off a survey last week asking what the newest version of SQL Server is that you have in production. Here are the results: I&#8217;m not surprised by these results, and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-01T17:42:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-05-01T19:00:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/\",\"name\":\"More businesses than you think are on the cutting edge - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg\",\"datePublished\":\"2013-05-01T17:42:27+00:00\",\"dateModified\":\"2013-05-01T19:00:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#primaryimage\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg\",\"contentUrl\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg\",\"width\":576,\"height\":212},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"More businesses than you think are on the cutting edge\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"More businesses than you think are on the cutting edge - Paul S. Randal","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.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/","og_locale":"en_US","og_type":"article","og_title":"More businesses than you think are on the cutting edge - Paul S. Randal","og_description":"As a counterpart to my recent survey on what the oldest version of SQL Server you have in production (see the results here), I kicked off a survey last week asking what the newest version of SQL Server is that you have in production. Here are the results: I&#8217;m not surprised by these results, and [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/","og_site_name":"Paul S. Randal","article_published_time":"2013-05-01T17:42:27+00:00","article_modified_time":"2013-05-01T19:00:57+00:00","og_image":[{"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg","type":"","width":"","height":""}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/","name":"More businesses than you think are on the cutting edge - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg","datePublished":"2013-05-01T17:42:27+00:00","dateModified":"2013-05-01T19:00:57+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2013\/05\/newestversion.jpg","width":576,"height":212},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/more-businesses-than-you-think-are-on-the-cutting-edge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"More businesses than you think are on the cutting edge"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4115"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4115\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}