10th Annual Orlando Code Camp

Today’s event is the 10th Annual Orlando Code Camp conference. I’ll be speaking on Introduction to SQL Server Performance Tuning.

For those that are interested I’ve included a link to the PDF that details the performance tuning methodology as well as the slide deck.


SQL Saturday 232 – Orlando

Attached are the presentation files for Maintaining Indexes with SQL Server that I’ll be presenting at SQL Saturday Orlando this year. It’s the same presentation that I did in Jacksonville which seemed to be well-received. Feel free to get in contact with me if you have any questions.

SQL Saturday 215 – Jacksonville

This is my third year attending the Jacksonville SQL Saturday but this will be my first year there as a presenter. There’s a lot of talented database professionals in Jacksonville and I’m honored to have this opportunity. The topic I’ll be covering is Maintaining Indexes. It’s an entry-level topic and my first time presenting it, so it should be interesting to see how people react to it. SQL Saturday 215 will be on April 27th.

Orlando Code Camp 2013

I’ve been selected to speak at Orlando Code camp on March 16th. Again I’ll be covering the topic of Automating Processes with SSIS. I had a great time last year at Code Camp and I’m really looking forward to presenting again this year. I’m hoping this topic in particular can be something that .NET developers might be interested in leveraging.

SSIS, Excel, and 64-bit… getting them to play together.

Okay, I’ll admit that this post is a bit of a cop-out but if you landed here then you’re most likely having some troubles getting SSIS and Excel working correctly with some error regarding the usage of 64-bit drivers. Rather than going through each of the possible solutions, I’ll refer you to another blog that has links to several other blogs with several solutions. Each solution is different depending on your environment and your needs. In general, I try to avoid using Excel at all with SSIS and prefer to use CSV’s. Most business users can be convinced to save their data as CSV and it’s much more friendly for SSIS to process. It also removes all kinds of funky formatting that users love to throw in spreadsheets.