Who are you?

You are a SQL developer, but when you handover your code to your senior, you sometimes might hear: “Don’t do this anymore, it’s a bad practice!”. If you want to learn more about those bad practices which I see are being used a lot, this session is for you!

How is this session going to help you?!

In this session you will learn about some of those "code smells". I will show you an example of the bad practice, explain why it should be avoided and give a possible solution for them. We are going to talk about: Functions in the WHERE clause, Implicit casting, SELECT * and some others. This knowledge will help you make your queries run faster, need less resources and therefore will make your DBA and users happy.