Welcome to the Microsoft Medium Business Centre

Solutions, resources, ideas and communities for medium businesses

Microsoft SQL Server 2008

Microsoft SQL Server 2008

Your data, anyplace, anytime

With Microsoft SQL Server 2008, you can drive better insight and business intelligence throughout your entire organisation by integrating information into your data warehouse faster and more efficiently. Run your mission-critical applications on a trusted platform that provides high levels of security and reliability.

Features

Benefits of SQL Server 2008 for your medium business:

Protect your information

  • Encrypt data in an entire database or in data files without changing application codes.
  • Centralise auditing with new comprehensive data auditing capabilities, such as auditing when data has been read or when data modifications have been made.
  • Monitor all events at both the server and database levels.

Reduce total cost of ownership by simplifying administrative tasks

  • Enforce configuration policy compliance and apply policies throughout your organisation with Declarative Management Framework.
  • Troubleshoot, tune, and monitor one or more instances of SQL Server across your organisation with Performance System Analysis.
  • Schedule automated administrative tasks, and respond proactively to events.

Deliver business intelligence where your users want it

  • Control workload resource prioritisation and provide consistent performance to end users with Resource Governor.
  • Maximise storage, and increase query performance with built-in data compression.
  • Take advantage of improved performance, usability, and integration with the Microsoft Office 2010 system in SQL Server Reporting Services (US).
  • Efficiently store, manage, and analyse any kind of structured or unstructured data for a diverse range of data types, including relational data, XML documents, FileStreams, and spatial data.

For more detailed product information on Microsoft SQL Server 2008 and to learn more click here.

End of Mainstream Support for SQL Server 2005

As of April 12, 2011, SQL Server 2005 will transition from Mainstream Support to Extended Support, which includes paid support, charged on an hourly basis per incident, and security update support at no additional cost. Non-security related hotfix support will require a separate Extended Hotfix Support Agreement to be purchased within 90 days of the end of Mainstream Support (July 11th, 2011).

Your Options:

  • Remain on SQL Server 2005 with Extended Support.
  • Remain on SQL Server 2005 with Extended Support and purchase Extended Hotfix Support.
  • Upgrade to a supported version of SQL Server.

To learn more about your support options, visit the SQL Server Support Updates page and click the SQL Server 2005 tab.

To understand more about the SQL support lifecycle, click here, and to learn more about your support options, visit the SQL Server Support Updates page and click the SQL Server 2005 tab.

Related Solutions

For further reading, and to learn more about other business solutions relating to this product, check out the links below: