When you read the title of this blog post you might think this post is about changes during the lifecycle of Microsoft Dynamics AX 2012. Or maybe it is related to the security framework in older versions (AX 2009), the current version (AX 2012) or the new Microsoft Dynamics AX (aka ‘AX 7’). Well, it’s not. […]
Are SQL Window Functions new? Since 2003 in the SQL ANSI/ISO standard and extended in 2008. Microsoft implemented the first window functions in their SQL Server 2005 version (known as OVER clause) and extended them in the following versions. So to be short no they are not new for the ANSI/ISO standard and for Microsoft SQL Server window functions […]
Let us have a look at SQL Compression, with this I mean Data compression not the backup compression which is also available in SQL Server nowadays. This feature can be implemented in SQL Server without affecting the programs that use the database, because it is only used inside of SQL Server and the way it […]
In several environments I have seen some wrong security role names or other artifacts. Then instead of the role name it will display a label ID. This post will inform you about how to solve this issue in your environment if you encounter a similar issue.
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 […]
After reading the six posts about the Security Development Tool from André, I got excited about the tool and started using it on a regular basis. It proved to be a powerful tool which cut down development time quite a bit. Almost everything you need for security development is available. But there was one scenario […]
For our office in Malta we are, as a result of growth and promotions, looking for a Microsoft Dynamics CRM developer to support our growing Dynamics CRM practice. This is a permanent employment position, with excellent salary and benefits. Responsibilities: Customisation of entities CRM Installation, Configuration and Support Translate design specifications into CRM customisations […]
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 […]
Microsoft’s Convergence is not a showcase of software products – it is an immersive experience which exposes you to rich insights on solving your business problems today, and how you can open up to future opportunities.
Sometimes companies are in the need to change the fiscal book year to another start and end date. It is possible to change a fiscal calendar for legal entities in Microsoft Dynamics AX 2012. This post is a walkthrough to guide you through the steps to achieve the desired result.