Debug vs Release Build

During implementation stage, what we normally do is we build (or compile) it as usual and then copy and paste the dll file from local to development server for testing. And after the testing is succesfully, we moved the dll from development server to staging server for testing again and then to production server. Everything Read more about Debug vs Release Build[…]

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 Read more about Inline/Dynamic SQL vs Stored Procedures (Just 5 short summarized points)[…]

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 Read more about Organize your code with Region[…]

Best interactive website to learn SQL

Today, my senior recommended me a website to learn sql, http://sqlzoo.net/ This is much better than famous w3schools and better than other interactive SQL sites like http://sqlcourse2.com/groupby.html and http://www.xlinesoft.com/articles/interactive_sql_tutorial/index.htm. The reason is because you can actually type those query yourself to do those exercises and the result will appear on your right side. If the Read more about Best interactive website to learn SQL[…]