The Iowa Road Show - SentryOne Team Blog

The Iowa Road Show

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
http://eastiowa.pass.org/

I-380 PASS Chapterhttp://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
http://iowa.pass.org/

Iowa PASS Chapterhttp://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!

Comments ( 1 )

  • Scott R. says:

    Andy,

    These topics sound great. Thanks for your efforts.

    For those of us that can't attend in person (not local to Iowa), will you post materials that we can review offline (slide deck, demo scripts, recording, etc.)?

    Scott R.

Leave A Comment

Your email address will not be published.