Changing templates on items with search and powershell
I encountered a production issue where a deployment change had released several items to production where newly created content folders were of the wrong template type.
Single node Facets in the xDB database
The xDB Mongo database collects essential data about each visitor to your Sitecore site. While it automatically tracks page clicks, time spent on pages, and user identity, its real strength...
Bonfire Profile Information API
The Bonfire team focuses on digital marketing, Sitecore Experience Platform, and customer journey tracking. I frequently need to monitor how current test users or real users progress through their experience,...
Helix: Your Best Practice Guide to Sitecore Development
Sitecore is a dynamic and configurable content management system. However, its openness creates challenges, as developers can approach Sitecore implementation in numerous ways, leading to ongoing debates about best practices....
Moving controllers routes into Sitecore
I traditionally registered custom API controllers in Sitecore by modifying the Global.ascx.cs file, similar to standard ASP.NET MVC practices. However, when deploying packages to customer applications, overwriting the Global.ascx file...
Getting multilist from SQL
A client requested to export site structure via SQL, and I encountered a challenge with multilist controls that reference other items. Since selected items for a multilist is the item...
Order of Pipelines for the Analytics Tracker
I encountered challenges while developing a Tracker modification for Sitecore’s marketplace. The core issue involved determining which pipeline stage to use for custom code that calls an external API to...
Parsing the __Tracker object for indexing
This article addresses performance challenges when indexing Sitecore profile data. Martin Davies discussed in a presentation how the TrackingField object in Sitecore performs excessive processing beyond indexing needs.
AWS vs Azure for Sitecore
This article examines infrastructure options for Sitecore deployments, focusing on virtual machine configurations rather than PaaS solutions.
Reset Ektron Search Property on Content
This article addresses a limitation in Ektron’s content management system. When administrators modify the searchability checkbox on a folder, the change applies only to newly created content. Previously existing items...
Intellisense Issue When Using Sitecore Local NuGet Files
The Sitecore Instance Manager (SIM) tool introduced local NuGet support, eliminating the need to manually manage library folders and track DLL versions. However, users implementing this feature encountered a problem:...
Reseting the admin password to b
To reset the admin password to ‘b’ via SQL, run the following SQL on the core database:
Getting Sitecore out of SQL
Accessing Sitecore data directly through SQL queries has limitations compared to using Sitecore’s native API. Direct database queries bypass the caching mechanisms built into the platform.
Find size of all SQL tables
To find all the sizes of the SQL tables on disk, run the following query. This helps locate problematic databases and identify which tables consume the most storage resources.