****This meeting will be 100% online — there will be no in person meetings at this time ****

**PLEASE READ** [Azure Tech Groups – Code of Conduct ](https://developer.microsoft.com/en-us/azure-tech-groups/code-of-conduct)
Connection Software: Microsoft Teams
The Des Moines chapter of the Iowa Data Professionals (IDPA) will meet the Monday before the 2nd Wednesday of the new month. The 2nd Wednesday of the new month is reserved by Quad City PASS.
**Meetup Organizers will start the Microsoft Teams meeting at 5:30 PM, Central Time (22:30 UTC), and will then admit attendees into the remote meeting.**
Please connect, eat your dinner and network with other data professionals until the meeting is called to order.
**At 5:50 PM Central Time (23:00 UTC) our Local Group Leader will call the meeting to order with brief announcements.**
**At 6:00 PM Central Time (23:00 UTC) we will introduce the featured speaker.**
**Session Title: Memory-Optimized Data Structures in SQL Server**

**Session Description:**

With each version of SQL Server, more features become available that allow for data or metadata to reside in memory. These improvements can greatly reduce contention, improve query performance, and reduce the computational overhead of frequently executed T-SQL.
This session discusses different features that allow for the use of memory-optimized data and the ideal use-cases for each. Topics include:
• Memory-optimized tables
• Natively-compiled stored procedures
• Memory-optimized TempDB metadata
• Memory-optimized table variables
• Memory-optimized table-valued parameters
• Data durability
• And more!

Effective use of memory-optimized data structures can greatly reduce locking, latching, blocking, and other common hallmarks of OLTP contention. This session will help you take control of your most critical and time-sensitive transactional processes by taking full advantage of memory-optimized data in SQL Server!

These tools have very specific use-cases and the goal of this session is to thoroughly describe those use-cases so that memory-optimized objects can be used for the ideal situations they were intended for.