Month: June 2008

Categories
ASP.NET 1.1 SQL / Stored Procedures VB.NET

Inline/Dynamic SQL vs Stored Procedures (Just 5 short summarized points)

After reading some articles and discussions on this topic, my conclusion is:

  • It is a myth to use all inline/dynamic SQL for all the queries in the application.
  • It is a myth to use all Stored Procedure for all the queries in the application.
  • Use Stored Procedure when the query is very complicated, easily will need changes and with many business logics. Reason is easier maintenance. Business logic easily change. Changes in Stored Procedure does not required re-compile of code.
  • Use Stored Procedure when the query will take long time to complete it. Reason is better performance.
  • Other that the two situations above, use inline/dynamic SQL in the code, but it needs to be a parametrized SQL. (classic ASP doesn’t have this but ASP.NET)

    • References

  • http://codebetter.com/blogs/eric.wise/archive/2006/05/24/145393.aspx
  • http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
  • http://weblogs.asp.net/aaguiar/archive/2006/06/22/Stored-Procs-vs-Dynamic-SQL.aspx
  • http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx
  • http://www.theserverside.net/news/thread.tss?thread_id=31953
  • http://www.codinghorror.com/blog/archives/000292.html
  • http://www.codinghorror.com/blog/archives/000117.html
    • Categories
    ASP.NET 1.1 VB.NET

    Organize your code with Region

    When you have many related functions, you can consider to group them together using Region.

    Example, if you have four functions which are related to Paging, you can just add a region like below (ASP.NET 1.1, VB.NET syntax):

    #Region "Paging"

    Public Property CurrentPage() As Integer
    ' Your code here ...
    End Property

    Private Sub ImgBtnPrevBottom_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImgBtnPrevBottom.Click
    ' Your code here ...
    End Sub

    Private Sub ImgBtnNextBottom_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImgBtnNextBottom.Click
    ' Your code here ...
    End Sub

    Private Sub ItemsGet()
    ' Your code here ...
    End Sub

    #End Region


    Now, go to your Visual Studio 2003. Click Edit > Outlining > Collapse to Definitions, you will see the below:

    Print Screen - Region

    It is very simple to do, yet useful.

    Categories
    Web Usability

    Writing Web Content

    Compilation of Writing Web Content tips:

  • Content Title – Catchy, 4-5 words and direct.
  • Use Simple English – avoid jargons.
  • Concise – express much in few words, because users don’t read much text. They scan text.
  • Check grammar and spelling
  • Make it interesting – After you have solid and informative content, make sure you deliver it interesting. Maybe you can sprinkle some humors into them.
  • Limit the Number of Words and Sentences – to enhance the readability of prose text, a sentence should not contain more than 20 words. A paragraph should not contain more than 6 sentences.
  • Well-structured – Example

    1st paragraph – outline your article, share the points you are going
    review in the article, and state why these points are important.

    2nd paragraph – review point one

    3rd paragraph – review point two

    4th paragraph – review point three

    5th paragraph – summary. restate the points of your article and reiterate why those points were important.

    • References

  • Criteria of a Quality Article
  • Research-Based Web Design & Usability Guidelines

    • More Resources

  • http://www.webdesignfromscratch.com/copywriting.cfm
  • http://www.alistapart.com/topics/content/writing/
    • Categories
    SEO Website Online Tools

    Google Sitemaps Free Online Generator

    I realized from Google Webmaster Tools that I don’t have a google sitemaps and I hope to have one.

    I also learnt that there are site out there which can generate this google sitemaps. I have tried some sites but they fail to do a good job. But, just now, at last, I found a good one. It is sitemapdoc.

    What is the usage of this sitemap? My knowledge at this time is, it helps search engine to crawl my website better.

    So, after the site has generated the xml, I copied and paste it to my notepad and save it as .xml file. Then, I upload it to my website. Then, I went to Google Webmaster Tools to add this Google Sitemaps. It took some time (less than 30 minutes) to process the sitemaps. Right now, I got a sitemaps, hurray!