IDUG NA 2026

The blessing of SQL is: when logically correct it will return an answer. Unfortunately, this is also the curse. Depending on how you write your SQL, you give the optimizer more or fewer choices .In this session we will go over understanding performance basics and common made SQL mistakes and the impact they have on the optimizer's choices.
Bring our application DBA's and developers to this session to train them and avoid common SQL performance pitfalls

Modern engineering teams move fast, but brittle tests, flaky mocks, and sluggish integration pipelines can slow even the strongest React + Node backends to a crawl. Database testing is often the first casualty—SQL tests get skipped because they require a persistent Db2 instance, complicating CI/CD and slowing development. This session presents a battle‑tested alternative: using SQLite as an ephemeral, SQL‑compatible stand‑in for Db2 to deliver fast, reliable, production‑like backend tests. You’ll learn how to spin up isolated in‑memory databases, seed realistic data, run true end‑to‑end API tests, and automate teardown without touching production infrastructure. We’ll cover schema alignment, SQL‑driven test design, and strategies for keeping tests blazing fast as your backend grows. If you want to test backend logic as it actually runs—not as mocks pretend it runs—this talk will give you the practical patterns and real‑world insights to elevate your testing strategy and ship with confidence.