Today, we’ve reached the next big milestone on the road to unlocking breakthrough insights across organizations with a cloud-ready information platform—we released Microsoft SQL Server 2012 RC0! You can find the installation media at the Microsoft.com Download Center. When you try it, don’t forget to also download the corresponding Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010 Release Candidate 0 (RC0).
There are many highlights and stunning BI features in SQL Server 2012. If you evaluated the previous SQL Server 2012 Community Technology Preview 3 (CTP3), you might already know that PowerPivot now supports hierarchies, multiple relationships between tables, a measure grid to easily create, edit, and manage measures and Key Performance Indicators (KPIs), new DAX functions (Time series, distinct count to name a few), and importing of binary large objects (BLOB). All of these features—and many more—are also available on the server in tabular Analysis Services databases, including row-level security, partitions and DirectQuery mode, enabling you to access the information directly from the source system. Substantial improvements can also be found in our SharePoint components. Among other things, we separated setup and configuration tasks, so it’s easy to install and uninstall, configure and re-apply configuration settings. All of these features are also in RC0. Moreover, Project “Crescent”—now called Power View—provides even more features than in CTP3 to create engaging visual experiences that are presentation ready at all times. Try it for yourself and perhaps also check out the SQL Server 2012 Customer Testimonials to see what others are saying about their SQL Server 2012 experience and the features they’re most excited about.
Installation prerequisites at a glance:
- SQL Server 2012 PowerPivot for Excel RC0 Install Visual Studio Tools for Office (VSTO) 4.0 runtime and .NET Framework 4.0 before you install PowerPivot. You can find the VSTO runtime at http://go.microsoft.com/fwlink/?LinkId=232657 and the .NET Framework 4.0 at http://go.microsoft.com/fwlink/?LinkId=232658. Also, if you are running Windows Vista or Windows Server 2008, install the Platform Update at http://go.microsoft.com/fwlink/?LinkId=186051.
- SQL Server 2012 PowerPivot for SharePoint RC0 Install Microsoft SharePoint Server 2010 Service Pack 1 (SP1) available at the Microsoft.com Download Center at http://www.microsoft.com/download/en/details.aspx?id=26623. You must fully patch the SharePoint farm before you add SQL Server 2012 RC0 features. No separate PowerPivot download required because the PowerPivot for SharePoint components are installed through SQL Server Setup. Run the PowerPivot Configuration Wizard after the installation to configure your farm.
- SQL Server 2012 Analysis Services RC0 Install .NET Framework 3.5 Service Pack 1 as well as .NET Framework 4.0 and Windows PowerShell 2.0. You also need an update for the .NET 3.5 SP1:
For additional information and known issues, check out the Microsoft SQL Server 2012 RC0 Release Notes and the PowerPivot for Excel Online Help. You can access additional articles, blogs, and other community content on the PowerPivot TechNet page. And, of course, you can also find more info on PowerPivot and Analysis Services features on this blog as well as on the Reporting Services team blog at http://blogs.msdn.com/b/sqlrsteamblog/.