Showing posts with label performance. Show all posts
Showing posts with label performance. Show all posts

Friday, November 10, 2017

CRMUG Summit 2017 Recap

It’s hard to believe that CRMUG Summit Nashville was already a month ago! The 2017 event was amazing! Full of live music, great content, and lots of networking! Of course, the #CRMUGDC Monkey was hanging around and we even had a party for all the DC, Virginia, and Maryland Attendees. If you didn’t make it out to this party, be sure to check out the Photo Gallery.

Better late than never, check out the top takeaways from the sessions I attended at #CRMUGSummit2017 (I also linked to the materials for those who attended Summit to download).


Alex Fagundes

Data breaches are very common and very expensive plus on average the breach isn’t detected until after over 6 months. We discussed statistics, ways to prevent and detection techniques. In addition several tools were discussed for different security functions.

Top ways to prevent:

·       Move to CRM Online – 99.9% more secure

·       If On Premise: Set up external and internal scans weekly to check for issues and follow best practices (network and windows server hardening best practices)

·       Have a security awareness program to train your users – they are the weakest point! Plus minimize their security to eliminate risky access they don’t need (Export to excel, SDK access, etc.)

·       Follow Service Account best practices – one server account per integration, do not grant admin rights, set as a non-interactive user (cannot login via the web)

·       Turn on Two Factor authentication




Rick McCutcheon leading a panel featuring: Peter Vieira, Anne Stanton, Beth Burrell, Jennifer Codding, and Neven Bradasevic and Melita Bouchet.

The panel broke the discussion into the different phases of the project and discussed their tips and tricks for user adoption including:

·       Set expectations for the initial release

·       Gather information from your users and identify your key stakeholders and champions

·       Involve end users in the building process

·       Discuss end results with stakeholders especially reporting needs – Remember that data has value and explain this to users

·       Don’t forget about less frequent tasks users need to perform (What tasks do you perform weekly? Monthly?)

·       Find the low effort, high reward items to resolve pain points (the gold nugget)

·       Involve department influencers in testing

·       Plan trainings carefully

o   Set up groups based on level of skill with the system, knowledge of past systems, keep departments together

o   Find Training Champions to become subject matter experts and help other users

o   Consider pairing stronger and weaker users together to assist each other

o   Keep training materials specific and provide in multiple formats (manual, video, email, etc.)

o   Use real data to keep training relevant




Alex Fagundes

So many tips on performance and many beyond my level of expertise. Here are just my top takeaways that I can put into practice:

·       Use a modern browser with temporary files (cache) set to >=250 MB

·       Views – sort by only one column, minimize or eliminate columns from related entities

·       Remove “All Accounts” Default views on large entities, no reason to display everything

·       Forms – Collapse unnecessary sections, avoid using too much JavaScript and instead use multiple forms

·       Workflows – keep Asynchronous, auto delete when complete and only have ONE running per entity (then use child workflows for different actions)

·       Follow SQL Best practices and use tools to review your indexes

·       Avoid Plugin chains – one plugin triggering two more

·       Run enterprise reporting against a read only replica of your system

·       Set up automated monitoring that can notify you if there is an issue



Panel featured Jennifer Johnson, Trisha Tunilla, Rob Harrison and Victor Guven

This is a topic that I especially needed assistance on – how to help Marketing and IT get along and get the results both sides want. The major take away from this session was just to get shared understanding on both sides. Have IT spend time with marketing to understand how they manage their business. Have Marketing learn more about the systems so they can better understand the framework. Build relationships on both sides to ease the process of working together.

This understanding and personal connection will build the trust necessary to get work done. When work comes from the other side, the team knows it is necessary. Most of the problems between marketing and IT can come down to poor communication. Take the time to build that understanding.

We also spent some time discussing the value of data and what to do with “dirty” data. These discussions can be hard when IT may not want “bad” marketing data in the CRM system. This comes down to determining a data governance plan at the beginning. This allows us to choose what data is the master and what data can go where. Remember that marketing sees all data as an opportunity!


Ryan Talsma

This was an excellent session that helped to clear up the confusion between the Outlook App and the soon to be deprecated Outlook client (expected to be gone by the 10.0 major release, end of 2018?).

Most importantly – the App is available for On-Premise. The main difference is that the Client must be installed on all workstations where as the App is a light-weight add-in pushed via Office 365. The App does require Office 365 and Server Side Sync. Server Side Sync means that the user does not need to be logged in for a workflow to send email and appointments can sync when out of the office as well. The App is also much more stable than the client so fewer (if any) issues with disconnecting, re-enabling, etc.

