SQL Server 2012 Product Guide

Just released a new SQL Server 2012 Product Guide ready to download.


connect PowerPivot to an Oracle database

Not very well documented on how to connect PowerPivot to an Oracle database. You need the Oracle client installed and the TNS names configured. In PowerPivot the server name to connect to the Oracle instance is host:port/service_name. If port number is already in TNS names you should be good. Other little gotcha was be sure…


Reporting Services 2012 and Dashboard Designer

Alot of confusion on how to integrate the new SharePoint integrated mode of Reporting Services 2012 into your Performance Point Dashboards. If Reporting Services is configured to use Trusted Account authentication in SharePoint Server, then the server name typically takes the form http://servername/_vti_bin/reportserver. more info here