Welcome

The Madison SQL Server Users Group (MADPASS) is an official chapter of the Professional Association for SQL Server. We are here to support the SQL Server users in the Madison, WI area. We plan to meet on the third Wednesday of every month.

Meetings are always FREE and food is provided. Details about the next meeting can be found below.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session. Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 5:45 - General Q&A session & Announcements
5:45 - 6:15 - Food &Networking
6:15 - 7:30 - Main Presentation
7:30 -7:45 - Q&A Session / Door Prizes / Wrap-up

 

Meeting Location Provided By:
Talavant

Next Meeting

Wednesday,

March

20

March MADPASS meeting | Exploring why UDFs & nested views hinder the query optimizer

  • In-Person @ 5510 Nobel Drive Fitchburg, Wisconsin, United States (map)
  • Online @ None
  • 17:45 - 20:15 Central Daylight Time

Monthly chapter meeting

Featured Presentation:

Exploring why UDFs & nested views hinder the query optimizer

Andy Yun, Senior Solutions Engineer SentryOne

Ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions & views? Did you know that object-oriented code reuse can significantly hinder the Query Optimizer? In this session, learn how T-SQL is not like other common programming languages. We will deep dive inside the Query Optimizer to understand why applying object-oriented principles can be detrimental to your T-SQL's performance. Extensive demos will not only explore solutions to maximize performance, you will also be introduced to a T-SQL tol that will aid you in unraveling nested code.

About Andy:
Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for over 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.

Connect with us!

 

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

Office 365 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids