I380 Corridor PASS Chapter

  Eastern Iowa's SQL Server User Group
  Cedar Rapids • Iowa City


Meeting Details




SQL Murder Mystery Hour: Living and Dying by Dynamic SQL

  • In-Person @ 201 S Clinton St, Iowa City, Iowa (map)
  • Tue, Oct 13 2015
    17:30 - 19:30 Central Daylight Time
  • Language: English

Featured Presentation:

SQL Murder Mystery Hour: Living and Dying by Dynamic SQL

Doug Lane SQL Theater

Ask any DBA if they want to manage dynamic SQL: "Impossible-to-read source code and SQL injection? No thanks!" they'll say. However, dynamic SQL not a tool of the desperate and unskilled. It is flexible and makes complex queries screaming fast when more conventional methods cannot. In this session, we focus on: * Understanding pros and cons of dynamic SQL * Writing fast and efficient dynamic SQL code * Monitoring dynamic SQL statements and their performance To spark discussion and keep the audience riveted, this session is styled as a technical presentation weaved into an interactive murder mystery, complete with suspects, interrogations, and clues. Attendees form small groups to observe, discuss, and ultimately solve the mystery of the deadly dynamic SQL. Developers and DBAs: if you want to become wise in the ways of dynamic SQL, this session is for you. Be sure to bring your sleuthing skills!

About Doug:
Doug Lane is the founder of SQL Theater, a company specializing in helping junior developers and public speakers. Doug has over 15 years' experience in IT and holds a Bachelor of Arts degree in Media Production. In addition to presenting at conferences, SQL Saturdays, and user group meetings, Doug also blogs and produces video training courses.

Back to Top