As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many products it can be difficult to know the best products to use when building a solution. When it comes to … Continue reading →
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set of blogs covering the major announcements. Next up is the technical Preview for Power BI reports on-prem in SSRS. The … Continue reading →
I am happy to say I have published my first book! It is called Reporting with Microsoft SQL Server 2012 (order). Much thanks goes to my co-author and friend Bill Anton. Below is a brief overview or check out the … Continue reading →
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (cubed-based, which can be the multidimensional model or the tabular model). Note that any reporting tool that supports the … Continue reading →
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does not support SSAS, SSIS, or SSRS. Well, not anymore! Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading →
UPDATE 3/6/13: VS 2012 now supports BI! Check out Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does … Continue reading →
Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do not need to install IIS on the machine that you will install SSRS. This only applies when you configure it … Continue reading →
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT). Version 1.6 … Continue reading →
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took (see How to: Install and Configure SharePoint Integration on a Stand-alone Server): Install SQL Server 2008 and on the on the Feature … Continue reading →
SQL Server 2012 contains six new features for SSRS: Excel Renderer for Microsoft Excel 2003, 2007 & 2010 – Excel renderer will support the Excel 2007 XLSX format. To enable this feature, Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint must be … Continue reading →
Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a … Continue reading →
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice. Sometimes it is better to report off of the data warehouse that the cube is built from. For example, say … Continue reading →
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio. Version 1.5 can be downloaded here, and read up on the new features. It’s a must-have … Continue reading →
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010. So I copied … Continue reading →