Blog

Maintaining your Dynamics Ax indexes

Please read the following blog related to maintaining indexes in Dynamics Ax:http://blogs.msdn.com/b/axinthefield/archive/2012/08/01/database-maintenance-strategies-for-dynamics-ax.aspxI added on more join to the following script in order to find where the indexes come from:...

Shrinking the transaction log

At some point, specialy if you don't give regular mainteinance to your Ax database, the transaction log will be huge. We followed the article http://support.microsoft.com/kb/907511 to reduce the log size and it worked perfectly. Some things to consider for setting the log file is to set it to autogrow and to give a fixed increment size (100 MB for example.) The reasons that could make your lo...

Another way to debug your sql statement

Sometimes it could be annoying to turn on database tracing in Dynamics Ax 2012, you will get a lot of useless stuff. A way to only get to know your query is by using the new operator GENERATEONLY, but make sure you disable caching on the table otherwise you will get nothing. See example below: ...

TFS connection string using TFS preview

Since microsoft released TFSPREVIEW (tfspreview.com) we were wondering how to connect AX 2012 TFS client to TFS cloud provided by tfspreview.comWe were finally able to connect without any custom, just point ax tfs configuration to the following address: https://<yourname>.tfspreview.com:443/defaultcollectionJust use your live id in the credentials pop-up and you should be fine. This was...

Back to Blog

© 2020 Dynaxti, inc. All rights reserved.

Navigation

Social Media