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.

Live Blog: PASS Summit–WIT Luncheon

WIT – Women In Technology 10 anniversary PASS Summit Luncheon

Please go to this link for more info on the speakers and content. I am blogging and tweeting from this luncheon to help with exposure of the message and to learn more myself.

Louisiana has a WIT community - http://www.la-wit.org/ Read more

0 comments, 412 reads

Posted in The Smiling DBA on 8 November 2012

PASS Summit 2012–Thursday morning

Using SSIS 2012 for ETL in a Data Warehouse

Well, I feel great relief that my session has been completed, and completed successfully. The room was full with people on the floor and along the walls. That was great considering Peter Meyers and Devin Knight had done similar sessions 2… Read more

0 comments, 307 reads

Posted in The Smiling DBA on 8 November 2012

PASS Summit 2012–Day 1

Morning

Could not sleep past 4:30AM this morning, daylight savings time and 2 time zone changes did not help. So, exercise now in the morning and off to Summit for 7:30AM.

Meet 2 new Summit attendees in the elevator from Los Angles working for Stamps.com. They were both developers of… Read more

0 comments, 271 reads

Posted in The Smiling DBA on 5 November 2012

PASS Summit 2012–My Schedule

Using SSIS 2012 for Data Warehouse ETL

I have been fortunate to be selected this year to speak at the PASS Summit 2012 in Seattle. This presentation will go mainly over 3 new features: The Change Data Capture and DQS controls as well as deploying SSIS projects/packages to the… Read more

0 comments, 502 reads

Posted in The Smiling DBA on 1 November 2012

When a Covering Index no longer covers

I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about an error: Deadlock. Searching the SQL Log, I was able to get the details of the deadlocking. We have Trace Flags 1204 and 1222 turned on which provides the details.… Read more

2 comments, 1,227 reads

Posted in The Smiling DBA on 14 October 2012

Part II - Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server…continued

The PASS Data Architecture Virtual Chapter will host part II of Designing for Common Problems in SQL Server by Dr. SQL Louis Davidson as he helps application and database developers design and implement SQL Server databases.

I saw Louis at the first PASS Summit I attended in Denver in 2006.… Read more

0 comments, 296 reads

Posted in The Smiling DBA on 9 October 2012

24 Hours of PASS: Hosting Rod Colledge–BI in Sharepoint

The Virtual Chapters of PASS are asked to host sessions during this Fall’s 24 Hours of PASS preview for the PASS Summit in Seattle, WA Nov 5th-9th. The Data Architecture VC gets to host Rod presenting on BI Architecture With SQL 2012 & SharePoint 2010. This is a good… Read more

0 comments, 524 reads

Posted in The Smiling DBA on 18 September 2012

Lookup transformation in SSIS: Performance Improvements

There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting the surrogate key for a fact table. I hope to introduce here a third.

The first is the caching option.

 

The Full Cache option will cache the whole table… Read more

0 comments, 1,578 reads

Posted in The Smiling DBA on 28 August 2012

PASS Virtual Chapter August presentations

If you do not know by now, PASS has many virtual chapters that give free webcasts all month long. I have helped chair the Data Architecture VC for the past year or so, started by volunteering  with the Performance VC for about 6 months and have done presentations on the… Read more

0 comments, 430 reads

Posted in The Smiling DBA on 19 August 2012

Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server

The PASS Data Architecture Virtual Chapter hosts none other than Dr. SQL Louis Davidson as he helps application and database developers design and implement SQL Server databases.

I saw Louis at the first PASS Summit I attended in Denver in 2006. He and Paul Nielsen help me see where data… Read more

0 comments, 660 reads

Posted in The Smiling DBA on 10 August 2012

SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint

This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing and Bill Waters. Sharepoint sessions are great for those in the BI field using Microsoft BI stack managing PerformancePoint and PowerView/SSRS integration or SQL Server DBAs having a… Read more

2 comments, 524 reads

Posted in The Smiling DBA on 28 July 2012

PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?

I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my top 3 sessions last year at the Summit. He has an excellent way of using visuals to explain things. The session for the PASS Data Architecture VC on Thursday (July… Read more

0 comments, 438 reads

Posted in The Smiling DBA on 22 July 2012

SQL Saturday #150 and TechDay Baton Rouge–BI 1 track

The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks this year. This blog will be about the speakers from first track.

The full schedule can be found here.

 
8:20AM - Introduction to SSIS with a Real-World Example

Read more

2 comments, 489 reads

Posted in The Smiling DBA on 19 July 2012

PASS BI/DW presents Dimensional Modeling 101–by me…

With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach to Data Warehousing. The PASS DW/BI Virtual Chapter has graciously allowed me to present on Dimensional Modeling. I am not an expert, so this is an introduction to what… Read more

0 comments, 487 reads

Posted in The Smiling DBA on 16 July 2012

I’m Speaking: PASS Summit 2012 and more…

Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of July and August 2012. My local brother from a different mother, Patrick LeBlanc, hosted a SQLLunch for me as I demonstrated the new CDC controls in SSIS 2012. Patrick’s… Read more

0 comments, 381 reads

Posted in The Smiling DBA on 12 July 2012

Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered the new business building for out event.

This blog continues the series of blogs over the next few weeks to spotlight the tracks for this FREE event. Of course, nothing… Read more

0 comments, 552 reads

Posted in The Smiling DBA on 10 July 2012

Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got the ball rolling 4 years ago and now a team of IT professionals from Baton Rouge have continued the effort.

This blog starts a series of blogs over the next… Read more

0 comments, 592 reads

Posted in The Smiling DBA on 8 July 2012

MAXDOP and Cost Threshold for Parallelism – an example for a parallel query

The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no comments, so I am not even sure if it was helpful to anyone, but me.

This post will be an example of a query from the AdventureWorks database that… Read more

6 comments, 982 reads

Posted in The Smiling DBA on 18 June 2012

PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint

Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity and Performance.

We will also be giving away an Amazon gift card plus someone gets a book - Itzik’s T-SQL Fundamentals.

If you would like to volunteer for this VC,… Read more

1 comments, 324 reads

Posted in The Smiling DBA on 14 June 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 Read more

0 comments, 316 reads

Posted in The Smiling DBA on 26 May 2012

Newer posts

Older posts