SQL Server CLR Function on Azure SQL Server Managed Instance
When you need to deploy an assembly (.net DLL) SQL Server CLR Function on Azure SQL Server Managed Instance, you have to do it slightly differently. I’ll show you how to do this with the least amount of effort! On a locally hosted or native installation of SQL Server, you would reference the assembly locally. […]
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. […]