Useful MS Dynamics CRM Articles – Part 2

This last couple of weeks have been very very busy.  However, I still have some good articles that I am going to record. I used the following 2 articles to setup a large update on a few thousand records. Importing and Updating Records in Microsoft Dynamics CRM Changing the Lookup Reference When Importing Related Data   And something Read more […]

Useful MS Dynamics CRM Tools Part 1

I decided to start  a list of useful tools and articles that I find each week. Today I was working on something that I needed to do at work.  I have a workflow that I built kind of after the fact.  It is a workflow that is triggered on a field update. I am turning off another workflow that updates that field but I still needed to kick off this Read more […]

MS Dynamics CRM – Recording Negative Durations

I recently needed to track available support minutes where the minutes went into a deficit.  The only problem in MS Dynamics CRM is that duration fields cannot be negative.  Some people would say to just use a regular number field. That was not entirely something I could do since the values being subtracted from the available support minutes were Read more […]

Business Rules in MS Dynamics CRM – What are they?

The official definition from Microsoft is: Simple declarative interface to implement and maintain fast changing commonly used business rules that will be applied to main and quick view forms or to an entity. So what does that really mean in terms of the application and data?  First, let’s talk about what is a business rule.   Wikipedia defines Read more […]

8 Things I Hate and Like About MS Dynamics CRM

I’ve been working with MS Dynamics CRM Online (the subscription version) for about 9 months now.  I’ve come to hate and like parts about it.  That is the nature of working with these types of complex systems. It’s always to get through the bad stuff before you get to the good stuff.  So without further ado, the bad: Building workflows through Read more […]

Book Review: 8 Hour Bestseller

Normally I only write about programming books and programming. I have been thinking about writing a book to put on the Kindle platform. I went on a search and decided on this book by Tim Castleman called 8 Hour Bestseller: How to Write Your Bestselling Book in Record Time.  I know, I know the name is kinda cheesey like a lot of books out there.  The Read more […]

Finding Last 2 Dated Columns – SQL Ranking

Once again, I need to use the Transact -SQL  Rank in a query.  I must be going senile because I always have to review this function.  I don’t always use it but it comes in handy when I get asked to find the last X recorded values. Last nearly always means dated.  So just to save time looking for how to do this appropriately, I  am writing down Read more […]

2 Years of SQL Stored Procedures

It has been 2 years since my last post. Well that sounds like a confession you would give to a priest.  I guess that’s ok though.  Two years ago I was finishing up a PHP project where I had rewritten the backend of a poorly designed customer relationship management system. Well, poorly designed is a misnomer.  It was more of a prototype to what could Read more […]

How to Sabotage your Project in 5 Easy Steps

As I look back some of the projects I worked on, I noted that they had mistakes made early in the project that slowed them down and kept them from being the application could have been by the time the stakeholder closed the doors on them. Some of the mistakes were on the part of the developers but other mistakes were on the part of the stakeholder. If Read more […]

Notes On Guy Kawasaki’s 12 Lessons

1. Experts are clueless. Figure stuff out yourself. 2. Customers cannot tell you what they need. They describe things in terms of better, cheaper, faster status quo etc… they don’t know innovation 3. Biggest challenges beget the best work. Huge challenges are what people rise to do their best work of their career. 4. Design counts. Not price.. Read more […]