Welcome to Blog

Get in control with Sharepoint DB names

1        Introduction When installing SharePoint 2010 a lot of additional DB’s are created. This can be nasty from maintenance point of view, especially when a Central SQL server is used. Take a look at the next picture. This shows the worst case of DB naming.  If these DB are stored on a central DB, you […]

upgrade to AX 2012 R2

I thought an upgrade from AX 2012 to AX 2012 R2 was easy My customer asks me if we could upgrade to R2. I should him no problem. But it had acutely more work than I expected. – There is country localization in the code every where – The kernel build number went to 6.2 […]

Dynamics AX Compatibility with SQL Server 2008 SP3 and R2 SP2

Perhaps you recognize this scenario. Dear customer please update to the latest service pack of SQL. You customer replies, are the supported? The answer is official not, but the current version is also not supported by the SQL team of Microsoft. So we have a deadlock, but to avoid the deadlock, sustained engineering has new […]

Cluster index

These days we have the surrogate key in AX 2012. In general it is a recid Index that acts as primary and cluster index. Theoretically this looks perfect as long as we develop in the AX 2012 style. But there is a catch to it. First you may think this index can’t get fragmented. This […]

Performance Guide

3 years ago I had an idea; writing a book about performance. Great Idea but, my co-writer started working for MS and had a lot of legal stuff, AX 2012 came along, and Publishers think that thing like Performance Guide for Dummies is possible. On the end; we had 90 pages of draft content and […]