Dynamics 365 Great Plains
SQL Snippets: SELECT INTO
This post is part of the series on SQL Snippets. I occasionally need to make a backup of a SQL table and all rows…
Tag: SQL
Dynamics 365 Great Plains
Microsoft Dynamics GP Reporting Services Reports Not Supported on SQL Express
Usually when installing or upgrading Microsoft Dynamics GP for clients they will use SQL Server Standard and sometimes Enterprise; very rarely, I’ll encounter a…
Dynamics 365 Great Plains
SQL Snippets: Create and Use Database Role to Restrict Access
This post is part of the series on SQL Snippets. I create a lot of SQL objects such as views, tables, stored procedures and…
Dynamics 365 Customer Engagement
How to – Export Dataverse (Dynamics 365) data to Azure SQL using Azure Data Factory pipeline template
[Visual Guide to Azure Data Factory – https://acloudguru.com/blog/engineering/a-visual-guide-to-azure-data-factory] Using the new Azure Data Factory pipeline template – Copy Dataverse data from Azure Data Lake…
Dynamics 365 Business Central
Dynamics 365 Business Central on-premise and SQL on Azure VM: reducing storage costs
If you search on my blog, I’we written in the past a lot of articles with suggestions and best practices for using Dynamics 365…