Cannot Provision Skype for Business / Microsoft Teams Audio Conferencing License via CSP
Mar24

Cannot Provision Skype for Business / Microsoft Teams Audio Conferencing License via CSP

The Audio Conferencing add-on for Skype for Business / Microsoft Teams can oft be a requirement if you find yourself needing to schedule frequent online meetings that involve external participants. While most tech-savvy organisations these days will be fully equipped for taking calls via their laptops or other devices, a lot of businesses still do rely on traditional telephone headsets as… Continue Reading The CRM Chap’s...

Read More
Ranking Categories within Power BI Datasets (DAX)
Mar17

Ranking Categories within Power BI Datasets (DAX)

I’ve been doing some work with Power BI Online datasets this week. It’s the first time I’ve taken a look at them in any great detail, as I have traditionally preferred to create and deploy any data sources needed for my reports via the Desktop client. Datasets address the needs for users who do not necessarily have the necessary Power Query/DAX language and require a mechanism to quickly hook… Continue Reading...

Read More
Backup Azure SQL Database within Azure DevOps Release Pipeline
Mar10

Backup Azure SQL Database within Azure DevOps Release Pipeline

Software deployments and updates are always a painful event for me. This feeling hasn’t subsided over time, even though pretty much every development project I am involved with these days utilises Azure DevOps Release Pipelines to automate this whole process for our team. The key thing to always stress around automation is that it does not mean that all of your software deployments suddenly… Continue Reading The CRM...

Read More
“Cannot move resources because some site(s) are hosted by other resource group(s)…” Error Message (Azure Web App)
Mar03

“Cannot move resources because some site(s) are hosted by other resource group(s)…” Error Message (Azure Web App)

After a few months of working with Microsoft Azure, you start to become familiar with the concepts behind the Resource Manager model and also how it is possible to move resources around, depending on business requirements. Whereas in the past, you would typically need to open a support request to Microsoft to complete this action, the vast majority of these operations can now be given to Azure… Continue Reading The CRM...

Read More
“Access to the registry key…” Error in PowerShell Script Task (Azure DevOps)
Feb24

“Access to the registry key…” Error in PowerShell Script Task (Azure DevOps)

As epitomised by the recent rebranding exercise Microsoft conducted with the product, I very much see Visual Studio Team Services/Team Foundation Server Azure DevOps becoming an increasingly dominant tool for development teams the world over. I came into the product after discovering its benefits from Ben Walker at a CRMUG meeting a few years back and, since then, the product has proved to be… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Summary Post
Feb17

Exam 70-778 Revision Notes: Summary Post

For the past 13 weeks on the blog, I have delivered a series of posts concerning Microsoft Exam 70-778, specifically focused towards providing a set of detailed revision notes that cover the broad array of Power BI features assessed as part of the exam. To round things off, today’s blog will bridge together everything I have discussed thus far in the series; with the hope being that this post… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Working with Apps and App Workspaces
Feb10

Exam 70-778 Revision Notes: Working with Apps and App Workspaces

Welcome to the final post in my blog series concerning Microsoft Exam 70-778, where I hope to provide a revision tool for those planning to take the exam or a learning aid for those looking to increase their Power BI knowledge. Last weeks post discussed a range of topics about access and security when using Power BI as your Business Intelligence solution. We now move onto the final exam focus… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Securing Power BI Dashboards, Reports and Apps
Feb03

Exam 70-778 Revision Notes: Securing Power BI Dashboards, Reports and Apps

Welcome to the twelfth and penultimate post in my blog series concerning Microsoft Exam 70-778, where I hope to provide a revision tool for those planning to take the exam or a learning aid for those looking to increase their Power BI knowledge. We’re on the home stretch now and, after reviewing last week the various options available to publish Power BI Reports both online and on-premise, we… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Publish and Embed Reports
Jan27

Exam 70-778 Revision Notes: Publish and Embed Reports

Welcome to the eleventh post in my blog series concerning Microsoft Exam 70-778, where I hope to provide a revision tool for those planning to take the exam or a learning aid for those looking to increase their Power BI knowledge. In last week’s post, we covered a broad spectrum of topics ranging from Dashboards through to integrating on-premise data sources within Power BI Online. Dashboards… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Report Publishing, On-Premise Gateway & Creating Dashboards
Jan20

