Previous month:
November 2012
Next month:
February 2013

To the SQL Guru Audience - Can I write directly to the Microsoft Dynamics CRM SQL Database?

If I had a dollar for every time the following question was asked in the field I could.. ! Well here is a much better response then a flat No and my thanks to Steven Vlaanderen Oldenzeel from Microsoft PFE for sharing!

Can I write directly to the Microsoft Dynamics CRM SQL Database? 

  1. We will support everything you would do when you are using the CRM application layer.
  2. For CRM users we do NOT allow direct SQL Server connections, except for excel touching filtered views (but the user might not even know how this technically works).
  3. For a DBA, CRM Consultants and other technicians, we will allow anything you do on the SQL Server directly (maintenance, indexes, select statements), but we cannot support it, but your SQL team can support it. This means, test it first and document it properly!
  4.  We will NOT allow direct data inserts or updates at all. Do this via the CRM application layer and do not bypass the CRM Security model. This also counts for writing SP’s, Triggers, Functions directly on SQL. Please use Workflows and Plugins.

 


Keep Learning

I am amazed at how I continue to learn more  and more about Dynamics CRM despite focusing on the platform for over eight years. The product team continues to release small and large updates and are amazing in how fast they manage to keep up with the pace of technology change.

Additionally the current product (even before any updates) has a ton of depth and a number of under utilized functionality. When was the last time you decided to add something new to your business processes? What about learning one small area of the software in full?

Consider Goals, or Connections - take a peek at subjects or perhaps you want to become a FetchXML guru

Did you know you can tie web sense into charts?

There is so much that can be done.

Given this I offer this link and suggestions: Go review the Microsoft Dynamics CRM v2011 IMPLEMENTATION GUIDE. You might not have looked at it for a few years, a few months or even ever and it is packed with great information. So take an hour for study, each day this week - shoot make it a team effort and start up a Dynamics CRM brown bag lunch or book group. You will be pleasantly surprised.