Triangle SQL Server User Group

 
 
 

Do you have a question about SQL Server or the data platform space? Are you running into technical problems in the office and want a second opinion? Do you have an urge to stump our panel with arcane or weird scenarios--or watch others do just that to us? Then Shop Talk is for you.

Shop Talk is a Q&A-driven broadcast featuring Mala Mahadevan, Tracy Boggiano, Mike Chrestensen, and Kevin Feasel. Each week, we will dedicate one hour to answering your questions, including live questions with no prep (and I can't see how that could possibly go wrong!). Send questions to us on the air at https://www.twitch.tv/trianglessug or get them to us early by e-mailing [masked] and give us a fighting chance to come up with the right answer.

Prior episodes' show notes are available at https://shoptalk.tripass.org .

 
 
 

Abstract
Are you interested in learning about AI Insights that are in Power BI Desktop? In this session, I will briefly review the collection of pre-trained models. I will then focus on text analytics and its library of functions: language detection, sentiment analysis, and key phrases.

### Priscilla Camp

Business Intelligence and Analytics Specialist III
Priscilla Camp is a Business Intelligence and Analytics Specialist III at the University of Central Florida. She is a Microsoft Certified Data Analyst Associate, and the leader of the Orlando Power BI User Group. She has 10 years of experience in the field of IT working as a Business Intelligence Analyst. Priscilla started her career working for a startup small business in 2010 and several years later moved over to the Higher Education Industry where she currently resides. Priscilla’s focus is T-SQL, Data Warehousing, MS Power BI, and B.I. Strategy.

 
 
 

Azure SQL DB and SQL Server 2022 introduce yet more ground-breaking query performance enhancements under the Intelligent Query Processing family. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! In this session we will discuss the latest innovations in this space.

Speaker Bio
Pedro Lopes is a Principal Architect in the Azure Data team and has been working with SQL Server for over 20 years. He is currently the tech lead for all database engine features that ship in SQL Server 2022 and Azure SQL, while keeping a special focus on the Query Processor.
He blogs about all things SQL at http://aka.ms/sqlserverteam. Authored the book “Learn T-SQL Querying” (https://aka.ms/LearnTSQLQuerying), and several tools in the TigerToolbox on GitHub (http://aka.ms/TigerToolbox) and SQL-Server-Samples GitHub (http://aka.ms/SQLServerSamples). Including AdaptiveIndexDefrag (http://aka.ms/AID) for index and stats maintenance and the BPCheck script for SQL Best Practices and Performance checks (http://aka.ms/BPCheck)

 
 
 

In this session Tim will walk you through his productivity toolbox, the must have tips, tricks, and tools that make it possible for him to get his job done on a day to day basis as an analytics consultant. You'll learn ways to optimize SSMS, review and manage query performance and even a tip or two to make working with data in Excel less awful.

Speaker Bio:
Tim Costello is a data architect in the Dallas / Fort Worth area. His passion is moving data (with Biml and SSIS), designing structures to save data (with the agile data warehouse methodololgy), and sharing data (with Tableau). When he's not writing queries he loves riding his bicycle in local parks near his home