Too Soon for SQL Server 2008?

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.

Discuss this Article 7

Markus_SQL
on Jul 20, 2007
We have only one SQL 2005 install here. The rest (20 Prod servers) are on SQL 2000.... about half on Win2000. We are in a budget crunch so we cannot come up with the 250k or so to upgrade. At this point we will probably be doing the calendar year 2009-10 jump from SQL Server 2000 to 2008.
Pranil (not verified)
on 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.
cherie (not verified)
on 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 (not verified)
on Aug 9, 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
Mark (not verified)
on Jul 20, 2007
I couldn't agree more. We're still in the process of rolling out SQL 2005 and the vast majority of our 100+ production SQL servers are still on SQL 2000 which has proven to be a highly stable and reliable platform. SQL 2005 was such a major change from 2000 that required much work to integrate in our environment. With the pending release of SQL 2008 this forces end-of-support dates for SQL 2000 and thus drives many upgrade projects for maintain viability purposes, which the business benefits little from. As mentioned in another article we'll be leapfrogging 2005 for the most part to extend support dates. regards, Mark
Steve (not verified)
on 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.
ragresti
on 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.

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Michael Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 21, 2013
blog

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.