Change the sa password in SQL Server

Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.

The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.

SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted

The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created.
The following actions might require a table to be re-created:

• Dropping a column
• Changing column nullability
• Changing the order of the columns
• Changing the data type of a column

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Check the Microsoft Certification

Use the below link to Check/Share the Microsoft Certication Details
https://mcp.microsoft.com/authenticate/validatemcp.aspx
use the Transcript ID and access code as your password
You are now ready to share your qualifications with your employer, friends, and colleagues. 
Provide them with your Transcript ID and the Access Code, and direct them to https://mcp.microsoft.com/authenticate/validatemcp.aspx. Remember, you can change your Access Code at any time. 
If you decide to stop sharing your transcript, simply change your Access Code at https://mcp.microsoft.com/mcp/tools/MCPDirectoryPreferences.aspx and refrain from sharing the new Access Code with anyone.

The below link is used to update your Certification details 
https://www.microsoft.com/learning/members/en/us/mcp/mcp-default.aspx 

Tools used in Microsoft CRM 2011

1. The following tools are all part of the CRM 2011 Software Development Kit (SDK) SDK Download: http://www.microsoft.com/download/en/details.aspx?id=24004 

a. Plugin Registration Tool - http://msdn.microsoft.com/en-us/library/hh237515.aspx 

b. Plugin Profiler - http://msdn.microsoft.com/en-us/library/hh372952.aspx 

c. Developer Toolkit - http://msdn.microsoft.com/en-us/library/hh372957.aspx 

d. Web Resources Tool - http://msdn.microsoft.com/en-us/library/gg328133.aspx 

4. Metadata Document Generator - http://metadatadocgenerator.codeplex.com 

5. Visual Ribbon Editor - http://crmvisualribbonedit.codeplex.com 

6. SiteMap Editor - http://sitemapeditor.codeplex.com 

7. Odata Query Designer - http://crm2011odatatool.codeplex.com 

8. Fiddler - http://www.fiddler2.com 

9. Internet Explorer - F12 debugger - http://msdn.microsoft.com/en-us/library/ie/gg589507(v=vs.85).aspx 

10. JavaScript Conversion - http://crm2011scriptconvert.codeplex.com 

11. Form Reporter (CRM 4.0) - http://archive.msdn.microsoft.com/mscrm4formreporter 

12. Metadata Document Generator for Microsoft Dynamics CRM 2011 (Form Reporter) - http://metadatadocgenerator.codeplex.com 

Setting Blank iFrame in CRM 2011

when you need to default an iFrame to a blank page.  When this is the case, through JavaScript, you’ll then want to set the page to the desired URL.

With CRM 4.0, you could set your page to “/_root/blank.aspx”.  This page however, is no longer an option inside CRM 2011.

With CRM 2011, I like to use the loading screen “/_static/loading.htm”.  Although this page contains an animated .gif and slightly more HTML than a blank page, the reason I prefer this page is because it is already cached by the browser and provides the user with a nice loading graphic.

Add a new iFrame and in the URL filed give the above highlighted text.

Trick to get FetchXML in MSCRM 4.0

Just use following steps and enjoy.....

• Use the advance find of MS CRM; 
• define your query and click on Find button; 
• Press CTRL+N, this will create a new IE window but will keep the context; 
• Replace the url in the address bar                 javascript:alert(resultRender.FetchXml.value); 

What is REST/SOAP?

What Is REST?

REST represents Representational State Transfer. REST is an architectural style in which every resource is addressed by using a unique URI. In Microsoft Dynamics CRM, a resource can be an entity collection or a record.

REST works the way the Internet works. You interact with resources by using HTTP verbs such as GET , POST , MERGE , and DELETE . Various libraries can be used to process the HTTP requests and responses. REST provides a standard interface that you can use with any programming language. REST allows for either synchronous or asynchronous processing of operations. The capability to perform asynchronous operations makes REST well suited for AJAX and Silverlight clients.

OData sends and receives data by using either ATOM or JavaScript Object Notation (JSON). ATOM is an XML-based format usually used for RSS feeds. JSON is a text format that allows for serialization of JavaScript objects.

Limitations

The REST endpoint provides an alternative to the WCF SOAP endpoint, but there are currently some limitations.

Only Create, Retrieve, Update, and Delete actions can be performed on entity records.

a.Messages that require the Execute method cannot be performed.

b.Associate and disassociate actions can be performed by using navigation properties.

Authentication is only possible within the application.

a.Use of the REST endpoint is limited to JScript libraries or Silverlight web resources.

What Is SOAP?

Unlike the REST endpoint for web resources, the SOAP endpoint uses the Organization service. This is the same service used when writing applications that exist outside of the Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online application. The differences are:

a.Requests are sent to a different URL: <organization URL>/XRMServices/2011/Organization.svc/web.b.Authentication is provided by the application.

Because authentication is provided by the application, you must create web resources in the application before the code that uses the service can operate.

Comparison of Programming Methods

You can use the SOAP endpoint for Web Resources with JScript libraries or by using Microsoft Silverlight. The process for using this endpoint is very different, depending on the technology used.

Using the SOAP Endpoint with JScript

With JScript, you will be using XmlHttpRequest to POST requests to the service. The body of the request must contain the XML appropriate for the message you are using. You must also parse the XML returned in a response. With XmlHttpRequest , it is possible to make synchronous requests. However it is highly recommended to always use asynchronous requests. Because manually configuring each request is very time consuming, it is expected that you will reuse existing libraries or create your own. Microsoft Dynamics CRM 2011 does not provide a comprehensive set of JScript libraries. The specific syntax used when calling JScript libraries depends on how they are designed. Several sample JScript libraries are provided with the Microsoft Dynamics CRM SDK, but these are not intended to represent the only or best library design. The content in the Microsoft Dynamics CRM SDK focuses on helping you create your own libraries.