CVS Vs GIT Vs TFS

As we know, three of them are for source version control.
Long time ago i compared some source controls in this post . I felt that it will be nice if I can further write my opinion on them.

CVS and GIT having free version.
TFS need payment.

In my opinion:

CVS are very straight forward and easy to use. You can set it up and check in the code, with 1 step, your partner can get your source code. But cvs is very dangerous, because it doesn't warn you for conflicts. It can be useful if you always have the major all time mighty latest powerful code in your local that you can save to overwrite other code. Else, it can be disaster when you end up spending hours to debug just to finally noticed someone overwritten the code. Tracing can be really easy because you just need to right click, select cvs -> history. then you can see the history of this file's changes. BUT, again but, it can be not helpful if you what to know what else you had checked in regarding to the same working item. Comparison of code is available. select the history, click on two versions, ( can be version 1 and version 10, hold alt key for the second selection, but only compare 2 files at 1 time.) selection option: compare.  

Delete database from azure and stop paying for database usage in azure

I have a hard time trying to temporary shut the database offline so that I don't have to pay for my database that serve as testing purpose. Unfortunately, what I found online is there is not temporary shut down in azure database either!

What can we do is delete the database. As long as your database doesn't store any data, you will not need to pay 1 cent. If you have a data, the payment is per hour based on the data size.

I cannot find delete database in Azure (manage.windowsazure.com)  sql databases.
A lot of post suggest to use the SqlAzureExtension , but the database can be delete without using any extension. It is pretty simple, just log on to your sql management studio, connect to the azure server and delete it as the same way you delete any database. That's it?? YES! I am happy because due to slow network that causing me hard time to download and search the azureExtension, I found this easy solution.
:D

Cheers,
Happy clouding.

How to start MSDTC (Fix MSDTC not available error)

you can set it here:
START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.

or create a .dat file with this line of command:
net start msdtc
and run it

or
Administrative tools > Component services>component services > my computer > distributed transaction Coordinator > Local DTC > right click , propertires, security tab > Security settings > check the transaction manager communication.

Bootstrap

a.k.a twitter bootstrap.
This is one of the most famous platform recently, mainly because it fully the single responsive design.
Responsive design means you will see your web design as a fluid and the browser or device as a container. The fluid will fit into any container that you fill them to. With the rapid grow of internet, a lot of web wants to emerge in the shortest time in most of the device available.
This platform attract a lot of user because of the flexibility in fitting all device that we have, deskstop , mobile and tablet.

Break vs continue

It is very important to know the differences between this two, especially in the loop.

If you use break, you will go out from the loop;

If you use continue, you will continue to the next looped item.

query not execute when click F5

This morning i was hit into a trouble where whenever i click f5 or execute in the sql management studio, it keep prompt the 'save changes' box. I am so confused. Luckily able to figure out that it is because I accidentally clicked on the 'Result to Files'. By selecting the 'Result to Grids', it solved.
:)

Hope this post can save some ppl or myself in future..hehe..

If you not sure where is it, just make sure u select the one circled out with white pen will do.

change target framework.

If you found that you cannot select the device for debugging, maybe your target framework is higher than your existing debugging device. You can confirm this when you get this error:
"Running this project required an Android device with API 21 or above".

Because I only install the recommended device and I am still new, I finally manage to found out that all we need to do is go to the project option ( by clicking the "Configure Target API..." or go to "Project" + " 'projectName' Options" (it is under "solution Options") ) Change the Android Application's Minimum Android version and Target Android version to the lowest option, which is might be "Override - Android 1.6 (API level 4).

Go to workspace, select the device, and cheers !Happy coding. 

How to change language in xamarin’s Android emulator?

How to change language on android (xamarin emulator) ?

If you are having some difficulty on using the Japanese language keypad, you can click and hold on mouse click for some times, until a small pop-up appear(just like what we did on holding text box on smart phone for few seconds), and you can change the keyboard language.

Select input method in the pop-up screen.

Select the input method that you like, for example, I choose “Android keyboard”.

 This is how my screen became after selecting Android keyboard.

