Belated SQL Server Upgrade Retains Its Appeal to Testers

Transferring Best Practice Analytics from Experts to Everyone When The BI You Know Isn't The BI You Need Gaining Insights Through Analytics Sign up to receive Security Resource Alerts

November 07, 2005 (Computerworld) -- Microsoft Corp. is finally set to launch its SQL Server 2005 database today. And despite a two-year delay, several users who have tested the software cited the improved performance and new functionality it brings as positive developments that likely will convince them to upgrade soon.

For example, beta tester Mayur Raichura, managing director of information services at The Long & Foster Cos. in Fairfax, Va., said he is "hoping that with the five years they have spent developing and tightening this product, this is truly not a 1.0 version." Raichura added that he wants to avoid the need for "some serious patch management" or deployment of service packs.

But he said that based on the features he has tested so far in the beta version, SQL Server 2005 could rival the databases of market leaders Oracle Corp. and IBM within a year. Long & Foster plans to begin using a production version of the database in the spring, when the real estate company is due to launch a new version of its corporate Web site.

SQL Server 2005 supports database encryption and other new security features, as well as full-text search, native storage and querying of XML documents, and added business intelligence functionality. The database is also integrated with Visual Studio 2005, which lets developers write applications in C# or Visual Basic instead of doing SQL programming.

Fabio Catassi, chief technical officer at Mediterranean Shipping Co.

Mediterranean Shipping Co., a Geneva-based company that operates container ships, is already running the new database on production systems. As part of Microsoft's Technology Adoption Program , Mediterranean Shipping beta-tested SQL Server 2005 for nearly a year before going live with the Enterprise edition several months ago.

Fabio Catassi, the shipping company's chief technical officer, said end users experienced a "dramatic reduction" in the time needed to run queries after Mediterranean Shipping upgraded to a 64-bit version of SQL Server 2005 running on a Unisys ES7000 server. The performance gains were also a result of high-availability features such as the database's online index-rebuilding capability, he said.

SQL Server 2005 doesn't have everything Catassi is looking for. Some promised capabilities, most prominently database mirroring for automatic backups of information, aren't due to be available until next year. Meanwhile, his personal wish list still includes features such as the ability to load and compare multiple performance monitoring logs from different systems.

Benefit to Developers

Craig Steele, a senior network engineer at Progent Corp., an IT consulting firm in San Jose, said the most tangible improvements in SQL Server 2005 likely will benefit developers more than database administrators. For example, he pointed to the integration of the database with Visual Studio 2005, which is also being launched this week.

"Developers will be happy with the new SQL Server, but if you're an IT professional, whoop-dee-doo-dah-day," said Steele, who consults with corporate users on projects involving SQL Server and Microsoft's Exchange Server.

Steele added that he doesn't view the new release as a huge shift in technology from its SQL Server 2000 predecessor. "I know pure SQL [Server] people will love it," he said. "I'm just not sure about the rest of the world."

Raichura said the support for Microsoft's Common Language Runtime technology via Visual Studio will let him avoid having to go to multiple developers with different specialties. "I can natively write stored procedures straight into software," he said. "This increases my resource pool because it reduces the distinction between software developers and architects."

Kirk Pothos, a software development manager in Xerox Corp.'s printer service division, called Visual Studio 2005 "a huge step forward" for Microsoft. He added that his team has already upgraded to the new versions of both SQL Server and Visual Studio.

Robert Hurlbut, an independent software consultant in Worcester, Mass., said SQL Server 2005's security features are a big improvement over what was in the previous release of the database, especially for government users and companies in the health care and financial services industries. Microsoft has "locked down the ports and turned things on automatically that you used to have to do by hand," Hurlbut said.

DesignMind Inc., a software development firm in Oakland, Calif., has been using "a narrow set" of SQL Server 2005's features in live applications for several months, said Mark Ginnebaugh, the firm's president and head of the San Francisco SQL Server User Group.

Now DesignMind is moving forward on more extensive projects, such as using SQL Server 2005 to set up a large data mart for one client, Ginnebaugh said. Doing that on top of the client's existing DB2 database "would have been far more costly and difficult," he added.

