Testers give high marks to new features in SQL Server upgrade
But whether the additions will be enough to spur widespread upgrades is unclear
Computerworld - A conference being held in Denver this week by the Professional Association for SQL Server user group will provide a forum for the biggest public unveiling to date of Microsoft Corp.'s SQL Server 2008 database.
But as many as 20,000 users have already been testing the upcoming software, which is scheduled for release by next June. And their reactions, detailed in interviews or via blog postings, have been mostly positive thus far.
For instance, David Smith, CIO at ServiceU Corp. in Cordova, Tenn., said that SQL Server 2008 has improvements in "hundreds of areas. It's exactly what I need."
ServiceU, a provider of event and box-office management services, is a member of Microsoft's Technology Adoption Program for SQL Server and is already using an early version of the 2008 release in a number of business intelligence applications. Smith said he also plans to deploy SQL Server 2008 for ServiceU's mission-critical systems before the software's official release.
Gartner Inc. analyst Donald Feinberg said he thinks that SQL Server 2008 will put the Microsoft product on an equal technical footing with IBM's DB2 database, and also make it equal with Oracle databases "in terms of base functionality."
Microsoft has made four Community Technical Preview (CTP) releases of SQL Server 2008 available for testing, with the most recent version appearing last month. One of the areas that Microsoft has particularly targeted for improvement is security, which was a major Achilles' heel as recently as SQL Server 2000 -- just two releases ago.
Many of the security shortcomings were fixed in the current SQL Server 2005 release, although the cost to Microsoft was an extra two years of development. Company officials say that SQL Server 2008 will include a number of additional security and auditing features, without an accompanying delay.
One of Microsoft's most highly touted new features is a data encryption capability that operates so transparently that users won't need to rewrite applications or suffer any performance hits when it is turned on, according to Ted Kummert, corporate vice president of the vendor's data and storage platform division.
"It's important to cover data throughout the entire life cycle, both when it's at rest and in motion," said Kummert, whose development schedule calls for SQL Server 2008 to be released to manufacturing in next year's second quarter (see companion story posted here).
First Premier Bank, a credit card issuer in Sioux Falls, S.D., is testing the transparent encryption feature on a 2TB data warehouse, according to Ron Van Zanten, the company's directing officer for business intelligence. So far, "the performance is OK," Van Zanten said, adding that the encryption tool is much simpler to implement than the one in SQL Server 2005.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Who's afraid of the big (data) bad wolf? Survive the big data storm by getting ahead of integration and governance functional requirements This paper provides a detailed review of the best practices clients should consider before embarking on their big data integration projects.
- Understanding big data so you can act with confidence Automating information integration and governance and employing it at the point of data creation helps organizations boost confidence in their big data.
- Integrating and Governing Big Data The end-to-end information integration capabilities of IBM® InfoSphere® Information Server are designed to help organizations understand, cleanse, monitor, transform and deliver data-as well...
- The MDM advantage: Creating insight from big data To help enterprises create trusted insight as the volume, velocity and variety of data continue to explode, IBM offers several solutions designed to...
- Live Webcast Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing...
- The Software-Defined Data Center: Is your ADC ready? Data center transformation is accelerating beyond virtualization to next-generation cloud architectures and software-defined data centers, bringing new challenges for application performance, scalability and...
- Application Acceleration: Optimize the End-User Experience Watch this on-demand webcast and learn how you can optimize your web content, accelerate performance across any device and browser combination, and offload... All Business Intelligence/Analytics White Papers | Webcasts