Wanna to Learn the Microsoft Interview Proc?

This site provides more informations on how to prepare for Microsoft Interview which usually differs from other company.

Take It!

Good Morning - Wonderful Story! Don't Miss It

Monica married Hitesh this day. At the end of the wedding party,

Monica's mother gave her a newly opened bank saving passbook.

With Rs.1000 deposit amount.

Mother: 'Monica, take this passbook. Keep it as a record of your marriage

life. When there's something happy and memorable happened in your new

life, put some money in. Write down what it's about next to the line. The

more memorable the event is, the more money you can put in. I've done the

first one for you today. Do the others with Hitesh.When you look back

after years, you can know how much happiness you've had.'

Monica shared this with Hitesh when getting home. They both thought it

was a great idea and were anxious to know when the second deposit can be

made.

This was what they did after certain time:

- 7 Feb: Rs.100, first birthday celebration for Hitesh after marriage

- 1 Mar: Rs.300, salary raise for Monica

- 20 Mar: Rs.200, vacation trip to Bali

- 15 Apr: Rs.2000, Monica got pregnant

- 1 Jun: Rs.1000, Hitesh got promoted

..... and so on...

However, after years, they started fighting and arguing for trivial

things.They didn't talk much. They regretted that they had married the

most nasty people in the world.... no more love...Kind of typical

nowadays, huh?

One day Monica talked to her Mother:

'Mom, we can't stand it anymore. We agree to divorce. I can't imagine how

I decided to marry this guy!!!'

Mother: 'Sure, girl, that's no big deal. Just do whatever you want if you

really can't stand it. But before that, do one thing first. Remember the

saving passbook I gave you on your wedding day? Take out all money and

spend it first. You shouldn't keep any record of such a poor marriage.'

Monica thought it was true. So she went to the bank, waiting at the queue

and planning to cancel the account.

While she was waiting, she took a look at the passbook record. She looked,

and looked, and looked. Then the memory of all the previous joy and

happiness just came up her mind. Her eyes were then filled with tears. She

left and went home.

When she was home, she handed the passbook to Hitesh, asked him to spend

the money before getting divorce.

The next day, Hitesh gave the passbook back to Monica. She found a new

deposit of Rs.5000. And a line next to the record: 'This is the day I

notice

how much I've loved you thru out all these years. How much happiness

you've brought me.'

They hugged and cried, putting the passbook back to the safe.

Do you know how much money they had saved when they retired? I did not

ask.I believe the money did not matter any more after they had gone thru

all the good years in their life.

"When you fall, in any way,

Don't see the place where you fell, Instead see the place from where you

slipped.

Life is about correcting mistakes!"

ADO .net Sync service on VS using Sql Server 2005

I am going to furnish you a set of steps to follow in order to configure the SQL Server 2005 in VS for ADO. Net synchronization.

If you would have read my previous blog on  What is Synchronization and How they work, it will be a piece of cake for you to follow these steps.

I am going a head to describe the steps thinking that you have basic knowledge on ado.net synchronization.

 

1. Create a new project in Visual Studio, preferably Windows application
2. Add a new item called “Local Data Cache” ( This item will be displayed in the dialog only if you have installed the SQL Server Compact Edition 1.0 or higher)
3. The filename will have a extension of .sync
4. Once the new item is added you will have a screen to configure items.

a)     You can select the server connection, if you have any of those in the dropdown or click the New button to create a new Sql server 2005 connection

b)     Same way you can select the client connection or click the New button to create a New SQL Compact Edition ie, only Compact edition of sql server can be used as client and not SQL express

c)      Click the Add button below the Cached Tables to add the table which you want to be synchronized with the Server

d)     Click the “Show Code Example” link in the right most bottom of the screen and copy the code to the clipboard( a button will be there to do the operation). I will tell you were to use the this code.

e)     Click OK, so that at the first time the data will be downloaded from the server to the client database.

f)       It will also try to create a dataset, just click cancel.

g)     For synchronization the schema of the table in the server and client will be modified and the script for this will be place in the current solution in a folder called “SQL Scripts” and “SQL Undo scripts”. This scripts does nothing but add two columns to your table for keeping track of the changes happened in offline and to sync with the Server tables. Column name “CreationDate” and “LastEditDate”

 

 

5. Now you can open your compact database .sdf and verify the table which will have all the data that are in the server with two additional columns
6. Go to the view code of the .sync file and specify the Sync direction for your local database cache item. You will have different enum for Sync Direction. Since here we are going to synchronize both the client and server, specified as Bidirectional

Ex. this.DataElement.SyncDirection = Microsoft.Synchronization.Data.SyncDirection.Bidirectional;

 

7. Now just create a form to update you client database table with values which are not updated in the server.
8. Put a button in the form and paste the code you have in the clipboard in the click events.
9. Now do some updates in the screen and see if the data is updated in the client and not in the server.
10. Then click the button(sync button) which will execute the two line code and update the server and same can be done vice versa by updating the data in the server table and doing a sync, which will update in you local database.

 

I hope you got a glimpse on how to work on ado.net sync. I will explain in my next article on how to do the same with SQL Server 2008

Right click on Macbook with Windows Vista

Yesterday evening our chairman gave a Macbook( we are addicted with windows) and asked us to create a shortcut for MS outlook. As we tried to do that task we shocked that right click option was not poping up using touch pad.

Then me and my friends started digging on the web for quite some time and found an answer.

So I thought of posting that tips in my blog.

To get the pop up with right click menu, just press two fingers(only) in the touch pad and then press the touch pad button. Great...you will get the pop up menu. 

MS ADO.net Sync Services

Sync Services for ADO.NET is a part of the Microsoft Sync Framework (MSF). MSF is a comprehensive synchronization platform that enables developers to add synchronization capabilities to applications, services and devices. MSF solves the fundamental problem of how to synchronize any type of data in any store using any protocol over any topology. Fundamental to MSF is the ability to support offline and collaboration of data between any types of endpoints (e.g. device to desktop, device to server, etc.).

Sync Services for ADO.NET enables synchronization between ADO.NET enabled databases. Since Sync Services for ADO.NET is part of the MSF, any database that uses Sync Services for ADO.NET can then also exchange information with other data sources that are supported by MSF, such as web services, file systems or custom data stores.

The primary focus of this document will be on synchronizing information between database systems and how Sync Services for ADO.NET helps developers avoid many of the common issues associated with OCAs.

ADO.net with VS2005 or VS2008 synchronization can be done with both the SQL server 2005 and 2008. MSDN link on various synchronization framework is here

So with MSF for ADO.net we will be able to synchronize the data stored in the mobile device or any other PC where the data is updated to the client database during the system is in offline. ie, we will be updating the data through our application to our local database and once the system or device is connected to the network it synchronize the data to the server it was mapped, with this any one can happily work offline.

For this, MS uses the Sql Server Compact Edition for the client database and SQL server 2005 or 2008 as the server.

The following link will give you more practical information on how this framework works for VS2008 SP1 and SQL Server 2008

For more information reach me by mail 

Good Morning

One Early morning a mother went to her sleeping son  and woke him up.

 MOM : "Wake up, son. It's time to go to school."

 SON : "But why, Mama? I don't want to go to school." 

MOM : "Give me two reasons why you don't want to go to school."

SON : "One, all the children hate me. Two, all the  teachers hate me."

MOM : "Oh! that's not a reason. Come on, you have to go to school."

SON : "Give me two good reasons WHY I *should* go to  school?"

MOM :

One, you are FIFTY-TWO years old and should understand  your responsibilities.

Two, you are the PRINCIPAL of the school.