The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. The I-380 PASS Chapter was formed in 2009 to support SQL Server users in Cedar Rapids, Iowa City, and surrounding areas. We meet the second Tuesday of every month, and we're working hard to develop a vibrant and interactive SQL community for Eastern Iowa.

Meetings are always FREE and food is provided, typically pizza. Please register to help us know how much food to bring, but feel free to come even if you decide at the last minute and cannot register ahead of time. Details about the meeting can be found below.

If you have any questions, please contact Ed Leighton-Dick (ed@380pass.org).

Next Meeting

Tuesday,

July

11

Exploring Why UDFs & Nested Views Hinder the Query Optimizer

  • In-Person @ 415 12th Ave SE, Cedar Rapids, Iowa (map)
  • Tue, Jul 11 2017
    17:30 - 19:30 Central Daylight Time
  • Language: English

Dinner at 5:30p - Meeting at 6:00p

Please RSVP for this meeting using the survey to the right.

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 tool 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 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.

Announcements

Adding Image and Voice Intelligence to Your Apps
Thursday, May 4, 2017

David Giard from Microsoft will present: Adding Image and Voice Intelligence to Your Apps

Cognitive Services is a set of APIs that use the power of Machine Learning to enhance your application. Using these APIs, you can quickly add image recognition and analysis; facial recognition, speech recognition, text-to-speech capabilities, and many other features to your application.

In this presentation, you will learn about the capabilities of these APIs, how to test them, and how to call them via a REST web service and using some helpful .NET libraries.

 

Adding Image and Voice Intelligence to Your Apps
Thursday, May 4, 2017

David Giard from Microsoft will present: Adding Image and Voice Intelligence to Your Apps

Cognitive Services is a set of APIs that use the power of Machine Learning to enhance your application. Using these APIs, you can quickly add image recognition and analysis; facial recognition, speech recognition, text-to-speech capabilities, and many other features to your application.

In this presentation, you will learn about the capabilities of these APIs, how to test them, and how to call them via a REST web service and using some helpful .NET libraries.

 

Looking for session materials?
Thursday, July 16, 2015

Looking for session materials?  Check the Meeting Archive page!  We're uploading files we receive from speakers to each meeting's record.