Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database

    The Wait for SQL Server 2005 Ends

    By
    Lisa Vaas
    -
    November 4, 2005
    Share
    Facebook
    Twitter
    Linkedin

      Its here.

      After five long years in development, after delay upon delay, after the Blaster worm threw the SQL Server team for a paradigm-shifting tizzy, after the miraculously rubbery feature list contracted and expanded like Gumby on a rabid bronco, its here: SQL Server 2005.

      Microsoft will launch officially on Monday the three products that together compose its “application platform” for the future: its SQL Server 2005 database, Visual Studio 2005 tool suite, and its BizTalk Server 2006 integration server.

      SQL Server 2005 (code-named Yukon) and Visual Studio 2005 (code-named Whidbey) are shipping now.

      BizTalk Server 2006 is on tap to ship in the early part of 2006, as will the Team Server edition of Visual Studio 2005.

      Of the triumvirate, SQL Server 2005, Microsofts next-generation database, is the beating heart.

      Its the encapsulation of Microsofts plans to bust out of the departmental closet.

      Its Microsofts attempt to expand beyond the humble ranks of the inexpensive, easy-to-use database used on the departmental level but rarely in the aristocracies of high-end data centers, where databases have to scale like mad to earn their place at the end of a power cord.

      Heres how it now stands: Gartner Groups database market stats from May showed Microsoft in third place, with a 20 percent share of the overall relational DBMS (database management system) market.

      IBM and Oracle Corp., in contrast, were neck-and-neck, with both holding about 34 percent of the market.

      Microsoft owns the low end of the database market, with the SMB market neatly tied up.

      The only place to go, the only place to change its third-place status, is up the food chain, into the realm of the enterprise.

      Hows it getting there? This database release comes packed with enterprise goodies.

      Feature breakthroughs include scalability and performance boosts such as 64-bit support and partitioning; high-availability features include database mirroring and failover clustering; security enhancements will bring data encryption and key management; programmability benefits include T-SQL enhancements and integration with CLR (Common Language Runtime) and .Net, along with XQuery, native XML and Web services integration; and one of the tastiest slices of the pie, the BI (Business Intelligence) capabilities and integration with Office 12.

      When it comes to scaling the enterprise walls, the BI piece of the puzzle is crucial. Much of the 10.3 percent growth in the 2004 database market came from BI, data warehousing and data analysis.

      Hence we see Microsoft responding to the increasing hunger to analyze geometrically expanding data stores by tying in powerful tools to its overall BI platform, including data integration, analysis, reporting and Report Builder, the end user ad hoc reporting tool that, Microsoft says, is its customers most frequently requested BI functionality.

      Microsofts BI plans dont stop there.

      The company is set to revolutionize use of the insanely popular Excel spreadsheet, setting it up so that Office 12 has new server-side Excel capabilities called Excel Services.

      /zimages/5/28571.gifClick here to read more about Microsofts business intelligence plans.

      With Excel Services, Excel will be able to be used as a BI interface sitting on top of SQL Server.

      What will that do? For the first time, it will give administrators the power to centrally secure, share and manage spreadsheets on the server, as opposed to the all-too-familiar scenario of having knowledge walk out the door when employees with mission-critical data stored on their desktops leave the company.

      Understandably, when it comes to SQL Server 2005, BI vendors are none too pleased.

      Hardware vendors, on the other hand, are ecstatic.

      SQL Server 2000 has supported a 64-bit version for Itanium for some time. Thats nice, but Itanium serves a high-end, niche server market.

      The majority of databases Microsoft sells are on X86-based platforms, not Itanium.

      SQL Server 2005, on the other hand, is plugging into AMDs Opteron. SQL Server 2005 running on top of Opteron-based servers are benchmarking at comparable performance to proprietary, RISC-based platforms.

      That means that for comparable performance, businesses will now be able to pay about half the amount of money.

      Next Page: Addressing customers worries.

      Addressing Customers Worries

      Margaret Lewis, AMDs commercial software strategist, said this addresses something data center customers are particularly worried about: bringing in powerful servers that need a lot of power and cooling.

      For the financial community in Manhattan, for example, its simply not doable, given the astronomical costs associated with bringing additional power lines into buildings.

      “They need to fill computing centers with very efficient power platforms that still give performance they need but fit within the power envelope,” she said.

      Whereas people have in the past bought high-end, large SMP servers for running critical databases, theres now an alternative in terms of performance, reliability and availability.

      As Lewis pointed out, its not often that big advancements happen in the database world, but this is one of them.

      “What I think it will do is make people think about the underlying architecture in data centers,” she said.

      Put that thought on top of the fact that BI has become a crucial part of the enterprise-level database.

      “What were seeing is the major database vendors such as Oracle and Microsoft are understanding that it isnt just data management anymore,” Lewis said. “That users are looking for more than just a backend database. So youre seeing [the vendors] responding.”

      Users stand to benefit with more analysis tools that are easier to use and more tightly packaged with databases.

      The new, more affordable chips will form an infrastructure to handle data very well, but will also have the CPU power for doing the advanced, now more widely available data analysis.

      Its the launch of a radically new application platform. Its the launch of Microsofts raid on the enterprise.

      Its the convergence of high-performance, low-cost chips, a plethora of BI, new manageability features, and plenty more.

      Finally, its here, and after enterprises have a chance to plug it into production, time will tell if SQL Server 2005 was worth the wait and if it lives up to its heady promise.

      Check out eWEEK.coms for the latest database news, reviews and analysis.

      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×