{"id":4191,"date":"2013-08-20T14:30:29","date_gmt":"2013-08-20T21:30:29","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4191"},"modified":"2019-12-30T17:27:26","modified_gmt":"2019-12-31T01:27:26","slug":"build-numbers-survey-results","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/","title":{"rendered":"More than half of all SQL Server instances are out-of-date and unsupported!"},"content":{"rendered":"<p>Back in May I started a survey to collect build numbers to see how up-to-date people keep their SQL Server instances and I&#8217;ve been putting off writing this post as I wanted to do justice to the data.<\/p>\n<p>I received results for 3085 SQL Server instances from several hundred respondents &#8211; thank you! I broke down the results from <em>@@VERSION<\/em> using some T-SQL code and then used information from\u00a0<a href=\"http:\/\/sqlserverbuilds.blogspot.com\/\">http:\/\/sqlserverbuilds.blogspot.com\/<\/a>\u00a0to figure out what each build number corresponded to.<\/p>\n<p>Here are the summarized results:<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nRelease   Instances    Survey %    Out-Of-Date %    Unsupported %\r\n----------------------------------------------------------------------------------\r\n7.0       1            0.03%       100%             100%\r\n2000      164          5.32%       82.93%           100%\r\n2005      1285         41.65%      67.08%           67.08%\r\n2008      394          12.77%      41.12%           41.12%\r\n2008 R2   1058         34.29%      43.48%           43.48% (25% more from October)\r\n2012      182          5.90%       24.73%           0% (24.73% more from November)\r\n<\/pre>\n<p>My definition of &#8220;out-of-date&#8221; is basically not being on the latest SP for the release. I know that many people do not like updating with every Cumulative Update so it was hard to make any more finessed decision than that. My definition of &#8220;Unsupported&#8221; is based on the Microsoft Support site for each release, which I&#8217;ve linked to in the detailed results below.<\/p>\n<p>I think the results are quite amazing.<\/p>\n<p><strong>51% of all instances in the survey are out of date, by at least not being on the latest SP build, and 53% of all instances in the survey are unsupported.<\/strong><\/p>\n<p>That&#8217;s just incredible. Granted that my results are only from several hundred people, but I&#8217;m going to go out on a limb and say I believe this is representative of the state of the installed SQL Server base.<\/p>\n<p>I urge you all to check your SQL Server instances to make sure they&#8217;re running as close to the latest build as possible, so you have the most bug fixes and are supported if you do have a problem. I realize that there are many reasons to still be running an older version of SQL Server (e.g. my post <a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/you-guys-still-use-sql-server-2000-really\/\" target=\"_blank\" rel=\"noopener noreferrer\">You guys still use SQL Server 2000? Really?<\/a>\u00a0that discusses application certification) but at least be running the most recent Service Pack or Cumulative Update if you&#8217;re able to!<\/p>\n<p>I&#8217;m still amazed at the results. I hope you find this information useful.<\/p>\n<p>The detailed results are below.<\/p>\n<h2>SQL Server 7.0<\/h2>\n<p>All SQL Server 7.0 builds are unsupported.<\/p>\n<p>Data for 1 SQL Server 7.0 instance (0.03% of results):<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nHow Many   Build Number     Release\r\n------------------------------------------------------\r\n1          7.00.841         7.0 SP2\r\n<\/pre>\n<p>The latest \u00a0build available for 7.0 is 7.00.1152, which is 7.0 SP4 + MS08-040, so 100% of 7.0 instances in the survey are out-of-date and are unsupported by Microsoft.<\/p>\n<h2>SQL Server 2000<\/h2>\n<p>All SQL server 2000 builds are unsupported as of April 9th, 2013 (see MS Support site\u00a0<a href=\"https:\/\/support.microsoft.com\/lifecycle\/?p1=2852\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>).<\/p>\n<p>Data for 164 SQL Server 2000 instances (5.32% of results):<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nHow Many   Build Number     Release\r\n------------------------------------------------------\r\n14         8.00.760         2000 SP3\r\n5          8.00.818         2000 SP3 + MS03-031\r\n16         8.00.2039        2000 SP4\r\n5          8.00.2040        2000 SP4 + KB899761\r\n3          8.00.2050        2000 SP4 + MS08-040\r\n13         8.00.2055        2000 SP4 + MS09-004\r\n15         8.00.2066        2000 SP4 + MS12-060\r\n10         8.00.2187        2000 SP4 CU1\r\n1          8.00.2246        2000 SP4 CU1 + KB935465\r\n37         8.00.2273        2000 SP4 CU1 + MS08-040\r\n27         8.00.2282        2000 SP4 CU1 + MS09-004\r\n5          8.00.2301        2000 SP4 CU1 + MS12-027\r\n13         8.00.2305        2000 SP4 CU1 + MS12-060\r\n<\/pre>\n<p>MS12-060 addresses a critical security issue, so instances on 8.00.2066 or 8.00.2305 I&#8217;ll consider up-to-date. That means that only 28 (17.1%) of the 200o instances in the survey are up-to-date, and all of them are unsupported by Microsoft.<\/p>\n<h2>SQL Server 2005<\/h2>\n<p>All SQL Server 2005 builds are out of mainstream support and have extended support until April 12th, 2016 (see MS Support site\u00a0<a href=\"https:\/\/support.microsoft.com\/lifecycle\/?p1=2855\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>).<\/p>\n<p>Data for 1285 SQL Server 2005 instances (41.65% of results):<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nHow Many   Build Number     Release\r\n------------------------------------------------------\r\n7          9.00.1399.06     2005 RTM\r\n1          9.00.2040.00     2005 SP1 CTP1\r\n5          9.00.2047.00     2005 SP1\r\n1          9.00.2153.00     2005 SP1 CU1\r\n37         9.00.3042.00     2005 SP2\r\n1          9.00.3050.00     2005 SP2 + KB933508\r\n1          9.00.3054.00     2005 SP2 + KB934458\r\n1          9.00.3073.00     2005 SP2 + MS08-052\r\n7          9.00.3080.00     2005 SP2 + MS09-062\r\n2          9.00.3159.00     2005 SP2 + KB924459\r\n1          9.00.3200.00     2005 SP2 CU4\r\n2          9.00.3233.00     2005 SP2 CU4 + MS08-040\r\n12         9.00.3282.00     2005 SP2 CU9\r\n2          9.00.3310.00     2005 SP2 CU9 + MS09-004\r\n71         9.00.3353.00     2005 SP2 CU15 + MS09-062\r\n192        9.00.4035.00     2005 SP3\r\n102        9.00.4053.00     2005 SP3 + MS09-062\r\n40         9.00.4060.00     2005 SP3 + MS11-049\r\n10         9.00.4211.00     2005 SP3 CU2\r\n120        9.00.4262.00     2005 SP3 CU2 + MS09-062\r\n20         9.00.4266.00     2005 SP3 CU6\r\n106        9.00.4273.00     2005 SP3 CU7\r\n4          9.00.4285.00     2005 SP3 CU8\r\n1          9.00.4305.00     2005 SP3 CU10\r\n116        9.00.4340.00     2005 SP3 CU15 + MS11-049\r\n252        9.00.5000.00     2005 SP4\r\n144        9.00.5069.00     2005 SP4 + MS11-049\r\n10         9.00.5266.00     2005 SP4 CU3\r\n1          9.00.5292.00     2005 SP4 CU3 + MS11-049\r\n16         9.00.5324.00     2005 SP4 CU3 + MS12-070\r\n<\/pre>\n<p><a href=\"https:\/\/technet.microsoft.com\/library\/security\/ms12-070\" target=\"_blank\" rel=\"noopener noreferrer\">MS12-070<\/a> (Reporting Services) and <a href=\"https:\/\/technet.microsoft.com\/library\/security\/ms11-049\" target=\"_blank\" rel=\"noopener noreferrer\">MS11-049<\/a> (XML editing) are not critical updates unless that area of SQL Server is being used, so I consider anyone on 2005 SP4 onward as up-to-date. This means that only 423 (32.9%) of the 2005 instances in the survey are up-to-date and supported, as only SP4 is in Extended Support.<\/p>\n<h2>SQL Server 2008<\/h2>\n<p>Any SQL Server 2008 build before SP3 is unsupported. Mainstream support ends on July 8th, 2014, with extended support available until July 9th, 2019 (see MS Support site <a href=\"https:\/\/support.microsoft.com\/lifecycle\/?p1=13165\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>).<\/p>\n<p>Data for 394 SQL Server 2008 instances (12.77% of results):<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nHow Many   Build Number     Release\r\n------------------------------------------------------\r\n5          10.0.1600.22     2008 RTM\r\n39         10.0.2531.0      2008 SP1\r\n5          10.0.2573.0      2008 SP1 + MS11-049\r\n2          10.0.2723.0      2008 SP1 CU3\r\n2          10.0.2734.0      2008 SP1 CU4\r\n3          10.0.2746.0      2008 SP1 CU5\r\n1          10.0.2757.0      2008 SP1 CU6\r\n2          10.0.2789.0      2008 SP1 CU9\r\n6          10.0.2799.0      2008 SP1 CU10\r\n58         10.0.4000.0      2008 SP2\r\n15         10.0.4064.0      2008 SP2 + MS11-049\r\n2          10.0.4067.0      2008 SP2 + MS12-070\r\n1          10.0.4272.0      2008 SP2 CU2\r\n15         10.0.4311.0      2008 SP2 CU4 + MS11-049\r\n2          10.0.4316.0      2008 SP2 CU5\r\n2          10.0.4333.0      2008 SP2 CU11\r\n2          10.0.4371.0      2008 SP2 CU11 + MS12-070\r\n169        10.0.5500.0      2008 SP3\r\n8          10.0.5512.0      2008 SP3 + MS12-070\r\n1          10.0.5766.0      2008 SP3 CU1\r\n6          10.0.5770.0      2008 SP3 CU3\r\n10         10.0.5788.0      2008 SP3 CU6\r\n22         10.0.5826.0      2008 SP3 CU7 + MS12-070\r\n9          10.0.5828.0      2008 SP3 CU8\r\n1          10.0.5829.0      2008 SP3 CU9\r\n5          10.0.5835.0      2008 SP3 CU10\r\n<\/pre>\n<p><a href=\"https:\/\/technet.microsoft.com\/library\/security\/ms12-070\" target=\"_blank\" rel=\"noopener noreferrer\">MS12-070<\/a> (Reporting Services) is not a critical update unless that area of SQL Server is being used, so I consider anyone on 2008 SP3 onward as up-to-date. This means that 232 (58.88%) of the 2008 instances in the survey are up-to-date and supported, as only SP3 is supported.<\/p>\n<h2>SQL Server 2008 R2<\/h2>\n<p>SQL Server 2008 R2 RTM builds are unsupported, and support for SP1 builds ends on October 10th, 2013. Mainstream support of SP2 builds ends on July 8th, 2014, with extended support available until July 9th, 2019 (see MS Support site\u00a0<a href=\"https:\/\/support.microsoft.com\/lifecycle\/?p1=14917\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>).<\/p>\n<p>Data for 1058 SQL Server 2008 R2 instances (34.29% of results):<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nHow Many   Build Number     Release\r\n------------------------------------------------------\r\n167        10.50.1600.1     2008 R2 RTM\r\n21         10.50.1617.0     2008 R2 RTM + MS11-049\r\n3          10.50.1746.0     2008 R2 RTM CU4\r\n1          10.50.1753.0     2008 R2 RTM CU5\r\n1          10.50.1797.0     2008 R2 RTM CU8\r\n2          10.50.2425.0     2008 R2 RTM CU14 + unknown\r\n168        10.50.2500.0     2008 R2 SP1\r\n26         10.50.2550.0     2008 R2 SP1 + MS12-070\r\n37         10.50.2769.0     2008 R2 SP1 CU1\r\n2          10.50.2772.0     2008 R2 SP1 CU2\r\n3          10.50.2796.0     2008 R2 SP1 CU4\r\n14         10.50.2806.0     2008 R2 SP1 CU5\r\n5          10.50.2811.0     2008 R2 SP1 CU6\r\n3          10.50.2817.0     2008 R2 SP1 CU7\r\n5          10.50.2861.0     2008 R2 SP1 CU8 + MS12-070\r\n2          10.50.2868.0     2008 R2 SP1 CU10\r\n518        10.50.4000.0     2008 R2 SP2\r\n3          10.50.4260.0     2008 R2 SP2 CU1\r\n10         10.50.4263.0     2008 R2 SP2 CU2\r\n10         10.50.4266.0     2008 R2 SP2 CU3\r\n19         10.50.4270.0     2008 R2 SP2 CU4\r\n34         10.50.4276.0     2008 R2 SP2 CU5\r\n4          10.50.4279.0     2008 R2 SP2 CU6 (replaced by build 4285)\r\n<\/pre>\n<p>I consider anyone on 2008 R2 SP2 onward as up-to-date. This means that 598 (56.52%) of the 2008 R2 instances in the survey are up-to-date and supported, with a further 265 (25.05%) already out-of-date instances going unsupported in October.<\/p>\n<h2>SQL Server 2012<\/h2>\n<p>All builds of SQL Server 2012 are currently supported, but support for RTM builds will end on November 7th, 2013 as that will be one year form the SP1 release (see MS Support site <a href=\"https:\/\/support.microsoft.com\/lifecycle\/?p1=16139\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>).<\/p>\n<p>Data for 182 SQL Server 2012 instances (5.90% of results):<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nHow Many   Build Number     Release\r\n------------------------------------------------------\r\n38         11.0.2100.60     2012 RTM\r\n1          11.0.2218.0      2012 RTM + MS12-070\r\n1          11.0.2332.0      2012 RTM CU3\r\n1          11.0.2376.0      2012 RTM CU3 + MS12-070\r\n1          11.0.2383.0      2012 RTM CU4\r\n1          11.0.2395.0      2012 RTM CU5\r\n1          11.0.2405.0      2012 RTM CU7\r\n33         11.0.3000.0      2012 SP1\r\n19         11.0.3128.0      2012 SP1 + KB2793634\r\n6          11.0.3321.0      2012 SP1 CU1\r\n53         11.0.3339.0      2012 SP1 CU2\r\n21         11.0.3349.0      2012 SP1 CU3\r\n2          11.0.3350.0      2012 SP1 CU3 + KB2832017\r\n3          11.0.3368.0      2012 SP1 CU4\r\n<\/pre>\n<p>I consider anyone on 2012 SP1 onward as up-to-date. This means that 137 (75.27%) of the 2012 instance in the survey are up-to-date, and all instances are supported.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Back in May I started a survey to collect build numbers to see how up-to-date people keep their SQL Server instances and I&#8217;ve been putting off writing this post as I wanted to do justice to the data. I received results for 3085 SQL Server instances from several hundred respondents &#8211; thank you! I broke [&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-4191","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 than half of all SQL Server instances are out-of-date and unsupported! - 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\/build-numbers-survey-results\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"More than half of all SQL Server instances are out-of-date and unsupported! - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Back in May I started a survey to collect build numbers to see how up-to-date people keep their SQL Server instances and I&#8217;ve been putting off writing this post as I wanted to do justice to the data. I received results for 3085 SQL Server instances from several hundred respondents &#8211; thank you! I broke [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-20T21:30:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-31T01:27:26+00:00\" \/>\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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/\",\"name\":\"More than half of all SQL Server instances are out-of-date and unsupported! - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2013-08-20T21:30:29+00:00\",\"dateModified\":\"2019-12-31T01:27:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"More than half of all SQL Server instances are out-of-date and unsupported!\"}]},{\"@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 than half of all SQL Server instances are out-of-date and unsupported! - 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\/build-numbers-survey-results\/","og_locale":"en_US","og_type":"article","og_title":"More than half of all SQL Server instances are out-of-date and unsupported! - Paul S. Randal","og_description":"Back in May I started a survey to collect build numbers to see how up-to-date people keep their SQL Server instances and I&#8217;ve been putting off writing this post as I wanted to do justice to the data. I received results for 3085 SQL Server instances from several hundred respondents &#8211; thank you! I broke [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/","og_site_name":"Paul S. Randal","article_published_time":"2013-08-20T21:30:29+00:00","article_modified_time":"2019-12-31T01:27:26+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/","name":"More than half of all SQL Server instances are out-of-date and unsupported! - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2013-08-20T21:30:29+00:00","dateModified":"2019-12-31T01:27:26+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/build-numbers-survey-results\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"More than half of all SQL Server instances are out-of-date and unsupported!"}]},{"@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\/4191","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=4191"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4191\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}