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.
