Author Archives: ddarden

Demo Materials for PASS Session BIA-302 – Building a Supportable ETL Framework

Last week I presented the session “” at the PASS 2013 Summit. Here’s a link to the demo that I went through. BIA-301 – Demo Materials

Posted in Uncategorized | Comments Off on Demo Materials for PASS Session BIA-302 – Building a Supportable ETL Framework

Deploying a custom SSRS Assembly to the GAC

I briefly mentioned a technique I used to deploy custom assemblies for SSRS to the GAC in my PASS presentation on Building a Reporting Services Framework.  I didn’t spend a lot of time on that, but I did get some … Continue reading

Posted in How To | Tagged | Comments Off on Deploying a custom SSRS Assembly to the GAC

Demo Materials for PASS Session BIA-304–Building a Reporting Services Framework

I presented my session on ‘Building a Reporting Services Framework’ at the PASS Summit 2011 on Friday.  I had a great time at the summit, both presenting and attending all the great sessions.  A wonderful time was had by all. … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Demo Materials for PASS Session BIA-304–Building a Reporting Services Framework

Automatically Using the Latest Version of an SSRS Template

The ability to add Templates to SSRS (such as documented here and here and here) is a neat feature.  Basically, you just create an RDL and put it in the “C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesProjectItemsReportProject” directory… now you can … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Automatically Using the Latest Version of an SSRS Template

Using SSRS queries with parameters with Netezza

Our company has started using SQL Server Reporting Services 2008 R2 to handle most of our reporting against Netezza.  This works pretty well over all using the Netezza 6.0 OLE DB driver.  There are a few things to be aware … Continue reading

Posted in Uncategorized | Comments Off on Using SSRS queries with parameters with Netezza

Extracting MySql UTF-8 fields with SSIS

Last week I ran into an interesting task with SSIS.  I’m pulling data from a MySql database (5.0.79-enterprise) using the MySql ADO.Net Connector with SSIS and loading the data into a SQL Server 2008 R2 database.  This has worked pretty … Continue reading

Posted in Uncategorized | Comments Off on Extracting MySql UTF-8 fields with SSIS

Migration to Word Press

We recently migrated this site from Community Server to Word Press. Most of the posts came over pretty well, but some of the code samples and pictures didn’t make it. I’ll try and get these updated and fixed over the … Continue reading

Posted in Uncategorized | Comments Off on Migration to Word Press

Presenting ‘Enterprise Class Analysis Services Development’ at the Vancouver PASS Chapter

Hey Guys! I’m going to be giving a presentation on Enterprise Class Analysis Services Development at the Vancouver PASS Chapter Friday, March 12th.  http://vancouverbi.sqlpass.org/Home/tabid/1551/Default.aspx I’ll be talking about some of the topics I’ve blogged about here, including working with multiple … Continue reading

Posted in Uncategorized | Comments Off on Presenting ‘Enterprise Class Analysis Services Development’ at the Vancouver PASS Chapter

Using MSBuild with SQL Server Analysis Services Projects

I’ve written several blogs and community samples on working with SSAS Projects directly using AMO (instead of SSAS Databases on an Analysis Services server).  I was travelling this weekend, and got a chance to create a sample MSBuild task that … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Using MSBuild with SQL Server Analysis Services Projects

Validating SSAS Projects Programmatically

Earlier this week I got a feature request from someone someone that was looking in to my SsasHelper sample on the Microsoft SQL Server Community Samples:  Analysis Services site on CodePlex.  She was interested in Building a SQL Server Analysis … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Validating SSAS Projects Programmatically