Exam 70-778 Revision Notes: Report Publishing, On-Premise Gateway & Creating Dashboards

Welcome to my tenth post in a blog series aimed to provide a revision tool for Microsoft Exam 70-778, and for those looking to increase their expertise in Power BI. In last week’s post, we explored the possibilities developers have to leverage Power BI within their applications and how the Power BI API relates to all this. As we now get into the home stretch, this weeks post combines two exam… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Managing Custom Reporting Solutions
Jan13

Exam 70-778 Revision Notes: Managing Custom Reporting Solutions

Welcome to post number nine in my series designed to provide a revision tool for Microsoft Exam 70-778, and for those looking to increase their expertise in Power BI. The topics we have covered so far in the series have all involved Power BI Desktop primarily, and we now move away from this as we evaluate how to Manage Custom Reporting Solutions with Power BI. This focus area for the exam… Continue Reading The CRM Chap’s...

Read More
Exam 70-778 Revision Notes: Create and Format Interactive Visualizations
Jan06

Exam 70-778 Revision Notes: Create and Format Interactive Visualizations

Happy New Year! As 2019 dawns upon us, Microsoft Business Application professionals start in the right place, as the concept of the Power Platform starts to take hold. Through this, it is pleasing to observe more consistency across these range of products, with regular releases, increased integration and better learning tools, provided directly from Microsoft. I’ve mentioned this previously on… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Creating Hierarchies
Dec30

Exam 70-778 Revision Notes: Creating Hierarchies

The New Year is almost upon us, meaning its time to put in place some resolutions for the year ahead. I can think of no better commitment then to learn more about Power BI in 2019, which is hopefully the reason why you are reading this right now . Welcome to the eighth post in my series concerning Microsoft Exam 70-778, where I hope to provide a learning/revision tool for anyone who is taking… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Utilising KPIs with Gauge Visualisations
Dec23

Exam 70-778 Revision Notes: Utilising KPIs with Gauge Visualisations

As we move into the festive period, now is the time to put your feet up, relax, take stock for the year ahead…or, if you are reading this over Christmas, grab the opportunity to learn more about Power BI . In the seventh post in my series concerning Microsoft Exam 70-778, we move away from the suitably large subject area of DAX into a topic much more visually focused and accessible – Measure… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Using DAX for Calculated Columns
Dec16

Exam 70-778 Revision Notes: Using DAX for Calculated Columns

Welcome to post number 6 in my series concerning Microsoft Exam 70-778. The series aims to provide a revision tool for those who are looking at taking the exam and to also provide an introduction into some of the fundamental concepts around Power BI. As alluded to previously on the blog, Power BI is increasingly a topic that Dynamics 365 Customer Engagement professionals need to grapple with,… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Create and Optimise Data Models
Dec09

Exam 70-778 Revision Notes: Create and Optimise Data Models

Another week, another Power BI post This is the fifth post in my series focusing on Microsoft Exam 70-778, where I aim to provide a detailed overview and description of the skills needed to tackle the exam successfully. Last week’s post rounded off the opening theme, Consuming and Transforming Data By Using Power BI Desktop, as we focused on the options available to us to help tidy up data… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Cleansing Data
Dec02

Exam 70-778 Revision Notes: Cleansing Data

Welcome to the third post in my series on Microsoft Exam 70-778, where I aim to provide a detailed overview and description of the skills needed to tackle the exam successfully. We saw in the previous post how we could use the Power Query Editor to perform a multitude of different transformations against data sources; this will now be taken further, as we start to look at how to ensure optimal… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Performing Data Transformations
Nov25

Exam 70-778 Revision Notes: Performing Data Transformations

Welcome to the second post in my series concerning Microsoft Exam 70-778, where I hope to provide a detailed revision tool for those preparing to take this exam. Last week’s post introduced the fundamental notions behind connecting to data sources in Power BI Desktop, and we will lead on from this to look at the Perform transformations topic, which covers the following skills: Design and… Continue Reading The CRM...

Read More
Exam 70-778 Revision Notes: Importing from Data Sources
Nov18

