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…


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…