Are you interested in a little extra reading on Microsoft Dynamics CRM? Check out this list of 2013 white papers.
Are you interested in a little extra reading on Microsoft Dynamics CRM? Check out this list of 2013 white papers.
Within Microsoft Dynamics CRM each entity has a set of system views. These system views can be configured or added to and as such are a powerful feature within the system. You can even create new views.
So what exactly is a view?
If you are familiar with a spreadsheet, you know that you have rows and columns of data and each piece of data sits in its own little cell. A view in Dynamics CRM is just like a spreadsheet. It has rows and columns of data. Additionally any given view in the system also let's you "click" and export to Excel.
Other powerful features of views include the ability to add columns of data from not just the entity where the view is defined, but from every entity that is related to the entity where the view is defined.
You can also sort views of data by clicking on the header of a column and secondarily sort by shift clicking on the next column.
People using Dynamics CRM can also use "Advanced Find" to create their own personal views of data. So if your IT Department is a bit buried under a long to-do list, you don't have to wait. You can create your own personal views AND you can even share these views with your peers or manager.
OK, so you really don't want to give up Excel and all the pivoting and graphics that you can do with it. Guess what, you don't have too! Views feed Excel and all the powerful data manipulation techniques that Excel offers. Check Out PowerView, PowerBI and PowerPivot, if you love Excel, you will go over the top with these Excel add-ins. CRM + Microsoft Excel "Better Together"
Views have another role within the world of Dynamics CRM. They feed charts, so setup your favorite view and then use the CRM Chart feature to chart the data from that view. These charts can be added to Dashboards for instant, dynamic, graphical love!
If you want to learn even more about views you can read about them in the MSDN library entry called Customize Entity Views.
Posted at 01:17 PM in MS CRM Configuring , MS CRM in Enterprise , MS CRM Knowledge Base Articles , MS CRM Partner Resources, MS CRM Studying, MS CRM Tip of the Day, MS CRM Training Resources, MS CRM Users: Network and CRM SQL Database Administration, MS CRM Users: The Executive Office, MS CRM Users: The Marketing Department, MS CRM Users: The Sales Department, MSDYNCRM04, MSDYNCRM11, MSDYNCRM13 | Permalink | Comments (0) | TrackBack (0)
Keeping up with the incredible Microsoft Dynamics CRM versions in the old days was hard enough, but now the team is updating and releasing at an even faster pace.
These Resources can help
Posted at 09:13 AM in Announcements, CRM Development, MS CRM Partner Resources, MS CRM Selling, MS CRM User Resources, MS CRM Users: The Executive Office, MS CRM Users: The Support Department, MS Dynamics xRM in the field , MSDYNCRM13 | Permalink | Comments (0) | TrackBack (0)
I have recently changed my daily process to include Yammer and the value add has been significant. Take for instance the release of Microsoft Dynamics CRM v2013 Rollup 1, Yammer post with link and discussions letting me know it was available.
If your company currently has YAMMER and you are not using it, you might want to reconsider. Timing is everything when it comes to accepting new and sometimes you just need to re-evaluate on an ongoing basis.
Microsoft Dynamics CRM v2013 has so much to offer and one of the best ways to start getting your head around what is being offered is to regularly attend some great either 100 or 300 level webinars.
Luckily Microsoft is offering such webinars for partners, customers and prospects.
You can find the whole series here: http://www.microsoft.com/dynamics/offers/crm2013demos/
Or if you want to just sign up for tomorrow's session, here is the link: https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032569331&Culture=en-US&community=0
Promote via LinkedIn/Twitter as well! Thanks!
As we move into this bold new world of many different devices, we are also opening the door for many different options for accessing our central Dynamics CRM store of data. When learning about all the different options keep in mind the differences between an application that is built to work in different OS environments such as the new Tablet access to Dynamics CRM and an application that is built for a more specific set of criteria such as a specific Windows 8 CRM Phone applications. Key areas of slight shift are items such as on a phone you are usually talking about the "phone" focus and providers like Verizon and AT&T whereas on a tablet your focus on phone might be Skype or Lync.
It is easy to get confused and Dynamics CRM v2013 offers so much!! I have to admit I am excited.
The Tablet access offers cross browser, but also many different tablet centric features like touch, pinning and choice of surfacing what you want to see where.
The Mobile access offers the really tiny form factor (for those small phones) as well as consideration for offline.
We also continue to have the Outlook Client which leverages all that is Dynamics CRM and all the great features within Outlook and the Web Client Access offering the application from your choice of a set of browsers.
In this brave new world you need to figure out how to best communicate all of the power of choice to your customers, peers and team members. As much as we are One Microsoft and One OS across many different devices, there are certain features and options that are very relavant for some devices and not important to others. Given this the technology you are using and the choices it offers does make a difference.
Choice is also not limited to technologies, it is also all about business culture, department process and individual working styles. The convergence of business and information technology is now!
What is amazing about Microsoft is that they offer so many incredible choices without nickel and diming their customers. They help customers use what they need where from their deep pockets of choice.
Within the world of millions of pieces of data, relating certain data to other data can create a new piece of data. Take for instance a Full Name.
A full name can be considered one piece of data or it can be broken down into two, three, four or more pieces of data. Take the full name : Mr. John Jay Smith III and broken down we see the following:
and these pieces can be data or can be combined to create a number of different data names. John, John Smtih, John Jay Smith, John Jay Smith III, Mr. John Jay Smith III
Why does this even concern anyone? Well these are details that are important within the world of development and coding.
So welcome to Composite Control! A development choice for grouping the need to enter like data through a smooth user friendly interface.
In Dynamics CRM v2013 Composite Control is offered on Name and Address and via the SDK even more can be done.
Do you have a lot of other OutLook Integrations? CRM Outlook Client causing you grief on just one machine?
This rollup includes “process isolation” to split the Outlook Client out from the core Outlook process, an upgrade to SQL CE 4.0, and reductions in isolated performance issues with a large address books (among other things, it’s all in the KB)
General best practice for OnPremise users is to stay within two roll-ups. Just consider the large team of developers writing code, fixing any issues (reported by the millions of users) and continuing to make Dynamics CRM the absolute best CRM product on the market.
Microsoft Dynamics CRM v2011 Roll-up 14 has just been officially released. Learn more here.
Within the world of the CRM Industry there is a cutting edge ...
AND when it comes to the cutting edge pushing the design of data consumption is right up there with tying the use of CRM to employee motivation. As in they get more motived the more they use the internal CRM application. (yes, really, but I will save that for a future post)
Thanks to Mark for sharing this great post and a free solution on data display design - Perhaps take a few minutes to check it out and comment.
Julie Yack has such a great way with words that I just had to share. Take a look at her summary about how you might fit in the world of Dynamics CRM.
oh and after you read the above, here are a few more
You might be a Dynamics CRM Power User if…
You might be a Dynamics CRM administrator if…
You might be a Dynamics CRM developer if…
I won't be at Convergence this year, but I wanted to go ahead and share some getting the most out of the event tips and tricks. because Convergence isn't just about great sessions and learning, but it is also about
2) Meeting the Third Party Providers and ISVs who partner with Microsoft on Dynamics CRM
and add value add
3) Meeting the Microsoft CRM Support Team and technical resources (bring your questions)
4) Meeting the Microsoft CRM Developers and development team (there are new faces to watch for)
5) Meeting other Microsoft team members
6) Communicating with other CRM users (Look for CRMUG)
7) Listening and learning from Authors, Field Experts and great consultants
So In my many years going to and presenting at Convergence I offer you the following
1) Know which sessions you want to go to before you go and have a backup option
(sometimes sessions are sold out)
2) Know who the speakers are: Ask or search the net or read their blogs, being great at what you know doesn't mean you are a great speaker. Look for both!
3) Use Twitter during the conference to keep up with the live session buzz and to connect with other CRM tweeters. My guess is the tweet tag will be #conv2013 or #conv13
4) Know the level of the session: They can range from 100 to 400 and have a lot to do
with presenter and audience. Convergence has both sales sessions to show what is new and deep technical sessions to get you up to speed fast so you have to know how to pick them.
5) Go to the parties and don’t stay at one. Roam from one party to the next and check out the culture, the mood, the tone, the side talks, the buzz
6) Talk to Strangers
7) Eat with people you don’t know and when you sit down, talk to them
8) Make time to visit the bookstore (even if to just see what CRM books are available)
9) Make time to visit the booths (I have had more great technical talks with CEOs at
trade shows than anywhere else)
10) Go to some non-CRM Sessions such as Office, SharePoint and BI – products that work
great together with CRM
11) Go to some business sessions – they have some incredible leaders presenting on
leadership, change management, etc. Many are well recognized business book
writers. (loved hearing Malcolm Gladwell a few years back)
12) Setup a Meet the Expert Connect session and have a one on one with a developer,
business leader, or other resource. A few years back I met with the development team working on a key feature in the newest version of CRM. What a blast to get their perspective.
13) Attend the Pre-Convergence CRMUG Day, the sessions are smaller and the content incredible.
14) Bring business cards, share your business cards, collect business cards AND schedule time when you get home to follow up. Not just the week after, but again two weeks after and a again after 2 months, etc. Networking is about meeting and then building relationships that offer win/win value to both people.
15) Share what you know! Evaluations make a HUGE Difference in the world of Microsoft. Peer to Peer sharing makes a HUGE difference in the success of Dynamics CRM.
16) Attend the last session of the day and the event. Those speakers are sometimes the best, because they draw out the day.
1) It is New Orleans! Get up on the balcony and share the fun of throwing beads at people.
2) Plan to eat incredible food.
3) Don't plan on sleeping too much, but don't burn up all the brain cells so you don't have time to learn.
Posted at 01:57 PM in Announcements, CRM in General, CRM Vendor News, MS CRM General Announcements, MS CRM Partner Resources, MS CRM Selling, MS CRM Studying, MS CRM Tip of the Day, MS CRM Users: Network and CRM SQL Database Administration, MS CRM Users: The Executive Office, MS CRM Users: The Marketing Department, MS CRM Users: The Sales Department, MS CRM Users: The Support Department | Permalink | Comments (0) | TrackBack (0)
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.
1) Unit testing CRM – Some interesting food for thought
2) Enterprise CRM team development – Feedback from the field from Shan (CEO of ADX) and more good food for thought –
A special 2 hour XrmVirtual presentation on Enterprise CRM team development focusing on change management and application lifecycle management (ALM) tools. Here is the event page: http://www.xrmvirtual.com/events/team_dev_ShanMc_CRM2011
The fastest way for you to find out about the hot trending topics from Microsoft Convergence is to go on over to Twitter and to search on #conv12, #conv2012 and (to get a few missed items) #con12. You can also search on #CRMLady (that is me) and #msdyncrm.
The buzz during the event was hot, fast, real time and enlightening. I can't tell you how many times I smiled while reading 140 characters. A quick glance, a smile and back to 100% listening to content.
What was great was to post a thought and then to see all the reviberating thoughts on the speakers while the speaker was still speaking.
In fact at one of my presentations. Someone TWEETED a question, I read it (yes, while speaking) and responded to the entire group. How did I do that? Well there were two of us presenting so the back and forth gave me a chance for a quick peek.
Talk about an entirely different way to present to geeks and introverts - Look out future tomorrows, the power of the introverts enabled!
For anyone ramping up on Dynamics CRM development make note
There are a TON of utilities to make your life easier available in codeplex, Microsoft Downloads, and in the SDK. Some of these utilities are version specific and some are good for all verisons
Go check them out and to get you started here are just a few to wet the appetite
Occassionally the need arises to double check exactly what version of Microsoft Dynamics CRM you are running and when I say version, I mean the exact .0000000 version. Christian recently posted on exactly how one goes about doing that.
His post can be found HERE or below are some of his wise, wise words.
"As many Dynamics CRM 4.0 aficionados know, Microsoft releases regular updates to iron out documented issues [and to sprinkle in a little love]. CRM 2011 is no exception; three Update Rollups have already been released since RTM.
Note that the On-Premise build numbers I list below may be different than what you will find in CRM 2011 Online. Microsoft continuously adds new updates behind the scenes, thus the likelihood of having a greater build number in comparison to the latest Update Rollup version.
To determine your current build number from the IE web client, simply:
To determine your current build number from the Outlook CRM client:
A window will pop up with your build number listed. If you used Outlook, you will see the build numbers for both the Server and Outlook CRM Client (sample screenshot below).
See below for a chart of the Dynamics CRM 2011 build versions. I’ll try to keep it current, so be sure to bookmark and check back later!
PowerObjects had a great little blog post on Internet Explore 8 when it came out highlighting a few of the cool NEW features that are worth learning about if you are using Dynamics CRM.
Now that IE 8 is part of your everyday routine (and you are thinking about IE 9) take a look at this post on some of the features that might have slipped your notice in what you ALREADY have.
Oh and in terms of security (for those of you running other web browers)
"Testing conducted by the independent NSS Labs found that IE8 provided signifigantly better malware blocking capabilities than Mozilla Firefox, Opera, Google Chrome and Apple Safari."
The CRM development team at Microsoft slid in the Microsoft Dynamics CRM Mobility option called Mobile Express a while ago - (I could even say years ago -Check out Settings, Mobile Express) and as far as I can see they have been updating it little by little as the rollups and new versions come out.
What does this mean? It means that Mobile Express is an option worth checking out, BUT that it does not necessarily meet ALL your extensive mobility needs depending on what you need in a Mobile client and what and how many platforms you need it to run on as well as how many extra mobile specific features you want.
The mobile ISVs including TenDigits and CWR Mobility are totally focused on working with mobile teams to empower them and encourage them to get more from their Dynamics CRM Investment. They also have additional features that are integrated so if you need those additional features get the teams at CWR and TenDigits to give you a demo, BUT if you just want to access Dynamics CRM from your cell phone once in a while then take a peek at Mobile Express.
Of note Mobile Express is a Free feature in Dynamics CRM and yes, there are a number of people who don't realize this. Pay to get it configured and to learn the best way to use it from your partner, but don't worry about extra licensing fees.
Articles on Mobility and Dynamics CRM are as follows:
Just because we are a year or two away from the initial release of Dynamics CRM v4 does not mean that we are past some of the long ago solved problems.
Needless to say here is a item that you might want to look into if you are in "Database Cleaning Mode" or if you are having performance issues with a Dynamics CRM v4 footprint.
1) Run cleanup scripts to address existing Database problems!
Warning (probably unnecessary but): Before running any SQL Cleanup scripts backup the database in case you run into problems.
Note: You might want to set the Max Degree Of Parallelism option greater than Zero (1 is just fine) if you are running a multi CPU SQL Server. This option is under the Advanced options of your SQL Server. This one is a bit debatable among the DBAs and CRM experts. On small queries you want to define resources so the system doesn't burn up resources figuring things out and on more complex queries the benefits exist to let the system figure it out.
Now the next question you are going to ask is WHERE ARE THESE Cleanup scripts. Good Question!
Right now most teams (particularly in the larger CRM footprints) have their own or perhaps it is better to consider the partners supporting your CRM footprint. They have their own utilities, tips and tricks for great maintenance as well.
So where do you start?
Start here: An easy way to identify if you are running into an old issue with the AsyncOperationBaseTable is by checking how many records are in this table. Run a simple Count(*) and checking how many records you have of OperationType = ‘10’ and Succeeded/Completed.
If you do have this issue you can go back and check out Ben's blog and/or do a bit of Binging.
Thanks to David Fronk at Dynamics Methods for sharing a quick little trick for changing a field to be set to Case Sensitive. Now before I share this tip be aware that it is NOT supported by microsoft so what this means is that a Rollup, A SQL Server Update, a Upgrade or any other quick little patch might disable this feature.
This tip was also shared in the heavy v4.0 Days of CRM so when it comes to SQL 2008 R2 you might have to updated the steps.
Now on that note here is the link to David's quick checklist for setting the Case Sensitive Flag.
Partners Restart your Engines!
Have you downloaded the latest Microsoft Dynamics CRM 2011 VPC? As per most VPCs from the CRM team it is packed with a TON of goodies BUT this version not only has your traditional CRM it also three other xRM Models.
Now if you want to really drive yourself a bit nuts and burn some time you can take this new VPC and load it up on an underpowered Windows 7 laptop. Ouch! I mean imagine running Windows Server, SharePoint, CRM and more all within a virtualbox on a laptop with 2-4 gbs of ram. Oh it an be done, but you will not be impressed.
So Tip 1
Get the Hardware where it needs to be for demonstrating all the cool power of this incredibly powerful product! If all you have is a laptop then at least max it out with as much RAM as possible and use an external drive (or internal solid state).
Windows 7 Virtual PC cannot run Windows Server 64bit. Yes, this VPC is 64bit so if all you have is a Windows 7 laptop you are going to have to depend on alternative virtual technology support such as Virtual Box from Oracle.
Take a little bit of time and configure the image so that it uses it's resources in the most efficient and best manner possible. Even if this requires that you grab the ear of your infrastructure or Virtual guru.
Make it yours - remove what you don't need, change the data to better fit how you talk about the product and add your own views and reports.
DEMO TO WIN - An incredible class that Microsoft has offered over the years. This little class really helps people who are tasks with demonstrating any software to understand how to both present and how to best present demonstrations of applications. Look it up, Sign Up, take the class.
HAVE FUN! Technology solves some really painful business problems. You can be part of this solution, but in this really noisy world it isn't easy, but it is worth it.
Wow - CodePlex grew while I wasn't paying attention. There are now almost one hundread different free solutions available, all with interesting hints of cool stuff.
The Microsoft Dynamics CRM development team has released CRM v4.0 Rollup 16 and not only have they managed to resolve some of the issues reported from the field, they have also fine tuned some of the existing features. (it is amazing what a team of programmers writing code every day can create in 8 weeks) Particularly given there are change control processes, testing processes, QC, Builds, Deploys and more to pull together.
Do you have feedback?
Share your comments !
If you work with any of the Microsoft Dynamics products or if you are just thinking about jumping onto the xRM/CRM bandwagon then you will want spend some time thinking or rethinking about attending Convergence 2011 in Atlanta!
Microsoft Convergence is one of the largest Microsoft shows in North America and as such it draws a large number of cool people from a wide variety of vendors and from Microsoft. I love just having a chance to sit down for 15 minutes or so with a number of different partner contacts, support staff, guru field experts and even the people who happen to sit next to me at breakfast. There are so many fascinating minds at work in this world!
Additionally although some of the presentations can be a bit too marketing oriented (the last couple of years have shown huge improvement in this area), there are even more that are totally intense field feedback packed. Not to mention that many of the speakers come right from the front line.
Realize that this year the EXPO hall at Convergence was sold out way in advance. Welcome back buzzing economy! AND the conference attendence is so full that Microsoft marketing doesn't have to do much so don't expect any extra motivation from your local Microsoft Rep!
Here are my top 5 tips for getting the most out of Convergence 2011 AND if you are going to be in Atlanta watch for me!
1) Spend the time to setup meetings in advanced. These can be a quick lunch, a specific breakfast table or an agreement to go to selected sessions together. Meet with people you don't know! A lot can be accomplished in those first 15 minutes before a presentation starts.
2) Line up your agenda now, but give yourself choices. One of the morning sessions might influence which session you pick in the afternoon.
3) Know the speakers and pick the speaker that is going to offer you the content at the level you are interested in. This could be highly technical, a mix of business and technical, 101 or case studies.
4) Make time to visit the Expo Room so you can connect and learn about all the incredible third party offerings. Many of the people in the booths are GREAT contacts to know from CEOs, to developers to passionate CRM gurus.
5) Attend DAYOne sponsored by CRMUG and supported by xRMVirtual. It is a great way to warm up, ask questions, find out how the week will unfold and meet some of the people who spend a significant amount of their time helping the community and learning from answering CRM specific questions.
6) Follow the TWEETs on the event so you know where things are happening and what you don't want to miss. The tweets let you find out about unpublished events and can give you access to Convergence experienced feedback minute by minute. #CONV11
Posted at 09:28 AM in Announcements, MS CRM General Announcements, MS CRM ISV and 3rd Party Add-on Products, MS CRM Partner Resources, MS CRM Training Resources, MS CRM User Resources, MS CRM Users: Network and CRM SQL Database Administration, MS CRM Users: The Executive Office, MS CRM Users: The Marketing Department, MS CRM Users: The Sales Department, MS CRM Users: The Support Department | Permalink | Comments (0) | TrackBack (0)
For those of you who are cruising along on your last years knowledge of xRM development habit you might make a note to add a task to your to do list!
SDK v4.0.13 (and SDK v4.0.12) offers NEW options and CHANGES old accepted xRM development practices
This release includes the new Advanced Developer Extensions for Microsoft Dynamics CRM, also referred to as Microsoft xRM. This is a new set of tools included in the Microsoft Dynamics CRM SDK that simplifies the development of Internet-enabled applications that interact with Microsoft Dynamics CRM.
In addition to the documentation, this download package includes the projects for all sample code found in the documentation, and full featured samples that are not included in the documentation. The package includes a visual style guide you can use to make your customizations fit in smoothly, and a style sheet you can use as a basis for your work. There are also tools and helper code provided in this package. Look for regular updates to this SDK!
So now that you have completed all your New Years Resolutions (or abandoned them) take a bit of time and do a bit of deep diving into the new v4.0 SDK
and for those guru, gurus who are developing on the v2011 platform. The same applies :) as many of the new concepts within the sdk world made it into the v2011 SDK world as well.
A late but very heart felt congratulations to the Microsoft Dynamics CRM Development team who have now officially released Microsoft Dynamics CRM v2011 OnPremise.
Not only do they now have Microsoft Dynamics CRM Online v2011 and Microsoft Dynamics CRM OnPremise released, but they released the OnPremise version ahead of schedule.
Sweet ! Download Information (warning: please do not try to install without reading the implementation guide)
(They now shift their focus to Microsoft Dynamics CRM 2011 Rollup1 and the next version)
I just found this great little How To series on creating custom reports in Microsoft Dynamics CRM.
This little series is a great learning tool for the interns that dive into learning about the world of Microsoft Dynamics CRM.
Microsoft Dynamics CRM 2011 has been released now both as an Online offering and as an OnPremise offering.
The buzz from the field is that the product is packed with 500+ new features and a ton of new options with regards to customization and after working with the product I have to agree. The team is offering some incredible power and flexibility while still maintaining all that is great in v4.0.
Power however comes with a price. As partners and customers across the world learned in Dynamics CRM v3.0 and v4.0 if you don't take the time to understand then it is easy to dig your own hole of frustration.
So how can this be avoided by those just getting interested? Particularly given that 2011 offers even more!!
Here are five key steps to getting off on the right foot!
1) Take baby steps and small bites, grow with the product
2) At a minimum READ the installation guide twice (OnPremise)
3) Remember, just because it is easy to configure and customize doesn't mean you know the best way to configure and customize. Tap into experience.
4) Good "CRM" partners have already invested in the basics and offer those as part of every project (why pay to rebuild these, just for the learning exercise? There are better ways)
5) Senior .NET developers who don't know XRM/CRM still have a lot to learn when it comes to thinking XRM. Junior XRM/CRM developers still have a lot to learn when it comes to thinking .NET
and as a little bit of extra - Item 6
6) Many of the features within Dynamics CRM are version 4.0! but some are v1.0 - set proper expectations when utilizing a specific feature set.
Kicking off the New Year, this new page is packed with all things Microsoft Dynamics CRM 2011! If you are planning, prepping or in general curious about the next version of CRM you might want to take a peek.
David Jennaway has a great post on the Asynchronous Service as well. You can read some of it here and link to the rest over on Dave's great CRM blog at http://mscrmuk.blogspot.com/
CRM 4.0 UR 3 brought in a useful feature, the ability to configure the CRM Asynchronous Service to automatically delete records from completed asynchronous operations, and hence keep the size of the asyncoperationbase SQL table down to a reasonable size. This behaviour is configured by the registry values AsyncRemoveCompletedJobs and AsyncRemoveCompletedWorkflows
At the moment, the only workaround I have is to remove the registry values, and to use a scheduled SQL job to periodically clear out the asyncoperationbase table. Here is an example of such a script.
Thanks to Matt Wittemann over at ICU MSCRM
Posted by Matt Wittemann
There have been several KB articles and updates published to help control the size of the AsyncOperationBase table, which can cause your CRM database to grow very large, very quickly. (See here and here.) But just what are all those records anyway?
I pulled the following lists together from the SDK and technet in order to put this info in one place, where it’s a little more user-friendly (at least for me!).
First, the list of AsyncOperationTypes:
READ MORE at
|1||Event||Specifies a system event.|
|2||BulkEmail||Specifies a bulk e-mail operation.|
|3||Parse||Specifies an import file parse operation.|
|4||Transform||Specifies an operation to transform parse data.|
|5||Import||Specifies an import operation.|
|6||ActivityPropagation||Specifies a campaign activity propagation operation.|
|7||PublishDuplicateRule||Specifies an operation to publish a duplicate detection rule.|
|8||BulkDetectDuplicates||Specifies a bulk duplicate detection operation.|
|9||CollectSqmData||Specifies an operation to collect SQM data.|
|10||Workflow||Specifies a workflow operation.|
|11||QuickCampaign||Specifies a quick campaign operation.|
|12||PersistMatchCode||Specifies an operation to update the matchcode.|
|13||BulkDelete||Specifies a bulk delete operation.|
|14||DeletionService||Specifies a Deletion Service operation.|
|15||IndexManagement||Specifies an index management operation.|
|16||CollectOrgStats||Specifies an operation to collect an organization's statistics.|
|17||ImportingFile||Specifies an import subprocess operation.|
|18||CalculateOrgStorageSize||Specifies an operation to calculate an organization's storage size.|
|19||CollectOrgDBStats||Specifies an operation to collect an organization's database statistics.|
|20||CollectOrgSizeStats||Specifies an operation to collection an organization's size statistics.|
|21||DatabaseTuning||Specifies an operation for database tuning.|
|22||CalculateOrgMaxStorageSize||Specifies an operation to calculate an organization's maximum storage size.|
|23||BulkDeleteChild||Specifies a bulk delete subprocess operation.|
|24||UpdateStatisticIntervals||Specifies an operation to update statistic intervals.|
|25||FullTextCatalogIndex||Specifies an operation to generate an organization full text catalog index.|
|27||UpdateContractStates||Specifies an operation to update contract states.|
|30||ReindexAll||Specifies an index management operation.|
Next, here’s a list of the different state/statuscodes that each of these operation types can be in:
|State||Status||Numeric status value|
Hope this is useful to you! Have fun with it.
Over the years I have been asked what skills are required for a really good Microsoft Dynamics xRM (CRM) Master?
Needless to say when I saw this post, on some of the interview questions used in a Microsoft Dynamics CRM Developer interview, I thought they were fun to share.
The other resource, that perhaps many have not yet tapped into, is the job descriptions carefully documented as part of the Microsoft Dynamics CRM SURE STEP application.
Do you have favorite interview questions for the next or current generation of Master Dynamics CRM resources? (Developer, Subject Matter Expert, Customer or IS Test Lead, Installation and Infrastructure support, Business Analyst, etc.)
A big shoot out to Microsoft Dynamics CRM Support. I know they cringe (or run) when they see it is a rare support call from Anne, but I did want to say that I really appreciate all the hard work that the guys in North Dakota put into solving some of the toughest problems. They use team work, a win/win attitude and have they have a keen ability to listen with an open mind to get to the root of things.
All you CRM GURU, GURUs in the field - if you have not shared your latest edge case discovery with support lately then I would encourage you to document and post to the appropriate CRM Forums. "Help thy neighbor, helps thy self."
Create a simple Ad Hoc Report
Save and Export to an RDL file
Now do the same report directly using Visual Studio and SQL Reporting Services
Compare the two RDLs. Notice anything different?
I recently had the chance to do this and opened a few programmer eyes. As it turns out CRM offers a few tricks to the trade when it comes to getting what you want out of the system. Now from a programmer's view these might be "cheats" but from an application point of few these are features that every programmer working with Dynamics CRM might want to know about.
So the next time you tap into an expert SQL resource for some SSRS reporting, take a few minutes to talk about the Dynamics CRM platform and the features and functions they might be able to leverage.
Also never forget that there is a TON of field experience shared within the world of blogs, twitter, linkedin, CRM forums and even facebook.
This week this post peeked my interest.
Over the years I have been keeping my eye on the Microsoft SureStep Project Methodology. It was originally very ERP centric and as many of the CRM Consultants in the field know - CRM and ERP are very different projects! The audience, the style of design and the rollout are a different mindset.
Consider for instance that an ERP project is focused on a small group of people in the financial department with some interaction from management. CRM on the other hand spreads far and wide and can impact ever department and every person within a firm.
Needless to say despite keeping on eye on SureStep I have yet to embrace it.
With my latest deep dive into the application I can say that it has matured to a point where it is definitely worth checking out. There are still documents that need updating (references to Payroll and AP), but there are also a number of documents that can make your CRM projects much more professional, more organized and more successful.
So if you have not taken a look at SureStep and you are "reinventing the wheel" with regards to project templates or you think it is time to update what you are using then I would suggest that you log into Microsoft PartnerSource and download SureStep.
You are a new customer to Microsoft Dynamics CRM and one of your first questions might be "How do I get started?" and "What training resources are available to me?"
The Top 7 8 New Customer Resources
1) Microsoft Partner of Record: Never under estimate the power of working with your Partner of record. Microsoft Dynamics CRM partners have been there and many times done that and they have a variety of resources available including consulting services, training options, white papers, and relationships to key contacts both at Microsoft and within the ISV (add-on applications) community. I might also add that if your partner of record isn't working out you do have the power of choice. Invest in a win/win relationship.
2) Books: There are now a number of books available which provide a solid foundation of knowledge. These can be found at your local and online bookstores. For the developers search on the following authors: Mike Synder, Jim Stegner and David Yack and for the users the Microsoft Step by Step book and you can get a good primer and start from my book "Teach yourself Microsoft Dynamics CRM in 24 hours"
3) User Groups: There are two great user groups providing some awesome recorded and live training sessions. The XRM User group has a focus on the people working with, developing in, extending and customizing Microsoft Dynamics CRM and the CRM User Group has a focus on leveraging the CRM features of the software to their highest potential. CRMUG additionally has some special interest groups based on industry and both XRMUG and CRMUG have local chapters.
4) Blogs: I follow about 60 blogs (all on Microsoft Dynamics CRM) and I know there are more that I am most likely missing. I have a couple of favorites when it comes to a user focus and the first is Richard Knudson's Dynamics CRM Trickbag blog. Richard is a Microsoft Dynamics CRM trainer and as such his blog is packed with learning CRM resources. The second is the Microsoft Dynamics CRM Team blog which is a great place to search for answers.
5) Dynamics CRM Forums: In the Dynamics CRM forums you can post a question and you will get a variety of answers. No questions is to basic! There are forums for all the different audiences using and working with Dynamics CRM. My personal tip: When working with the forums make sure you post your question in the right forum to the right audience. For instance if you have a question about sales process then you might not want to post that in the developer forum.
6) Twitter, LinkedIN and Facebook: On Twitter Search on #MSCRM and you will immediately feel the buzz. If you are not tweeting or if you are just getting into twitter then choose to follow one or two of the consultants in the field and feel free to post your own questions using the #MSCRM tag. On LinkedIn and Facebook (Jim Glass, Guru CRM Community Liasion) has some awesome Dynamics CRM Groups where people from all over the world share information.
7) Microsoft Dynamics CustomerSource: CustomerSource is a benefit of your service contract and is managed by Microsoft Business Solutions.
8) Don't Forget the resources within the third party software vendors (ISV's): The Independent Software Vendors writing solutions on top of Microsoft Dynamics CRM have a TON of educated and trained resources. Talk to them, invite them in to do a presentation and ask them about the Dynamics CRM way of life.
Learn to Think CRM
Posted at 07:52 AM in MS CRM Partner Resources, MS CRM Studying, MS CRM Training Resources, MS CRM User Resources, MS CRM Users: Network and CRM SQL Database Administration, MS CRM Users: The Executive Office, MS CRM Users: The Marketing Department, MS CRM Users: The Sales Department, MS CRM Users: The Support Department | Permalink | Comments (0) | TrackBack (0)
You wouldn't add nitro to just any car without a good bit of knowledge and the same holds true with the Microsoft Dynamics CRM Accelerators. They are powerful! Just put them in the right hands, with the right knowledge and a little bit of tender loving polish and look out.
My hope is that Microsoft will continue to increase the amount of polish, but for now know what you are dealing with and don't expect to just drop in the fuel without understanding.
Release 2 of The Partner Relationship Management (PRM) Accelerator has now been posted. The PRM Accelerator allows businesses to use Microsoft Dynamics CRM to distribute sales leads and centrally manage sales opportunities across channel partners.
The cool team over at Power Objects has a nice little post that my library and I wanted to go ahead and share it.
Have you ever had a need to send a generated report in PDF format to someone? The PowerObjects team has developed a workflow extension that allows any user to schedule a SQL Server report to be sent via email.
If you are looking at importing a large amount of data into Microsoft Dynamics CRM then you might want to get caught up with this post Speed up your CRM SDK imports and updates
If you are a Microsoft PARTNER then you will definitely want to check out the current version of the SureStep Project Methodology for Microsoft Dynamic CRM (I think they finally got it) AND have a few of the consultants take the exam
Are you looking for more Address Data Validation? How about tying to a Standard Source? Check out PostCodeAnywhere Address Lookup.
Trying to Solve a Problem with Dynamics CRM v4? Did you turn on Trace? Scott gently offers a reminder on problem solving and disk space.
It is snowing and raining in New England today and yet we have had an early spring! The daffodils are blooming, the grass is green and the buzz of the Microsoft Dynamics conference "Convergence" in Atlanta is in the air!
If you are an Enterprise Dynamics CRM USER or IS Contact at an Enterprise account you will want to mark the underground lunch meetup on your calendar. We are meeting at lunch on Sunday at the edge tables in the lunch room. (signs on the table) This is informal so please come on over and introduce yourself to some peers!! (Meals are in Building B, Hall B3-4)
If you are not planning on attending Convergence you might want to reconsider after reviewing Julie Yack's great post on "Why Convergence?" or you might want to follow the Microsoft Convergence threads on Facebook or search Twitter via #CONV10. Some of the best information on Dynamics CRM is FIELD learning and there are not many places where you can get this kind of training from peers.
Key things to make sure you do!!
1) Plan on spending time after sessions finding out about where information is being "shared"!
2) Sit down for 15 minutes or so with the Dynamics CRM Technical support team. They have usually have a few kiosks or booths.
3) Find out about the Dynamics CRM events/parties and after hours networking. I have learned so much from these!
4) Don't be shy talk to the people you sit next to on the buses. To and from the hotel, to and from events, etc.
5) USE MICROSOFT CONNECT and setup at least one meeting.
I will be doing/participating in two presentations. One is sponsored by CRMUG (a great learning resource) and it will focus on "Is the Customer always right?" and the other is a panel with a few of the developers where they ramp up a totally new Dynamics CRM/XRM solution in two sessions!!
There is a week left! It is not too late to register! Come on down and join in the fun.
If you are in the ATLANTA area you can also consider a Day Pass!
Just a small bit of code placed in just the right place. Sometimes the biggest business benefit is not necessarily the biggest development effort.
A small little button opening a world of possibilities.
Posted at 09:12 AM in CRM Development, MS CRM ISV and 3rd Party Add-on Products, MS CRM Partner Resources, MS CRM Selling, MS CRM Tip of the Day, MS CRM Users: The Executive Office, MS CRM Users: The Marketing Department | Permalink | Comments (1) | TrackBack (0)
One of the benefits of blogging is having a place to capture items that might be worth remembering when problems occur.
Recently Microsoft released a technical article on running Microsoft Dynamics CRM v4.0 in a Windows 2008 64 Bit Server environment.
Some of the Key Items include an
"Error message when you try to open the Microsoft Dynamics CRM 4.0 Web application"
but the article also includes work arounds to many of the issues discovered in the field.
For those of you who work within a Feature Driven Development model (FDD) there are a number of great resources on the whole subject area on this website.
The Nuts and Bolts article Outlook Synchronization in Microsoft Dynamics CRM 4.0, which is available for download from the Microsoft Download Center:
Outlook synchronization enables Outlook users to view Dynamics CRM information, including contacts, tasks, phone calls, letters, faxes, appointments, and e-mails, within the Outlook interface. This document describes the client synchronization process that is associated with Update Rollup 7 for Microsoft Dynamics CRM 4.0 or later (for on-premise deployments) and with Microsoft Dynamics CRM Online November 2009 Service Update or later (for online deployments).
Posted at 12:21 PM in Announcements, CRM Development, MS CRM General Announcements, MS CRM Knowledge Base Articles , MS CRM Partner Resources, MS CRM Studying, MS CRM Tip of the Day, MS CRM Training Resources, MS CRM Users: The Support Department | Permalink | Comments (0) | TrackBack (0)
Take a look and Get Ready
Update Rollup 9 for Microsoft Dynamics CRM 4.0 will be available February 11th