Archive for September, 2010

Difference between ETL and ELT

September 22nd, 2010 No comments

Today I heard an interesting answer to the question : what is the difference between ETL and ELT ?
The answer is : in ETL the transformations are processed by the ETL tools while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
Read more…

Repair the TCP/IP protocol under Windows

September 20th, 2010 No comments

Lately, I have had problems connecting to the internet. The connection would last for 2, 3 or 5 hours before it would fail again.
After trying many methods, I found out that the problem was the TCP/IP protocol itself.

There is a way to repair a damaged TCP/IP protocol, which is a core component of Windows.
Under DOS, with administrator rights, type in the following commands :
Read more…

Categories: Microsoft Tags:

First introduction to NoSQL

September 16th, 2010 No comments

This week, I attended a meeting about NoSQL. And so here is a summary of the notes i have taken and what i have learnt and understood, so far.

First, what is NoSQL ?
That term stands for (N)ot (O)nly SQL. A detailed definition can be found on Wikipedia.
Read more…

Categories: Databases, NoSQL Tags:

How to use customized entities

September 9th, 2010 No comments

CRM Dynamics contains native entities (contact, account, opportunity, appointment …).
The CRM SDK API already contains specific classes for these native entities.
It is possible to create customized entities. To use them in programs, i found that there
are two options for that : either use crm webservice or use the CRM SDK API. With the latter option, you have to use Dynamic entity to access your custom entities.
Read more…

Categories: .Net, C#, CRM, Dynamics CRM, Visual Studio Tags:

Steps to run a plug-in for the Dynamics CRM in debug mode

September 8th, 2010 No comments

Here are the steps to run a plug-in in debug mode
1) In Visual Studio (BIDS), build the project
2) Copy the generated DLL file and the PDB file (they are located in the project folder, under bin\Debug) to the CRM assembly folder : C:\Program Files\Microsoft Dynamics CRM\Server\bin\assembly
3) Deploy or redeploy the plug-in using the Plug-in registration tool
Read more…

Categories: .Net, C#, CRM, Dynamics CRM, Visual Studio Tags: