Dynamics NAVAX

Someone at work showed me this. With the production environment the Query Store is enabled. So when you bring it back to a sandbox environment. All that information comes with it. If you connect to the database via SQL management studio. Then navigate to the Query Store. There is a lot of great in depth information you could get. I have a customer that has gone live for 3 months and I wanted to see if there were any improvements we could do. Such as missing indexes we could add to our product. I won’t dive in too deep as there are some great resources online on how to utilise Query Store. I should mention a lot of this information shows up summerised on LCS. So that should be your starting point but I am really glad this is available.

Recently there was a release of the entity store for AX 2012 R3. This is a great tool that makes data warehousing simple and close to real time. Traditionally with a data warehouse, you would have to do full updates. This is fine for overnight process but when it comes to regular updates, it is a bit much to ask. Here are the links to Microsoft blogs of the release announcement: https://blogs.msdn.microsoft.com/dynamicsaxbi/2016/05/02/introducing-entity-store-for-dynamics-ax-2012-r3/ https://blogs.msdn.microsoft.com/intel/archives/185 The concept uses DIXF to do incremental updates to the secondary entity store database. This is done using change tracking which is enabled at the database level. One thing to note is, the entity store database should ideally be on a different server. Allowing you to have SQL 2014 or latest SQL 2016 installed. The entity store uses column store indexing which is super fast. Have a read of the whitepaper in the above links. Below is a diagram of what ...

I recently had to install the Feature pack on CU3 environment and I thought I should share my experience. Note: I won’t go through every single detail. Just the database and models.   Install the Feature pack for the Database using the full Feature pack disc This will warn you that you have a new model and it may override Install CU3 and this should import a model "Extensions update" model Install your custom model - merge whatever you need to merge Start your AOS - make sure your service and client are both on the CU3 build Run the client and you should see "The model store has been modified" pop up Select "Start the software update checklist" since this is a minor update The software update checklist will start Follow the check list - I did my merge already before so I didn’t run the "Detect code upgrade conflicts". I marked it as compete. You could do yours here. When you get to the "Synchronize database" it may f...

This is a nice link listing all the build version for SQL Server with links to their kb article. http://www.sqlteam.com/article/sql-server-versions

Recently found this through the NAV team blog. http://blogs.msdn.com/b/nav/archive/2011/07/22/sql-server-data-compression-and-microsoft-dynamics.aspx Release is available here:  http://archive.msdn.microsoft.com/MSSDCTD I am going to play with it and try to post.

Ola Hallengren has updated his site to take care of SQL2008R2. That is some great work he has done. Specially considering he is giving it out for free. http://ola.hallengren.com