Exam 70-778 Revision Notes: Importing from Data Sources

As discussed recently on the blog, I have been on a journey to try and attain the Microsoft Certified Solutions Associate Certification in BI Reporting. I was very fortunate to overcome the final hurdle of this task by passing Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI the other day. I enjoyed the opportunity to dive deeper into the world of Business Intelligence,… Continue Reading The CRM Chap’s...

Read More
WP GDPR Compliance Plugin Vulnerability: Check your WordPress Site NOW!!
Nov11

WP GDPR Compliance Plugin Vulnerability: Check your WordPress Site NOW!!

I don’t typically stray too far from Microsoft technology areas as part of this blog, but having experienced this particular issue at the coalface and, being acutely aware of the popularity of the WordPress platform for many bloggers, I thought I’d do a specific post to help spread awareness. For those who are in a hurry… TL;DR VERSION: IF YOU ARE USING THE WP GDPR COMPLIANCE PLUGIN ON YOUR… Continue Reading...

Read More
My thoughts on Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel
Nov04

My thoughts on Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel

The life of a Dynamics CRM/Dynamics 365 for Customer Engagement (CRM/D365CE) professional is one of continual learning across many different technology areas within the core “stack” of the Business Applications platform. Microsoft has clarified this in no uncertain terms recently via the launch of the Power Platform offering, making it clear that cross-skilling across the various services… Continue Reading The CRM...

Read More
Configuring PIN-less Entry for Skype for Business Online Audio Conferencing
Oct28

Configuring PIN-less Entry for Skype for Business Online Audio Conferencing

The whole concept of audio conferencing – the ability for a diverse range of participants to dial into a central location for a meeting – is hardly a new concept for the 21st century. Its prevalence, however, has undoubtedly grown sharply in the last 15-20 years; to the point now where, to use an analogy, it very much feels like a DVD when compared to full video conferencing, à la Blu-Ray…. Continue Reading The CRM...

Read More
ERROR_FILE_IN_USE when Deploying .NET Core App to Azure App Service (VSTS/Azure DevOps)
Oct21

ERROR_FILE_IN_USE when Deploying .NET Core App to Azure App Service (VSTS/Azure DevOps)

Towards the back end of last year, I discovered the joys and simplicity of Visual Studio Team Services (VSTS)/Azure DevOps. Regardless of what type of development workload that you face, the service provides a whole range of features that can speed up development, automate important build/release tasks and also assist with any testing workloads that you may have. Microsoft has devoted a lot… Continue Reading The CRM Chap’s...

Read More
Solution Import Errors on Marketing List Entity (Dynamics 365 Customer Engagement Version 9.0+)
Oct14

Solution Import Errors on Marketing List Entity (Dynamics 365 Customer Engagement Version 9.0+)

The importance of segregated deployment environments for any IT application cannot be understated. Even if this only comprises of a single test/User Acceptance Testing (UAT) environment, there are a plethora of benefits involved, which should easily outweigh any administrative or time effort involved: They provide a safe “sandbox” for any functionality or developmental changes to be carried… Continue Reading The CRM...

Read More
Incoming Emails Not Synchronizing in Dynamics CRM/Dynamics 365 Customer Engagement
Oct07

Incoming Emails Not Synchronizing in Dynamics CRM/Dynamics 365 Customer Engagement

Earlier this month, a colleague escalated an issue to me involving Dynamics CRM/365 Customer Engagement (CRM/D365CE), specifically relating to email tracking. This feature is by far one of the most useful and unwieldy within the application, if not configured correctly. In days of yore, the setup steps involved could be tedious to implement, mainly if you were operating within the confines of… Continue Reading The CRM...

Read More
Managing Azure Data Factory Triggers During an Azure DevOps Deployment
Sep30

Managing Azure Data Factory Triggers During an Azure DevOps Deployment

The introduction of Azure Data Factory V2 represents the most opportune moment for data integration specialists to start investing their time in the product. Version 1 (V1) of the tool, which I started taking a look at last year, missed a lot of critical functionality that – in most typical circumstances – I could do in a matter of minutes via a SQL Server Integration Services (SSIS) DTSX… Continue Reading The CRM...

