• Finding Duplicates using SQL

    by Venkata Koppaka | Jan 25, 2010

    Here is a handy script to find duplicates in a table using SQL -

    1 select column, 
    2     count(column) as numofoccurrences 
    3 from table 
    4 group by column 
    5 having count(column) > 1 

    Cheers,

    Venkata

    Go comment!
  • Building my own Blog

    by Venkata Koppaka | Jan 11, 2010

    Over the last few days, I am spending some time to build my own blog. I often feel that a real developer builds his own blog and then blogs using it.:)

    With all these CMS tools , blogging systems I have tried and seen the source code for , I always wanted to write my own blogging system that I can blog and add functionality to my blog whenever I want to in the way I want to - not waiting for a new release for the tool I am using or not waiting for someone to make a change so that I can use it.

    So here I am building my own blog - I will be using .NET 4 and ASP.NET MVC 2 to build my own blog.

    I will be posting a series of blog posts at various stages of development indicating where I am at and my decisions to do a certain task and why I choose that path.

    I am going release a Version 1 of my blog even if it sucks any way on codeplex.

    See you in Build Your Own Blog (BYOB) series soon.

     

    Venkata


    Go comment!
  • Happy New Year 2010

    by Venkata Koppaka | Jan 01, 2010

    I wish everyone a very Happy and Prosperous New Year 2010. :)

     

    Go comment!