Note: PhoneWord??? I was following a tutorial from xamarin named “ phoneword” at that particular moment. :D

How to use the android emulator , how to type/ write on MonoForAndroid_API_10(emulator) ?

I closed the emulator a few times just because I "don't know" that it actually need times to start up..
X.X

Step:

1)      Wait…..till you see screen no. 2.

Have some patient…

2)      Use your mouse to drag unlock to the right.

3)      If you are not able to drag it, simply click the “Menu Button”.

4)    If you are struggling on clicking the keypad on right hand-side just like I was before this, stop it…

Click on the input box\ text box until you see the keypad on the screen, use your mouse to click on it. 

what is the default constructor for parameter in C#?

default constructor C# private or public?
Default constructor for C#, if it is not specificed, is private.
you can test it via
public class TestConstructor
{
public string title2 = string.Empty;
string title = string.Empty;
}

you will found that when you
TestConstructor tc = new TestConstructor();
tc.title2 ==> this is valid in the intellisence
tc.title  ==> TestConstructor.title' is inaccessible due to its protection level
tc.somethingNotExist  ==> TestConstructor does not contain a definition for 'somethingNotExist' and no extension method 'somethingNotExist' accepting a first argument of type 'TestConstructor' could be found (are you missing a using directive or an assembly reference?)

What is outOfBrowser in Silverlight?

Microsoft's explaination:
https://www.microsoft.com/silverlight/out-of-browser/
Silverlight offers a new set of features for building light-weight, sandboxed companion experiences for the Web that run on the desktop. Silverlight out of browser allows websites to build even closer, persistent relationships with customers. It enables the application to be placed in a restricted store on the user’s machine; and then provide a link directly to it from the user’s desktop or start menu. This is all enabled within Silverlight without any additional download of runtime or the need to write applications in a different way. An application can now be easily found on the user’s desktop or start menu, and launched with a single click. In addition, it can test if the network is connected, it can update itself, and can also have access to Isolated Storage. Taken together, these features represent a radical upgrade to the web experience.

Synopsis:
can create shortcut from desktop and don't need additional download when start the silverlight application. If network is connected, the application will update itself.

:)

how to make grid to show 100% for xaml?

I had a little struggle to archive this, finally found that it is just as simple as setting both HorizontalAlignment and VerticalAlignment = "Stretch".
also if you have separate your grid to 3 column, set your Grid.ColumnSpan="3";
finally, remember to set MinHeight="" and MinWidth="" instead of height n width.

happy coding.

string to array, array to string via string builder.

Change comma separated string to array of string.
separate the string with comma into an array.
eg:

private void validateCompanyList()
{
    //txtCompany output = "Company1,    company2, company3,company4";
    string[] companyList = txtCompany.Text.Split(',').ToArray();
    if (companyList.Count() > 0)
    {
        foreach (string company in companyList)
        {
            //eg: 1st iteration => company = "Company1"
            //     2nd: company =  "    company2"
            //     3rd : company = " company3"
            //     4th : company = "company4"

            //if you take the company.trim(), then you will get
            //     1st: company.trim() = "Company1"
            //     2nd: company.trim() = "company2"
            //     3rd: company.trim() = "company3"
            //     4th: company.trim() = "company4"
        }
    }
         
}

you can then use stringBuilder to join back the company into a string.
for example:

using System.Text;

private void validateCompanyList()
{
    if (string.IsNullOrWhiteSpace(txtCompany.Text))
        return;

    string[] companyList = txtCompany.Text.Split(',').ToArray();
    StringBuilder sbErrorMsg = new StringBuilder();

    if (companyList.Count() > 0)
    {
        foreach (string company in companyList)
        {
            int found = CompanyObject.Where(t=> t.COMPANY_CODE == company.Trim().ToUpper() && t.REC_DELETED == Constant.RECORD_ACTIVE).Count();
 
            if (found == 0)
            {
                if (sbErrorMsg.Length != 0)
                    sbErrorMsg.Append(",");

                sbErrorMsg.Append(company.Trim());
            }                  
        }
    }
    if (sbErrorMsg.Length != 0)
    {
        ErrorMessage.errorMessageControl(string.Concat("Invalid company code(s) : " , sbErrorMsg));              
    }
         
}

