Präsentation von @Tom Bascom (White Star Software LLC)​ im Rahmen der Jahreshauptversammlung der PUG Deutschland am 14. Mai 2025:

When Your Code Becomes the Culprit

Understanding The Database Problems That Code Causes

Tom Bascom, White Star Software

Some database problems are out of your control—corruption, lost connectivity, natural disasters, or the occasional mysterious Error 49. But many of the headaches that DBAs and developers face are rooted in the code. This session explores the common (and not-so-common) database problems that originate in application code. We’ll look at performance killers like poor WHERE clauses and inefficient algorithms, dive into issues with record locking and transaction scope that leave users "hung," and explore how sloppy external integration can cripple your system. We’ll also cover how your code may be quietly consuming more resources than you think, causing disk, memory, and network constraints. And yes, we’ll even explain why your absurd SQL width isn’t a bug—it’s a feature. Come away with practical tips and real-world examples to help you write cleaner, faster, and safer database code.