ms crm keyboard shortcuts

Copy text – Ctrl+C
Paste text – Ctrl+V
Undo previous text change – Ctrl+Z
Save a record  – Ctrl+S
Close a record –  Esc
Cut text – Ctrl+X
Delete text – Delete
Delete selected text immediately without putting it on the
Clipboard –  Shift+Delete
Move to the first tab on the ribbon – Ctrl+[
Move to the last tab on the ribbon – Ctrl+]
Move the insertion point to the start of the next word – Ctrl+Right Arrow
Move the insertion point to the start of the previous word – Ctrl+Left Arrow
Select all text in the current field – Ctrl+A
Display the System menu for the active window – Alt+Spacebar

MS CRM Dynamics 2013 Certifications

Microsoft Dynamics CRM 2013 Certification Exams

MB2-700: Microsoft Dynamics CRM 2013 Applications
MB2-701: Extending Microsoft Dynamics CRM 2013
MB2-702: Microsoft Dynamics CRM 2013 Deployment
MB2-703: Microsoft Dynamics CRM 2013 Customization and Configuration

In Page notification in ms crm 2013 

Case 1: Navigation to/from existing records – notification

When navigating away back and forth from new records, if there is any change made to its
fields, then an in-page notification is displayed as a warning.

Case 2: Navigation to/from new records – notification

When you navigate away back and forth from existing records, if there has been a change on
the form as well as some related error, then an in-page notification is displayed as a
warning.

However, if there are no errors on the form, then an auto-save occurs to update unsaved
changes when navigating away on existing records. This will occur regardless of whether
the auto-save feature is turned on or off.

Fetching currency using javascript ms crm 2013

function currency()
if(Xrm.Page.getAttribute(“transactioncurrencyid”).getValue()!=null)
{
var c = Xrm.Page.getAttribute(“transactioncurrencyid”).getValue();
alert(c);
}
}

Get current UserId using javascript from ms crm 2013

We can get current userid from the context like this,
function show()
{
var userid = Xrm.Page.context.getUserId();
alert(userid);
}

Disabling Microsoft Dynamics CRM 2013 Auto Save feature for a specific entity form or a CRM organisation to avoid undesired execution of plugins or workflows

Microsoft Dynamics CRM 2013 has a new auto-save feature which triggers a save action on forms every 30 seconds.
Suppose, if you are editing a form, an autosave is triggered automatically by CRM 2013 on regular intervals.
The problem with this feature is that if you have a plugin or a workflow that first on saving the form, it will be triggered every time the auto save action is fired.
This will obviously cause undesirable actions and potentially unexpected consequences to several processes especially in the case of an upgrade from Dynamics CRM 2011 to Dynamics CRM 2013.

To disable the Auto Save feature in Dynamics CRM 2013, you can stop it at organisation level
Go to Settings
–> System Settings
–> General Tab (first tab)
–> Enable Auto Save on All forms
–> No.

ms crm dynamics tutorial links

Here are the few links which may be useful for ms crm developers,

http://www.microsoft.com/en-us/dynamics/crm-customer-center/videos.aspx

http://curah.microsoft.com/31635/microsoft-dynamics-crm-2013-helpful-resources

http://crmorion.blogspot.in/2013/10/microsoft-dynamics-crm-2013-helpful.html

http://garethtuckercrm.com/2011/03/16/jscript-reference-for-microsoft-dynamics-crm-2011/

http://ashwaniashwin.wordpress.com/2013/10/28/step-by-step-installation-of-microsoft-dynamics-crm-2013-on-premise/

To find the desc of an table in sql server 

In oracle we use the following the command to see description of an table.

desc tablename

In sql server we can use the following methods,

1. exec sp_columns TableName

(or)

2. exec sp_help TableName

(or)

3.

select *
from information_schema.columns
where table_name = ‘TableName’
order by ordinal_position

How to shrink database in sql server

In sql server, we can shrink database like this,

1. Open Microsoft SQL Server Management Studio
2. Right click on your database.
3. Select Properties.
4. Click on Options.
5. Change the recovery model to Simple.
6. Click OK.
7. Right click on the database.
8. Select Tasks > Shrink > Database.
9. Click OK.
10. Right click on the database.
11. Select Properties.
12. Click on Options.
13. Change the recovery model to Full.
14. Click OK.

(or)
ALTER DATABASE MyDB SET RECOVERY SIMPLE

GO

DBCC SHRINKFILE (MyDB_Log, 10)

GO

ALTER DATABASE MyDB SET RECOVERY FULL

GO

How to disable foreign key in sql server

If you want to disable foreign key to do updates in a table, here are the steps

1. Disable all the foreign keys by using,

ALTER TABLE TABLE_NAME NOCHECK CONSTRAINT ALL

or

ALTER TABLE TABLE_NAME NOCHECK CONSTRAINT CONSTRAINT_NAME

2. Update the key values

2. Enforce the keys again to work like charm.