April CASSUG Monthly Meeting #Networking @CASSUG_Albany

Our April meeting will again be online. NOTE: you MUST RSVP to this Meetup at https://www.meetup.com/Capital-Area-SQL-Server-User-Group/events/277383641/ to view the Zoom URL!

Our April guest speaker is Andy Yun!

Topic: How Intelligent Query Processing improves T-SQL performance

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019.

While IQP has benefits for both operational and development DBAs, this presentation will focus on T-SQL capabilities. We will explore how IQP impacts Table Variables, Scalar User Defined Functions, and Batch Mode for Rowstore.

When you leave, you’ll have a solid understanding of how SQL Server 2019 can improve your T-SQL code performance, potentially without a single code change!

Our online meeting schedule is as follows:

  • 6:00: General chat, discussion, and announcements
  • 6:30: Presentation

We usually wrap up between 7:30 PM and 8:00 PM.

Please RSVP to this Meetup using the above link, then use the online event URL to join (note: you MUST RSVP for the URL to be visible). We will send out a meeting password as we get closer to the event.

Thanks to our sponsor, Datto, for making this event possible!