Press "Enter" to skip to content

Useful xDB troubleshooting queries

There is not much structure to be found in this post, I will mainly use it as a location to keep track of useful xDB…

Posted in Azure, Azure DevOps, Experience Analytics, Experience Profile, IAAS, PAAS, Sitecore, Xdb | Tagged , , , , , , | Leave a comment

Sitecore Identity server deployment: “AspNetCoreRuntime extension not found”

When you run in to the following ERROR while deploying your Sitecore XP solution, and in specific the Identity Server: 8:21:15 PM – Resource Microsoft.Web/sites/siteextensions…

Posted in App Service Deploy, ARM, Arm templates, AspNetCoreRuntime, Authentication, Azure, Azure DevOps, Deployments, PAAS, Sitecore, Sitecore Identity Server | Tagged , , , , , , | 7 Comments

Monitor Sitecore certificates and RunAsAccount(s) using Azure Automation

Using the instructions underneath you will be able to import an Azure Automation runbook that will alert you using Sendgrid before certificates will expire. The…

Posted in Azure, PAAS, Powershell, Sitecore | Tagged , , , , , , , , | Leave a comment

Sitecore Hotfix Version Selector

Because of the fact we are running a lot of different Sitecore versions for our customers we love to have a good overview of the…

Posted in Azure, Azure DevOps, PAAS, Powershell, Sitecore | Tagged , , , , , | 2 Comments

Validate (all) your Sitecore ARM templates on build

While working with ARM templates and Azure DevOps it definitely adds value to validate all your Json files during build. This might save you a…

Posted in ARM, Azure, Azure DevOps, PAAS, Powershell, Sitecore | Tagged , , , , , , , | 1 Comment

Rebuild your reporting database with electric speed

Since there is a lot of information to be found on the terribly slow rebuilding of your reporting database I would like to provide you…

Posted in Azure, Experience Analytics, Experience Profile, PAAS, Sitecore, Xdb | Tagged , , , , , , , , , , | 1 Comment

Restoring or migrating your Xdb data

Whenever you want to restore your Xdb data to another environment there are certain steps to take. I will take you through the steps to…

Posted in Azure, Experience Analytics, Experience Profile, PAAS, Sitecore, Xdb | Tagged , , , , , , , , , | Leave a comment

Report your team about Sitecore stats using Flow and AI

In reality I notice that not every person within a client team has or takes the time to look into the data that Sitecore is…

Posted in Application Insights, Azure, Flow, PAAS, Sitecore | Tagged , , , , , | Leave a comment

Rebuilding your Sitecore Xdb index [v9.0.1]

Since there is no complete out of the box functionality for rebuilding the Sitecore Xdb collection based on all historical data within your sql shards…

Posted in Azure, Experience Profile, PAAS, Sitecore, Xdb | Tagged , , , , , , | Leave a comment

Experience Analytics – there are errors

While pressing the tile ‘Experience Analytics’ in Sitecore 9, the following errors showed up: There are errors. The TopTenCampaignsByValue graph cannot be displayed due to…

Posted in Azure, Experience Analytics, Experience Profile, PAAS, Reporting, Sitecore, Xdb | Tagged , , , , , | Leave a comment

SQL Azure geo-replication error

While geo-replicating our SQL databases from one region to another region we ran into an issue. We were able to add geo-replication for the first…

Posted in Architecture, Azure, HA, PAAS, SQL, SQL Azure | Tagged , , , , | Leave a comment

Disabling Sitecore config files in Azure App Service using Azure DevOps

Since we are keen on keeping the Sitecore scwdp packages OOTB as untouched as can be (as of our deployment strategy) we have two type…

Posted in App Service Deploy, Azure, Azure DevOps, PAAS, Powershell, Sitecore | Tagged , , , , , , | Leave a comment

Baseline your Sitecore dashboards using ARM templates

In one of my previous posts (click) I mentioned some useful AI query’s for maintaining and managing your Sitecore solution. To make sure every Sitecore…

Posted in Application Insights, ARM, Azure, PAAS, Sitecore | Tagged , , , , , | Leave a comment

Sitecore Symposium 2018 – Must read takeaways!

“Returning from this year’s Sitecore Symposium in Orlando, I would like to share some improved/new insights that have come to me due to attending some…

Posted in App Service Deploy, ARM, Azure, Azure DevOps, IAAS, PAAS, Sitecore, Symposium, TFS | Tagged , , , , , , | Leave a comment

Check your Sitecore environment using these Application Insights query’s

While using Sitecore on Azure you will most likely be able to find your way around using Application Insights. Keeping your Sitecore instances running smooth…

Posted in Application Insights, Azure, PAAS, Powershell, Sitecore | Tagged , , , , | Leave a comment

Monitor your Azure SSL certificate expiration

Using the instructions underneath you will be able to import an Azure Automation runbook that will alert you using Sendgrid whenever certificates will expire. The…

Posted in Azure, PAAS, Powershell, Sitecore | Tagged , , , , , | 4 Comments

Replacing the Sitecore client certificate on Azure in 5 steps

These instructions are for a Sitecore 9.0.1. XP1 Topology – on Azure. For using X-connect there is a need of using client certificates. In Azure…

Posted in Azure, PAAS, Powershell, Sitecore | Tagged , , , , | 4 Comments

Download Sitecore media items to local disk

For one of our customers we were in need of downloading all media files from Sitecore to our local hard disk. Since we are using…

Posted in Azure, PAAS, Powershell, Sitecore | Tagged , , , | Leave a comment

ETIMEDOUT issues on App Service Deploy task (TFS)

We experienced issues while uploading files to the slot of an App Service. We were using the Azure App Service Deploy task. We have approximately…

Posted in App Service Deploy, Azure, PAAS, Sitecore, TFS | Tagged , , , , | Leave a comment

Sugcon 2018 Berlin

Since there were 60 sessions to participate in, it seemed like a hard job to make a selection. On the other hand, there weren’t as…

Posted in Azure, IAAS, PAAS, Sitecore | Tagged , , , , , | Leave a comment

Appsettings not present after ARM deployment

Within the config section of an App Service you are able to define multiple sections. In this example we are using three sections : web,…

Posted in ARM, Azure, PAAS | Tagged , , , , | Leave a comment

Sitecore 9.0.1 – xcServerConfigurationEnvironment parameter

We’re setting up an automated deployment using the Sitecore ARM templates. Doing so we came across the following parameter: xcServerConfigurationEnvironment This variable can contain either…

Posted in ARM, Azure, PAAS, Sitecore | Leave a comment

Sitecore hardening using Azure App Authentication

With Azure App Authentication it is easy to secure your app with an identity provider. The steps to take are described at the following page:…

Posted in AAD, Authentication, Azure, Hardening, PAAS, Powershell, Sitecore | Tagged , , , , , , , | 2 Comments

ipSecurityRestrictions on Azure App Services

With the powershell scripts underneath you can easily close and open traffic towards your azure app services. Note: by adjusting the resource name variable you…

Posted in Azure, PAAS, Powershell, Sitecore | Tagged , , , , , , | Leave a comment

How to export Sitecore SQL Azure databases to Storage Account

The script underneath can be used to export a sql azure database to a storage account. It will create a storage account if it does…

Posted in Azure, PAAS, Powershell, Sitecore | Tagged , , , | Leave a comment