In SQL Server 2008, Microsoft offers increased spatial capabilities allowing customers and partners to consume, use and extend location-based data through spatial-enabled applications and build location-aware applications.
Resource Governor allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to end users.
Microsoft SQL Server 2008 offers security feature enhancements that help provide effective management of security feature configuration, strong authentication and access control, powerful encryption and key management capabilities, and enhanced auditing.
SQL Server 2008 allows users to easily build ad-hoc and author reports with any structure through Report Designer.





