Useful [Sitecore] KQL Application Insights queries
As a successor to one of my previous posts, I would like to share some additional KQL queries which might help you during the troubleshooting…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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…
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:…
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…
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…