Learn more about SQL Server tools

   
   















































Why Upgrade to SQL Server 2008

MSSQLTips author Jeremy Kadlec By:   |   Read Comments (2)   |   Related Tips: More > Upgrades and Migrations

Problem
With the recent release of SQL Server 2008, getting up to speed on the technology is necessary from a number of different perspectives.  From your view of the world what are the drivers from a business, technology and career perspective?  Have you heard insight or opinions related to employers view of SQL Server 2008?  Do you have any suggestions when talking to management about moving to SQL Server 2008?

Solution
Making a compelling reason to upgrade to SQL Server 2008 may be difficult in some organizations and an expectation in others.  The same is true for new development with SQL Server 2008.  What is necessary is to understand where your organization or specific projects fall into this spectrum.  Depending on the expectations at this level, they can drive a great deal of the decision to upgrade or perform new development.  If you are faced with a situation where the upgrade has not been a consideration, try to learn about the decision making factors to understand how the technology is perceived by the business, before jumping in too far.

Business

When making the case to upgrade or perform new development on SQL Server 2008 with your management team, be sure to speak their language.  They might not understand all of the intricacies of SQL Server and they may not have the time to research the items you bring forth, so consider these aspects when speaking to them:

  • Operating costs - Based on how your organization does business, research the SQL Server 2008 features then outline aspects of SQL Server 2008 that will reduce operating costs or improve business\process efficiency.  Here are a few examples, although many more exist:
    • Resource Governor can be used to split the resources across the SQL Server 2008 instance for multiple business, application or processing needs extending the life of the hardware platform
    • Data encryption provides the ability to natively protect your sensitive data to put your customers at ease
    • Auditing is also natively available to ensure your applications are meeting internal, industry and contractual agreements
  • Microsoft support - Thus far I have been very surprised that support from Microsoft alone has not driven customers to upgrade from SQL Server 2000 to SQL Server 2005 or SQL Server 2008.  Based on the two entries below, it appears as if Microsoft will continue to support customers, but the support is based on a customer support agreement or an extended support agreement, which may be more costly than working through the upgrade or ensuring new systems are developed with SQL Server 2008.  Based on your agreement with Microsoft find out about these costs and determine what the financial impacts are for upgrading or not.  Please reference this information from Microsoft concerning SQL Server mainstream support:
  • Return on investment (ROI) - One of the first items when I think about ROI for the SQL Server 2008 platform is extending the life of the hardware.  With the support for hot pluggable CPUs and SQL Server Resource Governor you have the ability to scale and segment the resources to enable SQL Server to grow with your business.  To me this enables the organization to extend the life of the platform with the many hardware advances from various vendors.
  • Third party application support - Many vendors have been working with Microsoft to ensure their products support as well as leverage the new SQL Server 2008 features.  If your organization is dependent on many off the shelf products then it is necessary to ensure your third party vendors will support your platform moving forward.  Service and support agreements can be expensive, so make sure your platform does not violate any portion of the agreement based on the software versions.  If so, consider upgrading to not have an additional expense for extended support similar to the support needed with Microsoft.
  • Contractual agreements, external partners and relationships - In some organizations, the decision to upgrade or perform development on a new platform is based on an external organization or contractual agreement.  If that is the case in your organization, make sure you understand the ramifications before making a hard sell to your management.  Your management may be on board, but you may need to ask them to work with the other party to get SQL Server 2008 approved as an acceptable database platform.

Technology

From a technology perspective, SQL Server 2008 has introduced not only enhancements to existing features, but also delivered new functionality with the release to include:

  • Relational Engine
    • Development
      • Query guide support
      • MERGE statement
      • Change tracking support
      • LINQ
      • XML enhancements
    • DBA
      • Backup stream and data storage compression
      • Performance data collection
      • Native auditing objects
  • Integration Services
    • Many new toolbox features
    • Persistent lookups
    • Improved threading
  • Reporting Services
    • Native Microsoft Word based rendering
    • Eliminate IIS dependency
    • Improved charting and graphing
  • Analysis Services
    • Star JOIN support
    • Excel data mining interface
    • Partition table parallelism

For a complete list of new SQL Server 2008 features please review these two resources: SQL Server 2008 - Features, Function and Value and SQL Server 2008 List of New Features.

Career

One item that has stood out to me is a comment from a client a few months ago who was looking to hire a full time SQL Server DBA.  The comment they made was that they could not believe that anyone they were looking to hire was even looking at SQL Server 2008.  They indicated that the candidates were all knowledgeable in SQL Server 2000 and some candidates had strong SQL Server 2005 skills. They were really surprised that no one had really taken the time to get some exposure to SQL Server 2008.  The bottom line is that some employers are expecting candidates to be up on the latest and greatest technologies.  This is a key item to keep in mind as you are job hunting.

When I look at this from both sides of the fence, I know that DBAs\Developers are busy and do not have time to research all of the latest and greatest technology when development deadlines are looming or systems are having issues.  I think what is necessary is to strike some sort of balance and not be complacent.  The reality is very few people have production exposure to SQL Server 2008 as of the writing of this tip, so you are lucky if you are one of the few.  However, the masses have the opportunity to download, install and learn from the CTP's, online resources (web casts, online hosting, tips, articles, etc.) or local events (user groups, code camps, etc.).  Just be sure to take the time to get some exposure and pull together a plan for yourself to learn about the latest and greatest features of SQL Server 2008 that are of interest to you and your organization.

Next Steps



Last Update: 3/25/2008


About the author
MSSQLTips author Jeremy Kadlec
Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, Baltimore SSUG co-leader and SQL Server MVP since 2009.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates



       Note: your email address is not published. Required fields are marked with an asterisk (*)


Get free SQL tips:

*Enter Code refresh code     



Friday, June 01, 2012 - 4:40:41 PM - Jeremy Kadlec Read The Tip

Archana,

It has been awhile since I installed SQL Server 2005, but I think it is fairly similar to SQL Server 2008 from a functional perspective.

Is there something in particular you are concerned about?

Thank you,
Jeremy Kadlec


Wednesday, May 23, 2012 - 11:35:53 AM - Archana Read The Tip

please tell me wat is the difference between 2005 and 2008 installation?




 
Sponsor Information