OTHER PRODUCTS

In addition to SQL Server 2005, Microsoft this week is announcing: BizTalk Server 2006 Supports business activity monitoring procedures. Enables users to aggregate multiple business processes into a single application. Visual Studio 2005 Includes Visual Studio Team System for collaborative development. Adds integrated life-cycle management tools. Provides users with access to the .Net Framework. Lets IT architects and designers create service-oriented applications.

Print this Story

Send Us Feedback

E-mail this Story

Digg this Story

Slashdot this Story

Sidebar: Users Look to Database for Business Intelligence Apps Belated SQL Server Upgrade Retains Its Appeal to Testers

"We don't need al-Qaeda to blow us up. We are perfectly capable of lighting the fuse ourselves, courtesy of our..." Read more... "Analyzing data from online and your network may be a little easier because of a new browser. Yes, a browser...." Read more... Read more Business Intelligence posts or See all Blogs

Mozilla launches Firefox 3.0 RC1 early Microsoft: Don't misunderstand UAC, other Vista features HP confirms XP SP3 endless reboot snafu, promises patch More top stories...

Microsoft pulls Windows Home Server backup feature Yahoo tells Icahn that its own board knows best Tools circulate that crack Debian, Ubuntu keys

Shuttle Columbia's hard drive data recovered from crash site Specialists have retrieved about 99% of the data on a disk drive on board the crashed space shuttle Columbia. Don't miss the photographs of the recovered drive. The top 15 vaporware products of all time These big ideas were supposed to revolutionize technology, but they never actually appeared. In a few cases, you'll be glad they didn't. Opinion: Malware vs. anti-malware, 20 years into the fray Nearly 20 years after the first Internet worm, Steven J. Vaughan-Nichols takes stock of the malware/anti-malware landscape and spotlights how the two sides are approaching the battle. Leopard at six months: Does it live up to the early hype? Though some thought it was released too soon, Mac OS X 10.5 has matured into a solid operating system, says reviewer Michael DeAgonia. Windows Vista A to Z Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS. More Continuing Coverage After 9/11: Homeland SecurityAsk a Premier 100 IT LeaderBlackBerry Legal BattleData Security BreachesElectronic VotingFirefoxH-1B VisasHP's Boardroom ScandalHandheld DevicesHurricane Katrina AftermathMicrosoft Legal IssuesMicrosoft's VistaOpen SourceRFID TechnologySCO's Linux FightSarbanes-Oxley ActSpamVoice Over IPWi-FiWindows Meta File VulnerabilityWindows XP Service Pack 2 IT Careers 2010 Four years from now, the IT field will be a vastly different place. Will you be ready? More Special Reports Premier 100 IT Leaders 2007 Best in Class2006 Computerworld Horizon Awards2006 Premier 100 IT Leaders2006 Salary Survey2007 Best Places to Work in IT2007 IT Forecast2007 Premier 100 IT Leaders40 Years of ComputerworldASPs, Take TwoBest Places to Work in IT 2003Best Places to Work in IT 2004Best Places to Work in IT 2005Best Places to Work in IT 2006Business Intelligence Home RunsBusiness Intelligence: Smarter BIBusiness Intelligence: The Future of BICRM Goes VerticalCRM: Sober CRMCareer Planning Guide 2005Careers: IT Profession 2010Computerworld Horizon Awards 2005Data Management: Mining for GemsData Management: Taming Data ChaosDevelopment: Hard-Workin' Web SitesDevelopment: New Tools New ChoicesDevelopment: The New World of Application DevelopmentDevelopment: The Web Services TsunamiDevelopment: Web Services HurdlesDisaster Recovery: Preparing for the WorstE-commerce Grows UpE-mail/Groupware: Big DecisionsFaces of Mobile ITForecast 2006Global MobileHardware: Multiple Cores, Multiple ChallengesHardware: On-Demand Un-HypedHardware: The Shape of Things to ComeHorizon Awards: 10 Cool Cutting Edge TechnologiesIT Management: Guide to Managing VendorsIT Management: Navigating Global ITIT Management: Recovery AheadIT Management: The Future of ITIT Management: The Resourceful Project ManagerInnovative Technology Awards 2004Management: Reinventing ITMicrosoft in TransitionMobile/Wireless Leaders and LaggardsMobile/Wireless: The Untethered WorkerMobile/Wireless: Tiny Gadgets, Huge CostsNetwork Management: Taking ControlNetworking: Turbulence Ahead!Networking: VoIP Goes MainstreamOperating Systems: In the Slow LaneOperating Systems: Linux Goes GlobalOperating Systems: Should You Nix Unix?Outsourcing: Offshore Buyer's GuideOutsourcing: Outsourcing DangersPremier 100 IT Leaders 2004 Best in ClassPremier 100 IT Leaders 2005 Best in ClassROI: Do the Math!Salary Survey 2003Salary Survey 2004Salary Survey 2005Security Action PlanSecurity: Compliance HeadachesSecurity: Proactive SecuritySecurity: Risk and RewardSecurity: Tips From Security ProsSouped-up SecurityStorage: Battling ComplexityStorage: Cheap & Secure Data StoresStorage: Stretching Your Storage DollarsStorage: The Lean Storage MachineStorage: The New Rules of StorageStorage: The Ultimate Backup GuideSupply Chain: Missing LinksSupply Chain: RFID Reality CheckThe Business of SecurityWeb 2.0 SecurityWireless: Wireless At Work All Zones Application Performance Zone Enterprise-Class Security Zone Enterprise Solutions Zone The File Data Management Zone Grid Computing on Windows Zone Security Management Zone ITIL Best Practices Zone The SAS Zone Storage Virtualization Zone The Data Center Management Zone See your link here

