Using an ERD tool to create CRM entities

I get asked this now and then: “I want to use Erwin [or Visio or Visual Studio or…] to graphically design the CRM entity model, then have the actual CRM entities generated off of the tool I used to design the entities.” While I am not aware of a direct way to do this with…

2

CRM and SQL 2012 AlwaysOn Availability Groups

I’ve spent a fair amount of time lately talking to people about the benefits of using SQL Server 2012 AlwaysOn Availability Groups in your CRM infrastructure.  I just came across a great video that’s a great primer on AlwaysOn Availability Groups: Here is a link to the SQL documentation as well: http://msdn.microsoft.com/en-us/library/hh510230 AlwaysOn is already…

1

The new bulk API in Polaris/UR12

If you haven’t heard, CRM Online has completed the Polaris rollout and UR12 is available.  With it comes a new bulk API which makes programmatic data import into Dynamics CRM 2011 faster.  Check out Sonoma Partners blog post on a simple benchmark of the improvements.  As you can see, it’s really worth moving to this…

1

Converting a SQL report to FecthXML

Scenario: “I want to move to CRM Online, but I wrote all my SQL Server Reporting Services (SSRS) using the SQL Data Source.  How do I convert them to use FetchXML?” Below I have three reports: All three reports will look identical to the end user in the end. facilityFetch.rdl – Written using the “Microsoft…

3

Data Migration with CRM 2011

UPDATE (18APR2013): If you find this post interesting, then you will want to watch the Enterprise Data Integration for CRM, featuring Daniel Cai webcast. “I am building a solution using CRM 2011, but I need to migrate a significant amount of data from an existing system.  The Import Data wizard in the CRM 211 UI…

2

My Gov2.0 Expo presentation on Bing Maps / OData

You can find my deck here: http://cid-1f72da7294089597.skydrive.live.com/browse.aspx/Public/Gov2.0Expo I plan to have my OData + Entity Framework + SQL 2008 spatial demos packaged/cleaned up some time this week.  I will also record a deeper walkthrough of the demo/sample and publish it to Channel 9 some time soon.

0

US Census Data for SQL Server 2008

I’m presenting at Gov 2.0 Expo on May 25th: http://www.gov2expo.com/gov2expo2010/public/schedule/detail/14877 Since SQL Azure will support the Geospatial types soon, I’m planning on showing a demo that shows what will be possible once it does.  For details on the announcement of the upcoming SQL Azure features, see: http://blogs.msdn.com/sqlazure/archive/2010/03/19/9981936.aspx As part of my demo preparation, I was…

1

SCREENCAST: Running Reporting Services Reports in Windows Azure

In this screencast, I show you how to run a SQL Server Reporting Services 2008 report in Windows Azure using the ReportViewer control that ships with Visual Studio 2010.  As an added bonus, I demonstrate using ReportViewer against an OData service through the use of WCF Data Services client libraries and the ObjectDataSource. Direct link…

3

Virtual Earth, SQL 2008, & GeoJSON

I’ve been chatting with Vish over email.  He made me aware his approach to getting SQL 2008 & Virtual Earth to play well together using GeoJSON.  I actually didn’t know about GeoJSON.  Thanks Vish!  Check out his post explaining the approach: http://viswaug.wordpress.com/2008/06/02/sql-server-2008-virtualearth-made-easier-and-building-a-rest-api/ Technorati Tags: .net framework,sql server 2008,virtual earth,wcf

0

Want to access SQL Server 2005 from PHP?

You are in luck!  Version 1.0 RTM of the SQL Server 2005 Driver for PHP is live!  Check out the SQLPHP blog for more details: http://blogs.msdn.com/sqlphp/archive/2008/07/28/microsoft-sql-server-2005-driver-for-php-v1-0-has-released.aspx Technorati Tags: sql server 2005,php

1