Beside text.split(','); you can also take a look at text.split(new char[] { ',' }, StringSplitOptions), where you can choose StringSplitOptions.None or StringSplitOptions.RemoveEmptyEntries.
let's take a look at the second option :
string[] companySpliter = txtCompany.Text.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);

With this option, the return value doesn't not include array element that is empty string. This is a very good way if you want to exclude null string in array after split.

eg: txtCompany.Text = ",,,,,,";
companySpliter.length is 0 for this case.
while string[] companySpliter2 = txtCompany.Text.Split( ',' );
will have companySpliter2.length equal to 7, with all the child element having string.Empty.

However, StringSplitOptions.RemoveEmptyEntries will not exclude child element that contain only space(s).
eg: txtCompany.Text = " ,  ";
companySpliter.length is 2 for this case.
same with string[] companySpliter2 = txtCompany.Text.Split( ',' );
which will have companySpliter2.length equal to 2.

You will still need string.IsNullOrWhiteSpace(company) to check while looping the array if you wish to ignore the spaces.

How Scrum can help improve productivity

If you are struggling on whether to go or not for SCRUM, here is an article that you may found worth for a read.
https://www.scrumalliance.org/community/articles/2015/june/why-scrum

if you are wandering how can SCRUM help my organization, this article may give you some hints.

IsNullOrEmpty better or IsNullOrWhiteSpace better?

IsNullOrEmpty vs IsNullOrWhiteSpace

Are you also thinking , is IsNullOrEmpty better or IsNullOrWhiteSpace better?
The answer is IsNullOrWhiteSpace, unless you want to accept space (" ") or spaces("   ") as valid input.
The reason is IsNullOrWhiteSpace will validate (" ") as true, while IsNullOrEmpty required you to trim the string  inorder to validate it the empty space. If you trim a string that is null, you will get exception.
Before the introduce of IsNullOrWhiteSpace , the usual way checking might be:

if(!string.IsNullOrEmpty(stringA))
 if (stringA.Trim().Length != "")
dataSavingForExample;


IsNullOrWhiteSpace : lesser code, safer for empty space checking and better performance. :)

remove item in foreach loop c#

You will face error if u directly remove the item during the for each loop because dynamic changes on the loop parent is not allow. info msdn forum

here is what you should do:
Assign the object list into another (new) list, while looping, make changes to the original object.
eg:
List<Customer> custList = Customer.Populate();
      foreach (var cust in custList.ToList())
      {
        Customer.Remove(cust);
      }

Oracle installation errors. part 1.

Oracle installation errors. part 1.

Hit error: on install product option. Copy files section.

File not found “WFMLRSVCApp.ear”

Fixes:

1.       Check the empty disc space. Should have more than 1 GB.

2.       Make sure you extract the p10404530_112030_MSWIN-x86-64_1of7.zip and p10404530_112030_MSWIN-x86-64_2of7.zip in same installation folder.

new Scrum framework poster

This is taken from SCRUM Alliance, which I found that it is worth to read.

Drop the old scrum poster, say hi to the new one. :)

The Scrum framework in 30 seconds

- A product owner creates a prioritized wish list called a product backlog.

- During sprint planning, the team pulls a small chunk from the top of that wish list, a sprint backlog, and decides how to implement those pieces.

- The team has a certain amount of time — a sprint (usually two to four weeks) — to complete its work, but it meets each day to assess its progress (daily Scrum).

- Along the way, the ScrumMaster keeps the team focused on its goal.

- At the end of the sprint, the work should be potentially shippable: ready to hand to a customer, put on a store shelf, or show to a stakeholder.

- The sprint ends with a sprint review and retrospective.

- As the next sprint begins, the team chooses another chunk of the product backlog and begins working again.

- See more at: https://www.scrumalliance.org/why-scrum

Error: Unhandled Error in Silverlight Application
Code: 2103
Category: InitializeError

