MS SQL Server : The Game of Dynamic SQL

No matter how much we try to avoid dynamic sqls in our queries, there are times when we have no other choice than to use it. I have experienced that in general all programmers are not very well aware of the truths and myths related to dynamic sql queries and at times they end up implementing a solution that might not be the best one for their scenario.

I am not going to write about the truths and myths of dynamic sql here, but will point you to this article "The Curse and Blessings of Dynamic SQL" by Erland Sommarskog, which I came across long back. The article is very informative and is updated with latest changes in SQL Server. There are other articles from Erland on the same web and they are also equally informative and exhaustive. Also, there are other very useful links on the site that are related to SQL Server. A site - must to be in the 'favorites list' of any MS SQL programmer.

HTML Character Codes

Today I posted an article on the VB to C# blog about short circuiting in C# (read here). While previewing the post, I noticed that the pipe symbols are not appearing in the post. At first I thought that blogger should have converted it automatically to its HTML character code, but it didn't and they were just removed from the HTML. A search on Google took me to the complete dictionary of HTML Character Codes. Its really handy and helful for web developers. Its here!

New blog on Vb to C#

People, I have just started a new blog on common question that people from VB background ask when they start programming in C#. Read it at http://vbtocsharp.blogspot.com/. This is inspired by my personal experiences about moving to C# from VB.