Computerworld
Quick Menu
Search



Ads by TechWords

See your link here


Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
Computerworld 2007Subscribe to Computerworld
40 years of the most authoritative source of news and information for IT leaders.

Microsoft releases preview of SP1 for SQL Server 2005

SP1 offers database mirroring and, for Express edition, a management tool
 

Sign up to receive Databases Resource Alerts

March 15, 2006 (Computerworld) -- Microsoft Corp. today released a Community Technology Preview (CTP) of the upcoming Service Pack 1 for its SQL Server 2005 database.

New features in SP1 include full database mirroring to offer real-time data backups and SQL Server Management Studio Express, which is designed to help database administrators run the free version of SQL Server 2005, according to Ilya Bukshteyn, Microsoft’s director of product management for SQL Server. SP1 is on schedule for final release next month.

This is the first CTP ever released for a Microsoft Service Pack. Microsoft, which has traditionally released between one and three beta versions of a software product before its final release, has moved toward CTPs -- which arrive very two to three months -- for certain products, including SQL Server, Visual Studio and the client version of the Windows operating system, said Bukshteyn.

He acknowledged that Microsoft was partially inspired by the success of the open-source model of software development. “The thing that is very powerful is being open and transparent with the community,” Bukshteyn said.

More than 50 companies are already using SQL Server’s database mirroring, which was available in the initial release of SQL Server 2005 in November. It was not considered production-ready at that time.

Chip Andrews, chief IT officer for Brenau University in Gainesville, Ga., and webmaster for a Web site on SQL Server security issues, said he is “very happy” with SQL Server 2005 itself. But “the tools have undergone some serious changes, so I have had more stability problems with them than the SQL Server 2005 query engine itself," he added. "Hopefully SP1 will address those issues, as well as increase performance of the Management Studio.”

SP1, which is about 250MB in size and is available for download, includes fixes for bugs and other technical problems but no security updates this time around, Bukshteyn said. Security patches for SQL Server will in the future be available on an immediate, ad hoc basis as well as in the Service Packs.

One “ongoing” security complaint about SQL Server 2005 is the “still-vast number of extended stored procedures that can be executed by even low-privilege user accounts," said Andrews. "They still give normal users too much of an opportunity for mischief.”

Microsoft has not publicly discussed how well SQL Server 2005, which took five years to ship, is selling -- apart from revealing late last month that SQL Server revenue from its most recent quarter had grown 20% over the same quarter a year earlier.




Print this Story Send Us Feedback E-mail this Story Digg! Digg this Story Slashdot this Story
"She was the new girl in town for a while, but Google Chrome has lost her shine. Sorry Chrome: You've..." Read more...
"Welcome to a special..." Read more...
Read more Software posts or See all Blogs
Microsoft's Ballmer ordered to testify in 'Vista Capable' suit
Spyware case finally closed for teacher Julie Amero
Bush's exit to put new e-records system to the test
More top stories...
Judgment favors Novell in ongoing SCO case
Symantec sees spike in dangerous Microsoft attacks
BlackBerry Storm buyers brave the cold in Boston to be first with the new smart phone
If you're like our 7,000 survey respondents, your paycheck this year has been flattened and your bonus obliterated. We offer 12 ways to plump up your paycheck.
Microsoft's next OS might more accurately be called Windows 6.5: It's essentially a better version of Vista.
Twitter can be a valuable business tool -- if you know what you're doing. Here's how to juice it for all it's worth.
By helping Intel with loosened 'Vista Capable' requirements, Microsoft 'severely damaged' its credibility, said an HP exec in a newly unsealed Feb. 2006 e-mail.
Get the latest news, reviews and more about Microsoft's newest desktop operating system
Find wage data for 50 IT job titles.
All Zones
Business Continuity Zone
The File Data Management Zone
Security Management Zone
The SAS Zone
Business Intelligence and Analytics Zone
The Enterprise Search Zone
Software as a Service Zone
The Security Zone

Ads by TechWords

See your link here
Speeding the time to intelligence
Get this Computerworld report free for a limited time, compliments of SAS.
Time To Intelligence -- a concept defining how long it takes to get accurate and timely information into the hands of workers who need it most. Do it slower than your competitors and your company is toast. Do it faster, you scorch them. Business Intelligence is the key to optimizing Time To Intelligence, and success there is a combination of people, policies, and technology.
Download this executive briefing download
Transforming Disaster Recovery - VMware Infrastructure for rapid, reliable and cost-effective Disaster Recovery
Download this white paper today!
(Source: VMware) VMware Infrastructure transforms disaster recovery by providing you fast, reliable and cost-effective disaster recovery. Why suffer from the slow, expensive and unreliable problems associated with traditional disaster recovery solution? VMware makes disaster recovery affordable through consolidation savings and re-use of existing servers for your disaster recovery site. Experience the speed of virtualization!
Download this white paper go
From Laggard to Leader: Transforming the Data Center
From Laggard to Leader: Transforming the Data Center
Register for this complimentary webcast today!
Go to the webcast 
White Papers
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
Infoblox IP Address Management Solutions Brief
2008 Internet Malware Trends Report
Enterprise Findability Without the Complexity
View more whitepapers 

SAS Information Management Kit

SAS is the leader in business intelligence and analytical software and services. Only SAS offers leading data integration, storage, analytics and business intelligence applications within a comprehensive enterprise intelligence platform. SAS gives 97 of the top 100 companies in the 2007 Fortune 500 THE POWER TO KNOW®.

Webcast: The Information Management Roadmap
Imagine high-quality data, cleansed, analyzed and delivered throughout your organization. Join Computerworld, IT visionary Thornton May and a panel of experts to learn how SAS® can help you make it happen.

View this webcast 
Research Report: Information Management Initiatives at Midsize and Large Organizations
See the top-line results of this Computerworld sponsored survey to see how IT and business leaders are handling information management implementation.

Download this report 
White Paper: Information Management: Better Information for Winning Decisions.
This white paper explains how the SAS Information Evolution Model aids companies in assessing how they use this information to make strategic decisions and drive business.

Download this white paper