Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)
Tuesday, October 27, 2009 8:46 AM

Using SQL Server 2008 to Improve Report Resources Management

Today’s guest blog is submitted by CRM MVP Jim Steger of Sonoma Partners . We’ve all had it happen; someone runs a very resource intensive report during the day which slows down the performance of CRM for all the users. This now can happen more frequently
Posted by crmblog | 3 Comments
Wednesday, July 15, 2009 7:53 AM

Synchronizing an NTEXT field of more than 4,000 characters offline

Today we welcome guest blogger and CRM MVP Jim Steger who is a developer, blogger, and writer for Sonoma Partners . When Microsoft Dynamics CRM 4.0 provided an offline API, we now implement the Microsoft Dynamics CRM client for Outlook with Offline Access
Posted by crmblog | 0 Comments
Monday, May 04, 2009 11:55 AM

Building a Self-Contained Virtual CRM Development Server

Guest blogger and CRM MVP Matt Wittemann walks us through this process using Windows Server 2008 and SQL Server 2008. I’ve had to build a number of development servers for CRM, usually using virtualization technology, and I thought I’d share some of the
Posted by crmblog | 6 Comments
Wednesday, April 08, 2009 10:01 AM

CRM Usage Reporting Unleashed

Our CRM MVP guest blogger for today is David Jennaway who is the technical director at Excitation. A frequent request we come across is from companies who want to know which users are using CRM and when. The CRM platform provides the facility to gather
Posted by crmblog | 8 Comments
Thursday, February 05, 2009 10:48 AM

White Paper: Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL

The MS CRM Engineering and Excellence team is pleased to announce the release of the white paper Improving Microsoft Dynamics CRM Performance and Securing Data with Microsoft SQL Server 2008 , which is available for download at: http://www.microsoft.com/downloads/details.aspx?FamilyID=b5bb47a4-5ece-4a2a-a9b5-5435264f627d&DisplayLang=en
Posted by crmblog | 1 Comments
Monday, January 26, 2009 10:22 AM

Dynamic Export to Excel feature – How to protect data over the wire

One of the well-known features offered in Microsoft Dynamics CRM v4 is export data to Excel as a dynamic worksheet, a dynamic pivot table, or even to a static worksheet. Users can then refresh these dynamic Excel sheets alone to get the most current data
Posted by crmblog | 5 Comments
Tuesday, December 30, 2008 8:35 AM

Just do it – Deleting attributes that are in use by running Workflows

Microsoft Dynamics CRM MVP Aaron Elder of Ascentium provides some tips and tricks . Recently, we had the need to delete several attributes from an entity we had created (Employee).  Normally this is a very straight forward affair in Microsoft CRM. 
Posted by crmblog | 2 Comments
Monday, December 29, 2008 9:17 AM

“Poor man’s” Business Intelligence for Microsoft Dynamics CRM

CRM MVP Joel Lindstrom, a Solutions Consultant for CustomerEffective , blogs about BI solutions. Business Intelligence (BI) is getting a lot of attention these days. It makes sense that companies want to use the data collected by business systems like
Posted by crmblog | 2 Comments
Monday, November 24, 2008 7:57 AM

Rolling out CRM: Who should take ownership?

Today we welcome Microsoft Dynamics CRM MVP Umar Khan who is a Business System Consultant for SISCOM in Saudi Arabia. You can read more from Umar at http://umarkhan.wordpress.com . Umar also spends time in the Dynamics Forums answering your questions.
Posted by crmblog | 3 Comments
Thursday, November 20, 2008 9:46 AM

ASP.NET 2.0.50727.0 Warning Event ID: 1309 due to Request time out

Have you ever had users complain about the CRM web application timing out on large operations? If so, you may want to check the ASP.Net timeout setting. The reason for the warning is that the execution time required by CRM connecting with your remote
Posted by crmblog | 1 Comments
Filed under: , ,
Wednesday, November 19, 2008 8:09 AM

Auditing Report Execution using the ReportServer Database

We welcome our guest blogger David Jennaway who is the technical director at Excitation and a CRM MVP. Reporting Services is usually considered at most as just the engine for executing and rendering reports. However, it also has its own SQL database that
Posted by crmblog | 2 Comments
Monday, November 10, 2008 1:23 PM

Reports for CRM 4.0 using SQL Server 2008 and Report Builder 2.0

SQL 2008 Reporting Services SQL 2008 Reporting Services introduces a brand new set of components to be used in reports. A wide variety of chart types, gauge types and matrix reports have been introduced to provide the Dynamics CRM user extremely useful
Posted by crmblog | 8 Comments
Filed under: ,
Monday, October 13, 2008 9:04 AM

Deployment Manager: Import Organization vs. Edit Organization

Most of us know about Import Organization (formerly known as the Redeployment Tool), but I’m sure few of us have heard about the Edit Organization. Today I will explain the differences between Import and Edit, and when we should use one or the other,
Posted by crmblog | 1 Comments
Filed under: , ,
Friday, July 18, 2008 10:14 AM

How it Works: SQL Server Reporting Services and Dynamics CRM

At Tech-Ed Developer in Orlando a few weeks back I lead an interactive session on CRM and Business Intelligence. The session was open to any CRM and BI topic so I expected a lot of hard questions about data mining and the like but the topic of greatest
Posted by crmblog | 7 Comments
Filed under: , ,
Wednesday, May 07, 2008 9:45 AM

Integrating CRM using SQL Integration Services (SSIS)

Today we welcome our guest blogger CRM MVP Darren Liu from the Crowe company. Many Microsoft Dynamics CRM (MSCRM) implementations involved integration with other systems. When I think of integrations between systems, the common approaches pop up immediately
Posted by crmblog | 37 Comments
Filed under: , , ,
More Posts Next page »
 
Page view tracker