Configure and manage SQL Server availability groups for SharePoint ServerThere has been a lot of interest in using SQL Server 2012 with SharePoint 2010. Below are some official Microsoft documents that outline general requirements and feature support.
In a previous post I mentioned that service pack 1 for SharePoint 2010 is required in order to install SharePoint 2010 with SQL 2012. Specifically you need service pack 1 if you are going to use the SQL Server 2012 engine for the SharePoint content databases or catalog databases. The service pack is also required if you want to use PowerPivot or the PowerPivot configuration tool.
The knowledgebase article 2460045 describes what is included in SharePoint Server 2010 Service Pack 1. One specific bullet point under improvements states “Support for Microsoft SQL Server 2012.”
Update 04/24/2012: I ran across this great video showing a demonstration of SQL 2012 AlwaysOn capability with SharePoint 2010. A new TechNet article has also been published on how to Configure and manage SQL Server availability groups for SharePoint Server.