Now I know what should be the best SQL Server version (SQL Server 2012) to be used for my project. I am still in doubt to use SQL Server 2014 that's why it's not in my list. It just released this year and I'm not yet sure if there are bugs. My project will be a web-based application which needs data storage including pictures and drawings from AutoCAD. Honestly, I haven't tried this kind of feature in
ASP.Net wherein there's a map and users can put some color coding on the space or drag some pins on it. Do you think it's achievable?
Yes, it is achievable. You will probably end up using FILETABLE for storing the drawings, and full-text indexing to search the drawings. But exactly HOW it is to be done, using WHICH features of SQL Server is a matter och system- and database architecture. I can just see that from your limited description of functional requirements, you will be able to use SQL Server as your database platform. I would use SQL Server 2014 instead of SQL Server 2012. Yes, there might be minor bugs, but the product has been out on the market for enough time to spot and fix the worst ill-behaviours. Most of the functionality has been available in Azure for a long time, and there have been thousands and thousands of IT professionals using the CTP-versions prior to finally releasing the product. So don't worry about using the latest version of SQL Server. You are more likely to create bugs in your own system than you are to spot and be affected by bugs in the SQL Server code :)