Integrating Microsoft SQL Server 2008 into a client's infrastructure can deliver improvements in database availability, disaster recovery, workload management, resource consumption and more. Use this SQL Server 2008 guide to compare the current version's features to previous editions and to find out which security considerations are most important. Learn when it's essential to migrate over to the new version and how high-availability services can increase profits and regenerate business.
Table of contents
• SQL Server 2008 news
• SQL Server 2008 security considerations
• New SQL Server 2008 features
Choosing and comparing SQL Server versions
upgrading to SQL Server 2008 fit your business?
The applications your clients use can dictate whether or not you should perform a SQL Server 2008 upgrade. Learn when clients need to migrate, no matter what their circumstance.
between SQL Server versions
Compare the features in SQL Server 2008 with the SQL Server 2005 and 2000 versions. Learn which improvements clients can easily take advantage of after an upgrade.
SQL Server 2008 news
SQL Server 2008 prep begins
Discover which marketing and partner incentives Microsoft used to prepare VARs for the introduction of SQL Server 2008.
Server 2008 release news
Check out how SQL Server 2008 made headlines at the Microsoft Worldwide Partner Conference.
SQL Server 2008 security considerations
security audit in SQL Server 2008
Follow the steps for creating, enabling and viewing a SQL Server 2008 audit that can track database usage.
SQL Server 2008 security enhancements
Read about the new encryption support features added to SQL Server 2008 and how they can help drive your client's upgrade cycle.
Server security: Auditing
Changes in auditing requirements have forced Microsoft to introduce new features for audit querying activity.
Server security: Authentication
Get a recap of how security authentication and permissions have changed as new versions of Microsoft SQL Server developed.
New SQL Server 2008 features
replication features in SQL Server 2008
Learn about the most important replication changes in Microsoft SQL Server 2008, including snapshot and transaction delivery improvements.
to SQL Server 2008 and leveraging new features
Find out how new features such as the FILESTREAM data type and Policy-Based Management provide benefits to your clients that will convince them to migrate to SQL Server 2008.
SQL Server 2008 Resource Governor primer
This chapter excerpt explains how the Resource Governor feature improves SQL Server 2008 performance by managing workloads and resource consumption limits.
SQL Server 2008 high-availability services
Microsoft SQL Server expert Ross Mistry answers popular questions addressing how to use failover clustering, database mirroring, log shipping and replication.
SQL Server 2008 reference spec should improve credibility
Microsoft seeks to improve its standing in data warehouse applications with SQL Server Fast Track.
profiling tools in SQL Server 2008
How can you use the SSIS 2008 Data Profiling task and Data Profile Viewer to design a better business intelligence strategy?
in SQL Server 2008 Reporting Services?
Learn which new features in Reporting Services make upgrading to SQL Server 2008 worthwhile, including better memory management and improved charting components.
options in SQL Server 2008
Read how high-availability options, such as failover clustering and database mirroring, can increase database availability and improve disaster recovery.
This was first published in May 2009