Finding That Bad Data Base Query and Making it Perform

Very few developers have any training in realtional data models, set theory, or structured query language and wonder why they database queries stink.  Some developers use poor data and query design that make it impossible for the database to efficiently do its jobs. Or they continually run into the N+1 problem or use and ORM that slows things down even more.  This session will cover how to find that rotten query using common, simple tools. Then you will learn to examine that query to determine why it is rotten (data architecture, indexing, etc.) and develop ways to improve performance.  Then you will see how to monitor prformance of your queries on an ongoing basis for ensure continued performance. If you use a relational database to store you data you need to in this session.