Blog

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

Free some resources on database server

If you are working on a dev. environment and have on the same box the AOS and the database server it is good idea to set the Recovery model of the Ax databases to simple, this will release some resources on your box. Normally in a dev. env. you won't need the transaction log so this is a very save tip....

Back to Blog

© 2017 Dynaxti, inc. All rights reserved.

Navigation

Social Media