Sitecore Upgrade – Database Compatibility

In this blog I will share with you my recent experience with Sitecore upgrade, in a recent Sitecore upgrade I worked on I got the databases from my client, I restored them in my SQL server 2012 and complete the upgrade, I send the databases to client and asked them to restore to their database  server;  unfortunately they have SQL Server 2008 R2 and they don’t want to upgrade, So what I should do?

Building Custom Analytics Report – Part3 – SPEAK Report

In the previous posts of this blog series I discussed the business needs for building a custom analytics report and I showed how you can collect data into MongoDB and aggregate this data into the reporting SQL server database, now it’s time to display data as a report and of course adding this report to the existing reports under experience analytics.

Before starting you will need to install Sitecore Rocks plugin to your Visual Studio IDE, you can download it from here

Build Custom Analytics Report - Part 2 – Storing and Retrieving Data

In part 1 of this blog posts series I discussed the business needs for building a custom analytics report, In this part I will show you how you can save your analytics data to MongoDB using the analytics tracker, then how you can aggregate this data into reporting SQL server database, in future blogs posts will show you how we can build SPEAK application to display the data and how you can extend the analytics filters based on your report needs