Please visit www.workopolis and search for key words MCDBA, SQL, MS and SQL. You can get a sense.
If you just know MS SQL, it is hard for you to get jobs in Canada. Companies always want you to have 100 skills and just use two or three of them. If you know some VB and VC, your chance will be much much bigger.