SQL Server 2008 Notes Part-1: SQL Server Editions and Explanation

SQL Server 2008 Compact Edition: Free, embedded DB ideal for building stand-alone and occasionally connected apps for mobile devices, desktops and web clients on all Windows platforms

SQL Server 2008 Express Edition: Free and it is Integrated with Visual Studio. Ideal for non-professional developers and hobbyists.

SQL Server 2008 Web Edition: Low TCO option for web hosters and web sites that provide scalability and manageability capabilities for small to large scale web properties.

SQL Server 2008 Workgroup Edition: Ideal for branch location DB because it provides a reliable data management and reporting platform that includes secure, remote synchronization and management capabilities.

SQL Server 2008 Developer Edition: Includes all functionality of SQL Server 2008 Enterprise edition, but is licensed for use as a development and test system.

SQL Server 2008 Standard Edition: Designed for department-level applications. This is a complete data platform that provides ease of use and manageability.  Consider if you do not require the levels of scalability and performance offered by SQL Server 2008 Enterprise Edition.  Provides multi-instance support for 16 instances.

SQL Server 2008 Enterprise Edition: Most comprehensive version of SQL Server 2008 that is designed for high-level scalability and performance. Provides same functionality of SQL Server 2008 Standard edition and in addition

• Partitioning
• Data Compression
• Resource Governor
• 50 instances (25 instances on a failover cluster)
• Database Snapshots
• Hot-add memory and CPUs
• Mirrored Backups
• Backup Compression
• Transparent Data Encryption
• Fine-grained auditing
• Peer-to-Peer replication
• Distributed partition views
• Parallel index operations
• Change data capture
• Star join query optimization
• Data-driven subscriptions

SQL Server 2008 Notes Part-2: SQL Server 2008 Hardware and Software Requirements

Advertisement