Saturday, May 26, 2012

SQL Saturday #132 Pensacola and Wheeling, WV PASS UG

I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.

June 9th is in the 4th annual SQL Saturday in Pensacola. Karla and Mark Holmes look like they have setup a great event for IT professionals. The schedule is posted here and registration here. There is even a Pre-con on Friday. I spoke last year for the first time in Pensacola, but the Baton Rouge community of IT speakers have been going for all four years.


The first session is Execution Plan Beyond Basics. I did this one at the local Baton Rouge SQL Server User Group about 3 months ago, and was not able to get through all the material because there are lots of questions. Especially, questions like ‘If that is a problem, how do you fix it.’ The usual answer is ‘It depends’. The end of the presentation has some suggested tools to help answer these questions: For indexing, the Database Tuning Advisor Wizard and Missing Index suggestions and for better analysis of the query plan, SQLSentry’s Plan Explorer, but nothing beats heads down analysis of the query and database design. I have removed about 3-4 examples, so it can be finished in an hour.


The second is a new session on ETL with SSIS 2012. I decided to limit this session to 3 new topics: Change Data Capture control(s), the DQS component and the SSIS Catalog.  There are too many new features to cover them all, so I decided to demo the ones I am using at work with new development. The CDC is really a neat feature, which changes the design of the ETL flow in development of incremental loads.

John Sterret, my favorite pirate, asked me to do a remote Execution Plan Basics session for the Wheeling PASS User Group on June 21st. This one is a beginner level query plan session to get a DBA or developer familiar with reading a plan and understanding why some iterators are used. It is not for DBA beginners, but for developers or DBAs that are having to start tuning queries.


Well, that is all for now, but July and August are looking promising for some more remote presentations and a SQL Saturday in Baton Rouge.

God Bless!!!

Thursday, May 17, 2012

SQL Saturday #150 and Tech Day

Baton Rouge’s annual tech event for the IT community is coming up August 4th on the beautiful campus of LSU. The event is blessed to have one of the state’s universities to help us put on a wonderful day of technology. The local user groups help with the Tech Day.


The call for speakers is open:

Patrick LeBlanc took the bull by the horns 4 years ago to start this event. That day had 200 attendees, followed by 400 in 2010 and 375 last year. I found this picture of Patrick from Tim Mitchell’s pic gallery from #SQLRally in Dallas last week

Here are some more enjoyable pictures from last year. Sorry Patrick :)

What I have found interesting about the group of volunteers, is that more and more are helping out and finding great value with the networking opportunities. Local consultant companies like Antares, Sparkhound, Preficient and Geocent have seen the value in participating in this event. National sponsors like Quest, Red Gate, K2, HP, Microsoft, Telerick, Confio, Idera and Fusion IO help with the funding and man booths.

The day is full of SQL Server goodies (4-5 tracks), but there are additional sessions for .Net Developers, SharePoint gurus, IT Architects and IT management levels.

We hope ya’ll all will join us on August 4th, 2012 as a speaker, attendee, volunteer or cheerleader and come pass a good time, yea cher!!!

Photo  Photo

You might even win prizes…

Photo   Photo

Ever session gave away at least one book based on the topic of the talk.

Monday, May 14, 2012

PASS Data Architecture VC presents Mike Fal: SQL Server Table Partitioning

Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was able to attend at SQL Saturday in Colorado Springs in January of this year.

We will also be giving away an Amazon gift card plus someone gets to choose between Itzik’s T-SQL book or Kalen Delaney’s 2008 Internals.

If you would like to volunteer for this VC, please email

Subject: Eating the Elephant: SQL Server Table Partitioning

Start Time: Thursday, May 17th, 2012 12:00 PM US Central Time (6:00 PM GMT)

End Time: Thursday, May 17th, 2012 1:00 PM US Central Time (7:00 PM GMT)

Presenter: Mike Fal

Live Meeting Link:

Eating The Elephant: SQL Server Table Partitioning

Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.

Mike Fal

Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience along with some brief excursions into Oracle and Netezza. He has worked in several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.

Contact URL:

Add to calendarAdd to calendar