Read More
The September 2018 General Availability Release for the Azure Information Protection Client
Sep23

The September 2018 General Availability Release for the Azure Information Protection Client

The very nature of how businesses or organisations operate means that the sheer volume of sensitive or confidential data that can grow over time presents a genuine challenge from a management and security point of view. Tools and applications like cloud storage, email and other information storage services can do great things; but on occasions where these are abused, such as when an employee… Continue Reading The CRM...

Read More
Handling British Summer Time/Daylight Savings Time in Azure SQL
Sep16

Handling British Summer Time/Daylight Savings Time in Azure SQL

Is it just me or is British Summer Time (BST) AKA Daylight Saving Time (DST) an utterly pointless endeavour these days? Admittedly, on its introduction in 1916, it fulfilled a sensible objective – to provide more daylight hours during the summer. For agricultural, construction or other services that are reliant on sufficient light to carry out their work, this was a godsend. In today’s modern… Continue Reading The...

Read More
A Beginner’s Guide to using FOR JSON in SQL Server
Sep09

A Beginner’s Guide to using FOR JSON in SQL Server

When it comes to handling large datasets in a formal, structured and highly scalable manner, nothing beats SQL Server. Having worked with the product for almost six years, I always look forward to the opportunity of putting together some SQL queries or to build out a new database. I think of it as a nice little treat, a reward amongst the midst of other, sometimes tedious, tasks that I have to… Continue Reading The CRM...

Read More
The Mystery of the Missing Workflow Sitemap Area Revisited (Dynamics 365 Customer Engagement)
Sep02

The Mystery of the Missing Workflow Sitemap Area Revisited (Dynamics 365 Customer Engagement)

I’ve gone on record previously saying how highly I rate the Dynamics CRM/Dynamics 365 Customer Engagement (CRM/D365CE) community. Out of all the groups I have been a part of in the past, you couldn’t ask for a more diverse, highly passionate and – most importantly of all – helpful community. There are a lot of talented individuals out there which put a metric tonne of effort into providing the… Continue...

Read More
‘Access to the path…is denied’ Build Definition Error (Visual Studio Team Foundation Server/Team Services)
Aug26

‘Access to the path…is denied’ Build Definition Error (Visual Studio Team Foundation Server/Team Services)

A vital part of any DevOps automation activity is to facilitate automatic builds of code projects on regular cycles. In larger teams, this becomes particularly desirable for a multitude of reasons: Provides a means of ensuring that builds do not contain any glaring code errors that prevent a successful compile from taking place. Enables builds to be triggered in a central, “master” location,… Continue Reading The CRM...

Read More
Some Thoughts on the Cyber Essentials Scheme
Aug19

Some Thoughts on the Cyber Essentials Scheme

Cybersecurity should be an ongoing concern for any organisation, regardless of its size and complexity. This is chiefly for two essential business reasons: A cybersecurity incident or breach could, depending on its severity, result in significant reputational or financial damage if not adequately safeguarded against or handled correctly. When judging whether to award a contract to a business… Continue Reading The CRM...

Read More
The Mystery of the Missing Workflow Sitemap Area (Dynamics 365 Customer Engagement)
Aug12

The Mystery of the Missing Workflow Sitemap Area (Dynamics 365 Customer Engagement)

UPDATE 02/09/2018: It turns out that there is a far better way of fixing this problem. Please click here to find out more. I thought I was losing my mind the other day. This feeling can be a general occurrence in the world of IT, when something completely random and unexplainable happens – emphasised even more so when you have a vivid recollection of something behaving in a particular way. In… Continue Reading The CRM...

Read More
‘Could not create a managed connection manager’ Error Message on SSISDB .dtsx Package Execution
Aug05

‘Could not create a managed connection manager’ Error Message on SSISDB .dtsx Package Execution

SQL Server Integration Services (SSIS) package execution can always throw up a few spanners, particularly when it comes to the task of deploying packages out to a SQL Server SSISDB catalog – principally, a specialised database for the storage of .dtsx packages, execution settings and other handy profile info to assist with automation. Problems can generally start creeping if you decide to… Continue Reading The CRM...

Read More