Category: Technology

Have you had issues when trying to run the migration wizard from FRx to Management Reporter? When opening your row formats to validate, did you notice that you didn’t have any accounts in the link to financial dimension column?  If this has happened to you, it is most likely due to the use of account sets in FRx.  If you’re in row formats in FRx, you are using account sets which do not migrate into Management Reporter.  If this happens, what are your options to fix your reports?

The recommended mileage on a typical car in America to get an oil change is every 3,000 miles.  So that means a lot things.  Good… clean oil is absolutely crucial so that engine parts continue to cycle properly.

Not to mention the other important parts and services like an air filter, gas treatments, cables, wires, and spark plugs that are part of the normal maintenance on the very machine on four wheels that YOU (Mr. and Mrs. IT folks) place your children in to get to point A and point B.

In Part 1 of this blog series, we outlined the importance of creating a good starting point for performance tuning on your SQL Server  by establishing a baseline for your server’s current performance.  

In Part 2, we covered how to enable Instant File Initialization and adding additional TempDB files to your TempDB database. 

As a conclusion to those articles, we will look at the effects of those changes by running a simple GP2010 Sales Order processing batch posting. To run the test, I create a virtual server with SQL 2012 using the default setting and GP2010 SP2. I made one change to the default to limit SQL server to only use a max of 12GB of RAM since I was running GP2010 and SQL on the same image.  Below are the specs of the server

Microsoft Dynamics GP is coming to Windows Azure in June; Microsoft confirmed this at this year’s Convergence event.  This new deployment option will offer what you would expect from an enterprise-grade cloud service –  stability, protection, security and the ability to scale and grow.  Microsoft has referred to the Azure service as being elastic and the fact that it can grow without adding servers will be great for partners.

By change some default SQL Server settings you can increase performance.  The first two changes will provide performance increases when restoring SQL backups and looking pages in memory. 

Microsoft is known for making big announcements at Convergence every year  and this year was no different!  The most anticipated announcement was the release of Microsofts’ Product Roadmap.  The product roadmap outlined Microsoft’s aggressive strategy to commit resources toward the development of that they will be embracing cloud computing, devices and servicesto support channel partners and their customer base.

Setting the database compatibility level for a couple of SQL Server databases can be a simple task.  But what if you had 30 or 40 databases?  For those of you with a lot of databases, he is a simple step by step process to update the compatibility level to version 11 (SQL Server 2012).

A good starting point for performance tuning on your SQL Server is by establishing a baseline for your server’s current performance.  To help, Microsoft provides a SSMS dashboard to monitor your server’s performance.  The dashboard provides valuable information on: