SQL Server 2005 Feature Survey Results

,

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


Rate

Share

Share

Rate