Tomorrow I’m anticipating an exciting event. SQL Saturday in Jacksonville. This year sounds like it will be real exciting as this particular SQL Saturday will have an entire track for Big Data, one that I intend on going to every session that I can.

I will be presenting on Detecting Data Changes in SQL Server which will cover essentially triggers, change tracking, rowversion, and Change Data Capture.

The scripts and slide deck for my session are also available for download.

Slides and demos are available for download: DetectingChanges. I’m very excited for tomorrow’s event. There’s going to be over 800 attendees. I believe this is the largest CodeCamp I’ve been to yet!

I’ll be presenting later today at South Orlando’s PASS chapter.

Below are links to all the files that I will be using in the presentation. The topic is “Dynamic SQL – Uses and Risks”. In the presentation, I will demo how to safely and correctly use Dynamic SQL as well as show some common pitfalls to avoid.

Running the scripts in the Setup folder will create the database and populate it with sample data.

Slide decks can be found here: Dynamic SQL – Uses and Risks.

SQL scripts can be found here: DynamicSQL.

The .NET application can be found here: EnrollmentQuery.

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.

I have my presentation files posted on the SQLSaturday site. You can download them here also via this link.

Click here to download the presentation for Automating Processes with SSIS. With it is a document that has steps that were taken.

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.

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.

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.

http://www.amosfivesix.com/sql/34-64-bit-sql-server-ssis-packages-with-excel-and-access-data

I’ve been selected as a speaker for SQL Saturday 192 in Tampa, FL. I’ll be presenting Automating Processes with SSIS for the first time. In this presentation we’ll take a real world example and use SSIS to automate tasks such as file copying, encryption, imports, and exports. This is a good demonstration of using SSIS’s expressions, variables, and scripts to achieve tasks.