Why Upgrade to SQL Server 2008?

Looking through all the marketing material you get as a Microsoft Partner is a daunting task.  In the interim what I've done is upload all the materials to my internal SharePoint site, and index all the documents.  That way, if I need to search for something all I have to do is open SharePoint and do a search.  Very handy for hiding documents for later viewing.

Anyway...In my travels I came across the marketing reasons to upgrade to SQL Server 2008.  I did a presentation at Techdays in Montreal on a few of these, but that was really just a high level overview.  Here is the list:
  • Transparent Data Encryption
  • External Key Management
  • Data Auditing
  • Pluggable CPU
  • Transparent Failover for Database Mirroring
  • Declarative Management Framework
  • Server Group Management
  • Streamlined Installation
  • Enterprise System Management
  • Performance Data Collection
  • System Analysis
  • Data Compression
  • Query Optimization Modes
  • Resource Governor
  • Entity Data Model
  • LINQ
  • Visual Entity Designer
  • Entity Aware Adapters
  • SQL Server Change Tracking
  • Synchronized Programming Model
  • Visual Studio Support
  • SQL Server Conflict Detection
  • FILESTREAM data type
  • Integrated Full Text Search
  • Sparse Columns
  • Large User Defined Types
  • Date/Time Data Type
  • LOCATION data type
  • SPATIAL data type
  • Virtual Earth Integration
  • Partitioned Table Parallelism
  • Query Optimizations
  • Persistent Lookups
  • Change Data Capture
  • Backup Compression
  • MERGE SQL Statement
  • Data Profiling
  • Star JoinEnterprise Reporting Engine
  • Internet Report Deployment
  • Block Computations
  • Scale out Analysis
  • BI Platform Management
  • Export to Word and Excel
  • Author reports in Word and Excel
  • Report Builder Enhancements
  • TABLIX
  • Rich Formatted Data
  • Personalized Perspectives
What I'm thinking I'll do is make a post on each item once a week or so. Maybe more often if I have free time. :)