Using Merge in Sql Server 2008

Credits:

I came to know about merge through my friend, my colleague and my partner Gireesh. Thanks for the effort he put in.

 

The scenario for using Sql Server 2008 Merge?

Office 2010–Read all mail as text and back to html

Recently to check how emails display in text only format in office 2010, i turned on the option to “Read all mail as text”, but thanks to my forgetfulness after 2 days i had forgotten where the option was. So the steps for “Reading all mail as text” and reverting it back to html is documented below:

To Turn on the Read all standard mail in plain text

In office 2010:

Learning WCF - windows communication foundation

It is the umpteenth time i am starting on wcf, however each time since the study is not documented, i find myself staring at the same place. Hoping this documentation through my blog will help me graduate to the next step.

Steps to learn WCF?

1. Build a live WCF hello world service.
2. Host the WCF service in
   1. A console.
   2. A windows service.
   3. IIS.
3. Consume the WCF Service in
   1. Console
   2. Windows Form
   3. Silverlight
   4. Windows 7 Mobile
   5. Android & IPhone (don’t know the possibilities but no one can deny my wish list.)
4. …… till Infinity (My wish list doesn’t end).

Now with the steps outlined, i will be posting each step as a separate blog, i will also be updating a list of all references to learn wcf i come across in a separate blog.

Correct schema in a sql server database

Recently we came across the condition where there were multiple schema’s for the same object. Hope someone finds this useful.

This was solved using by running the result set of this query.

Script

Select 'Alter Schema dbo Transfer ' + [s].name+'.'+o.name  from sys.schemas s inner join sys.objects o on s.schema_id = o.schema_id and s.name = 'Test_user'

So what does this do? 

This simply transfers each object’s schema to dbo.