8/07/2008

So SQL 2008 went RTM yesterday...cool.

Now, to dig in and see what (if any) of the really cool new features moved to the standard version instead of Enterprise. Or even stuff from 2005 moving into standard...

Post a comment if you already have the list :)

OK...here we go:
Features Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx

Backup compression: Enterprise only. No thanks, I'd rather buy Litespeed or Red Gaet SQL Backup than pay this premium :(

Encryption: Enterprise only (TDE and Data Compression): Great feature, easier to use, worth the expense for some companies/industries

Resource Governor: EE only...cool feature, but I wonder how often it will get used in practice

Database Mirroring: Yes (safety full only) in Standard edition

Auditing: EE only. Someone is going to blow performance out the door by auditing everything...be judicious here folks!

Capacity Specifications for SQL 2008 objects:
http://msdn.microsoft.com/en-us/library/ms143432(SQL.100).aspx

Maximum Number of Processors Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143760(SQL.100).aspx

A Processor is still defined as a socket here, so 4 quad cores gives you a SE SQL Server with 16 CPUs.

Memory Supported by the Editions of SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143685(SQL.100).aspx
Workgroup edition got a 1gb bump here

And my favorite feature thus far is still the very configurable installer. I install at least 1 SQL Server per week and despise having to physically move the system databases and set the default locations after he install for the user dbs. There are (too?) many options in this installer that were simply not available pre-2008. Rockin'

So, there's some links and my take on a few pieces.

Fries and a shake to MS for not slipping the date to Q4!

Kevin3NF