Blog
Difference between DateTime and SmallDateTime in SQL Server
In short, the dll hell problem is solved in .NET by signing the shared assemblies with strong name.
How .NET finds the assemblies during program execution
What is GAC. How and when to install an assembly into GAC
Strong naming of an assembly
ILDASM and ILASM
Joins in sql server
Window functions in SQL Server