{"id":4388,"date":"2014-07-07T15:27:34","date_gmt":"2014-07-07T22:27:34","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4388"},"modified":"2017-04-13T09:52:14","modified_gmt":"2017-04-13T16:52:14","slug":"sql-server-2005-survey-sql-server-team","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/","title":{"rendered":"SQL Server 2005 survey from the SQL Server Team"},"content":{"rendered":"<p>SQL Server 2005 will end Extended Support on 4\/12\/2016 (see the <a href=\"https:\/\/support.microsoft.com\/lifecycle\/search\/?sort=PN&amp;alpha=sql\" target=\"_blank\">Support Lifecyle<\/a> page for details) and the SQL Server Team in Microsoft is conducting a survey with customers to gain some insight that will help with development of the next version of SQL Server. I volunteered to host a public version of the survey on my blog, take responses from you, and forward them on to the relevant SQL Server Team members.<\/p>\n<p>If you&#8217;d like to participate, please cut-and-paste the survey below and <a href=\"mailto:paul@sqlskills.com?subject=2005%20Survey Answers\" target=\"_blank\">email me with your answers<\/a>. I&#8217;ll pass them on, stripping out your contact details if you specify that.<\/p>\n<p>I&#8217;ve made the survey into plain text to ease c&amp;p issues. Please don&#8217;t put your answers in a comment, just send them in email. I&#8217;ll delete your\u00a0email once I&#8217;ve processed it.<\/p>\n<p><strong>[Edit 9\/18\/14: Please don&#8217;t send any more answers &#8211; the SQL Server team has enough results. Thanks!]<\/strong><\/p>\n<p>Thanks!<\/p>\n<pre class=\"brush: plain; gutter: false; title: ; toolbar: true; wrap-lines: true; notranslate\" title=\"\">\r\nDo you want to be anonymous?\r\n\r\nQuestions from the SQL Server Team:\r\n1) Is your company still using SQL 2005 for applications in production?\r\n   a) If so, how important are the apps (mission-critical, LOB, etc.)\r\n   b) If so, which SKU (Express, Standard, Enterprise)?\r\n\r\n2) In the following list of features, are you or your company still relying on them?\r\n   a) SQL Mail\r\n   b) CREATE\/ALTER TABLE or CREATE INDEX syntax without parentheses around table options\r\n   c) sp_configure options 'user instances enabled' and 'user instance timeout'\r\n   d) SQL Server Database Management Objects (SQL-DMO)\r\n   e) sp_dboption\r\n   f) DATABASEPROPERTY\r\n   g) UPDATE table1, table2, ... SET syntax\r\n   h) Database compatibility level 80\r\n\r\n3) Are there any features in SQL Server 2005 that has been announced deprecated that you still rely on?\r\n   a) The deprecated features list is: http:\/\/technet.microsoft.com\/en-us\/library\/ms143729(v=sql.90).aspx\r\n\r\n4) If you're looking to upgrade from SQL Server 2005:\r\n   a) To which SQL Server version are you looking at upgrading to?\r\n   b) What are the biggest upgrade blockers you see?\r\n\r\nMany thanks for any information you can provide!\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 2005 will end Extended Support on 4\/12\/2016 (see the Support Lifecyle page for details) and the SQL Server Team in Microsoft is conducting a survey with customers to gain some insight that will help with development of the next version of SQL Server. I volunteered to host a public version of the survey [&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-4388","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>SQL Server 2005 survey from the SQL Server Team - 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\/sql-server-2005-survey-sql-server-team\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2005 survey from the SQL Server Team - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2005 will end Extended Support on 4\/12\/2016 (see the Support Lifecyle page for details) and the SQL Server Team in Microsoft is conducting a survey with customers to gain some insight that will help with development of the next version of SQL Server. I volunteered to host a public version of the survey [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-07T22:27:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:52:14+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=\"2 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\/sql-server-2005-survey-sql-server-team\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/\",\"name\":\"SQL Server 2005 survey from the SQL Server Team - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2014-07-07T22:27:34+00:00\",\"dateModified\":\"2017-04-13T16:52:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2005 survey from the SQL Server Team\"}]},{\"@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":"SQL Server 2005 survey from the SQL Server Team - 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\/sql-server-2005-survey-sql-server-team\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2005 survey from the SQL Server Team - Paul S. Randal","og_description":"SQL Server 2005 will end Extended Support on 4\/12\/2016 (see the Support Lifecyle page for details) and the SQL Server Team in Microsoft is conducting a survey with customers to gain some insight that will help with development of the next version of SQL Server. I volunteered to host a public version of the survey [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/","og_site_name":"Paul S. Randal","article_published_time":"2014-07-07T22:27:34+00:00","article_modified_time":"2017-04-13T16:52:14+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/","name":"SQL Server 2005 survey from the SQL Server Team - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2014-07-07T22:27:34+00:00","dateModified":"2017-04-13T16:52:14+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/sql-server-2005-survey-sql-server-team\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2005 survey from the SQL Server Team"}]},{"@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\/4388","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=4388"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4388\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}