Skip to content
Microsoft Dynamics 365

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0 

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,...

Read more

Serialising containers in X++ 

A problem I’ve hit a few times during troubleshooting is transferring containers from one environment to another. Importing a whole 100GB database to be able to access the results of a report packed into a 20MB container seems like a bit of an overkill. So, a natural idea would be to save the container to...

Read more

Announcing new LCS feature – Latest Kernels 

Installing the latest AX kernel version has the advantage of improving the quality and stability of the product because the kernel bundles all fixes checked in up to the release date. Until recently, finding the latest AX kernel version required searching for hot-fixes to specific problems and installing the corresponding KB package. The new feature...

Read more

Dynamics AX – 1099 Tax Updates for 2015 

Once again, tax season is right around the corner. As such, I thought I would take a moment to let everyone know that we have released the 2015 1099 updates for Dynamics AX and share some of the changes we have made.   Supported versions: Version: AX 5.0 Hotfix: KB311849Location: http://hotfixv4.microsoft.com/Microsoft%20Dynamics%20AX%202009/sp1/KB3118498/5.0.1600.3540/free/488628_intl_i386_zip.exe Version: AX 6.0/6.1 – Due...

Read more

How to proactively avoid parameter sniffing step-by-step 

In the following blog post the so called „parameter sniffing“ is explained: http://blogs.msdn.com/b/axinthefield/archive/2014/01/09/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil.aspx The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d...

Read more