About James Serra
I am a Data Warehouse/Business Intelligence Architect, specializing in the SQL Server BI stack. I also am a DBA and have been for the last 15 years. I work for B.I. Voyage.-
Recent Posts
- Being careful in SSAS to not make a cube/dimension unprocessed
- Data Warehouse vs Data Mart
- Fast Track Data Warehouse Reference Guide for SQL Server 2012
- SSAS File System Error
- SQLSaturday in Houston Presentation
- SQL Server 2012: Certification Upgrade Info
- SQLSaturday in Houston
- SSDT – Installation confusion
- Consultants: Corp-to-Corp vs 1099
- SSAS development quick tip
Recent Comments
- Saso on SQL Server 2012: Installing on a Virtual Machine
- Kevin on SSDT – Installation confusion
- rike on Consultants: 1099 or W-2?
- Data Warehouse vs Data Mart | James Serra's Blog on SQL Server 2012: Multidimensional vs tabular
- James Serra on SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)
Archives
- May 2012 (3)
- April 2012 (10)
- March 2012 (15)
- February 2012 (14)
- January 2012 (13)
- December 2011 (12)
- November 2011 (12)
- October 2011 (14)
- September 2011 (14)
- August 2011 (15)
- July 2011 (15)
- June 2011 (20)
- May 2011 (13)
- April 2011 (3)
Categories
- Active Directory
- Antivirus
- Appliance
- BISM
- Blog
- Business Intelligence
- Career
- Certification
- Data warehouse
- DAX
- Dimensions
- DNS
- ETL
- Excel
- Fast Track
- Fuzzy Lookup
- Introduction
- KPI
- MDX
- Microsoft
- PASS
- PDW
- PerformancePoint
- Power View/Project Crescent
- PowerPivot
- Presentation
- ProClarity
- Project Apollo/Column-store indexes
- Quick Tip
- Report Builder
- Security
- Session
- SharePoint
- SQL Azure
- SQL Server
- SQL Server 2012
- SQLPASS
- SQLServerPedia Syndication
- SSAS
- SSDT/Juneau
- SSIS
- SSMS
- SSRS
- Team Foundation Server
- Tools
- Training
- Videos
- Virtualization
- Visio
- Visual Studio 2008
- Visual Studio 2010
- Visual Studio vNext
- White Paper
- Windows 8
Meta
Subscribe by email
Favorite Blogs
Rockstar Blogger
Category Archives: SSRS
BIDS Helper 1.6 for SQL Server 2012 released
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
SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode
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
Posted in SQL Server 2012, SQLServerPedia Syndication, SSRS
3 Comments
SQL Server 2012 (“Denali”): Details on the next version of SSRS
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
Posted in SQL Server 2012, SQLServerPedia Syndication, SSRS
Leave a comment
End-User Microsoft BI Tools – Clearing up the confusion
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
Complex reporting off a SSAS cube
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
Posted in Data warehouse, SQLServerPedia Syndication, SSAS, SSRS
8 Comments
BIDSHelper 1.5 for SSAS, SSIS, SSRS released
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
Posted in SQLServerPedia Syndication, SSAS, SSIS, SSRS, Tools, Visual Studio 2008
Leave a comment
Watch out, Visual Studio 2010 does not support BI
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
