Microsoft Dynamics 365 Local Business Data aka On-Premise - Database Topology

Greetings

As you know Microsoft have release Dynamics 365 LBD - On premise version.

Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements

About Database the main question is use SQL Server 2016 Standard or Enterprise Edition.
Obviously, refer to the Microsoft link in order to check the features supported by the SQL Server editions.

In a medium and not complex Project, my suggestion is to use the Standard Edition.
With the standard version is possible to setup an Always On Availability Group Cluster with a limit of two replicas (Primary and Secondary).

From a Business Intelligence perspective, we can setup a SQL snapshot on the Secondary replica and link to the snapshot the Reporting activities.

Stay Tuned!

Microsoft Dynamics 365 useful links

Hi

Below some useful links about Dynamics 365:

General Links:

1- Microsoft Dynamics 365 – Launch Portal
2- Introduction to Dynamics 365 for Operations
3- Overview of Microsoft Dynamics 365 for Operations for Developers and IT Pros
4- Dynamics 365 for Finance and Operations. Static IP Addresses?
5- Microsoft Dynamics 365 for Finance and Operations architecture
6- Videos for Finance and Operations
7- Azure status
8- Connecting to custom help sites from Finance and Operations

SaaS Evaluation Copy:

1- Get an evaluation copy
2- Try out Dynamics 365 for Operations now for free!
3- Have you given Microsoft Dynamics 365 for Finance & Operations, Enterprise Edition a try?
4- Microsoft Dynamics 365 for Finance and Operations, Enterprise edition deployment options

Database Management:

1- Copy a Dynamics 365 for Operations database from Azure SQL Database to a SQL Server environment For instance update Data from the UAT Environment to a Sandbox Environment.
2- Copy a Finance and Operations database from SQL Server to a production Azure SQL Database environment
3- Copying Data into a New Legal Entity in Dynamics 365 for Finance and Operations
4- How to copy a database from on-premises to cloud Tier 1 in Dynamics 365 for Finance and Operations
5- How to copy a database from cloud tier 1 to on-premises in Dynamics 365 for Finance and Operations
6- Cleanup routines in Dynamics 365 for Finance and Operations
7- Schema comparison between versions of MsDyn365FO
8- How to Connect to Your Non-Production D365 Finance and Operations Database

On-Premise:

1- Dynamics 365 for Finance and Operations, Enterprise edition (on-premises) system requirements
2- Set up and deploy on-premises environments
3- On-premises deployment landing page
4- Features not implemented in on-premises deployments
5- Purchase Dynamics 365 for Finance and Operations, Enterprise edition (on-premises)
6- Troubleshoot Dynamics 365 for Finance and Operations, Enterprise edition on-premises
6.1- Troubleshooting on-premise environment deployment D365FFO
6.2- Package Deployment Database Synchronization Issues
7- Update the local agent
8- Video Real World Dynamics 365 On Premises Performance Testing
9- Cloud and on-premises feature comparison
10- Dynamics 365 for Finance and Operations (on-premises) update
11- Install network printer devices in on-premises environments
12- Configure reverse proxy for your on-premises environment
13- AD FS user sign-in customization
14- Software lifecycle policy and on-premises releases
15- Client internet connection
16- Debug a Dynamics 365 for Finance and Operations on-premises instance without Visual Studio
17- Debug Dynamics 365 for Finance and Operations on-premises with Visual Studio remote debugger
18- How authentication works in Dynamics 365 for Finance and Operations On-premises
19-How to scale out Dynamics 365 for Finance and Operations on-premises
20-How to link SQL SPID to user in Dynamics 365 for Finance and Operations on-premises
21- On-premises diagnostics
22- PowerBI.com integration with on-premises environments
23- D365FFO On-Prem AOS Restart

On-Premise - Certificates

1- Configuring certificates for D365 On-premises installation
2- Creating self signed certificates with makecert.exe for development
3- Dynamics 365 for Finance and Operations On-Premises – Certificate Templates
4- Dynamics 365 for Finance and Operations On-Premises – Certificate Creation

Document Management

1- How to select the document management storage location

Financial Dimension 

1- Adding a new Financial Dimension D365 FO

Platform Update

1- Restricted Admin Access on development VMs with Platform update 12: What you need to know
2- Custom fields: handle with care!
3- How to Install Dynamics 365 for Finance and Operations Platform Update on a Disconnected Local Developer VM

Integration

