Get FetchXml From Advanced Find (CRM 4.0)

Open the advanced find and press CTRL+N , This will open the advanced find view in the new window.
Now design the query and click on the query button

In the address bar copy and paste the below script and press enter

javascript:void( new function() { var s=""; function f(p){ s+= p + "=" + eval("advFind." + p) + "\n\n"};f("FetchXml");prompt("my query:",s) } )


You will get the fetchxml in an alert

Connecting to CRM 2011 Online

Connecting to CRM 2011 in the Cloud is trickier than connecting to CRM 2011 On Premise.

Check c:\Program Files to see if you have Windows Identity Foundation. If not you will need to install it.

You need to get some device credentials and this is done using a utility in the CRMSDK called DEVICEREGISTRATION. Go to \sdk\tools\deviceregistration directory and load deviceregistration.csproj. Compile the application and navigate to the \bin\debug folder. Open a command window and type

deviceregistration.exe /operation:Register

Dynamics CRM 2011 accelerators availability

http://mscrmmaster.com/2011/03/02/dynamics-crm-2011-accelerators-availability/

PowerPivot tutorial videos

PowerPivot Video Tutorial

Materials

1.     Deck : SQL Server 2008 R2 Overview

2.    Book : Introducing SQL Server 2008 R2

3.     Hands On Lab - PowerPivot in SQL Server 2008 R2.zip

Set 1

1.     Presentation What's New in the Excel 2010 Client

2.     Demo What's New in the Excel 2010 Client

3.     Presentation Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010

4.     Demo Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010

5.     Presentation Creating Reports with SQL Server PowerPivot for Excel 2010

6.     Demo Creating Reports with SQL Server PowerPivot for Excel 2010

7.     Presentation Defining DAX Calculations with PowerPivot for Excel 2010

8.     Demo Defining DAX Calculations with SQL Server PowerPivot for Excel 2010

Set 2

1.     Part 0 Installing the PowerPivot Add-In for Excel

2.     Part 1 Using the PowerPivot Add-in to Import Data into Excel 2010

3.     Part 2 Import data from a SQL Server Database

4.     Part 3 Import Data from an Access Database

5.     Part 4 Using Copy-Paste to Import Excel data

6.     Part 5 Using a Linked Excel table to Import data

7.     Part 6 Compressed data in PowerPivot for Excel

8.     Part 7 Handling big data in PowerPivot for Excel

9.     Part 8 Importing SAP data in PowerPivot for Excel

10.  Part 9 Reports as data sources in PowerPivot for Excel

11.  Relationships - 1 Overview

12.  Relationships - 2 Creating Relationships

If you are interested in Business Intelligence video tutorials, I would recommend you to visit Microsoft’s Channel 9, plenty more of the good stuff there.

Converting multiple rows into a single comma separated row

Create Table #Names (name varchar(10))

Insert Into #Names(name) values ('varun')

Insert Into #Names(name) values ('vinod')

Insert Into #Names(name) values ('manognya')

Insert Into #Names(name) values ('aradhana')

Insert Into #Names(name) values ('manoj')

SELECT * FROM #Names

SELECT STUFF((SELECT   ', '+  name as [text()] from #Names  FOR  XML PATH('')),1,2,'')

DROP Table #Names

Microsoft Dynamics CRM 2011 Released for On-Premises and Partner-Hosted Deployments

Microsoft Corp. (Nasdaq “MSFT”) today announced that Microsoft Dynamics CRM 2011 for on-premises and partner-hosted deployments has been completed and released for customer download. This release complements the latest version of Microsoft Dynamics CRM Online, which delivers Microsoft Dynamics CRM 2011 as an on-demand service from Microsoft’s datacenters and was launched into 40 markets and 41 languages in January. With a single multitenant code base across cloud and on-premises deployment models, Microsoft Dynamics CRM 2011 delivers the Power of Productivity to sales, service and marketing organizations worldwide.

Microsoft Dynamics CRM 2011 is now globally available and existing customers with active Microsoft Software Assurance agreements can access the new version immediately via the Microsoft Download Center. ( http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c3f82c6f-c123-4e80-b9b2-ee422a16b91d ).

Read the rest of the press release here: http://www.microsoft.com/Presspass/press/2011/feb11/02-16OnPremisesPR.mspx

Congratulations to the CRM program team from the 12,000 members of the Microsoft Dynamics CRM. LinkedIn community.