9 Reasons Why Experience Analytics and SQL are buddies again in Sitecore 9

Couple of years back Sitecore launched No-SQL platform for analytics by collaboration with MongoDB. Which drastically increased scalability for websites struggling with performance issues using Sitecore Analytics on SQL with heavy traffic. Sitecore mandated to use Mongo for Analytics hence whoever was upgrading to the latest versions left with NO options other than implementing MongoDB. …

Continue reading 9 Reasons Why Experience Analytics and SQL are buddies again in Sitecore 9

Here I planned my 4 days @ Sitecore Symposium 2017

Four full days of excitement, knowledge sharing and meeting with brilliant minds. What else one can expect… But there is a lot more than you think which need to be planned per the schedule. Symposium 2017 Breakout Sessions have 5 different tracks with variety of session scheduled. Developer Track: This series of sessions is dedicated …

Continue reading Here I planned my 4 days @ Sitecore Symposium 2017

Estimation Tips for a Sitecore Upgrade

Most of us often try to reduce the time it takes to an upgrade. This is obviously appealing to the client. Less time = less money spent. And while it’s tempting to upgrade the Sitecore Instances quickly, be aware that these methods are not officially endorsed by Sitecore, and you may struggle to get help …

Continue reading Estimation Tips for a Sitecore Upgrade

Planning Sitecore Upgrade – Tips

Continuous updates and multiple yearly releases is the beauty of Sitecore which makes Sitecore more powerful, extendable and useful for everyone. But regular update introduce the need for upgrade the version which we are currently using as Upgrading is inevitable. Based on my Upgrade experiences, thought of penning some tips which can help you to …

Continue reading Planning Sitecore Upgrade – Tips

GeoIP Tracking in MongoDB and Forward Request HTTP Header

When we load balance your web site at layer 7, it will become non-transparent. This means that the actual client source IP address is replaced by the load balancer’s own IP address, and therefore ONLY this address will be recorded in the IIS logs. One way around this is to insert X-Forwarded-For headers on the load balancer to …

Continue reading GeoIP Tracking in MongoDB and Forward Request HTTP Header

Building Sitemap XML for Delivery Servers

OOB "Sitemap XML Module" generate the Sitemap XML on Content Management Servers only. To get it generated on Content Delivery Servers as well, we need to add a custom event. Normally we have atleast one Content Management and one Content Delivery Server. But on scalable and distributed architecure number of servers increases based on requirements. …

Continue reading Building Sitemap XML for Delivery Servers

Upgraded from 7.2 to 8.1, Sort by Relevance in Lucene is not working

We recently upgraded from 7.2 to 8.1 Update 2. We experienced that Sort by Relevance in Lucene search is not working when we are using Contains, StartsWith, EndsWith, Equals, Like, and MatchWildcard operators while building the search querying _fullpath.  Sample code: string sitePath = "/sitecore/content/home"; var results = SearchContext().GetQueryable<CustomResult>().Where(r => (r.Path.Contains(sitePath + "/")); So if we have …

Continue reading Upgraded from 7.2 to 8.1, Sort by Relevance in Lucene is not working

Sitecore MongoDB with SSL Customization

Worked on client requirement on Sitecore 8.1 to integrate MongDB with SSL client certificate. Client had their own SHA-2 SSL certificate and wanted to integrate Mongo with Sitecore using that. Customized MongoDB Pipeline: Customize the MongoDB pipeline  by defining  a new "updateMongoDriverSettings" pipeline in the Sitecore.Analytics.MongoDB.Config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <sitecore> <!-- MongoDB settings …

Continue reading Sitecore MongoDB with SSL Customization

Historical analytics data conversion to MongoDB for Sitecore 8.x – Batch Aggregation

Are you currently using Sitecore Analytics without MongoDB? Are you planning to upgrade Sitecore to 7.5 or upper version with MongoDB? If yes, its time to decide whether you want to convert the historical data or want to go with a fresh MongoDB setup. Cause if you want the historical analytics data, you need to go …

Continue reading Historical analytics data conversion to MongoDB for Sitecore 8.x – Batch Aggregation

Sitecore ShowConfig for Content Delivery

On lower environments if we want to view the ShowConfig we follow the URL mentioned below: /sitecore/admin/showconfig.aspx To access this URL the Sitecore and underneath folders should be accessible. But on Content Delivery most of the Client wants the Sitecore pages to be blocked, specially the Login and other Admin Pages. May be I am …

Continue reading Sitecore ShowConfig for Content Delivery