Mike Burger

Done with Session 01 of the 24 PASS Webinar. This was by far the largest live meeting I have been a part of with over 450 users. I will not have time to write a complete review of all the webinars, however, I will add updates in this blog posts comments as I go along! […]

I am about ready to start my first of eleven meetings for the 24 hours of PASS webinars. I only have two webinars tonight with a break in between so I should have time to add updates as I go along. It will be a little more difficult to add updates as I go tomorrow […]

Starting tonight PASS (Professional Association for SQL Server) will begin broadcasting webcasts for 24 hours straight. These webcasts include many topics, however, I am most interested in those surrounding SQL Server Maintenance and Business Intelligence. As of now I plan on attending at least 11 of these sessions (more depending on my ability to keep […]

Introduction: In the scenario I am about to describe trusted accounts and domain accounts were used in order to allow Reporting Services to run in SharePoint Integrated mode. This was the initial installation of SSRS within the organization and needed to be done using trusted and domain accounts since SQL Server Reporting Services (SSRS) was […]

Introduction: There are a couple logical steps to take to troubleshoot any error or issue that arises while users attempt to access the SSRS reports from a report library in SharePoint integrated mode. If a user complains that a report does not properly render or that an error is given after clicking on a report […]

Introduction: It is sometimes inevitable that data within an SSIS package will need to be loaded from flat files. If you have ever had to develop with SSIS you know that it can be quite finicky with its data types. I have found that it is sometimes even worse when the data is coming from […]

Introduction: I was recently challenged with creating a reporting database off of a lot of source tables that had no timestamp associated to any of the records. In order to allow for historical analysis of the data, the solution was to create an SSIS package that took a snapshot of the data each quarter. However, […]

Introduction: The Business Intelligence team at PointBridge was recently sent the following email: Guys, How would we do these: 1. Display on one dashboard only the KPIs that are red (or Y or G) from an entire SharePoint site collection (SC) 2. Display on one dashboard all KPIs in a SC that if the current […]

I have recently been sharpening up on my SSRS skills and I have decided to take time to share what I feel are some valuable tips and tricks. This is a large list but can serve as a great resource to refresh your memory before starting any SSRS project. General Design Tips: 1. Always use […]

Overview: I had recently been tasked to perform my first installation of PerformancePoint Monitoring Server 2007 onto a Server Farm. Most of my experience to date had been using the SQL Server 2005 Business Intelligence suite (SSIS, SSAS, SSRS, and PerformancePoint), however, I had not yet had an opportunity to do much of the actual […]

Problem: I was recently tasked with creating an SSIS package to pull data from a 32-bit version of Windows Server 2003 with an installation of Oracle 9i Database into a 64-bit version of Windows Server 2003 with an installation of SQL Server 2005. On the surface this seemed like a simple task since SSIS has […]