•  

SQL Anti-Patterns

A session at SQLSaturday Cambridge 2015

  • Kennie Nybo Pontoppidan

Friday 11th September, 2015

8:30am to 5:30pm (GMT)

You can learn the basics of SQL in three days but it’ll take you 10 years to become good at it.

In this full training day we will take a look at a range of common design and coding mistakes to get an idea of the patterns and practices that absolutely do not work well for optimum performance, scale and design.

Anti-patterns are a way of naming these common design mistakes in order to make them easier to identify and remember (and correct!). Sooner or later as the demands on your database performance increase, so will the need to identify and resolve your anti-patterns.

During the day we will grow acquainted with anti-patterns on a physical level, a logical level, a SQL Query and application level, and spice it them up with some seriously foolish errors made by both myself, my colleagues and the industry at large!

Examples of SQL Anti patterns that we will address during the day will include:

ID required
31 flavors
index shotgun
Null is evil
…and many more!
There will be lots of interaction with the audience in an attempt to uncover the worst database design war stories as well as hearing about my numerous mistakes and experiences over the years!

You can expect to leave the class with a big bag of tricks of BAD database design ideas, illustrated with many examples from real projects in order that you can make a bad database good!

About the speaker

This person is speaking at this event.
Kennie Nybo Pontoppidan

CEO of Effektor

Sign in to add slides, notes or videos to this session

Tell your friends!

When

Time 8:30am5:30pm GMT

Date Fri 11th September 2015

Session Hash Tag

#sqlsatcambridge

Short URL

lanyrd.com/sdpbry

Official session page

sqlcambs.org.uk/precon5/

View the schedule

Share

See something wrong?

Report an issue with this session