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...

AX 2012 SSRS and labels

It's a mess now when you prepare a multi-idiom SRSS report. Labels are handled like:=When you open this textbox you will never know what's that about.So to easy things up, there's a nice little trick:Everything after the char ' is a comment, so when you open the textbox expression you will be able to understand what it will print =)...

Back to Blog

© 2019 Dynaxti, inc. All rights reserved.

Navigation

Social Media