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.

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, 396 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, 576 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

1 comments, 465 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, 386 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, 447 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, 385 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, 345 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, 489 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, 474 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, 858 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, 288 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, 264 reads

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

0 comments, 207 reads

Posted in The Smiling DBA on 17 May 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… Read more

1 comments, 232 reads

Posted in The Smiling DBA on 14 May 2012

SQL Saturday Houston #107 Recap

I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the past years that I should concentrate on 2 or 3 items to take from the training. The first was no matter what kind of T-SQL development is done through an… Read more

2 comments, 527 reads

Posted in The Smiling DBA on 27 April 2012

PASS Data Arch VC presents Mike Fal: Eating the Elephant: 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… Read more

0 comments, 214 reads

Posted in The Smiling DBA on 18 April 2012

SQL Saturday #107–Houston

Wow, blessed to speaker at another SQL Saturday in Houston #107. The first task of this weekend is Friday. Kalen Delaney will be doing a Pre-Con on SQL Server Query Plans: Tuning and Management which is sold-out. I pre-registered early whether I was going to be able to go… Read more

0 comments, 287 reads

Posted in The Smiling DBA on 9 April 2012

Execution Plans – Table, Clustered Index and Non-Clustered Index Scan

An important operator to understand in execution plans is a scan. A Scan can be good and bad, so understanding the difference between them is a basic skill needed by a DBA or developer that is going to do performance tuning.

The Table Scan means that a table does not… Read more

5 comments, 1,226 reads

Posted in The Smiling DBA on 2 April 2012

Execution Plans – Merge Join

The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.

There is an interesting Clustered Index in the Adventure Works database. The SaleOrderDetail table’s primary key is a combination of the SalesOrderID and SalesOrderDetailID, not just the identity field of the… Read more

0 comments, 702 reads

Posted in The Smiling DBA on 15 March 2012

Execution Plans – Nested Loop

The nested loop is a physical operator used to join 2 or more sets of data when the query optimizer believes this is the best plan for the query.

The following query can be run against the AdventureWorks database:

SELECT cust.CustomerID, soh.SalesOrderID
    FROM Sales.Customer cust
        INNER JOIN Sales.SalesOrderHeader… Read more

0 comments, 278 reads

Posted in The Smiling DBA on 9 March 2012

Newer posts

Older posts