-->
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.

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, 178 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, 170 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, 295 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, 270 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, 385 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, 290 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

1 comments, 311 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, 387 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,750 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, 342 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, 409 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

1 comments, 314 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, 313 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, 340 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, 318 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

Tuesday,January,31

Introduction to Oracle SQL and PL SQL

More Details

February, 2017

Wednesday,February,01

Linux OS Fundamentals for the SQL Admin

Read more

3 comments, 510 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,245 reads

Posted in The Smiling DBA on 14 January 2017

Query Data Store–SQL Server 2016

SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to do performance tuning on T-SQL queries. This new feature of SQL Server 2016 is contained within a database with configuration options for storage of history and query plans. The option… Read more

0 comments, 391 reads

Posted in The Smiling DBA on 27 December 2016

SQL Server 2016–Live Query Statistics

WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while the query runs. Never saw that coming. And even a bonus, you can use SQL Server 2016 Management Studio (SSMS) to watch queries run on versions 2014, 2012 and 2008… Read more

0 comments, 1,764 reads

Posted in The Smiling DBA on 10 November 2016

PASS Summit 2016 – Announcements

There have been different announcements for new and upcoming features in the Microsoft Data Technology ecosystem. The one today I am hearing about is Data Migration Assistant (DMA) tool v2.0 GA and Tech Preview of DEA – Data Experimentation Assistant. James Serra blogged about it here - http://www.jamesserra.com/archive/2016/10/pass-summit-announcements-dmadea/. The… Read more

0 comments, 1,123 reads

Posted in The Smiling DBA on 28 October 2016

Older posts