Computerworld Report: Storage Gets Strategic Download this Computerworld Report, free, compliments of HP. (Source: Computerworld) Data Storage has emerged from the back room to become a key part of regulatory compliance, disaster recovery and strategic tecnhology plans. Learn more in this new this Computerworld report, a $49.95 value, available free for a limited time, compliments of HP. Download this executive briefing  Why SaaS is Vital to Email and Web Security Why SaaS is Vital to Email and Web Security Download this webcast, free, compilments of Webroot Software Go to the webcast  The Advantages of a Hosted Messaging Security Solution Get this report now! (Source: Microsoft Office Live Meeting) Messaging management is becoming more difficult thanks to the growing malware threat. At the same time, messaging system administrators are under enormous pressure to push their messaging infrastructures to do more than ever, including archiving messaging content for regulatory compliance, archiving to support legal discovery and for overall litigation support, providing services to a growing body of mobile users, and ensuring continuity by making the messaging system more reliable, and managing policies for message encryption. Download this white paper  White Papers Read up on the latest ideas and technologies from companies that sell hardware, software and services. Securing Financial Services Beyond the Perimeter Intercept Spam & Viruses With MessageLabs Meeting PCI Compliance with SonicWALL Global Management System View more whitepapers

• Sidebar: Users Look to Database for Business Intelligence Apps
• Belated SQL Server Upgrade Retains Its Appeal to Testers

• Mozilla launches Firefox 3.0 RC1 early
• Microsoft: Don't misunderstand UAC, other Vista features
• HP confirms XP SP3 endless reboot snafu, promises patch
• More top stories 

Computerworld Technology Briefing: An open-source path to optimal virtualization Looking for a virtualization strategy that offers both the flexibility and reliability to meet the demands of mixed-source environments? Look no further than the fast-emerging open virtualization approach backed by some of the biggest names in enterprise computing. Together they are pointing the way toward higher data center performance without higher costs. Download this briefing



XenServer FREE trial Citrix XenServer is the simplest and most effective way to virtualize and provision servers. XenServer combines comprehensive server virtualization capabilities with unparalleled scalability, performance, economics, and ease-of-use. Based on the open source Xen hypervisor, XenServer delivers fast performance, easy management, and advanced features such as live migration. Request free trial now



Since You Asked A weekly storage column from storage analyst, Steve Duplessie of the Enterprise Strategy Group Click here to read the latest column by Steve Duplessie