OWASP web site ( https://www.owasp.org/index.php/Main_Page ) The Open Web Application Security Project (OWASP) is a 501c3 not-for-profit worldwide charitable organization focused on improving the security of application software. In their web site...

As promised in the previous blog , I am going to talk about the common mistake and trciks on LEFT join in LINQ to SQL. Common issues I saw? 1. Using DefaultIfEmpty in value type variable. If you copy the LEFT join example from internet and then...

As promised, I am going to explain how we could translate the following SQL query into LINQ SELECT * FROM TableX LEFT JOIN TableY ON TableX.YID = TableY.YID LEFT JOIN TableZ ON TableY.ZID = TableZ.ZID Before we do this, I feel that using...

I had been asked how to write a Left join for Linq to SQL recently, I totally forget the SQL style syntax of Left Join. So, I decided to write several examples/samples and put it in my blog. Hopefully, no people will get stuck with this again. How...

I write my first TSQL XML query a long time ago, and I repeatedly run into the same problem every year. What is the syntax? Let assume I am going to store my whole employee table in one giant XML and store it in the employee table with one row and...

Linq is one of the best creation I saw within the last 10 years. I strongly believe that Linq will change how people retrieve data in the future. To learn linq, I recommend you to try Linq Pad http://www.linqpad.net/

Firstly, I would say that no matter which technology, when more user and more user start using it, it will always increase decrease performance, even for the most popular search engine around the world. I am confidence that if suddenly every people start...

One of the must read article for security http://msdn.microsoft.com/msdnmag/issues/02/09/SecurityTips/

Yeah. I read an article recently which support my believe on SDL. In today ever changing software security environment, we need a self evolve process like SDL. http://blogs.zdnet.com/security/?p=697

Since I am the new developer of a internal tool which used by Microsoft internal project to help Microsoft product align with the Security Development Lifecycle (SDL). I had done more and more research about it myself. I recently found that SDL had been...

The November issue of MSDN magazine is out and the key topic is about security, I would recommend every people who care about security of their software to read it. http://msdn.microsoft.com/msdnmag/issues/07/11/

If you are serious about making your software secure, I would highly recommend you to read the book, The Security Development Lifecycle by Michael Howard. I outlined a process which is very easy to follow which help you to make your application securer...

Recently, I found more and more web sites using AJAX. However, I feel they are using a good technology in a wrong way. I guess it is probably related to Google success and every people feel the urgency to use some of the technology it promoted. Example...

I came across a simple document which outlining the basic principles on designing good software. I think it is pretty good. In case you want to check it out, you can find it in http://www.w3.org/DesignIssues/Principles.html

One of the key reason why C# team is so great and the thing I like most about C# team is our diversity. When I say diversity, I am not referring to people from different age, different races or different gender. I am referring to people with different...

Clearly, there is no standard rules on how you should categorize your automation, it all depends on your project size, schedule and product complexity. ASAIK, in general, testers usually break down their automation based on their needed and the...

I am a SDET in LINQ to SQL team. One of the question I got asked frequently is how to select a OR mapping tool. With no doubt, I think LINQ to SQL is the best. BTW, I come across a good article which talk about this. http://www.howtoselectguides...