Message: Invalid or malformed application: Check manifest

When you install IIS, make sure you have the Static Content feature enabled (under Common Http Features),

the .NET babies: Visual basic & C#

While you have a few years of experience for one of the language ( VB or C#), you might found some time is needed for yourself when you want to code another language. It is easy to read and understand them but when it comes to write, you might become not as fast as when you code using the other language. This is because of the syntax! (It makes me felt that this is just like some people can understand Cantonese but cannot speak in Cantonese. hehe..) 

First, C# is case sensitive while VB is case insensitive.
So,
you can do this to C# ==> Var i = 1; Var I = 10;
But,
you cannot do this to VB ==> Dim i as Integer = 1  Dim I as Integer = 10
the compiler will definitely complain about double declaration.

Consideration before adopting SCRUM

This article explain well on the key points you should clarified, be sure that you don't have those thinking before jump into SCRUM.

https://www.scrumalliance.org/community/articles/2015/january/consideration-before-adopt-scrum.aspx

5 types of system database in SQL

5 types of system database in SQL:
1) Master database
2) Resource database
3) Tempdb database
4) Model database
5) msdb database

1) Master database
- The ''VID''(very important database) of the SQL. Without this database, the server cannot be started. (because it store the initializing information)
- Act as a identity card for the server, because it store all the system level information.
(store all the authorized user information, logon accounts, system configuration settings and others metadata)
- The system object used to store in this master database but it is now in the resource database.
- Physical file : master.ldf and master.mdf
- It is not advise to : change any logon information or change information in the master database. In fact, a lot of changing, dropping, renaming, creating action is not allowed in this database. ( as per mention in msdn.
- If you have to do something with the master database, such as create user object , you are advice to backup the master database. In case of the master database unusable, you can restore the master database or rebuild the master (this is for severe damage, server not able to restart , and this will cause all the system database being rebuild ) .

Object Oriented programming

Module is a collection of classes,
Class is a definition,
and Object is a collection of data.

The object is actually an instance of class, it is 'born' based on the definition of the class. While module is a collection of classes.

This is for biology lover:

We have Kingdom, Family , Genus .....( I forgotten what I had memorized during high school)..
what makes those Families under that Kingdom is due to they have some similarities, but each of them is different.

For example, human and chimpanzee are under Hominidae, both is warm blood , about similar structure. In programming, human and chimpanzee inherit the definition in the Hominidae. Let's imagine them as each individual class. Human can walk, Chimpanzee can walk, Human extend from the base class and have something they have but Chimpanzee doesn't has.
in code:  class Human(Hominidae)
Human us a derive class and Hominidae is a base class.

In the human class, we have each individual human , just like U and I. We are an object , that is an instance of the human. We represent the human. ( object is a collection of data based on class)

Now, move a level up, before Hominidae, we have a super family which can act as module. Module is a collection of classes.

I had the idea after this interesting video that describe OOP with the city planner example. Here is the link.: https://www.youtube.com/watch?v=P1WcKEgvRFE

Usually, this concept is widely practice when a programmer do programming, but one mey notknow how to explain it. I normally will have a class contain all related functions. It is more manageable and cleaner in this way. For each function, try to let it only have a "mission" to archive.
Programming is an art. :)

3 DES - Security / encryption

3DES
- Triple data encryption Algorithm
-Encrypts data 3 times using 64-bit keys
-symmetric-key block cipher
-widely use on electronic payment.

RSA - Security / encryption

RSA is public key encryption that used for data sending over internet.
- It is well known industry strength encryption, this 'recognition' is given based on the fact that there is no easy way to factor very large number. To factor a very large amount of computer processing time and power is needed.
- Uses asymmetric cryptography algorithm i.e. it uses two different key to achieve encryption.
- Also know as public key cryptography because the give is given to everyone, to the public. The private key is kept privately, private key is a prime factor. With the public key, everyone / anyone can encrypt the message and reply. Only the person that know the private key can use the factor to decode the message.
- For example(just as an example) : public key = A, message = B,
user will send the result of A * B to me and I will use C mode A to get message as B .