The Iowa Road Show

Andy Yun

Published On: June 22, 2017

Categories: Community 1

While I've started a new chapter here at SentryOne, I fully intend to continue giving back to the community. Next month, I'll be heading out to present at a few user group meetings in Iowa:

 

Tuesday, July 11

I-380 PASS Chapter

I-380 PASS Chapter - http://eastiowa.pass.org/

Title:

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

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 tool that will aid you in unraveling nested code.

RSVP →

 

Wednesday, July 12

Quad Cities PASS Chapter (QCPASS)

Quad Cities PASS Chapter (QCPASS) - http://qcpass.pass.org/

Title:

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

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 tool that will aid you in unraveling nested code.

RSVP →

 

Thursday, July 13

Iowa PASS Chapter

Iowa PASS Chapter - http://iowa.pass.org/

Title:

T-SQL Tips & Tricks to Make Your Life Easier

Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you.

This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges. This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!

RSVP →

 

For all of you in the area, I hope you stop by to say hi at one of these sessions!

Andy Yun is a SentryOne Senior Solutions Engineer and a Microsoft MVP. He has been working with SQL Server for 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.


Comments