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

The Smiling DBA

Thomas LeBlanc is a Business Intelligence Consultant/Data Warehouse Architect in Baton Rouge, Louisiana. He uses his 25+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, PPS, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair of the Excel BI virtual chapter, past chair of the Data Architecture virtual chapter, and past virtual chapter mentor. He has helped the Baton Rouge SQL Server User Group with SQLSaturdays and speaks at local IT meetings.

5 Things to Know About Indexes for SQL Server

One of the first questions I got while interviewing for a potential position as a DBA was “If there is performance problem, where is the first place you would look?”

Now at this time, I was trying to move from Software Developer to DBA, and I answered that I would… Read more

0 comments, 5,318 reads

Posted in The Smiling DBA on 19 June 2014

SQLSaturday #308 Houston, TX Saturday May 10th

This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans and Multidimensional Analysis Services. These are 2 topics I deal with on a daily basis, so it is great I get to help others understand these technologies.

I also get… Read more

0 comments, 221 reads

Posted in The Smiling DBA on 7 May 2014

SQLSaturday #305 Business Analytics Edition Dallas–RECAP

So, I am flying home thinking about the event Saturday and many things are running through my head. No, not work on Monday. First, I would like to say that Hadoop is not going to replace SQL Server nor Business Intelligence. Second, a new thing is coming but it is… Read more

0 comments, 323 reads

Posted in The Smiling DBA on 5 May 2014

SQLSaturday #305 Dallas Business Analytics Edition

I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend including Eric Mezell’s An Introduction to Hadoop, Andy Egger’s Applied Predictive Analytics, David Browne on Enterprise Business Intelligence (for lunch) and… Read more

2 comments, 341 reads

Posted in The Smiling DBA on 23 April 2014

Call for Speakers – SQLSaturday #324 Baton Rouge

Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick LeBlanc back in 2009 with #17 http://sqlsaturday.com/17/eventhome.aspx and with help from local User Groups (William AssafSparkhound), it has expanded its topics and attendees. This event is… Read more

0 comments, 257 reads

Posted in The Smiling DBA on 11 April 2014

5 Tools Every DBA Should Know About

After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day for spot check views of a system. The order here is not a countdown from 5 to 1. They are presented here in no particular order, because each has its…

Read more

4 comments, 5,580 reads

Posted in The Smiling DBA on 25 March 2014

5 Things a developer should know about databases

 

Database Normalization

Theoretical versus real-world

There is not a strong need for developers to know the theoretical definition of 1st thru 5th normal form, but there needs to be an understanding of some design practices. The keys are:

  1. No Duplicate data in columns in one table
  2. Relationships built as…

Read more

9 comments, 4,801 reads

Posted in The Smiling DBA on 9 March 2014

Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks

Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and Tricks presented in 5 minute lectures.

DataArch.SQLPass.org

Next Meeting

Thu, Jan 30 2014 12:00 (GMT-06:00) Central Time (US & Canada)


RSVP: https://attendee.gotowebinar.com/register/2529334496189827586

This is a SQL presentation for the YouTube…

Read more

0 comments, 232 reads

Posted in The Smiling DBA on 28 January 2014

PASS BI/DW Virtual Chapter–Analysis Services Attributes and Hierarchies

Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in Analysis Services 2012. This is a presentation I have shown at 2 SQLSaturdays and the Baton Rouge SQL Server User Group as well as 24 Hours of PASS.

http://bi.sqlpass.org/

Next…

Read more

0 comments, 316 reads

Posted in The Smiling DBA on 15 January 2014

Jan 8th – Baton Rouge SQL Server User Group - Azure

Please join us tonight, Wednesday Jan 8th starting at 5:45PM with networking and food. The information below is from the BRSSUG Website: http://www.brssug.org/

January '14 Baton Rouge User Groups Meeting - Azure!

Topic: Microsoft Azure!

This is an all user groups on deck meeting! SQL, .net, SharePoint, IT Pro, La-WIT…

Read more

0 comments, 342 reads

Posted in The Smiling DBA on 8 January 2014

Data Architecture VC hosts Nigel Sammy: TSQL Tips and Tricks

Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips and Tricks for developers and DBAs.

Thu, Dec 19 2013 12:00 (GMT-06:00) Central Time (US & Canada)

Nigel Sammy - T-SQL: Tips and Tricks

RSVP: https://attendee.gotowebinar.com/register/5187602867480253442

Queries are running longer…

Read more

0 comments, 321 reads

Posted in The Smiling DBA on 18 December 2013

PASS Data Architecture VC presents Steve Simon–Challenges to Designing Financial Warehouses

Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look at Steve’s experience while implementing a financial data warehouse.

https://attendee.gotowebinar.com/register/3299406050712061698

Next Meeting

Thu, Nov 14 2013 12:00 (GMT-06:00) Central Time (US & Canada)


Challenges to designing financial warehouses

Summary:

In…

Read more

0 comments, 236 reads

Posted in The Smiling DBA on 11 November 2013

Summit 2013 Review!!! plus SQLSaturday #237 Charlotte BI Edition

The week is over and I waiting for my flight home. I did not to get to as many sessions as past summits, but that was replaced with speaking opportunities consisting of 1 half-day session, a 75 minute regular session and speaking at the Charlotte BI SQLSaturday.

Tuesday was a… Read more

0 comments, 376 reads

Posted in The Smiling DBA on 20 October 2013

My PASS Summit Schedule this Week

Well, it is here folks. The PASS Summit 2013. If you have never been to a PASS Summit, please look in to attending one year. There is more SQL Server Learning than you could fit in a month. You just need to break it down into digestible chunks.

Monday… Read more

0 comments, 225 reads

Posted in The Smiling DBA on 14 October 2013

Houston Tech Fest 2013

I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at the Reliant Center. The session in the first of the morning in the database track. SSIS 2012 has lots of new features, but this presentation focuses Change Data Capture component,… Read more

0 comments, 259 reads

Posted in The Smiling DBA on 25 September 2013

PASS Data Arch VC presents Louis Davidson Relational Database “Good Enough”

Please join us Thursday Sept 12th at noon Central for the monthly Data Architecture Virtual Chapter presentation. We will have SQL Server MVP talking about relational databases. Please don’t miss this session which is a preview to the Pre-Conference session Louis will be doing at the PASS Summit 2013 in… Read more

0 comments, 225 reads

Posted in The Smiling DBA on 10 September 2013

Baton Rouge SQLSaturday and Tech Day 2013

This will be the fifth SQLSaturday and Tech Day in Baton Rouge, LA on Saturday August 3rd, 2013.

I found a collection of SQLSaturday, SQLRally and PASS Summit shirts with various stickers collected over the last 5 or 6 years.

It is going to be hot this weekend in Baton… Read more

0 comments, 222 reads

Posted in The Smiling DBA on 1 August 2013

24 Hours of PASS: Preview to Slicing and Dicing Summit Session and more…

For 24 Hours of PASS 2013 Summit preview (#24HOP – twitter hash tag), I was asked to give a preview of the 1/2 day session on Slicing and Dicing in Analysis Serves 2012 for the upcoming PASS Summit 2013. My response: No Problem.

In Denver, it was the year… Read more

2 comments, 336 reads

Posted in The Smiling DBA on 12 July 2013

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, 348 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, 295 reads

Posted in The Smiling DBA on 11 June 2013

Newer posts

Older posts