Microsoft SQL Server 2008

Available for free on all servers.

Power. Speed. Transparent data encryption. Are you as excited about the new Microsoft SQL Server 2008 as we are? Offering the latest in advanced security measures, solid reliability, and ultimate scalability for your server, this update from Microsoft is one of the best things to hit the Beach since we installed that handy shark net.

Features

• Resource governor - Define limits and priorities for concurrent workloads and consistent performance
• Transparent data encryption - Enable encryption of a single database file or an entire database without having to change your application

With Microsoft SQL Server 2008 running on Windows 2008 operation system, databases are protected in a secure environment designed for maximum uptime.

• The addition of several new technologies prevent unauthorized connections to your database, enhancements to encryption, security auditing, and policy-based management
• External key management - Support for third-party key management and Hardware Security Mobile (HSM) products
• Declarative management framework - Manage one or more instances of SQL Server 2008
• Server group management - Manage server groups from one central location including multiple SQL Server 2008 instances
• Performance data collection - Get performance data on disk usage, server activity, and query statistics
• Backup compression* - Create and store backups using compression technology designed to save space and make restoring faster and more efficient
• Offers range and fuzzy searches for more advanced searching requirements

When you order Microsoft SQL Server 2008, ServerBeach will install the Standard or Enterprise version at no additional charge. And you can get Microsoft SQL Server 2008 in either 32-bit or 64-bit versions.

• SQL Express W/Tools
• The SQL Server Express database platform is based on SQL Server 2008. It is also a replacement for Microsoft Desktop Engine (MSDE). Integrated with Visual Studio, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, secure in storage, and fast to deploy
• SQL 2008 Web* - Develop dynamic, database driven websites with the Web version. Ideal for web hosts and websites that demand easier management tools with large-scale capabilities
• SQL 2008 Workgroup* - Run branch location databases for remote synchronization and advanced reporting
• SQL 2008 Standard - Provides built-in intelligence capabilities to run departmental applications
• SQL 2008 Enterprise - Provides unlimited virtualization and the highest levels of security, reliability, and scalability

Compare Microsoft SQL Server 2008 Editions

*Please note that SQL 2008 Web and Workgroup editions do not include SQL Server Integration Service (SSIS). As a result, when you create a maintenance plan to backup your database, it will appear as though it is set up properly, but it will not in fact backup the data. This is because both of these SQL editions require SSIS to function. For more details on a solution to this, please visit the Microsoft website.

Other Useful Links:

SQL Server Training & Certifications

SQL Tutorials