Creating, Deleting and Updating Records in the Data Export Service for Dynamics 365

The Data Export Service for Common Data Service apps such as Dynamics 365 is used to copy data from the cloud-based Dynamics 365 data store to an Azure SQL Server database. Let’s look at some synchronization examples. First, let’s connect to our Azure SQL database and search our accounts for an account where the name is TEST. We can see it does not exist: Now, in the Dynamics 365 org, … Continue reading Creating, Deleting and Updating Records in the Data Export Service for Dynamics 365

Best Practices Analyzer for USD – Recommendations

Following on from previous posts, below is a list of Unified Service Desk Best Practices Analyzer recommendations. Note these were run in a test environment and may not reflect the outcomes of what you would see if run in your environments: Hard Disk Space: Enable Automatic Crash Recovery: Client Caching: Process Termination Threshold: Internal WPF Hosting Type: Action Calls in PageLoadComplete Event: Action Calls in DesktopReady Event: Action Calls in … Continue reading Best Practices Analyzer for USD – Recommendations

Best Practices Analyzer for USD – Setup and Using

In a previous post we installed the Unified Service Desk Best Practices Analyzer. Now we will go into the setup. First, we will create a hosted control. Go to Settings->Unified Service Desk: Hosted Controls: Click New: Enter the following configuration for a new hosted control, with: Microsoft.Crm.UnifiedServiceDesk.BestPracticesAnalyser Microsoft.Crm.UnifiedServiceDesk.BestPracticesAnalyser.BestPracticesAnalyserControl Note the hosted control assembly should exist in the USD client of the USD version that supports the Best Practices Analyzer. You … Continue reading Best Practices Analyzer for USD – Setup and Using

Getting the Connection String to an Azure SQL Database using Visual Studio

To get the connection to an Azure SQL Database using Visual Studio, do the following. Log into Visual Studio and select Server Explorer: Choose SQL Server and click Continue: Enter your connection information and click OK: The database will appear under Data Connections. Click Properties: Then, under Properties, you will see the Connection String:  

How to Install SQL Server Management Studio from Download

To install SQL Server Management Studio (SSMS) without installing the full version of SQL Server database, go to https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 and click the Download link: Open the downloaded file: Click Install: Click Close: SSMS is now installed. Search for it in Windows to open it: The application will load: From here, you can connect to a SQL Server:  

How to Create a Log Analytics Workspace in Azure

To set up Azure Log Analytics Workspaces, go to https://portal.azure.com and search for Log Analytics Workspaces, then select it. You will see the window below. Click Add: Select a resource group and provide a unique name, then click Review and Create: Click Create: Click Go to Resource: The resource has been created: If you go to Logs, you will have the ability to query the logs:  

Creating an ASP.NET Core 3.1 Visual Studio Project with Sample

In this post, we will install an ASP.NET Core 3.1 Project in Visual Studio. This will also install the Weather sample. To do this, first open Visual Studio, create a new project: Search for ASP.NET Core Web Application: Enter a name, e.g. Carl.Weather.API and click Create: Select ASP.NET Core 3.1 and API and click Create: We see the project created: Press F5 to run. We see the weather forecast sample … Continue reading Creating an ASP.NET Core 3.1 Visual Studio Project with Sample

How to Delete a GitHub Branch

To delete a GutHub branch go to the repo and select Branches: There is a delete icon: It will now show as Deleted:  

Sending and Accepting a GitHub Repository Invitation

In this post, we will look at how to send an invite to a user in GitHub and how the user can accept the invite to a repository. First, go to the repo and go to Settings->Manage Access, then Invite a Collaborator: Enter the collaborator’s GitHub name: And click Add: Now copy the link and send it to the user: E.g. https://github.com/carldesouzacom/my-console-app/invitations When the user clicks on the link, they will … Continue reading Sending and Accepting a GitHub Repository Invitation

Creating and Approving Pull Requests in GitHub

In this post, we will go through creating and approving pull requests in GitHub. Our example will include multiple reviewers. First, let’s go to a repo and change a file. We will update the version number of an assembly: Change the version: Now, we will create a new branch based off this change: This takes us to the Pull Request. Let’s add some reviewers by clicking the link on the … Continue reading Creating and Approving Pull Requests in GitHub