Masthead image for SitecoreFundamentals.com
Banner image for How to Resolve SQL Connection Errors During Sitecore Installation Due to Non-verifiable Certificates article

The Sitecore installation process has come a long way since the introduction of SIF. It has been flawless under countless runs, but I was recently tripped up due to a SQL connection error. In this post I'll explain the cause, resolution, and some steps to make your  next try of the installation easier. 

Read More
Banner image for A Guided Tour of the Exclude Robot by Agent Module article

I've had a deluge of requests for a walkthrough of my latest module and the way it can help with excessive garbage data in the xDB. In this video I'll introduce the xDB to non-developers, talk about identifying the cyber attack, and how we can ignore/not capture the false traffic to your site.

Read More
Banner image for Cutting a Useragent's Value When It Exceeds the Maximum Possible Length for xDB Databases article

It's taken years of managing Sitecore sites for this one to come across my desk, but apparently there's no protection for the UserAgent value being longer than the maximum allowed length when saving the User's session to the xDB. Though it's fixed since version 10, there's no patch for earlier instances, so we're going to have to add our own pipeline processor to cut the offending UserAgent values short.

Read More
Banner image for Dynamic Placeholder Management When You Can't, or Don't Want to Use Experience Editor article

Ok, so dynamic placeholders are very cool and definitely needed, but unlike standard placeholders we depend on using the experience editor to manage them. But what if it's not working, hasn't been coded properly to use EE, or is just too plain slow? Today I'll show you how to manage them with the much faster and more reliable content editor.

Read More
Banner image for Understanding 100% Database Usage Caused by Your Sitecore GenericProcessingPool Table article

While managing an instance of Sitecore I saw a bot got past the excludedUserAgents configuration, which means its traffic is recorded and we don't want that. Flushing the data out is simple with the Analytics Database Manager, but there are cases where there's transient data queued for processing in the GenericProcessingPool table, and it can be a problem.

Read More