1- How to create Microsoft Form integration with Dynamics 365
2- Integration patterns and practices
3- Use Dynamics 365 web services
4- Service endpoints
5- Service authentication troubleshooting
6- Consuming external web services from Microsoft Dynamics 365 for Finance and Operations
7- Dynamics 365 for Operations Integration framework
8- Consuming Dynamics AX 365FO Data entities using Web API (Part 1)
9- Choose a data integration (import/export) strategy
10- Recurring Integrations Scheduler aka QuartzAX
11- Dynamics AX Integration samples and demos - Github
12- Authenticate with Dynamics 365 for Finance and Operations web services in on-premises
13- Custom services for Microsoft Dynamics 365 for Finance and Operations
14- Reading OData from Dynamics 365
15- Custom Web Service in few steps D365FO
16- D365FO - Azure authentication setup for web services (defined creds and interactive login)
17- Using OData to Count Records in a Table in Dynamics 365 for Finance and Operations
18- Service Endpoints, Authentication, and Integration Apps in Dynamics 365 for Operations
19- Test services by using third-party utilities
20- Using Postman to Test AX 2012 Web Services
21- USING POSTMAN WITH D365
22- Call x++ web service with web browser snippet
23- Consume a SOAP service in Dynamics 365 for Finance and Operations with ChannelFactory
24- Integration of Microsoft Dynamics 365 For Finance and Operations with 3rd Party Application Using Azure Service Bus

Data Entities

1- D365FO: Data entity filter on enum field
2- Add postTargetProcess method to a Data Entity via extension.

Troubleshooting

1- Fiddler Download
2- Procmon

Data Storage

1- Manage storage

Dynamics 365 Virtual Machine

1- Setup Dynamics 365 for Operations Virtual Machine
2- Setting up a personal Dynamics 365 For Operations, Enterprise Edition, development environment
3- Setting up a personal Dynamics 365 For Operations development environment
4- Virtual Machine(VM) setup to access Dynamics 365 for Operation instance
5- Running AX7 VM on Oracle VirtualBox
6- Download VirtualBox Guest Additions
7- How to Fix VirtualBox “UUID already exists” Errors
8- Access instances
9- How to rename a D365 virtual machine, link it to LCS, and optionally join it to a domain - Dynamics 365 for Finance and Operations, Enterprise edition
10- Rename a local environment to enable access to Visual Studio Team Services
11- Upgrade development VM from Windows evaluation version to “full” version
12- Export to Excel using Local VHD over LAN (Local Area Network).
13- Fix Certificate Issues on Development Machines
13.1 Renew Dynamics 365 for Finance and Operations Certificate on Dev Machine
14- Exposing Dynamics 365 Onebox to the LAN
15- Development and build VMs that don't allow administrator access FAQ
16- Update Visual Studio development tools
17- Call REST Webservice with HTTP Basic Authentication from X++

Development

1- Develop and customize using Visual Studio
2- Resolving X++ and metadata conflicts when merging code
3- Doing a code merge when a VAR/ISV has renamed an object
4- Collect Dynamics 365 for Finance and Operations event traces with Windows Performance Monitor
5- MSDyn365FO. Code to build cross reference data without a full compile.
6- Private, Protected and Public attribute access in Class Extension
7- D365FO Ninja Dev Tools
8- Customization Analysis Report (CAR)

Reports

1- Send SSRS Report as Email from Report Viewer in Dynamics 365 FO

Model

1- Inspecting a D365FO Meta Data Hotfix Content
2- Uninstall a deployable package in D365FO

Performance

1- How to run performance test for dynamics 365 ?
2- Performance SDK and multiuser testing in on-premises environments
3- DynamicsPerf 2.10 Available !!!

Visual Studio Team Services

1- Setting Up Version Control in Dynamics 365 for Operations with Visual Studio
2- Rename a local environment to enable access to Visual Studio Team Services
3- Visual Studio Team Services integration with Lifecycle Services
4- Continuous delivery home page
5- AX Developer ALM
6- Identities for Visual Studio subscribers
7- Setting Up Continuous Integrations in Dynamics 365 for Operations
8- Manage third-party models and runtime packages by using source control
9- How to setup automated deployments
10- How to setup automated deployments - Yammer Issue resolution
11- Migrate from TFVC to GIT
12- Code Compare
13- ComparisonTools

VSTS Build

1- Release your Dynamics 365 for Finance and Operation packages to LCS with Azure DevOps Pipelines
2- Setting up a development branch and build
3- How to setup build agent and create a build definition manually
4- Continuous / automated build setup on a non-Main Branch
5- Repost: Enabling X++ Code Coverage in Visual Studio and Automated Build
6- Service connections for builds and releases
7- Azure DevOps Release Pipeline
8- Developer tools and application lifecycle management
9- Release your Dynamics 365 for Finance and Operation packages to LCS with Azure DevOps Pipelines
10- Customize your build by selecting what models are part of the build definition
11- Azure DevOps Release Pipeline for Dyn365FO - Part 1: Automated Package Upload & Deploy via LCS API
12- Azure DevOps Release Pipeline for Dyn365FO - Part 2: Scheduled Releases with Approvals
13- MSDyn365 & Azure DevOps ALM


