Challenge: I had a discussion with people that is using iPhone and my phone is Blackberry. They said that you are developer right? Can you create this cool apps then? Solution: So I come back and explore the iPhone and here’s what I found so far: 1) 6 Tools for Beginning iPhone – http://idev4iphone.blogspot.com/2009/03/6-tools-for-beginning-iphone.html 2) [...]
Challenge: People is asking me how to avoid the cursor. Solution: There are couple ways to avoid this: 1) Always use a natural power of SQL Language (join, sub query). 2) Use Common Table Expression (CTE) – http://msdn.microsoft.com/en-us/library/ms175972(SQL.90).aspx. 3) Utilise Merge statment (SQL 2K8) or http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html
Challenge: I’ve been conversation with the GoDaddy technical support and asking to verify the locality on certificate. Solution: If you have a CSR, you ca go to the following url: www.csrparser.com to decode.
Challenge: People was asking me about Search Engine Optimisation (SEO). Solution: Based on my experience when applying www.dewateam.com, what I found that SEO is like an art and there is no a short cut to get to the top. This website is #1 when people searching keyword based on “classified community”, #2 for “community classified”. [...]
Challenge: When you’ve created an application, you tend to forget this fundamental syntax as well as other concept such as Pattern. Solution: Some useful of OO Concept and Pattern: 1. Abstract Class VS Interface – http://www.codeproject.com/KB/cs/abstractsvsinterfaces.aspx 2. Design Patterns in C#/VB.NET – http://www.dofactory.com/Patterns/Patterns.aspx 3. Strategy Pattern in C# – http://www.primaryobjects.com/CMS/Article70.aspx