ArcherPoint Dynamics NAV Developer Digest - vol 237
The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
NavContainerHelper Version 0.5.0.11Freddy calls out some important changes in the Version 0.5.0.11 release of NAVContainerHelper:
- .app instead of .fob
- Functions for invoking APIs
- AL files
POP, IMAP, and SMTP Settings for Outlook.comAdrian is “having an issue setting up the SMTP Mail for the approval process in the TEST database. When we click the Test Email Setup button, we get an error message that says ‘Unable to Connect to the remote server’. How can we troubleshoot the issue? Thanks!” Joe Shields asks: “Are you sure that is the right SMTP server address and port? Are they using Office 365 for email?” Matt T adds this link to the Microsoft Office support article for POP, IMAP, and SMTP settings for Outlook.com.
How Many Indexes Are Too Many?In his post in the series, Index Tuning Week: How Many Indexes Are Too Many?, Brent Ozar boils it down to this rule of thumb for performance tuners: “Aim for around 5 indexes per table, with around 5 columns (or less) each.” If you’re looking for some fundamentals for performance tuning your database, check him out.
Enumeration Types: Declaring an Enum in ALBill Warnke says: “I experimented with the new extensible enums (instead of making an Option field) just to see what it can do. Quick takes:
- It’s very close in functionality to the option value. Defined as a field on a table, it stores the value as an integer in SQL. It is order sensitive (you can't reorder without changing data).
- Instead of duplicating an option string from a table in a variable, or even another table, you can define the enum object type and "instantiate" it in a table or in a variable. Cool.
- It still uses an ID for each value. There could be collisions. Not Cool.
- Use an integer
- Lookup table
- Just store the enum value
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard