SQL Server errors

Tutorials on how to avoid SQL Server common errors like objects that do not exists, or invalid names and arithmetic overflows when converting data from one data type to another one.