Upgrade

1- Upgrading to Dynamics 365 for Operations from Dynamics AX - things you really need to know
2- Code migration and upgrade home page
3- Upgrade from AX 2012 to Finance and Operations
4- Upgrade data in development, demo, or sandbox environments
5- [Video] How to Successfully Transition from Dynamics AX to Dynamics 365 Finance and Operations
6- In-place upgrade process for on-premises environments

WHS

1- Customizing the Warehousing Mobile App

Environment Setup

1- Importing users in D365 Operations using Excel

Scripts

1- Dynamics365-FinOps-DevOps

Power BI

1- Accessing Analytical Workspaces and Reports on 1Box environment
2- Configure PowerBI on Dynamics 365 FO developer VM
3- Activate the new Power BI Embedded Reports for Dynamics 365 for Finance and Operations
4- Power BI content from Microsoft and your partners
5- How to Configure Power BI integration for Dynamics 365 Workspaces
6- How to: Configure Power BI for Dynamics 365 for Operations
7- PowerBI Embedded in D365 Finance and Operations
8- How to: Configure Power BI Embedded for Dynamics 365 for Finance and Operations (One-box environment)

PowerApps

1- Product Drawing PowerApp. Part 1.
2- Demystifying PowerApps Environments – Part 4 – Trial Environments
3- Using PowerApps to support warehouse processes
4- Item translation embedded in D365FO
5- Leveraging PowerApps with Microsoft Dynamics On-Premise

Financial reporting

1- Financial reporting Landing page
2- How to Launch Report Designer in Dynamics 365 for Finance & Operations from Chrome
3- Reset the Financial reporting data mart
4- How to setup Financial reporting on D365FO local One box VM

Security

1- Setting Up Security in Dynamics 365 for Finance and Operations – Part I – From the User Interface
2- Setting Up Security in Dynamics 365 for Finance and Operations – Part II – From the AOT
3- Setting Up Security in Dynamics 365 for Finance and Operations – Part III – Security Management
4- Automated Role Access Testing Using the SysTestSecurityAttribute in D365FO
5- Interesting Behavior of Unpublished Objects in Dynamics 365 for Finance & Operations
6- Extensible Data Security (XDS) in Dynamics AX Finance and Operations

Hotfixes

1- Upgrades, Updates and Hotfixes in AX7
2- Install a metadata hotfix
3- Installing Application X++ Updates Still Sucks (part one)
4- Installing Application X++ Updates Still Sucks (part two)

Debug

1- Debug X++ against a copy of a production database
2- First chance exceptions - when D365FO doesn’t show stack trace

Warehouse App

1- Announcing Dynamics 365 for Operations – Warehousing
2- Install and configure Microsoft Dynamics 365 for Finance and Operations – Warehousing
3- Customizing the Warehousing Mobile App
4- Warehousing for on-premises deployments

Workflow

1- Approve Workflow via email using template placeholders #Dyn365FO
2- How to run workflow form in Google Chrome

What's New

1- Microsoft Dynamics 365 Roadmap
2- What's new or changed

Project Management

1- Dynamics 365 Project Timesheets Mobile app – Seamless Project timesheet entry and approvals on the Go in Dynamics 365 For Finance and Operations!
2- Sneak Peek into Mobile Applications Framework of New Dynamics AX/Dynamics 365 For Operations

Unit Test

1- July 2017 update: Form Adaptors Replaced by Type Providers
2- Using the Systest framework and Task Recorder in Dynamics 365 for Finance and Operations to create integration tests
3- Performance SDK and multiuser testing via Visual Studio Online
4- Enabling X++ Code Coverage in Visual Studio and Automated Build
5- Capture screenshots toggle doesn't appear on Task recorder
6- Regression Suite Automation Tool - Create unique values
7- Acceptance test library
8- Web conferences on Acceptance Test Library

RSAT

1- Regression Suite Automation Tool
2- RSAT - Testing Lifecycle Demo

Common Data Services

1- COMMON DATA SERVICES (CDS), DATA INTEGRATOR AND DYNAMICS 365, WHAT WILL YOU DO?
2- Integrate data into Common Data Service for Apps

Ideas

1- IDEAS

FastTrack

1- FastTrack for Microsoft Dynamics 365 - Tech Talks
2- Videos for Finance and Operations

Training

1- Microsoft Dynamics Courses
2- Microsoft Learn
3- D365FO DIARY
4- Browse learning
5- Dynamics 365 Ax Technical,Functional Tutorial Collection
6- FastTrack for Microsoft Dynamics 365 - Tech Talks - OLD
7- FastTrack for Microsoft Dynamics 365 - Tech Talks - NEW

This page will be update frequently!

Enjoy!