Relational databases, SQL databases are wild beasts that need to be gently tamed. We cannot use them like dumb data stores. There are rules. Instead of stating good practices out of the blue, this session is addressing the problem differently. Let's list very common implementation and SQL code antipatterns, which you are guaranteed to have at some level in your company, and see, practically, how to solve them. This session is based on real-world experience I have acquired by auditing clients SQL Server databases in ten years of independant practice.
(no tags)
The video is not available to view online.