Microsoft Dynamics AX 2012 Customers can Benefit from Microsoft SQL Server 2012 Capabilities at General Availability of SQL Server 2012

Our colleagues over in the SQL Server world are having a bit of a get together today…or a virtual launch event as some of us marketers call it. You can find out more on the SQL blog here but I thought it might be useful to take a few moments to look at how Microsoft Dynamics AX 2012 and SQL Server 2012 can work together to bring customers business value. Some brief thoughts below…

Microsoft Dynamics AX 2012 can be configured to work with SQL Server AlwaysOn Availability Groups. SQL Server AlwaysOn enhances the capabilities of Database Mirroring, helps ensure availability of application databases, provides an integrated set of options including automatic and manual failover of a group of databases and simplifies deployment of high availability using integrated configuration wizard. A Microsoft Dynamics AX 2012  instance that is configured against a SQL Server AlwaysOn Availability Group can provide high availability and failover capabilities like many other applications that are built on SQL Server AlwaysOn technology. Additionally, Microsoft Dynamics AX partners can develop solutions to leverage the read-only secondaries in SQL Server AlwaysOn Availability Groups to offload some of the data warehousing needs to help reduce the load on the OLTP database. 

Microsoft Dynamics AX 2012 utilizes Microsoft Business Intelligence technologies for reporting and data analysis. SQL Server 2012 makes self-service reporting a reality by providing a highly interactive, web-based data exploration, visualization, and presentation experience to users of all levels. Customers implementing Microsoft Dynamics AX 2012 on SQL Server 2012 have the ability to utilize these powerful BI and data modeling capabilities allowing for customizable views to drive business decision-making. 

PowerView users have the ability to mash-up data with external data sources using PowerPivot to drive in-depth analysis.  Developers have the ability to build custom tabular BI models using aggregated as well as detailed data from Microsoft Dynamics AX. Resulting models (whether built using PowerPivot or using BI development tools) can be explored using SQL server Power view or from Microsoft Dynamics AX 2012 Role centers. 

Thoughts, views or opinions? How will you be looking to use some of the rich new capabilities of SQL Server 2012 with your own AX implementation? To learn more about Microsoft Dynamics ERP, visit



You can also connect with us on social media on Facebook, LinkedIn, Twitter & YouTube