Waiting Impatiently

xDB Development

Multi-node xDB Facet

A previous post covered creating single-node facets for xDB to track contact information like name, company, and location. This article extends that concept to multi-entity facets using arrays, enabling tracking...

Sitecore PowerShell

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.

xDB Sitecore

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...

Sitecore

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,...

Sitecore

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....

Sitecore

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...

Sitecore SQL

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...

Sitecore xDB

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...

Sitecore

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.

Sitecore AWS Azure

AWS vs Azure for Sitecore

This article examines infrastructure options for Sitecore deployments, focusing on virtual machine configurations rather than PaaS solutions.

Ektron SQL

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...

Sitecore

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:...

Sitecore SQL

Reseting the admin password to b

To reset the admin password to ‘b’ via SQL, run the following SQL on the core database:

Sitecore SQL

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.

SQL

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.