While developing new application or technology upgrades we are looking for Guidance. Now Microsoft supporting the .Net Architecture Guidance for modern applications like web applications,microservices,docker and mobile application with xamarin using .net. Microsoft giving free ebooks and sample apps for .net architecture guidance.use the below link for download.
In general while developing the queries the required result will retrieve from query. But the performance will be down after some days in production server due to data .In the scenario we have optimize the queries. So while developing the sql queries, stored procedures we follow some techniques for better performance. Below links for some of the practices sql queries.