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