If you haven’t heard already, there will be a Summit EMEA 2017 coming April 4-6 in RAI, Amsterdam. This is a community-driven conference around Microsoft Dynamics products. Information about this event can be found on the next website: http://www.summitemea.com. Attendees can learn from other customers and product experts to excel their daily work. I will also be present and will act as...
What is a SQL Trace Flag?
A SQL Trace Flag is an indicator that changes the way the SQL engine reacts. Why would we want to that? Well because the DBA always knows best, uh well actually because the standard behavior of the SQL engine will not always give the best possible performance for a Dynamics Ax ERP. Which SQL Trace Flag could be of interest for a Dynamics Ax Database? Well I found 5...
Before jumping into index fragmentation I’ll first explain what indexes are and how they are used by the SQL Server Engine. I tried to compare it to a real world way of searching data, to paint a clear picture in your head. I’m not going into the differences between clustered and non-clustered indexes as that would be a nice new blog.
How do indexes work?
Indexes are used by SQL...
Introduction
As a new member of the Kaya family I feel the urge to introduce myself. Hi I’m Boye Walters, a 34 year old developer with over 12 year experience in Microsoft Dynamics Ax and Microsoft SQL Server. Having worked with all versions of Ax ever released in the Netherlands I can truthfully say that I’ve seen a lot already in Ax. As for SQL Server I’ve actively worked with SQL2000 and...
This morning I wanted to see if there was a known issue for a problem. Then I noticed that there are new features and content on Issue search from Microsoft Lifecycle services. It was announced earlier that there would be more investments in LCS. There is now content related to several versions of Microsoft Dynamics AX and Microsoft Dynamics NAV.
(meer…)
The website of the Microsoft Dynamics Community has been completely redesigned. There is a new look, forums are redesigned, it is supporting a mobile-friendly interface, there are monthly leaderboards, and more. The Microsoft Dynamics Community is a website where you can find community contributions, ask questions and interact with Microsoft Dynamics experts.
(meer…)
Last year October I shared a neat utility to convert currency amounts using the exchange rate information available in Microsoft Dynamics AX. This was suitable for the versions AX 2009, AX2012 and AX2012 R2. You can read the blog with the announcement of the utility and how it works here. Recently I got the question if it was also supported within Microsoft Dynamics AX 2012 R3. This post will...
When you are in the need of converting an amount from one currency to another you can go to a website and convert online with exchange rates provided by a central bank. When you are using Microsoft Dynamics AX you setup your own currency exchange rates. In AX2012 R2 you can also use exchange rate providers to have the rates downloaded periodically.
(meer…)
