Microsoft Dynamics Nav SQL Queries

As part of our ERP query series we bring you Navision / Microsoft Dynamics Nav / Dynamics 365 Business Central the new name for the latter. The schemas are all pretty close and there are many tables and but there are a few core ones that are always used in ETL / BI Analytics projects. […]

SSIS Dependency Diagram with DiagrammeR and Sprockit

We can use DiagrammeR & Sprockit to discover Server Integration Services (SSIS) Dependencies. SSIS is a mature data integration tool bundled with SQL Server. SSIS like many other tools can lead to ‘dependency hell’. This is where packages or stored procedures are developed that carry out many tasks. With many of these packages it can […]