SQL Clone
SQLServerCentral is supported by Redgate
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.

PASS Summit 2018 – Call for Speakers

It is that time again. PASS has opened the Call for Speakers. I have submitted for the past 10 years, and have been selected the past 7 years. This was such an important milestone in my career to be selected and then to present. Making sure I know what… Read more

0 comments, 124 reads

Posted in The Smiling DBA on 28 February 2018

Speaking at PASS.org Summit

For the last 7 years, I have been speaking at the PASS Summit. This event is usually in Seattle, but one year it was in Denver (did not speak at this one) and one year Charlotte, NC. It is hard to explain everything that goes on during that week… Read more

2 comments, 149 reads

Posted in The Smiling DBA on 8 February 2018

VSLive 2018 Austin, TX

VSLive events are nice conferences to get a wide range of topics from .Net to mobile development to the data platform. It looks like they have added some Hands-on Labs on Friday in addtion to the Workshops on Monday. Regular sessions are Tuesday thru Thursday. The hotel is in downtown… Read more

0 comments, 283 reads

Posted in The Smiling DBA on 1 February 2018

Resources from the PASS community this coming month

Even though it is December, I noticed a lot going on for FREE in the PASS Microsoft Data Technology community. The first interesting one is a PASS Marathon: Linux!!! Here is the link. Never thought I would see something like this related to PASS. But it is here, so… Read more

0 comments, 266 reads

Posted in The Smiling DBA on 30 November 2017

IT Dev Connections 2017

The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers. It was nice to sit with Grant, Andrew, Mindy, Kevin, Tim, Monica, Daniel and Meagan for dinner Monday night.

I attended… Read more

0 comments, 224 reads

Posted in The Smiling DBA on 25 October 2017

SSAS Tabular DirectQuery–No Hierarchies in Dimensions

I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server and analyzing in Excel, the hierarchies for the Date and Product dimension were not available. SQL Server 2016 SP1 was used in this example.

You can go to this like… Read more

0 comments, 394 reads

Posted in The Smiling DBA on 28 September 2017

Elect The Next PASS Board Members

The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates before you vote. Both tweeter events will be on Tuesday September 19th at noon central and 3PM central. The hashtag will be #PASSelections, so join the conversation and ask… Read more

0 comments, 323 reads

Posted in The Smiling DBA on 12 September 2017

Analysis Services Series on SQLShack

Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with Multidimensional Cubes as well as Tabular Models.

The start was a Best Practices article for Dimensional Modeling and other items that… Read more

3 comments, 444 reads

Posted in The Smiling DBA on 16 August 2017

SQLSaturday Baton Rouge #628 2017

Come join around 500+ attendees and speakers learning and networking at the LSU College of Business – Business Education Complex on Nicholson Drive Extension in Baton Rouge on Saturday July 29th 2017 8AM till 5PM. There will be plenty of MVPs and other experts in the areas of SQL Server,… Read more

0 comments, 336 reads

Posted in The Smiling DBA on 21 July 2017

PASS Board Elections

Well, it is almost that time of the year again. Elections for the PASS Board.

This is a great way to show your passion for this wonderful community of SQL Server or now, Microsoft Data Professionals. It looks like it is getting harder and harder for someone to come up… Read more

0 comments, 363 reads

Posted in The Smiling DBA on 19 June 2017

SQLSaturday Pensacola and Houston

I have the honor of being selected to speak in Pensacola and Houston this month. Pensacola has been a great place for SQLSaturday and it is no different than Houston. Both have active PASS community volunteers that love to host a learning event for free.

Both events have conference level… Read more

0 comments, 451 reads

Posted in The Smiling DBA on 1 June 2017

Power BI Report Server–Trial

I just installed the Power BI report server following @SQLDusty YouTube 13 minute Step-by-Step video. You have to download both the Power BI Report Server and a new Power BI Desktop. Once installed, it is easy to get your Power BI Report onto the Server if it is developed on… Read more

6 comments, 1,903 reads

Posted in The Smiling DBA on 18 May 2017

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov 3rd. Oct 30th and 31st are for pre-conference sessions (all day workshops) and this year there is no open call for these sessions. Not sure the selection process because it… Read more

0 comments, 403 reads

Posted in The Smiling DBA on 11 May 2017

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users


Thu, Apr 27 2017 20:00 GMT Daylight Time

Power BI Dashboard within an hour for Excel users

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

Power BI Dashboard within an hour for Excel users

If you are an experienced Excel user or Someone in your organisation mentioned about Power BI and you want to understand…

Read more

0 comments, 464 reads

Posted in The Smiling DBA on 22 April 2017

SQLShack Arcticle and Upcoming PASS Events

The latest article on SQLShack continues on the path of Data Warehouse development with SQL Server Analysis Services. The first step after designing the Data warehouse is conneting to the Data Source. All good DW implementations have a central database to store the data. Analysis Services is a great tool… Read more

0 comments, 357 reads

Posted in The Smiling DBA on 19 April 2017

SSIS Articles on SQLShack

Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package… Read more

0 comments, 359 reads

Posted in The Smiling DBA on 21 March 2017

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.

But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session… Read more

1 comments, 399 reads

Posted in The Smiling DBA on 17 March 2017

Upcoming PASS Events

There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me but marketing is something I am not into…yet!!!

The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what… Read more

0 comments, 367 reads

Posted in The Smiling DBA on 23 February 2017

Upcoming PASS Free Training

Here is a list of the upcoming PASS Virtual Groups and SQLSautrday Events.

January, 2017


Introduction to Oracle SQL and PL SQL

More Details

February, 2017


Linux OS Fundamentals for the SQL Admin

Read more

3 comments, 554 reads

Posted in The Smiling DBA on 27 January 2017

Upcoming SQL Server Events from PASS

There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see… Read more

0 comments, 1,290 reads

Posted in The Smiling DBA on 14 January 2017

Older posts