Category Archives: Uncategorized

New Features for Visual Studio Team System 2008 Database Edition

Today I was creating a new project in Studio Team System 2008 Database Edition, and needed to import a SQL Server 2008 DB.  I went looking for a SQL Server 2008 template for Visual Studio… instead, I found the Microsoft® … Continue reading

Posted in Uncategorized | Comments Off on New Features for Visual Studio Team System 2008 Database Edition

SQL Load Generator Tool

A few weeks ago I spoke at PASS on using the Resource Governor in SQL Server 2008.  For my demo, I created a little application that could fire off multiple queries against SQL Server to simulate different users/applications.  This tool… … Continue reading

Posted in Uncategorized | Comments Off on SQL Load Generator Tool

SSIS Event Handlers

There was a question recently by a fellow MVP, who was wondering if the event handlers in SSIS were fired synchronously or asynchronously. The answer (which I double-checked with Matt Masson) is that they are synchronous. When events are fired … Continue reading

Posted in Uncategorized | Comments Off on SSIS Event Handlers

SQL Heroes Contest Winners

They announced the SQL Heroes contest winners at the PASS Summit keynote today. I’m very happy to say that both BIDSHelper and ssisUnit were in the top 5! BIDSHelper had a perfect score of 55 (the only perfect score), based … Continue reading

Posted in Uncategorized | Comments Off on SQL Heroes Contest Winners

Batch Destination and the Merge Destination

After I created the Batch Destination for my presentation at the MS BI Conference, I was talking with Matt Masson, who let me know that they’d been working on a MERGE Destination sample component, and would hopefully be releasing it … Continue reading

Posted in Uncategorized | Comments Off on Batch Destination and the Merge Destination

SSIS Tasks and Components

Todd McDermid (a frequent poster on the MSDN SSIS forums, and creator of the Kimball SCD component) and I have started a new project on CodePlex along with Todd McDermid, the SSIS Community Tasks and Components (ssisCTC) project. This project … Continue reading

Posted in Uncategorized | Comments Off on SSIS Tasks and Components

SQL Heroes Contest

David Reed, who manages the SQL Server community samples on CodePlex, has been running a SQL Heroes contest. It’s for open source applications that help improve the SQL Server experience. You can read more about it on the SQL Heroes … Continue reading

Posted in Uncategorized | Comments Off on SQL Heroes Contest

Troubleshooting Writeable Regions in PerformancePoint Plan

Only certain cells are considered “writeable” in a PPS Plan Excel form. A writeable region is a region where the user can enter data. Here is a checklist of reasons why a region that you expect to be writeable is … Continue reading

Posted in Uncategorized | Comments Off on Troubleshooting Writeable Regions in PerformancePoint Plan

Repeated Dimension Names in PerformancePoint Server Monitor & Analyze

A colleague came to me recently with a problem.  She was implementing a Dashboard in PPS M&A, and she was seeing some unexpected dimension names.  The behavior was specifically affecting her when she was creating a report using an Analytic … Continue reading

Posted in Uncategorized | Comments Off on Repeated Dimension Names in PerformancePoint Server Monitor & Analyze

Testing and Tuning an Internet Facing PerformancePoint M&A Dashboard

I’ve spent the past 15 months, off and on, working as the technical lead on a performance management project using PerformancePoint Server.  The project was to create a SharePoint Portal where users could view the performance of a school system.  … Continue reading

Posted in Uncategorized | Comments Off on Testing and Tuning an Internet Facing PerformancePoint M&A Dashboard