Monday, August 20, 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 the event on Saturday. Remember, the Saturday sessions are FREE!!!


image


As for the pre-conference Power BI event, there is a charge of $149. Please signup using this link.

Even though the deployed reports are going to be in SQL Server Power BI Reporting Services, there is still a lot of development in Power BI to assist anyone using the Desktop, Azure or On-Premises versions.

Wednesday, July 25, 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 go to resource for informative articles.

The first article is Why Use Analysis Service Tabular? This explains what I have seen in the field about SSAS.

The second article is about installing the components for using SSAS Tabular.

The third will build a model from the Wide World Imports DW database.


Hope you enjoy and help me with the uses for Analysis Services Tabular Models.

Sunday, June 24, 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 will be about Loops as well as Scans and Lookups. The conclusion will include the Query Store and my favorite: Live Query Statistics.

The presentation will last about 45 minutes.

https://register.gotowebinar.com/register/3340884064717649665

SNAGHTML4543ba4

Wednesday, April 18, 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.

image


The sessions are April 25th thru 26th, 2018. Register at this link.


image


I am probably going to watch my friend Samir talk about SQL Cross-Platform Tools


image


Also, chek out the schedule and see what works for you.


image

Wednesday, April 11, 2018

DBA Fundamentals–Tuesday 11 Central–Execution Plans

WHAT:       EXECUTION PLANS FOR BEGINNERS

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 get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

Thomas LeBlanc (Thomas-LeBlanc.com) is a Microsoft Data Platform MVP and Data Warehouse Architect in Baton Rouge, LA.    Today, he works with designing Dimensional Models in the financial area while using Integration (SSIS) and Analysis Services (SSAS) for development and SSRS & Power BI for reporting. Starting as a developer in COBOL while at LSU, he has been a developer, tester, project manager, team lead as well as a software trainer writing documentation for classes. Involvement in the SQL Server community includes speaking at SQLPASS.org Summits (2011-2017) and SQLSaturday since 2011 as well as a speaker at IT/Dev Connections (15,17) and Live! 360(2015-2017).  He is the past Chair of the PASS Excel Business Intelligence and Data Architecture Virtual Chapters and worked on the Nomination Committee for PASS Board of Directors for 2016 & 2017. Bing TheSmilingDBA for more information about Thomas.

Thomas.leblanc@cox.net

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 be presenting ‘SQL Server Execution Plans’ and Andy Parkenson will be doing a lighting round on Power BI (Witness the magic that is Power BI custom connectors!)


image