Tech 2002 Dynamics GP and Microsoft Office Solutions Challenge

In 2002 Microsoft ran a competition, the “Microsoft Global Solutions Challenge”, where participants from around the world were required to showcase a solution using Dynamics GP and Microsoft Office. We created a solution using Dynamics GP, BizTalk Server, XML, Web Services, Office Web Components and Microsoft Excel. My role was lead architect/developer, and solution presenter. THE BACKGROUND In late 2001, after the dot-com boom crashed and employer Blueberry.net went out … Continue reading Tech 2002 Dynamics GP and Microsoft Office Solutions Challenge

Building Better Software – Best Practices

When building software, several things can be done to minimize errors, prevent future code from breaking, and adding to scalability. Ideally, your practices include some of the following. TEST DRIVEN DEVELOPMENT Test Driven Development, or TDD, is the practice of writing unit tests for a new feature before writing the actual code. You essentially write the unit test case, run it so it fails, then write the code to make … Continue reading Building Better Software – Best Practices

Installing Dynamics AX 2009 with Sample Data and Developer Tools

To install AX 2009, download the installation media and run the setup. Then go through the following steps: Select Microsoft Dynamics AX. Select Developer installation: Select “Install prerequisite software”: Start Dynamics AX: Compile the application: Select the license file: Click through the next few options to synchronize the database: Create company accounts: To install the demo data, download from PartnerSource: Stop the AOT: Restore database. In this case I am … Continue reading Installing Dynamics AX 2009 with Sample Data and Developer Tools

SQL Server Integration Services (SSIS) – Your First Integration

Here I will go through a basic example of using SQL Server Integration Services (SSIS) to create an integration. I am using SQL Server 2012 with Visual Studio 2013. To get started, first download SQL Server Data Tools (SSDT) from the Microsoft website here. Install the file. Next, go to Start->Microsoft SQL Server->SQL Server Data Tools for Visual Studio 2013: This will open Visual Studio. Under Business Intelligence, select “Integration Services Project” and … Continue reading SQL Server Integration Services (SSIS) – Your First Integration