Book Give-away: 'Microsoft Dynamics AX 2012 Development Cookbook'

Book Give-away: Hold a chance to win free copy of the 'Microsoft Dynamics AX 2012 Development Cookbook', just by commenting!

For the contest we have two copies of Microsoft Dynamics AX 2012 Development Cookbook to be given away to two lucky winners.

How you can win:
To win your copy of this book, all you need to do is come up with a comment below highlighting the reason "why you would like to win this book”.

Duration of the contest & selection of winners:
The contest is valid for 7 days, and is open to everyone. Winners will be selected on the basis of their comment posted.

Microsoft Dynamics AX 2012 Development Cookbook is written by Mindaugas Pocius, a recognized Microsoft Certified Professional for Dynamics AX who is also one of the leading experts in Microsoft Dynamics AX. This is a practical cookbook, designed to demonstrate advanced development techniques for exploring data manipulation concepts in Dynamics AX. With the creation of custom lookups using AOT forms and generating dynamically from the X++ code, readers can enhance applications by using advanced form controls to create various microsoft office documents for exporting/importing business data for further analysis.

After reading this extensive cookbook, readers will not only be able to create and manage purchase and sales orders from code, but also create a custom electronic payment format and process a vendor payment using it. This book will help Dynamics AX developers to go beyond the basics of Dynamics AX programming and use implementations which can also be applied to learn the functional aspects of Dynamics AX.

Update:
The contest is finished. I wish to thank everyone who participated. The lucky winners will be contacted directly with instructions for getting the book.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Speaking @ Microsoft WinDays 2012

I am happy to be invited as presented at the biggest IT conference in Croatia - Microsoft WinDays.

This will be my second time to present at this conference with a long tradition and splendid organization. I will be speaking about Microsoft Dynamics AX 2012.

Conference will be held in beautiful seaside town of Rovinj.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Microsoft MVP Award - Dynamics AX for the third time