Last important note – the App can be pushed out to users if webmail (OWA) while they still use the full Outlook client on their office machines.




Panel discussion featuring Nhung Le, Bill Meadors, Beth Burell, and Phyllis Eriksen.

In this session, common issues were broken down into a few categories and then tips were discussed for how to handle each type.

·       Permission Problems

o   Do not edit the Out of the Box Roles – then you can review these if issues arise

o   XRMToolbox: Access Checker – select the user and entity to see the final permissions they have with all roles combind

o   If intermittent – try clearing the cache and restarting

o   Remember with Field Level Security – no access is granted by default

o   If it could be a permissions issue, assign Admin role temporarily to see if it resolves the issue. If it does, then the issue is permission related.

·       Data Import/Export Errors

o   Review the data mapping

o   If error on export, verify there are no duplicate field names as this will cause an error

o   To update data, an export must be done (must export for re-import, you cannot import and match)

·       Error Messages with no Information

o   Check Application log for details

o   Use Auditing to isolate issue (do not turn on for everything)

o   F12 for client-side troubleshooting

o   On-Premise: monitor event log for errors. These could be a sign of something bigger.

·       Testing tips

o   Clear cache and try to reproduce

o   Turn on F12 then try to reproduce

o   Test on a different browser, different computer, etc.

o   Check browser plugins




Gus Gonzalez

This session covered some great tips to keep in mind for all changes being made in your system. The goal of many of these is to change our thinking to implement with a business mindset as we want to enhance business outcomes not just think about the technology. These rules exist to help us avoid potential problems.

1.       Keep it simple – always look for the simplest, easiest, least work solution.

2.       Check before Create – if you can use something that already exists, use it. Avoid adding additional entities, fields, views, etc.

3.       Allow users to deactivate – remove delete permissions. Tell them “Deactivate” is the CRM word for delete, same behavior from a user perspective.

4.       Don’t customize production – plan then deploy to development, move to test and test, then deploy to production. Use unmanaged solutions.

5.       Use Tools – When getting a requirement, see if there is a tool you can use before building yourself.

6.       Change management systems – follow a change management system to help you implement successful change

7.       Field best practices

a.       Never use “Whole Number” because they may want more precision later

b.       Stay away from “Two Options”, use Option Set instead (no default, allows for change)

c.       Always use Global Option Sets

d.       Turn off “Searchable” for unused fields

e.       Use “Field Security” only if really needed

f.        Deactivate “Auditing” if info is not important

g.       Create “Mappings” if added to multiple related records

8.       Decentralized Command – get help and share administration tasks with others

9.       Be Proactive – stay up to date with Microsoft releases and new features, get involved in the preview program to test things before they are released

10.   Reach out! – Reach out to the experts for help! Don’t try to do everything on your own.

Monday, November 7, 2016

October 2016 Blog Review

