Looking into SQL Server 2008

Alright,

Now that Dynamics AX 2009 SP1 has been released, that means that SQL Server 2008 is offically the go to Database server for Dynamics AX 2009.

Of course you can run on SQL Server 2005 still, but I want to focus on SQL Server 2008 for a little while and talk about some of the benefits that it offers.

In this I want to go right to the performance enhancements that comes along with SQL Server 2008. This is where we can really see some real area's that a Microsoft Dynamics AX instance can really get some real mileage out of.

So with performance, let's focus on some key area's. These area's starting out will be:

• SQL Statement / Query Performance.


• Management of Resources on the SQL Server.


• Optimizing Storage with SQL Server

Each of these area's have some new improved items in SQL Server 2008, and I want to go into each. In doing so I also want to talk about how this will benefit a Dynamics AX 2009 instance and what this means for current and future customers.

So check back soon, as I dive into SQL Server 2008 for you, and walk into a new and faster Dynamics AX world!




"Visit the Dynamics AX Community Page today!"