Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server 2005 Feature Survey Results

By Brian Knight,

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

Total article views: 11081 | Views in the last 30 days: 0
 
Related Articles
ARTICLE

Review: Total SQL Analyzer

Total SQL Analyzer is a new product that can help document your SQL Server. This review examines the...

FORUM

SQL Server Features

SQL Server Features Implemented

FORUM

databases responding

databases responding

ARTICLE

New T-SQL Features in SQL Server 2005 Part 2

SQL Server 2005 has changed many of the ways in which we will use SQL Server in the future with a di...

FORUM

Why both "Target Server Memory" & "Total Server Memory" 0 ?

Why both "Target Server Memory" & "Total Server Memory" 0 ?

Tags
administration    
news    
sql server 2005    
sql server 7    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones