How to solve AX Data Refresh with Powershell?

The number of resources regarding PowerShell with AX, at our disposal, is so small and it is so little we can do with them, this is a topic that I would like to increase awareness starting an open discussion. I will try to bring to the blog scripts that have been helping me to optimize…

6

Dynamics AX Menu of Services for Premier customers

The Menu Of Services for Dynamics AX has been updated. This list contains all the Proactive Services that Premier Field Engineer can provide to Premier Customer & Partners. In the next few weeks, we will communicate the Premier offerings for Dynamics 365 for Operations. We will also write a specific blog on the Designated Support…

2

SQL Server Data Compression for Dynamics AX Part 4 – Actions post compression

In part 1 of the series we discussed Costs and Benefits of data compression together with some Best Practices to successfully compress your database. In part 2, we discussed the planning for Data Compression including prerequisites validation and steps to identify the best candidates for compression. In part 3, we showed you two different approaches…


SQL Server Data Compression for Dynamics AX Part 3 – How to compress Dynamics AX databases via SQL Server or Dynamics AX

In part 1 of the series we discussed Costs and Benefits of data compression together with some Best Practices to successfuly compress your database. In part 2, we discussed the planning for Data Compression including prerequsites validation and steps to identify the best candidates for compression. In this post we will show you two different…


SQL Server Data Compression for Dynamics AX Part 2 – Planning Database Compression

In part 1 of the series we discussed Costs and Benefits of data compression together with some Best Practices to successfully compress your database. In this post we will walk you through the planning of Data Compression, including Pre-requisites Validation and 3 steps to identify the best candidates for compression: 1. Estimate the space saving…


SQL Server Data Compression for Dynamics AX Part 1 – Introduction and Best Practices

In this blog post we will discuss the Benefits and Costs of database compression and we will provide Best Practices for successful data compression. Why data compression matters? Data compression is one of the Data Volume Management strategy (together with Data Clean up and Data Archive) which as we know, consists on actively managing the amount and type…


SQL Server Data Compression for Dynamics AX Blog series

Welcome to our blog series on SQL Server Data Compression for Dynamics AX. In this series of blogs, we will describe the steps to successfully plan and compress your Dynamics AX production databases. We will also provide some best practices for compression. This blog series was written by Dynamics AX and SQL Server Premier Field Engineers who…


How to analyze live performance issues with Dynamics AX (Public Cloud)

Back in July, I posted a step by step flow to troubleshoot performance issues on Dynamics AX 2012.  Today I would like to share the same list but this time for the latest release of Dynamics AX available on Microsoft Azure through Lifecycle Services. Because the new Dynamics AX is running as a Cloud Service managed by Microsoft, it means…

2

Interacting with IL-generated TempDB data

Together with Microsoft Dynamics AX 2012, there was a new execution mode introduced; called as “IL” execution mode, which is in some references also referred as “CIL” execution mode. The “IL” stands for “.Net Intermediate Language” and referring to the Intermediate Language available in the .Net Technology, see also X++ Compiled to .NET CIL and…


Collection Classes – Iteration performance

Collection Classes are very popular and frequently used composite data types within the Microsoft Dynamics AX developers’ community. The idea is to have generic collections, which provide you the ability to create and maintain in-memory collections of any type of objects at run-time. In many business scenarios, there is a need to iterate through the…