SharePoint 2010 and SQL Server 2008 R2
I am currently downloading SharePoint 2010 beta version and would probably take a week or two to install and play around it. One of the things on my mind is whether I would upgrade my current SQL Server 2005 to SQL Server 2008.
Going through some readings I found the following posts helpful:
SharePoint 2010 Better Together with SQL 2008 R2 Database Enhancements Top 10 (SharePointJoel)
Top 10 SQL 2008 Features for SharePoint IT Pros (Joel @ MSDN)
High Availability Improvements in SharePoint 2010 (SharePoint MadScientist)
Top 10 Features of SQL 2008 R2 (Database Journal)
SQL and Storage Considerations for SharePoint 2010 (SharePoint MadScientist)
SQL Server 2008 and SharePoint 2010 is a very powerful combination where most of the improvements are around infrastructure, & administration. At a developer level, blob, external lists, & PowerPivot are great additions. My interest on installing SharePoint 2010 is learning its architecture and development and as such I am more likely to upgrade my SQL Server 2005 VMWare to SQL Server 2008.
