Explore the top 10 mistakes that plague transactional databases in this 17-minute conference talk from SQLBits. Learn how these errors impact security, maintenance, and optimization while discovering easy-to-implement solutions. Join speakers Aaron Felton and Rae Ellingham as they humorously dissect common pitfalls and provide valuable insights. Delve into topics such as normalization, identity, hard deletes, columns, constraints, triggers, hierarchy IDs, indexes, curses, and dynamic SQL. Gain practical knowledge to enhance database management skills and avoid costly errors in transactional database design and implementation.
Overview
Syllabus
Introduction
What are transactional databases
Normalisation
Identity
Hard delete
Columns
constraints
triggers
hierarchy IDs
indexes
curses
Dynamic SQL
Summary
Taught by
SQLBits