Posts tagged ‘Presentations’

Less than 2 Weeks till SQLSaturday #48

SQLSaturday #48 is coming up in a few more days, but there is still time to register. There’s a great lineup of speakers, and you can can’t beat free for training.

I’ll be presenting 2 sessions on SSIS. If you are there, feel free to drop in.

2 Days to SQLSaturday #46

Only 2 days until SQLSaturday #46 – if you aren’t registered yet, there’s still time. $10 for lunch, lots of great speakers, and some really interesting presentations – what better to do on Saturday?

If you make it out, look me up. I’ve got two presentations, and when I’m not presenting, I’ll be hanging around the Varigence table.

Presenting at SQLSaturday #49 in Orlando, FL on October 16, 2010

I have a very busy schedule in October. As already mentioned, I’m presenting at SQLSaturday #48 in Columbia earlier in the month. I also have the privilege of presenting at the Orlando, FL SQLSaturday #49 on October 16th, 2010. Thanks to Andy Warren for squeezing me into a slot that opened up in the schedule.

I’ll be presenting a newly revised presentation on SQL Azure – Moving Data with SQL Azure and SSIS. The abstract is:

SQL Azure allows you to host your data in SQL Server in the cloud. That provides some big benefits in scalability and management. However, it leaves open the question, “How do you get your data into / out of the cloud?” At some point, you are going to need to move data to or from an on-premise store to SQL Azure. In this session, we’ll discuss the available options for this, including SSIS, the Sync Framework, and BCP. We’ll cover the pros and cons for each. We’ll drill into one of the options, SSIS, in detail, and review performance options and potential issues that you may encounter when doing this.

I’ve presented on SQL Azure in the past, focusing on how it could be leveraged for BI purposes. In this session, we’ll focus in on moving data in and out of SQL Azure, as that’s an area that’s changing pretty rapidly right now.

If you read the blog, please introduce yourself. I’ll be around all day, and I’m always happy to chat.

Thanks to the Raleigh Triangle SQL User Group

This is overdue (the aforementioned blog problems have delayed a lot of posts), but I wanted to say thanks to the Raleigh, NC TriPASS User Group for letting me present on August 17th, 2010. I talked about “Processing Flat Files with SSIS” and had a great audience, with lots of questions and participation. It was a great experience, and I thoroughly enjoyed it.

Presenting at SQLSaturday #48 in Columbia, SC on Oct. 2nd

I’m excited to be presenting at the upcoming SQLSaturday #48 in Columbia, SC on October 2, 2010. I get to give two presentations at this one:

  1. Creating Custom Components for SSIS – if you are interested in building your own custom components for SSIS, this is a good session to attend
  2. Processing Flat Files with SSIS – feeling confused and angry about the way SSIS handles your flat files? Join this group therapy session where you can learn some tips for making SSIS behave.

If you read the blog, please introduce yourself. I’ll be around all day, and I’m always happy to chat.

Presenting at SQLSaturday #46 in Raleigh September 18th, 2010

I’m very happy to be presenting at the upcoming SQLSaturday #46 in Raleigh, NC on September 18th, 2010. I’ll be presenting two sessions, one on Processing Flat Files with SSIS, and the other on Patterns for SSIS Configuration and Deployment.

I’d also like to mention that Varigence is one of the sponsors of this event, along with other a number of other impressive companies. It’s great that so many companies are willing to sponsor these local community events, and I know from helping with the SQLSaturday here in Charlotte that having willing sponsors makes setting up the event much easier. If you’d like to see a demo of Vivid, Mist, or Hadron, feel free to drop by our table at some point during the day.

If you are a reader of this blog, please introduce yourself. I’ll be around all day.

Speaking at the Carolina Code Camp

I’ll be presenting a couple of sessions at the Carolina Code Camp on Saturday, May 15th. This will be my second time presenting at the Carolina Code Camp, and I’m looking forward to it. Last time, I had great audience participation, and the event was well organized and fun.

I’ll be presenting on “Processing Flat Files with SSIS” at 8:45 AM and “Unit Testing SSIS Packages” at 12:30 PM. Looking forward to both – it should be fun.

If you are in the area, feel free to drop in – there is no charge for the Code Camp.

Presenting at the Triad Developers Guild

I’ll be presenting at the Triad Developers Guild on Tuesday. The presentation will be on Developing Custom Components for SSIS, a topic I’ve spoken on a few times before. Here’s the abstract:

“SSIS data flows are great tools for moving data. But what if you need to go beyond the out-of-the-box components provided with SSIS? John Welch will describe how custom components are a great way to encapsulate and reuse functionality for the data flow in SSIS. He will discuss what it takes to create and deploy custom components in SSIS, review the pros and cons of using custom components instead of scripts, and discuss some of the common challenges and issues with creating them.”

I’m looking forward to the presentation – it usually generates some good discussion, and I like talking about developing for SSIS. If you are in the area, please drop by.

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 great day – free SQL training from a lot of well-known, well-respected names, a number of our local community members, and some Microsoft people as well.

I’ll be presenting on Creating Custom Components for SSIS – a great way to extend the out-of-the-box functionality of Integration Services, and on Vulcan, an open source framework for modeling and generating portions of your BI solution.

We’re got a great set of sponsors, including SQL Sentry (thanks Peter and Greg for all the work and support for the event – without them, it wouldn’t be what it is today – and if you are using SSAS, you really should check out Performance Advisor for Analysis Services), and Microsoft, who’s providing access to their campus for the event, among other things. Quest, Confio, and Red Gate provide some great tools for administering and developing for SQL Server, Intellinet provides services for SQL Server, and CozyRoc provides a great set of SSIS tasks and components.

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 my SkyDrive.


Introduction to SSIS (SpeakerRate link)


Creating Custom Components for SSIS (SpeakerRate link)  (the sample component used in this presentation is on CodePlex in the Community Tasks and Components project.


Thanks again for attending, and if you have any follow up questions, please leave them in the comments.