October has been a very busy month for CRM. We have had the announcement for Dynamics 365 and of course CRMUG Summit (my recap coming soon, see Sonoma's right now). Let's jump right in to all the blogs that have been flying around throughout the month.

Ledgeview Partners showed us how to create mappings in Auto-Populate Opportunities with lead Data in CRM.

PowerObjects walks through a workflow example in Using Workflows to Switch Between Business Process Flows Automatically.

Hitachi wants to keep everyone's CRM systems running smoothly and shared 15 tips and Safegurards to Speed up your CRM Server.

Sonoma Partners also posted performance tips this month in Dynamics CRM Performance Considerations. This focuses on changes inside of CRM (security, views, etc.) whereas Hitachi focuses a bit more on server and more technical items.

Also check out RSM's Two Easy Ways to Improve CRM Forms. This shows some ways to use web resources to quickly make changes such as moving check boxes to the other side or adding instruction boxes.

Everyone struggles with CRM for Outlook troubleshooting. To assist with this the Microsoft support blog posted a multi-part series giving information and troubleshooting tips. Here are a few parts I would recommend:
Of course we should also talk about Dynamics 365. So start off with PowerObjects' What is Dynamics 365? and then for more information read Hitachi Solution's Understanding Dynamics 365: What you Need to Know and How it Affects your Business.

That's all I have to share. Anything I missed? What exciting news have you been following?

Friday, June 5, 2015

June 5 Blog Review

I cannot believe it is June already and summer is in full swing! Unfortunately I am not at the beach but we can make the most of it by looking at the CRM posts from this week.

CRM in the Field posted Improve CRM query performance using Compatibility version 120 with SQL 2014. This describes how some users saw performance issues in CRM for Outlook after upgrading from 2011 to 2015. To resolve check the Compatibility level of your SQL server to ensure it is set to SQL 2014.

Leon Tribe wrote Upgrade vs Rebuild, Interest vs Responsibility. This is a case study on the options available to upgrade from v3 to CRM 2015 and the implications of each method.

You should also check out Jukka Niiranen’s Tracking Pipeline Development Over Time in CRM 2015. This is the third article in his Smarter Sales Processes series.

A quick tip that is easily forgotten is that you can hold the Shift key to sort on multiple columns while in Advanced Find. Review Ledgeview Partner’s post on Sorting Multiple Columns in CRM for more details and screenshots.

The CRM Team announced this week the Dynamics CRM Dynamic Help Feature. This allows you to get help on an error within CRM for Outlook (CRM 2015) and be directed to an article for that specific issue. To get this all set up, they need assistance from users! So if you encounter an issue send them the error details and the redirect link so they can develop the necessary KB article.

Finally, here are a few quick tips from CRM Tip of the Day:



That’s all for today. Have a great weekend!

Friday, March 20, 2015

March 20 Blog Review

This has been a very exciting week because it was Microsoft Convergence! Lots of exciting things were discussed and announced so let’s cover that first.

The big announcement of course was the CRM 2015 Spring Release. The CRM Team blog posted the Official Pre-Release Content for you to check out.

Hitachi Solutions posted some great summaries of the announcements each day: Day 1, Day 2 and Day 3. The most exciting enhancement for me was themes which allows you to customize the colors of your CRM system and even add a logo! You can also see this feature on CRM Tip of the Day’s Turn CRM Green.

Microsoft’s Premier Field Engineers shared 3 posts on 15 tips in 15 minutes sessions that they had at Convergence – Upgrading, Optimization, and Customization.

Finally, McGladrey posted the Spring Release Highlights to recap what we have been looking at so far.

Non-Convergence related you should check out PowerObjects’ post on Definitions of ‘Append’ and ‘Append To’ in Dynamics CRM. This describes the difference, why it’s important and how to keep it straight in your mind.


That’s all I have. Have a great weekend everyone!

Friday, March 6, 2015

March 6 Blog Review

It is our first opportunity to catch up on the CRM News of March. Let’s see what has been going on.

Hitachi Solutions posted an extension of a post we looked at last week in Dynamics CRM Mission Advanced Find Impossible? This discusses how you can edit the FetchXML of an Advanced Find view to accomplish things that are not possible out-of-the-box.

CRM in the Field discussed Memory Management for CRM in a Virtual Environment. This describes what to look at when dealing with performance issues and some things to keep in mind.

Anne Stanton posted about xRM Best Practices. This goes over important things to keep in mind as you work to expand your CRM implementation. This includes things like loving the SDK and working with it and having a CRM architect map out your system so you have a sustainable design.

CRM Tip of the Day posted a two part series on the name of your CRM environment. First, Choose your name Wisely (don’t get name and display name confused) then if you made a mistake Rename the Organization.

CRM Tip of the Day also discussed Using Stored Procedures with CRM Reports. This talks about the benefits and disadvantages of using stored procedures and how to get started.


That’s all for today. Have a great weekend!

Friday, October 10, 2014

October 10 Blog Review

There are only a few more days before CRMUG Summit so next week will be full of news! Let’s see what has been going on this week.

The CRM Team posted – Looking for help for the CRM product family. This has lots of links to help, information and blogs about the different Dynamics CRM products (CRM, Marketing, Social Listening). This is a great resource to keep handy.

McGladrey posted two blogs about their takeaways from eXtream CRM 2014. What to Expect for CRM 2015 goes over the key features and functionality we can expect to be seeing in the next version. Then Looking beyond CRM 2015 talks about Microsoft’s vision and the things we can expect to see highlighted in the development of future products.

There were two CRM Tips that I would like to highlight today:
  • The Undo Button – this discusses the functionality of Jason Lattimer’s Audit undo solution which allows you to roll back changes on your form to an earlier audit record.
  • My Workflow is my business – here you can learn about the impact of the scope field on a workflow to segment your business processes or for use in testing.


CRM in the Field posted CRM Outlook Client Performance Troubleshooting and Optimization Guide. This goes through everything you need to look at and know when troubleshooting problems with CRM for Outlook.

Donna Edwards started her compilation of CRM 2015 Helpful Resources. Refer to this when you begin the process of upgrading to 2015 and find all the information you need.

Adam Vero posted a compilation of CRM 2015 YouTube Videos. This features three videos from Microsoft about what to expect in CRM 2015. The topics consist of Upgrading (must be on CRM 2013 SP1 to upgrade), Field Level Security (now for built-in fields!!), and Business Process Flow Improvements.

Finally, PowerObjects talked about the CRM 2013 Performance Center. This describes how to use this new functionality (2013 SP1) and how to review the data.


That’s all for today. Have a great weekend and I hope to see you at Summit!

Friday, October 3, 2014

October 3 Blog Review

Somehow it has become fall. Even though it is getting colder, the CRM news keeps coming. Let’s take a look at the news and blogs from this past week.

PowerObjects discusses Importing and Updating Records in CRM 2013. This talks about how to update records if you cannot use the Export/re-import functionality.

Hitachi Solutions also talked about CRM 2013 in The Best Little CRM 2013 Feature you might not Know what to do with: Timers. This discusses the timer feature release with 2013 service pack 1 and how to use it.

The CRM in the Field Blog blogged about Table Bloat Due to Workflow Log Entries. This talks about issues related to workflow history retention and what you can do about it.

Leon Tribe discusses Bringing Graphs Down to the Record Level. If you have ever wanted a graph on a record form – now you can learn how to do it!

Finally, Jukka Niiranen talked about 10 tips for Designing a Great User Experience in Dynamics CRM. Use these tips to increase user adoption and help your users enjoy the system experience.

That’s all for today. Have a great weekend!


Originally posted here:

Friday, September 5, 2014

September 5 Blog Review

Apparently it is September. So now it is back busy fall work, even though I believe the summer was just as busy but more sunny. Let’s see what was happening in the CRM world this week.

PowerObjects posted Create a List of Values for Workflow Check Conditions in CRM 2013. This talks through the different options you can use in workflows to set up an OR condition. This is especially helpful when working with long lists of values that need to be “OR-ed”.

Hitatchi Solutions wrote CRM 2013 Performance: Form/View Load Analyzer. This discusses the new analyzer included in Service Pack 1 that allows you to track form loads.

CRM Tip of the day blogged about Upgrading Behind the Scenes forms. This specifically discusses the importance of updating your Team form when you upgrade to CRM 2013.

CRM Tip of the Day also posted about When CRM for Tablets last Synced Metadata. If your mobile users are not seeing recent customizations, you can follow these directions to determine when they last downloaded customizations and resolve the issue.

McGladrey blogged about the CRM 2013 Data Import Limitations. This article goes over some of the common questions that come up about the built in data import capabilities and limitations. Although it is written for 2013, the same information applies to 2011.


That’s all for today. Have a great weekend!

Saturday, March 1, 2014

February 28 Blog Review

Most of the CRM news this week relates to Convergence next week. It should be a great event with lots of CRM MVPs and other superstars there to report back on the news. Let’s take a quick look at the other news this week.

CustomerEffective wrote about a solution to a customer’s CRM 2013 SubGrid to Associated View button. Basically the issue is that a sub grid on your form may not have the button to see the associated view for that record. The issue results from removing that related record from the main record type’s navigation.

CustomerEffective also wrote about Design and Scalability Considerations when using Access Teams in CRM 2013. This compares traditional owner access with sharing to Access Teams. Both access methods have their advantages but must be used in moderation. Using sharing as the primary method for access can result in slow performance especially in organizations with a large number of records.

McGladrey wrote an interesting blog on Export Limitations from CRM to Excel. As you probably know, there is a limit to the number of records you can export (for good reason because you don’t want people exporting all your data, perhaps accidentally, and causing performance to go down). However, you can get around this either by changing the export limit or through a changing the parameters of a dynamic Excel workbook.

The CRM Team posted the Integration Guide: CRM Online and Office 365 to help our CRM Online readers.

Sonoma Partners posted two blogs this week about dealing with vendors – Six Questions to Ask Before you Sign your CRM Contract and CRM Software RFPs – When Good Ideas go Wrong.

Sonoma Partners also posted about What’s New in CRM 2013 for End Users: Quick Create. Quick Create is a great new feature that allows users to create records without needing to leave what they are working on.

Scott Durow posted Real Time Workflow or Plugin? There are advantages to both options. Two principles discussed are that you should use plugins if there are already plugins on an entity, or if you know that it will need a very high throughput. However the advantage of Real-Time Workflows is that they can be created by end users.

“It is true that Plugins will out perform RTWs in terms of through-put but if the frequency of the transactions are going to be low then this usually will not be an issue. If you have logic that is going to be firing at a high frequency by many concurrent users then this is the time consider selecting a plugin over a RTWF.”

That’s all for today folks. Have a great weekend!

 

Tuesday, June 11, 2013

Late Weekly Blog Review – June 11


My Friday Blog review is very late since it is now in fact Tuesday. Still, let’s see what we can find.

Leon Tribe has some interesting thoughts on Associating Opportunities Directly to a Campaign.

Madrona posted a Review of Polaris Features. Interesting, most has been covered in the blogosphere already. One point I did find interesting is that in Polaris the Outlook Client search will be consistent with the Quick Find behavior in the web client, as opposed to just searching within the view.

MSDynamicsWorld has an interesting article discussing “Will Marketing Acquisitions change CRM competitiveness?” ExactTarget may be bought by Salesforce soon which could impact the many other CRM software platforms that are integrated with it. Also, with Microsoft’s acquisition of MarketingPilot some marketing vendors may be worried about losing business. General conclusion is that yes, things will change but it will take time. Marketing vendors have been working in the Marketing space longer so they will be able to stay in front of the curve.

Recently CRMUG hosted a great webinar about User Adoption, Gamification and the Yankees. You can read the summary on MSDynamicsWorld. If you are a CRMUG Collaborate member you can view the PowerPoint Slides as well.

Quick Tip from Mitch Milam about Working with Queues – create a new system view for all queues whose name does not begin with “<”. Use this to quickly hide all your personal queues.

Sonoma posted a review of the recently released Scalable Security Modeling White Paper (jump directly to the White Paper if you like). Main takeaways as highlighted in the article are: be careful with using too much sharing, do not have more than 1000 Business Units, don’t put users on too many teams, don’t modify team membership or user details often and be careful if a many users are logging in at the same time.

That's all the goodies for today. Good night!

Monday, May 6, 2013

May 3 Blog Review


Here is a quick review of the top articles and interesting pieces from the CRM world this week:

Yammer Integration Demo Video from Customer Effective – This video demonstrates how you can use Yammer within your organization. There are also a few other important tidbits brought up:
  • To use Yammer in CRM you must have the Enterprise Yammer subscription. That’s the paid version.
  • If you are already using Activity feeds and you begin to use Yammer, you will lose those posts. They will not be visible in your Yammer feed, but only through Advanced Find.
  • Finally, you need to keep Security in mind and verify it is set correctly inside Yammer. Yammer is beneficial because employees without CRM access can view the Yammer feed, just make sure they aren’t seeing more than they should.

Case Study on Data Load Performance – Interesting case study on the time/resources required for a large data load. Here is an exerpt from the Conclusion.

The results of this benchmark illustrate how a Microsoft Dynamics CRM 2011 implementation can scale to support performance on large data loads. By scaling out and adding more CRM application servers and scaling up the database server (with processors, memory and IO capacity), data processing capacity can improve linearly.
Customers may be able to achieve even higher levels of performance and scalability via customization and a finer level of optimization.
SQL Server is the crucial component for Dynamics CRM, proper sizing and performance tuning of the SQL Server/database is very critical for performance. This is not limited to data loads, but also for daily operations and use.

CRM for DHS and DoD – DefenseReady is a new CRM solution designed for Department of Homeland Security and Department of Defense organizations. It contains “out-of-the-box mission-enabling solutions for Force Readiness, Mission Execution and Training Management”. It looks to have many interesting features.

Using CRM to Meet Patient Standards – This describes a new solution developed by PowerObjects that can help to automate Hospital follow up with patients. This can ensure they are getting the care they need. The system can automate reminders to visit their primary care physician, refill prescriptions and even send information to assist patients.

Finally, in the April 26 Blog Review I discussed the Meet the Experts Webinar. There were several articles released this week related to the announcements made there:

Vision for Game-Changing CRM - For his part, Stutz maintains his focus on innovation and forward progress. "We're innovating at a pace that is pretty unbelievable," he said near the end of last week's webcast. "We made some very serious decisions to not charge for social, to just blend it in. If you buy CRM you get those capabilities. We're not charging for mobile, we think it's just another piece of CRM that you can't charge for. Things that become part of a CRM suite should just become part of the experience. That's one of the things that is so powerful about our system. Some we've acquired, some we're building, some we've borrowed from Microsoft, all come together for a solution."

Will Microsoft split MarketingPilot into a series of Components? - While features like campaign management, email automation, and lead nurturing are core features of many third party solutions, they are just a small sliver of what MarketingPilot offers. But based on market interest over the last few years, these features are the ones that most Dynamics CRM customers are interested in tackling first, and have been doing via third party marketing automation solutions.