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.

SQLServerCentral SSAS Tabular Series: 5th Article Cleaning Up Dimensions

The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to understand how the article has progressed to this point.


Read more

0 comments, 133 reads

Posted in The Smiling DBA on 3 February 2019

Power BI World Tour–Dallas Nov 27-29

Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World Tour. There will be a one-day workshop on Tuesday and then regular sessions on Wednesday and Thursday.

I am planning to be there and will be presenting on Data… Read more

0 comments, 184 reads

Posted in The Smiling DBA on 20 November 2018

PASSITON discount code for PASS Summit 2018

This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is in addition to registration going up next by $200 gives $400 off if registered by Friday.

Also, everyone who registers by Friday will be entered into a daily prize draw Read more

0 comments, 183 reads

Posted in The Smiling DBA on 18 September 2018

PASS Summit 2018 – Scheduled Released

The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which were released a couple of months ago.

Wednesday thru Friday are 75 minutes, 3 hour and Lighting Rounds (4 15 minute sessions). The options available for going to PASS… Read more

0 comments, 216 reads

Posted in The Smiling DBA on 8 September 2018

SQLSaturday Orlando–Power BI On-Premises In A Day

Please join me for a day of developing and deploying Power BI reports in an On-Premises environment. This event is a pre-conference session on the Friday before SQLSaturday #801 in Orlando, FL. This is their 12th SQLSaturday and should be a good one. Here is the schedule of… Read more

0 comments, 231 reads

Posted in The Smiling DBA on 20 August 2018

SQLServerCentral.com Stairway Series–SSAS Tabular

The first 2 articles have been published on a SQLServerCentral.com Stairway series for SQL Server Analysis Tabular models. This is truely a blessing to be able to publish on SQLServerCentral.com. I have been reading this site everyday since I started working in SQL Server 7.0. It has been my… Read more

0 comments, 221 reads

Posted in The Smiling DBA on 25 July 2018

Idera Greek Sync: Performance Tuning with Execution Plans

On Wednesday July 11th, please join Idera Geek Sync at 11AM Central for a walk through some basics in Execution Plans. We will look at the history of execution plans and demonstrate how Microsoft has improved the tools to help DBAs find performance problems. The main body of the presentation… Read more

0 comments, 327 reads

Posted in The Smiling DBA on 24 June 2018

Embeded PowerBI

0 comments, 417 reads

Posted in The Smiling DBA on 26 April 2018

24 Hours of PASS – April 25th–26th

Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours session go on once an hour for 24 hours. This is free training usually on a certain topic. The topic this time around is Cross Platform SQL Server Management.

The… Read more

0 comments, 2,299 reads

Posted in The Smiling DBA on 18 April 2018

DBA Fundamentals–Tuesday 11 Central–Execution Plans


WHEN:       Tuesday,    04/17/18  - 11:00 am – 12:00 pm

WHO:         Thomas LeBlanc

WHERE:     https://attendee.gotowebinar.com/register/7086336336602188044

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to…

Read more

0 comments, 576 reads

Posted in The Smiling DBA on 11 April 2018

Baton Rouge SQL Server User Group – Execution Plans

Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the same place – La. Tech Park.

The 2 user groups have been holding meetings together for some time now.

I will… Read more

2 comments, 306 reads

Posted in The Smiling DBA on 11 April 2018

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, 471 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, 318 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, 462 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, 591 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, 373 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, 822 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, 492 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, 637 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, 514 reads

Posted in The Smiling DBA on 21 July 2017

Older posts