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 Data Architecture VC presents Steve Simon–Challenges Designing Finance Data Warehouse

Steve Simon will join us on Thursday June 20th at noon central to help us understand some challenges with designing a financial data warehouse in the real world. Come chat with a SQL Server MCP and seasoned data warehouse architect to reflect on his many years experience in this industry. Read more

0 comments, 270 reads

Posted in The Smiling DBA on 16 June 2013

PASS Business Analytics VC presents Mark Tabladillo – Framework for Data Mining

Please join the Business Analytics Virtual Chapter as Mark Tabladillo talks about Best Practices for building a Framework for Data Mining. The GoToMeeting link for Noon Atlantic on June 13th is https://attendee.gotowebinar.com/register/7717448277059007488

More Information

June 13th BAVC Virtual Chapter Meeting

  • Online @ http://BAVC.sqlpass.org (map)
  • 12:00 - 13:00 (GMT-04:00) Atlantic Time…

Read more

0 comments, 192 reads

Posted in The Smiling DBA on 11 June 2013

SQLSaturday #220 Atlanta

From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5 or 6 sessions on each track. This will be the largest SQLSaturday event I have been a part of. It will be my first time at a SQLSaturday… Read more

1 comments, 243 reads

Posted in The Smiling DBA on 17 May 2013

PASS Data Arch VC presents Robert Davis–Case Study: Designing a Global Scale-Out Architecture

Thursday May 16th at noon central, we are going to be educated by MCM and past SQL Server MVP Robert Davis talking about “How to deliver a public-facing website on a global scale.” The online webcast is part of the monthly presentations by the PASS Data Architect Virtual Chapter which… Read more

0 comments, 210 reads

Posted in The Smiling DBA on 14 May 2013

SQLSaturday Atlanta #220–May 18th

I am pleased to be selected to present a session on Analysis Services at the Atlanta SQLSaturday this May 18th at Georgia State University. If you follow @SQLPass and #SQLSatAtl on twitter, you might have seen tweets about 775+ registered attendees for this event. You can still get on… Read more

2 comments, 182 reads

Posted in The Smiling DBA on 6 May 2013

SQLDiva reviews the First PASS Business Analytics Conference

Join Mellissa Demsak (twitter – SQLDiva) for a review of what she rates as the best from PASS’s first attempt at a Business Analytics conference. This session is hosted by the PASS Virtual Chapter for Business Analytics which was started by Mellissa.

May 02

May 2nd PASS BA VC Meeting

Read more

0 comments, 319 reads

Posted in The Smiling DBA on 29 April 2013

T-SQL Tuesday #41 – Presenting and Loving It

Some Tuesday mornings I have bacon with eggs and an English muffin. Not today though. I am blogging about Why I Love Presenting for T-SQL Tuesday #41 hosted by Bob Pusateri. I will attempt to answer all his questions.

What was the first time you gave a presentation in…

Read more

0 comments, 205 reads

Posted in The Smiling DBA on 9 April 2013

PASS Business Analytics presents MVP Jessica Moss: Putting the Business Into Business Analytics

I saw Jessica Moss presenting at the PASS Summit a couple of years ago on Reporting Services. She has been an author to many books and has a good series on SQLServerCentral.com’s Stairway series for Reporting Services.

Please join the PASS Business Analytics virtual chapter on April 4th at… Read more

0 comments, 268 reads

Posted in The Smiling DBA on 26 March 2013

PASS Data Arch VC presents Steve Hughes on Accounting for Windows Azure

I meet Steve this past November in Seattle at the PASS Summit. Reading his series on XMLA and Analysis Services help me understand more about SSAS. It was good to finally talk with this dude and get him to present to the Data Arch VC

His blog is Data on… Read more

0 comments, 292 reads

Posted in The Smiling DBA on 17 March 2013

Baton Rouge SQL Server User Group

Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge, LA. The topic will be Attributes and Hierarchies in Analysis Services 2012. The flow will be from requirements gathering thru implementation in the Semantic Model.

My employer, Turner Industries,… Read more

0 comments, 243 reads

Posted in The Smiling DBA on 3 March 2013

PASS Data Arch VC presents: Neil Hambly’s Think You Have The Right Data-Type?

Please join this Thursday Feb 24th 2013 at noon central for Confio SQL Server expert Neil Hambly talking SQL Server Data-Types. This seemingly simply feature is the heart of tables and data in SQL Server, so you do not want to miss Neil sharing implications of not knowing the details…

Read more

0 comments, 246 reads

Posted in The Smiling DBA on 24 February 2013

PASS Data Arch VC presents: Intro to Master Data Services by James Serra

Please join this Thursday Dec 20th 2012 at noon central for Business Intelligence expert/consultant James Serra talking Master Data Services. This new feature of the Microsoft BI stack is sure to help elevate your skills with data in SQL Server 2012.

Introduction to Microsoft’s Master Data Services (MDS) by James…

Read more

0 comments, 209 reads

Posted in The Smiling DBA on 16 December 2012

PASS Summit 2012 - Done!!!

Thursday afternoon

Thursday afternoon concluded with How to run SSRS in Sharepoint integration mode, Enriching Tabular with DAX and Monitoring SSAS. The best was the last.  Tim Peterson (SolidQ) shared his 12+ years working with SSAS to give us 3 ways to monitor SSAS – SQL Profiler, PerfMon and a… Read more

2 comments, 712 reads

Posted in The Smiling DBA on 13 November 2012

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, 374 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, 287 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, 246 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, 467 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,161 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, 269 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, 461 reads

Posted in The Smiling DBA on 18 September 2012

Newer posts

Older posts