Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Smiling DBA

Thomas LeBlanc ( MCITP 2005/2008 & MCDBA 2000) is a Senior SQL Server DBA at Turner Industries, LLC in Baton Rouge, LA. He has been in the IT field for 21 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, upgrading to Visual Basic versions 3-6 and even some .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 9 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Performance tuning and reviewing database design and code was an everyday occurrence for DBAs at Amedisys. Thomas’ free time is spent helping those less fortunate and improving his relationship with his family and God.

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.

image

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.

image

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.

image

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!!!

Comments

Leave a comment on the original post [thesmilingdba.blogspot.com, opens in a new window]

Loading comments...