June .NET and SQL Server User Group (Tech Park Edition)

Location: Louisiana Tech Park

Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks (Note our earlier start time!!)
• 5:45 - 7:15: Presentations
• 7:30 - Until: Open forum for questions

Presentations:

Build an enterprise-ready application with no code using PowerApps - Mike Huguet

One of the most common bits of feedback that we hear from executives with customers and partners is that custom software is expensive to build and maintain and the timelines for delivering are more than they would like. In late 2016, Microsoft introduced an answer to this concern through a product now called PowerApps. Since then, we have combined the xRM capabilities from Dynamics 365 and have integrated features from Office, Flow, Power BI, and Azure to extend the platform’s capabilities. In this session we will cover an overview of PowerApps including developing an application connecting to a data source without code, devices supported, running the application, licensing, extensibility points, and discuss why PowerApps can replace fully custom applications.

Execution Plans in SQL Server 2017 - Thomas LeBlanc

After our Modern Migration Tour special event at 3pm (see below!) stay for more SQL Server insights! Performance Tuning starts with looking at a plan SQL Server internally uses to execute T-SQL. There are many parts to the plan as well as additional options for performance tuning. This session will provide real-world examples of T-SQL that can cause execution plans to not be optimal. The plan might also expose additions in the form of new indexes that can be added to improve performance. There are many paths to reading these plans that need to be discussed and probably you will hear 'it depends' in this session. Explanations of why it depends will be used with examples. Plus a look at Query Store in 2017.

Presenters:

Mike Huguet is a Senior Software Engineering Lead on the PowerApps product development team at Microsoft. He and his team focus on features and tooling that aid customers and partners in improving the quality of their PowerApps and customizations to their Common Data Services and Dynamics 365 CE solutions. Mike has been a software professional for over twenty years.

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups as well as SQLSaturday in Baton Rouge. Blog - TheSmilingDBA.BlogSpot.com and Thomas-LeBlanc.com

SQL Lagniappe:

Join us early on Wednesday for a special SQL Server event presented by PASS, the Modern Migration Tour 2019 - BATON ROUGE! With End of support for SQL Server 2008 around the corner (ends in July!), do you have a plan? https://www.eventbrite.com/e/modern-migration-tour-2019-baton-rouge-tickets-61600333255?internal_ref=login

Don't forget to register for SQLSaturday Baton Rouge!
https://www.sqlsaturday.com/867/eventhome.aspx

There are 2 incredible precons available this year. Both are a paid full day of training by industry experts.

Kubernetes: Zero to Hero by Anthony Nocentino
https://www.eventbrite.com/e/kubernetes-zero-to-hero-by-anthony-nocentino-tickets-61845012096

Performance Tuning and Optimization for Modern Workloads (SQL Server 2017, Azure SQL Database, and Managed Instance) with Tim Radney and David Pless
https://www.eventbrite.com/e/tim-radney-david-pless-present-performance-tuning-and-optimization-tickets-61843425350