Karim's profileMicrosoft Dynamics CRM B...PhotosBlogListsMore ![]() | Help |
|
November 14 Performance Issue when Using CRM 4.0 API for Bulk InsertI faced lousy performance when I tried to do bulk insert using the CRM webservices (API) and I didn't know how to improve the performance of the code till today when I started to review "Programming Microsoft Dynamics CRM 4.0" by Jim Steger, Mike Snyder, Brad Bosak, Corey O'Brien, Philip Richardson, thank you guys.
When you are using the Microsoft CRM API to insert data in bulk you should pay attention to performance of the web service. Because you will typicall load data with a program to running as a specific user, you can take advantage of connection sharing as shown below:
//Create the service
CrmService service = new CrmService();
service.Credentials = _crmService.Credentials;
service.Url = _crmService.Url;
// Enable unsafe connection sharing
service.UnsafeAuthenticatedConnectionSharing = true;
Enabling the UnsafeAuthenticatedConnectionSharing option increases the performance significantly!!! November 13 SQL Server 2008 DownloadsMicrosoft SQL Server 2008 Books Online (August 2008)SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Microsoft® SQL Server® 2008 Express with Advanced ServicesMicrosoft SQL Server 2008 Express with Advanced Services (SQL Server 2008 Express) is a free, easy-to-use version of SQL Server Express that includes a graphical management tool and powerful features for reporting and advanced text-based searches. SQL Server 2008 Express provides powerful and reliable data management tools and rich features, data protection, and fast performance. It is ideal for small server applications and local data stores. SQL Server 2008 Express with Advanced Services has all of the features in SQL Server 2008 Express, plus you can:
Free to download, free to deploy, and free to redistribute as an embedded part of an application, SQL Server 2008 Express with Advanced Services is the fast and easy way to develop and manage data-driven applications with powerful built-in reporting and full-text search functionality. For more information about SQL Server 2008 Express with Advanced Services, including other versons and downloadable components now available, see Microsoft SQL Server Express. For information about the different editions of SQL Server 2008, see the Editions page. Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint TechnologiesMicrosoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007. The download provides the following functionality:
This Reporting Services Add-in works together with SQL Server 2008 Reporting Services, which is required for the report server instance. SQL Server 2008 Reporting Services provides the following functionality for a report server that runs in SharePoint integrated mode:
Warning: The Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies requires a SQL Server 2008 Reporting Services (SSRS) instance. This add-in is not supported with earlier versions of SSRS. Microsoft SQL Server 2008 Feature Pack, October 2008it contains the following : Microsoft ADOMD.NET Microsoft Analysis Management Objects Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider Microsoft SQL Server 2005 Backward Compatibility Components Microsoft SQL Server 2008 Command Line Utilities SQL Server Compact 3.5 SP1 Microsoft Connector 1.0 for SAP BI Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007 Microsoft SQL Server 2008 Datamining Viewer Controls Microsoft SQL Server 2005 Driver for PHP Microsoft Core XML Services (MSXML) 6.0 Microsoft SQL Server 2005 JDBC Driver 1.2 Microsoft SQL Server 2008 Management Objects Microsoft OLEDB Provider for DB2 SQL Server Remote Blob Store Microsoft SQL Server 2008 Policies Microsoft Windows PowerShell Extensions for SQL Server Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Replication Management Objects Microsoft SQL Server 2008 Report Builder 2.0 Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies Microsoft SQL Service Broker External Activator Microsoft SQL Server System CLR Types Microsoft SQLXML 4.0 SP1 Microsoft Sync Framework Microsoft SQL Server 2008 Upgrade Advisor November 12 Download MAPThe Microsoft Assessment and Planning is an agentless toolkit that will find computers on a network and perform a detailed inventory of the computers using Windows Management Instrumentation (WMI), the Remote Registry Service, or the Simple Network Management Protocol (SNMP). The data and analysis provided by this toolkit can significantly simplify the planning process for migrating to Windows Vista®, Microsoft Office 2007, Windows Server® 2008, Microsoft Application Virtualization 4.5 (formerly SoftGrid), Microsoft SQL Server 2008, Microsoft Online Services, Forefront and Network Access Protection, Windows Server 2008 Hyper-V, and Virtual Server 2005 R2. Assessments for Windows Server 2008 and Windows Vista also include device driver availability and recommendations for hardware upgrades that may be required.
November 07 Visual Studio Gallery .. Free ControlsCheck this link as it contains many of free controls and addons that you can use with Visual Studio , such as Power commands for Visual Studio 2008
November 04 Book Review : Microsoft Dynamics CRM 4.0 Step by Step by Mike Snyder, Jim Steger, Kara O'Brien, and Brendan LandersI read Microsoft Dynamics CRM 4.0 Step by Step book over the last month and It was nice experience as I was searching for key concepts about the CRM that I know that the business users whom are trying to learn Microsoft Dynamics CRM will seek and gladly I found them listed in there in a simple and easy way to understand. 1. Business users who want to learn how to use Microsoft Dynamics CRM in this Areas (Sales, Marketing and Service) 2. The book is not targeting developers or technical gurus as it's not talking about development or customization. 3. The book is focusing on the following parts: Part 1 Overview1. Introduction to Microsoft CRM Dynamics
2. Getting Around Microsoft Dynamics CRM it's very nice chapter that will take you in quick tour around the Microsoft Dynamics CRM, the nice thing the author mentioned in this Chapter was the use of the Resource Center as it is very important resource to learn more about Microsoft Dynamics CRM.
3. Working with Accounts and Contacts This chapter is very important to beginners and business users as it shows you how to handle the core of any CRM system; the Customers and the Author went through all the Tips and tricks in this area.
4. Working with Activities and Notes This chapter too holds very important Tips and tricks that are not explained in a lot of books talking about Microsoft CRM.
5. Microsoft Dynamics CRM for Outlook This chapter is very important to a lot of customers and business users as most of the users like to work from their outlook as they are familiar with everything in it and this chapter explains a lot of features and functionality that the user will encounter in his work.
Part II SalesThis part is targeting the sales people as it walks through the whole sales automation cycle. 6 . Working with Leads and Opportunities
7. Working with Quotes
Part III MarketingThis part is targeting the Marketing people as it walks through the Marketing cycle starting from creating Marketing lists ending to working on the campaign activities and analyzing the customer responses. 8. Using Marketing Lists
9. Managing Campaigns and Quick Campaigns
10. Working with Campaign Activities and Responses
Part IV ServiceThis part is targeting the Helpdesk and the service providers business users. 11. Tracking Service Requests
12. Using the Knowledge Base
13. Working with Contracts and Queues
Part V Data ManagementThis part is targeting the Administrators and the business users of the system as it shows you how to create rule to duplicate detect records, how to use the advanced Find and How to use the report wizard to create reports on the CRM and very nice feature which is Reporting with Microsoft Office Excel which a lot of customers ask for. 14. Detecting Duplicate Records
15. Using Advanced Find
16. Using the Report Wizard
17. Reporting with Microsoft Office Excel
18. Importing Data
The book is well organized and presents the data in systematic way and it listed the most important things for different categories of users whether to sales people or marketing or Service and call center users, although the book is very good but it didn't describe very important part of Microsoft CRM which is the CRM Workflow Engine which I'll publish very soon a detailed article on how to create workflow using the workflow engine in CRM and custom workflow using Workflow foundation and Visual Studio in Microsoft Dynamics CRM and it didn't talk about the customization in Microsoft Dynamics CRM. |
|
|