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

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, 64 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, 98 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, 109 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

0 comments, 114 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

1 comments, 108 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

1 comments, 306 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,046 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, 210 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,561 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, 881 reads

Posted in The Smiling DBA on 28 October 2016

PASS Summit 2016-Thursday Part II

The second half of the day was spent talking with various speakers and attendees. I got into a great conversation about trying to mentor developers at work places about how to write good T-SQL. It was interesting to here how some developers (or DBAs) are not open to new ways… Read more

0 comments, 255 reads

Posted in The Smiling DBA on 28 October 2016

PASS Summit 2016-Thursday Part 1

Today’s keynote was by David Dewitt. He did an excellent job explaining the architecture behind various Cloud Data Warehouse offerings. It was nice to get an explanation of the behind the scenes node and disk usage.

  

One announcement that caught me off guard was next year’s Summit is Oct… Read more

0 comments, 173 reads

Posted in The Smiling DBA on 27 October 2016

PASS Summit 2016-Wednesday

As all Summits, the first Regular Session day in Seattle started with the Keynote. Well, really it starts with a great breakfast at the Seattle Convention Center, but I digressed. Microsoft released information about new features for its Microsoft Data Platforms. The Keynote provided Customer specific examples of some… Read more

0 comments, 217 reads

Posted in The Smiling DBA on 27 October 2016

PASS Summit 2016–Tuesday

For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera as an outgoing Idera Ace. The session include a 45 minute presentation for me on a Customer Use-Case. The second half of the day was spent in #SQLPASS Community… Read more

0 comments, 178 reads

Posted in The Smiling DBA on 25 October 2016

VOTE!!! PASS Board of Director Elections

It is voting season again, and there is a great group of individuals running for the Board of Directors of PASS. You can go to the Elections Page of the SQLPass.org site and review all the information about the elections. Logging into the site will enable you to vote.

As… Read more

0 comments, 169 reads

Posted in The Smiling DBA on 6 October 2016

Live! 360–Speaking at SQL Server Live Orlando 2016

If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different areas of IT (including SQL Server) with some of the great experts presenting sessions for 5 days. The sessions are on December 5th thru the 9th in Orlando, FL… Read more

2 comments, 375 reads

Posted in The Smiling DBA on 10 September 2016

Using a Lookup Component in SSIS for Surrogate Keys in a Fact table

There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to repeat for facts and dimensions. This might be because the consistency Dimensional Modeling suggests for the design of fact and dimension tables. The SSIS Lookup component…

Read more

0 comments, 2,231 reads

Posted in The Smiling DBA on 21 July 2016

PASS Summit 2016 – Connect, Share, Learn

Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th. But before I talk about this year’s event, join me in a trip down memory lane about my path to the PASS Summit. If not, skip to the…

Read more

1 comments, 283 reads

Posted in The Smiling DBA on 24 June 2016

Why use a Date Dimension Table in a Data Warehouse

In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time dimension. Since then, the Time dimension has actually been separate from the…

Read more

2 comments, 2,680 reads

Posted in The Smiling DBA on 29 May 2016

SQLSaturday Atlanta #521 May 19th & 20th 2016

SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more work and time, but to see someone who is interested in SQL Server as a career take time to learn on a Saturday, makes it all worth the effort. When… Read more

0 comments, 343 reads

Posted in The Smiling DBA on 23 April 2016

Older posts