There are at least a few companies offering Dynamics connectors for SSIS, and it would be a little challenging to compare all of them. Personally, I used KingswaySoft connector on a few Dynamics data migration projects, and it never failed me. However, it is not the only one available, so you may ask why did I choose that… Read More »
There is something about SSIS that may not be quite clear when you first look at it from the Dynamics data migration perspective. You cannot really use out-of-the-box version to create data migration packages which will work with Dynamics. Actually, that might be a bit too much to say, but, if you are not a developer who… Read More »
Dynamics has an absolutely amazing set of SDK libraries which we can use to turn it into pretty much anything. It’s a bit of a curse, actually, since, every now and then, there is a Dynamics CRM project that involves so much development that you can’t help but think “well, would not it be easier… Read More »
I ran into this blog post today: http://socialtriggers.com/never-say-this-again Which is discussing the implications of saying “I’m doing the best I can”. And, suddenly, I don’t agree with the seemingly obvious. Why? Well, apparently one can use that kind of language to justify their lack of actions. On the other hand, we have natural limits, yet those… Read More »
List of running processes use master Select * from master.dbo.sysprocesses where dbid = db_id(‘DBNAME’) Killing all processes Use master Go Declare @dbname sysname Set @dbname = ‘DBNAME’ Declare @spid int Select @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) While @spid Is Not Null Begin Execute (‘Kill ‘ + @spid) Select @spid = min(spid)… Read More »
Once upon a time, there was a project where an attempt was made to use Dynamics CRM business process stages as navigation tabs. I think it happened, at first, because of some misunderstanding of what business processes are and how they are supposed to be utilized. Still, as I joined the team a few months ago,… Read More »
It will not come as a shock if I say that CRM stands for the customer relationship management. However, I have been wondering lately what it really means to have a tool that can facilitate customer relationships management. First, let me clarify why the question came up at all. I am a Dynamics CRM consultant,… Read More »
If you have a plugin that runs on “delete”, and if you need to detect whether that’s part of a “cascade delete” (in which case you might not want to update some sort of summary information on the parent entity), here is how it can be done: if (context.ParentContext == null || context.ParentContext.MessageName == “Delete”… Read More »
I have seen a few examples of how to handle associate/disassociate messages in the plugins, and I have done it myself multiple times; however, some of those examples don’t work as is, and, more often than not, I have to spend more time than I’d like to on this kind of plugins. The code below is fresh… Read More »
I have been living in Ottawa for almost a year, and one difference I have noticed here is the UNION. Not a SQL union, not that one.. a labour union. Honestly, this is the first time in my not so short IT career where I see a labour union in action, and it is actually… Read More »