• subscribe
July 19, 2007 12:00 AM

Too Soon for SQL Server 2008?

SQL Server Pro
InstantDoc ID #96028

Believe it or not, the next release of SQL Server—SQL Server 2008—is right around the corner. For software vendors in the SQL Server marketplace, a new release is always a good thing because it never fails to generate renewed interest in their products. On the product side, all the players get swept up in the release enthusiasm. But releases aren't necessarily good news for customers.

Many of the customers I'm in contact with are still struggling to adopt most of the new features in SQL Server 2005. Features such as the integration of CLR, the new HTTP endpoint capability, Notification Services, SQL Service Broker, and even Integration Services take a lot of time and effort to implement. For instance, incorporating them into existing databases and applications often requires design changes, which require lengthy development, testing, and deployment cycles to roll out updates for those databases and applications. And before those cycles even happen, there's often a planning period where companies evaluate the new features in a release and then examine where those features might be a good fit for their processes. This effort doesn't come lightly for organizations of any size, and it's a process that can take months or years to actually complete. With SQL Server 2005, many companies are just now in the initial development phase. And they're far from ready for a completely new release with an all-new feature set.

With precious little fanfare, Microsoft has put the SQL Server 2008 release on the table for early 2008. Though details about the new release are still sketchy, some of the main features that Microsoft announced at the Business Intelligence Conference 2007 in Seattle include an even stronger emphasis on business intelligence (BI). (For more information about the features in SQL Server 2008, see http://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx.) But those businesses that are already lagging behind in their BI adoption aren't clamoring for new BI capabilities. Although SQL Server's BI features are certainly one of the key differentiators that give it a competitive advantage over Oracle and DB2, BI features such as Analysis Services and Data Mining aren't used by all SQL Server organizations. Previous SQL Server Magazine Instant Polls indicate that only about 25 percent of readers use Analysis Services. (If you stretch the definition of BI to include Reporting Services and Integration Services, the percentage of shops that implement BI is much higher as most SQL Server 2005 organizations use these features. Although Microsoft likes to categorize Reporting Services and Integration Services as BI features, most organizations that use them wouldn't consider themselves BI implementers.)

I can't help but think that the upcoming SQL Server 2008 release will be too soon for most SQL Server–based businesses, which are still trying to incorporate the 2005 feature set into their applications. I'd love to hear what you think about SQL Server 2008. Are you chomping at the bit for a new release of SQL Server? Or is SQL Server 2008 just too much too soon? Let me know what you think; drop me a line at motey@sqlmag.com.



ARTICLE TOOLS

Comments
  • cherie
    5 years ago
    Nov 21, 2007

    Although I see the point with those still growing accustomed to 2005; we need the geodetic capabilities that are coming with 2008. Since all we do is work with geospatial data (aside from accounting), this will allow us to do more on the backend than was possible before. It can't come out too soon for us. And we did decide to not worry with upgrading our production servers with 2005 because of what we could get with 2008.

  • Diana
    5 years ago
    Aug 09, 2007

    Here are additional comments on this editorial that came directly to the author. We encourage your feedback and look forward to you sharing

    your opinion with us!
    Diana May - Technical Editor, SQL Server Magazine

    ==========================================
    Hi Michael,

    Just wanted to let you know I agree with your editorial. We just implemented SQL 2005 on our enterprise database in May of this year, and it’s

    sort of disheartening to think that I don’t really even have the time to get up to speed on the new 2005 features before I need to start looking at

    SQL 2008. We don’t use Analysis Services heavily, but we do use SSIS and SRS, and will probably want to leverage any improvements there

    (we are trying to move off of Cognos and into exclusive use of SRS). But we have other development projects to do, and we can’t just spend all

    our time on infrastructure upgrades. It was difficult enough to find a time to squeeze in the 2005 upgrade. I don’t know how soon we’ll be able to

    move to 2008.

    So anyway, you asked for opinions…there’s mine.

    Stephanie Williams
    Database Administrator

  • Robert
    5 years ago
    Jul 23, 2007

    We had done a lot of work in preparation of upgrading from 2000 to 2005 and were just getting ready to start, when we heard the announcement about 2008. Now we'll be leapfrogging 2005 and wait for 2008. For us the major issues are DTS to SSIS migration, user testing, and upgrading the skills of our development staff. Our motivation for upgrading was to get around the memory limitations of 2000 Standard Edition, and due to end-of-support issues.

  • Pranil
    5 years ago
    Jul 22, 2007

    It's too soon. We have just kicked off our upgrade of SQL 2000 to 2005, having about 30 servers. This will take at least a year due to dependencies between different applications and having to upgrade all our third-party software to the version which is supported on SQL 2005. And that doesn't even include plans to use other features such as Service Broker, Notification services, etc. The benefits of upgrading to 2005 in our environment is minimal as 2000 is very stable, so the main driver is the end of support for 2000.

  • Steve
    5 years ago
    Jul 21, 2007

    As a Small Business Server shop going to SQL Server 2005 was a no-brainer. But the compatibility level hasn't been changed - that requires testing we haven't made time for. So in that sense, we aren't up to speed on 2005 yet, so yes 2008 is a lot to contemplate.

You must log on before posting a comment.

Are you a new visitor? Register Here