AX7 development tools without VM

If you want to run and/or modify AX 7 (Dynamics 365 for Operations), you get a whole virtual environment configured by Microsoft and you either deploy it to Azure or run as a local virtual machine on Hyper-V. I have a huge laptop with 32 GB RAM and two SSD disks built specifically for running …

Continue reading ‘AX7 development tools without VM’ »

Why not to touch AX DB directly

I’ve been asked to reiterate some arguments against direct access to AX business data. (As you all know, the recommended approach is always going through AOS, such us calling web services.) Here are some of the arguments: You would bypass all business logic. It often means that you would have to re-implement some AX logic …

Continue reading ‘Why not to touch AX DB directly’ »

Index fragmentation on xRef tables

Building cross-references for code in Dynamics AX creates millions of records in xRef tables. It has also very negative impact on fragmentation of database indexes. This is an example of indexes on xRefReferences table from a customer’s environment after rebuilding all cross references. And here the same set of indexes a few minutes later after …

Continue reading ‘Index fragmentation on xRef tables’ »

MySQL Workbench

In pursuance of application design or an existing system analysis I sometimes need to draw entity-relationship diagrams. Diagrams are more illustrative than tables or word descriptions and they help especially with things involving relations (foreign keys, delete actions etc.) For this purpose I tried to find an easy to use piece of software with a …

Continue reading ‘MySQL Workbench’ »