Microsoft SQL Server 2008 improved data security, scalability, and management with features like Transparent Data Encryption (TDE), policy-based management, and support for spatial data. It enhanced high-availability capabilities with database mirroring and introduced the FILESTREAM storage option for unstructured data.