SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

SQL Server 2005 Feature Survey Results

By Brian Knight, 2004/03/22

Total article views: 10958 | Views in the last 30 days: 7

At the PASS conference last year, Andy, Steve and I were sitting around a dinner table wondering what would make us make the big jump to Yukon (now called SQL Server 2005).  We especially wondered what would make smaller companies that represent the backbone of SQL Server users make the big jump to SQL Server 2005. At the time it took a little imagination to see where Microsoft was going with Beta 1 of SQL Server 2005, since much of the interface would say “Not Implemented Yet” when clicking on it.  Well, 4 months later not much has changed but we now have word what all the features are. Those features can all be seen on Microsoft’s site at http://www.microsoft.com/sql/yukon/productinfo/top30features.asp.

A week ago, we solicited readers to let Microsoft know which of the SQL Server 2005 announced features mattered most to them. We had a great response, with 890 of you answering the survey in three days. The answers were pretty interesting. The full results can be seen at the bottom of this article. We essentially asked readers to look at the top 30 features and rank how important these features were in making them upgrade.

One of the most striking result was in the security realm. 77% of the respondents said that the proposed security enhancements were either an important or must-have feature. In the developer category, T-SQL enhancements was the most important feature.  One of the most important business intelligence features was DTS and scalability, which has been overhauled from the previous release.

We also asked readers if there were any features that they'd like to see in the next release of SQL Server. You can see that list of features in an un-edited form here: http://www.sqlservercentral.com/columnists/bknight/usersqlserver2005features.asp .

Complete Survey


1. SQL Server 2005 New Administration Features
  No need for feature Small need for feature Average feature need Important feature Must have feature Response Total
Database Mirroring 5% (37) 14% (113) 22% (180) 39% (316) 20% (162) 808
Online Indexing Operations 4% (30) 10% (82) 27% (218) 35% (282) 23% (187) 799
New Integrated Toolset 3% (21) 7% (59) 29% (229) 41% (323) 20% (162) 794
Snapshot Isolation 7% (57) 18% (145) 35% (279) 28% (222) 11% (85) 788
Data Partitioning 4% (30) 13% (102) 26% (209) 35% (281) 22% (177) 799
Mirrored Backups 6% (47) 17% (136) 27% (212) 32% (254) 17% (136) 785
Online Restore 3% (22) 12% (95) 21% (164) 37% (297) 27% (219) 797
Fast Recovery 1% (11) 8% (65) 20% (157) 39% (314) 32% (253) 800
Dedicated Administrator Connection 4% (29) 13% (101) 22% (176) 34% (267) 28% (224) 797
Replication Enhancements 8% (63) 16% (126) 26% (203) 31% (246) 20% (156) 794
Total Respondents  810
(skipped this question)  80

2. SQL Server New Development Features
  No need for feature Small need for feature Average feature need Important feature Must have feature Response Total
.NET Framework Hosting 7% (50) 11% (81) 24% (181) 34% (258) 26% (198) 768
XML Technologies 3% (26) 10% (79) 22% (171) 33% (255) 31% (241) 772
ADO.NET 2.0 4% (30) 9% (69) 25% (192) 36% (281) 26% (199) 771
Transact-SQL Enhancements 1% (6) 2% (12) 12% (90) 37% (289) 49% (382) 779
SQL Service Broker 6% (45) 16% (121) 38% (294) 29% (221) 11% (83) 764
Notification Services 4% (30) 13% (100) 30% (231) 36% (276) 17% (129) 766
Web Services 5% (37) 10% (79) 28% (212) 33% (255) 24% (183) 766
XQuery Support 7% (55) 16% (118) 31% (236) 28% (212) 18% (135) 756
Full-Text Search Enhancements 9% (73) 22% (172) 27% (211) 25% (191) 16% (122) 769
Security Enhancements 2% (16) 5% (41) 16% (122) 31% (237) 46% (357) 773
Total Respondents  785
(skipped this question)  105

3. SQL Server New Business Intelligence Features
  No need for feature Small need for feature Average feature need Important feature Must have feature Response Total
Data Transformation Services (DTS) 2% (17) 6% (48) 12% (91) 33% (254) 47% (368) 778
Data Mining 4% (32) 10% (78) 25% (188) 34% (262) 27% (207) 767
Clustering Support 5% (39) 10% (79) 24% (181) 29% (218) 32% (241) 758
Key Performance Indicators 3% (20) 6% (49) 26% (195) 36% (278) 29% (221) 763
Scalability and Performance 2% (12) 5% (35) 13% (97) 36% (273) 45% (346) 763
One-click Cubes 8% (63) 19% (149) 30% (227) 28% (215) 15% (111) 765
Architecture Enhancements 2% (18) 7% (54) 29% (220) 37% (282) 25% (187) 761
Integration with the Microsoft Office System 11% (83) 17% (128) 24% (187) 28% (218) 20% (154) 770
Total Respondents  775
(skipped this question)  115


5. If SQL Server 2005 was released in the first half of 2005, when would you upgrade?
  Response Total Response Percent
Immediatly 141 16%
After a few months 277 32%
More than 6 months after release 115 13%
After Service Pack 1 154 18%
After a year 56 6%
Never 5 1%
Total Respondents  743
(skipped this question)  147

6. Are you planning on participating in the SQL Server 2005 beta program?
  Response Total Response Percent
Yes 389 45%
No 355 41%
Total Respondents  739
(skipped this question)  151

7. What do you consider to be your role in your company?
  Response Total Response Percent
Developer 498 57%
DBA 539 62%
Business Intelligence professional 134 15%
Manager 97 11%
Business analyst 75 9%
Other 25 3%
Total Respondents  763
(skipped this question)  127

By Brian Knight, 2004/03/22

Total article views: 10958 | Views in the last 30 days: 7
Your response
 
 
Related tags
 
Already registered?  

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

  

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com