SQL

Database SQL BYOD Azure SQL Dynamics 365 BYOD

Export Data to Azure SQL!

Database SQL DDL Sync Administration / System Administration AX 2009 AX 2012

Repairing SQLDictionary can be a pain when it gets corrupt for any reason. Let's cover how to break it but also fix it.

2012 AX 2012 SQL toolkit Retail Retail

Setting up a Tool Kit User for AX 2012 R3 for Retail can be a bit trying, espcially since the techNet article for this topic is based on 2012 FP and is no longer current.

Number Sequences Organization Administration SQL Organization Administration AX 2012 View

Standard AX doesn't give you much info into number sequence consumption. This article can help streamline finding issues.

AX 2012 Financial Dimensions SQL General Ledger AX 2012 View LedgerTrans

This covers how to implement the default dimensions view for your data and account structure(s).

AX 2012 Financial Dimensions SQL General Ledger AX 2012 View

This articles covers implementing your Ledger Transactions with Financial Dimensions view. This create a view similar to the table LedgerTrans from 2009.

AX 2012 Financial Dimensions SQL General Ledger AX 2012 View

Implement a series of views that creates a view that works similar to the LedgerTrans table in 2009.

AX 2012 Financial Dimensions SQL General Ledger AX 2012 View

Part of a series of views to create a view that is similar the the table LedgerTrans in 2009.

AX 2012 Reporting SQL SSRS Basic AX 2012

Creating a database to hold simple but powerful reporting shortcuts can help provide data on demand to executives and department heads when a unique or surprising issue arises.

AX 2012 Financial Dimensions SQL General Ledger AX 2012 View

The changes from 2009 to 2012 as it related to financials are fairly comprehensive and those of us who have made that transition have at least one point in time said "I miss LedgerTrans".