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. :)