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 Database
    • Database

    SQL Server Needs Revision

    By
    Jim Rapoza
    -
    March 29, 2004
    Share
    Facebook
    Twitter
    Linkedin

      From Windows server 2003 to exchange Server 2003 to SharePoint 2.0 to BizTalk Server 2004, some of the best technology coming out of Microsoft lately has been on the server side. But all of these great server products have one problem: They are standing on an aging, creaky and often damaged base—Microsoft SQL Server 2000.

      As the name implies, SQL Server 2000 was released in the year 2000, along with Microsofts Windows 2000 and Office 2000. New versions of SQL Servers competitors were also released at that time, but they—and pretty much every other product released in 2000—have been upgraded in the four years since. Every product, that is, except SQL Server 2000.

      Theres been a lot of complaining lately, in the pages of eWEEK and elsewhere, about the extended wait for Microsofts Longhorn, code name for the next full upgrade to Windows XP. But, compared with the wait for the next SQL Server upgrade, the wait for Longhorn wont be long at all.

      Its true that big products such as databases tend to move in much slower product cycles than things such as office suites. But four years is a long time, no matter how you cut it. Five years is even longer, and itll be at least that long between SQL Server 2000 and the new release of the database, currently code-named Yukon. This could spell big problems for any company basing its infrastructure on Microsoft servers.

      Think of it this way. Imagine you were going to build a PC system. You decide to build a killer rig, and you get the best motherboard, a big-and-fast hard drive, lots of memory, a top-of-the-line graphics card, even a DVD burner and LCD screen. But in this best-of-breed system, you install a circa-2000 Pentium III processor.

      Thats what the current Microsoft server platform is like—lots of brand-new, high-performance products running on an old engine.

      Some companies may decide they can no longer wait for that engine to be upgraded.

      In fact, this may already be happening.

      As part of my job, I talk to lots of people in IT departments. I always ask for a list of IT products in use, and many of these companies are predominantly Microsoft shops.

      However, looking at my notes recently, I noticed a trend in these shops: a surprising absence of SQL Server in key spots.

      Sure, these shops have some SQL Server installations, but usually only in cases where another Microsoft application requires it. Many times, these companies were using another product as their key enterprise database, often Oracle or DB2.

      Microsoft recently announced that the next version of SQL Server wont ship until early next year. Even if the release date doesnt slip again (and would you really want to bet on that?), many companies wont be deploying the new SQL Server until 2006, especially if they follow the common practice of waiting for a products first service pack before full deployment.

      Im not in favor of rushing products to market. In fact, I think vendors and customers are better off with a late product than with a bug-ridden product that hits its release mark. Customers should not be involuntary beta testers.

      The feature set of the forthcoming SQL Server, which is expected to be named SQL Server 2005, looks compelling, especially for developers of next-generation business applications.

      But five years is a bit much. I think I speak for a lot of SQL Server users when I say that a SQL Server 2003 release would have been a good thing. It didnt have to be anything major, just something that addressed security problems more effectively than a service pack and that made SQL Server better equipped to deal with the current reality of Web services and XML.

      Instead, we wait. Or not. Because when it comes to a core enterprise database system, living in the past is not an option.

      Labs Director Jim Rapoza can be reached at jim_rapoza@ziffdavis.com.

      Jim Rapoza
      Jim Rapoza, Chief Technology Analyst, eWEEK.For nearly fifteen years, Jim Rapoza has evaluated products and technologies in almost every technology category for eWEEK. Mr Rapoza's current technology focus is on all categories of emerging information technology though he continues to focus on core technology areas that include: content management systems, portal applications, Web publishing tools and security. Mr. Rapoza has coordinated several evaluations at enterprise organizations, including USA Today and The Prudential, to measure the capability of products and services under real-world conditions and against real-world criteria. Jim Rapoza's award-winning weekly column, Tech Directions, delves into all areas of technologies and the challenges of managing and deploying technology today.
      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
      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
      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
      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.

      ×