Category Archives: Uncategorized

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

SQL Saturday #33 – Coming Up Next Weekend

The Charlotte SQL Saturday is coming up next weekend, March 6th. There is a great lineup of speakers presenting, and we are approaching capacity for the event, so get registered soon, if you haven’t already. It’s going to be a … Continue reading

Posted in Uncategorized | Comments Off on SQL Saturday #33 – Coming Up Next Weekend

Slides From the Columbia Code Camp

Thanks to everyone who made it out to the Columbia Code Camp this weekend, even with the sleet and snow in the area. I had a number of requests for the slides from my presentations, so I’ve uploaded them to … Continue reading

Posted in Uncategorized | Comments Off on Slides From the Columbia Code Camp

Slides From “Processing Flat Files with SSIS”

Thanks to the Columbia Enterprise Developer’s Guild for letting me present last night. The audience was great, and I got a lot of good questions. Several people asked if the samples could be made available, and I also had a … Continue reading

Posted in Uncategorized | Comments Off on Slides From “Processing Flat Files with SSIS”

A New Year and Upcoming Presentations

It’s a new year, and already a lot going on. The new job is going well, but keeping me extremely busy. I’ve got several upcoming presentations, and there’s a SQL Saturday event planned for Charlotte in March that I’m helping … Continue reading

Posted in Uncategorized | Comments Off on A New Year and Upcoming Presentations

Performance of Raw Files vs. Flat Files

It’s pretty well accepted that raw files in SSIS are a very fast means of getting data in and out of the pipeline. Jamie Thomson has referenced the use of raw files a number of times and Todd McDermid recently … Continue reading

Posted in Uncategorized | Comments Off on Performance of Raw Files vs. Flat Files

New Path, Same Focus

I’ve worked with Mariner for almost 12 years. It’s been a very good journey, with many great experiences. I’ve worked with a lot of great people, and delivered some really interesting BI solutions to clients in a number of industries. … Continue reading

Posted in Uncategorized | Comments Off on New Path, Same Focus

Sample Files for Introduction To Analysis Services 2008

We had good turnout at the Greenville, SC SSIG on Tuesday. If you attended, I hope you enjoyed the presentation. After the meeting, I promised several attendees that I would make the samples developed during the demo available, and here … Continue reading

Posted in Uncategorized | Comments Off on Sample Files for Introduction To Analysis Services 2008

Presenting At SSIG in Greenville, SC

I’ll be doing a presentation on Analysis Services at the SQL Server Innovators Guild in Greenville, SC on Tuesday, Dec. 1st. I’ll be delivering an introduction to SSAS, with lots of demos. If you are interested in attending, please register … Continue reading

Posted in Uncategorized | Comments Off on Presenting At SSIG in Greenville, SC

SSIS 101: Viewing Variable Values at Runtime

One of the common problems that beginners have with SSIS is debugging errors involving variables. One example of this occurs when a package uses a Foreach Loop container. These are often used to set a variable value differently for each … Continue reading

Posted in Uncategorized | Comments Off on SSIS 101: Viewing Variable Values at Runtime