Clinic 7045: What's New in Microsoft® SQL Server™ 2008
While I was over at Arlindo's Blog for VRMCplus, I couldn't resist clicking SQL Server 2008 in his tag-cloud. Next I grabbed my passport (euh LiveID) and headed to the 1.5 to 2 hour eLearning module (content will be available on your LiveID for a year).
Little topic overview:
- A lot on Database Engine and SSRS, less on SSIS and SSAS.
- FILESTREAM and spatial datatypes, as well as the other datatype enhancements/additions.
- Mentioning the new management capabilities and how this fits in with MS-initiatives like DSI.
- Mentioning the development features and integration (think ORM, EDM and LINQ).
- New to me (hadn't noticed it before); Security Auditing for Data Protection. This will be quite useful when you can't (due to vendor support restrictions) implement auditing based on altered table definitions, check constraints and triggers. Or now don't want with SQL2k8 because it will be faster to implement ;).
- Improved integrations with Office 2007 (and SharePoint).