SQL Server的十大Scrooge列表 - “Parar Express”版本

去年，我列出了我的第一个“SQL Server的十大克罗吉格列表”。在本赛季的精神，我开始考虑使用SQL Server 2008 Enterprise Edition的Microsoft收费的功能，该企业版真正应该包含在其他版本中。好吧，现在我知道比尔盖茨没有读我的博客，因为只有两个项目已被移开列表。Let’s take a look at last year’s list and how they stack up today with SQL Server 2008 R2… 1. Data Compression - still Enterprise :( 2. Data Driven Subscriptions - still Enterprise :( 3. Database Snapshots - still Enterprise :( 4. Backup Compression - now Standard Edition! :) 5. Transparent Data Encryption - still Enterprise :( 6. Peer to Peer Replication - still Enterprise :( 7. Distributed Partitioned Views - still Enterprise :( 8. Fuzzy Lookups in Integration Services - still Enterprise :( 9. Scale-Out Reporting Services - still Enterprise :( 10. Infinite Clickthrough in Report Builder - now Standard Edition! :) OK, in the spirit of the season, this year, instead of listing features in the higher editions that should be in the lower editions, I’ll list the features that are in the Express edition that we are lucky to have for FREE. Scrooge would certainly approve of the price if he were paying… Here’s my 2010 “Top Ten Scrooge List for SQL Server – Polar Express version” 1. An Express Database can be up to 10GB now (up from 4GB) 2. FILESTREAM Data is supported and does NOT count against the 10GB max 3. Database Mirroring Witness can be Express 4. SQL Server Import Export Wizard included 5. Change Tracking supported in Express 6. Column level Data Encryption included 7. Logon Triggers supported 8. Policy Based Management supported 9. Powershell support 10. Reporting Services in Express with Advanced Services edition (still FREE!) I guess the glass is half-full after all. Let’s be thankful for that this holiday season. Happy Holidays! Brian. PS Here's a nice festive B-Tree with a Heap of presents! http://xkcd.com/835/ (Thanks to my students at www.rim.com)