At the beginning of this month (not an April Fools' Day joke) I was notified by Microsoft that I have been re-awarded as MVP (Most Valuable Professional) for Dynamics AX. Same as last year this is a great honour for me, especially with so few MVPs in Microsoft Dynamics AX field. In this area currently only 9 other people in the world share this award.

You can see who are some of the new MVPs in CEE in this award cycle here. Congratulations to them and to all other re-awarded MVPs.

I will do my best to continue helping the community in future, as I did in past.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Speaking @ FON in Microsoft Academic Tour "Пролеће@University '12"

As one of the MVPs from our country, I have been invited to participate in Microsoft Academic Tour "Пролеће@University '12".Since I am deeply involved with academia, I loved the idea, and gladly accepted.

I will be speaking about at Faculty of Organizational Sciences on 27.03.2012 about Microsoft Dynamics AX 2012.

There is a very nice overview of this event at Microsoft Academic website, and there has been a short announcement at the faculty's website.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Microsoft Sinergija (Synergy) 2011

This year I will be speaking at the annual Microsoft conference Sinergija 2011 (Sinergy).

As a CIO I am very proud that this year there are even two speakers from our company's IT team, beside myself. This is a significant acknowledgement both to the whole company as well as to my work in inspiring and motivating others to grow and learn, but also to join the community and share the knowledge (starting with 2009 when one of my associates held one track, to 2010 and this with two of my associates being presenters).

You are kindly invited to come and check their sessions:

- System Center Service Manager – Implementing ITIL framework on 19.10. at 10:30 - 11:30.
- Data Mining In Retail Industry on 20.10. at 16:00 - 17:00.

As for me, I will be doing five tracks. The most important is Microsoft Dynamics AX 2012 (a new version of Microsoft's Flagship ERP system). I will be doing a session on Agile and also three community tracks (one of them is Microsoft Dynamics Meetup).

Community tracks are free, so anyone can come (more info: http://msacademic.rs/News.aspx?id=588).

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Lean Architecture: for Agile Software Development

I recently got my hands on hard copy of an excellent book of James Coplien - Lean Architecture: for Agile Software Development. I was one of the reviewers for the book and have only the words of praise for it.

This book brings the world of the architecture right in the context of agile. If you are using Lean, Scrum, XP or any of the other agile approaches in any of the roles in the process, this is the book for you. If focuses on the collaborative approach as one of the key success factors of the good development teams. Written in the clear and understandable tone, with the concrete samples in almost every popular language, you will get your hands deep on the new approach that is complimentary with the idea of the book.

James was one of the main promoters of Scrum in Serbia and has already twice visited our country and passed a part of his knowledge without compensation.

The book is currently top title on Amazon for agile and architecture. If you have space to order it, I think this is an excellent choice.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Microsoft Dynamics AX - Remedy for slow Microsoft Excel import

Recently I have been asked to help with solving an issue that involved reading data from Microsoft Excel (xls format) into Microsoft Dynamics AX

Original approach was used with default set of classes for Microsoft Excel (SysExcelApplication, SysExcelWorksheets, SysExcelWorksheet, etc.). The excel file in question was very small but with a rather large number of columns (~150). About 200 reads were made per row. What made us investigate this further was the fact that import was quite slow. After doing some basic profiling (we used Microsoft .NET's System.Diagnostics.Stopwatch so we can cross-compare the results) we found out that the time required to process one row increases almost exponentially.

After that we developed a small application in Microsoft.NET/C# (with Microsoft Visual Studio) that was reading data from Excel using OleDbConnection class and saving it in Microsoft Dynamics AX using .NET Business Connector.  The increase in speed was several orders of magnitude but what is also important is that near exponential growth of time per row was missing.

We then applied the same principle with Microsoft Dynamics in X++ using its set of classes for ADO access (CCADOConnection, CCADOCommand, CCADORecordset). The speed was still around 100 times greater than with default approach and ~2.5 times slower than .NET. With this set of classes we were lacking the ability to do arbitrary (e.g. accessing the previous row values) row access like in .NET, so some caching was needed. Still the speed increase was incredible. Below is the graph of time needed (in milliseconds) to process one row with all three approaches.

If you haven't tried this apporach, I suggest it.  For it will surely outweight the time needed for implementation, especially with bigger or files with many columns. Connection string and row selection query (you can remove absolute row range) for .NET and X++ should look something like this:

connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;";
rowQuery = strfmt("SELECT * FROM [Excel 8.0;HDR=NO;IMEX=1;Database=%1;].[%2$%3]", filename, "OrderWorkSheet", "A:EJ");


Update: Zubair got in contact with me regarding this and here you can find full X++ samples for XLS and XLSX.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Microsoft Dynamics & the Cloud

Recently I have been asked by Software Advice (click here to visit their site) to share their interview about Microsoft Dynamics and the cloud with Marie Huwe, General Manager of Marketing for Microsoft Dynamics.

The interview is 14 minutes long and presents Microsoft's roadmap for getting Microsoft Dynamics products in the cloud. You will hear about cloud partner profitability guide, cloud best practices, Dynamics marketplace and other cool tools that Microsoft is planning to apply. For me it looks best that some of these tools will be powered and will be accessible by Microsoft CRM which itself is the first one of Microsoft Dynamics products which is already in the cloud. You see the interview here.

Here is the link to Cloud partner profitability guide and one other pointer related to cloud and Microsoft Dynamics AX with focus on version 2012.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Retail IT Summit 2011

This is one of the conferences where I initally planned to attend because of industrial focus (retail), but I got invited by organizers to present instead.

The event will bring together representatives of leading retail chains in Serbia, who will attend a one day event (10th May 2011) on which they will follow the presentations and exhibitions of the biggest international experts in retail area (you can get more info and detailed list of exibitors here).

I will be presenting about our way of working with focus on our award winning in-house developed retail solution and its application in sports and fashion retail, with brief touch on our ERP system: Microsoft Dynamics AX.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Decisions Spring 2011

To my great pleasure, I have been asked again to speak about Agile Software Development and Microsoft Dynamics AX at one of the greatest virtual conferences on Microsoft Dynamics products: Decisions!

MSDynamicsWorld.com has been hosting these semiannual events for a couple of years now, and they are tremendous, free resources for learning and networking. This time it is spring version, and is again features 4 days dedicated to different Dynamics products, as shown on promo below:

One interesting thing is that expert will be answering questions from the audience through live chat after the sessions. And you may want to consider stopping in to the networking lounge at the event as well and continuing the conversation with the presenters or other attendees, as that tends to get some lively discussion. If you already attended this event, then you know from your own experiences how interesting this can be.

Here are the links for programs for individual days:

And you can register here.

Facebook Google Buzz BlinkList Del.icio.us Digg It! DZone It! Furl NewsVine Reddit StumbleUpon Technorati

Other profiles

View Bojan Jovicic's Microsoft MVP profile

View Bojan Jovicic's profile on LinkedIn

Follow Bojan Jovicic on Twitter

View Bojan Jovicic's profile on Facebook

View Bojan Jovicic's (CSM, CSP) ScrumAlliance profile

Search

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2012