22-25 April 2026 
SQLBits 2024
Top 10 transactional database mistakes, and how to avoid them
In this session we’ll both laugh and cry over the top 10 mistakes that make security, maintenance, and optimisation of transactional databases a nightmare, as well as discuss how they could have been so easily avoided.
Design choices for transactional databases matter. Making poor decisions can affect the security and performance of the application, make maintenance a nightmare, and cause big problems when it comes to data warehousing and reporting. In this short session we’ll go through the top 10 transactional database mistakes seen by Red Olive’s data consultants, and how they could have been avoided.
Speakers
Aaron Felton's previous sessions
Pagination made easy
An introduction and demonstration of Power BI Report Builder in action. This session aims to unveil the mysteries of pagination and explains why, sometimes, pagination is better.
Top 10 transactional database mistakes, and how to avoid them
In this session we’ll both laugh and cry over the top 10 mistakes that make security, maintenance, and optimisation of transactional databases a nightmare, as well as discuss how they could have been so easily avoided.
Rae Ellingham
red-olive.co.uk/news
Rae Ellingham's previous sessions
Pagination made easy
An introduction and demonstration of Power BI Report Builder in action. This session aims to unveil the mysteries of pagination and explains why, sometimes, pagination is better.
Top 10 transactional database mistakes, and how to avoid them
In this session we’ll both laugh and cry over the top 10 mistakes that make security, maintenance, and optimisation of transactional databases a nightmare, as well as discuss how they could have been so easily avoided.