Tag Archives: SQL

Sitecore high CPU usage – is the SQL Session State Provider the villain?

Posted on November 25, 2021 by briancaos

My massive Sitecore 9.1 installation started having CPU spikes, even when the servers did not seem to receive more requests. When CPU spiked, I could see that the requests queue would build up, until it crashed with the following error: … Continue reading →

Posted in Sitecore 7, Sitecore 8, Sitecore 9 | Tagged , , , | Leave a comment

Sitecore read from Custom Database

Posted on September 21, 2021 by briancaos

It is very easy to read from a custom database in your Sitecore code. STEP 1: ADD THE CONNECTIONSTRING TO CONNECTIONSTRINGS.CONFIG This is an example of a .config file that transforms the connection strings for existing Sitecore databases (like the … Continue reading →

Posted in c#, General .NET, Sitecore, Sitecore 6, Sitecore 7, Sitecore 8, Sitecore 9 | Tagged , , , | Leave a comment

Create a custom Azure Dashboard Tile Using an Azure Function and Markdown Format

Posted on August 20, 2021 by briancaos

The tiles on an Azure Dashboard will only display data from Azure itself. So if you have data from the outside, like a database, you need to make a few workarounds. Now, you cannot make your custom tile as pretty … Continue reading →

Posted in .NET Core, c#, Microsoft Azure | Tagged , , , , | 1 Comment

C# Using Dapper as your SQL framework in .NET Core

Posted on June 11, 2021 by briancaos

Dapper is a easy to use object mapper for .NET and .NET Core, an it can be used a variety of ways. I use Dapper instead of Entity Framework because it makes my code less complex. BASICS OF DAPPER: THE … Continue reading →

Posted in .net, .NET Core, c#, General .NET | Tagged , , | 1 Comment

System.DllNotFoundException: Unable to load DLL ‘sni.dll’ or one of its dependencies: The specified module could n ot be found. (0x8007007E)

Posted on March 11, 2020 by briancaos

This message happens when deploying my .NET Core 3.1 application to production (when compiling the code to an .exe file), but not when running the application locally. It turns out, that Dapper is missing a reference to System.Data.SqlClient. Adding the … Continue reading →

Posted in .net, .NET Core, c# | Tagged , , | 2 Comments

Improve Sitecore Membership provider performance 2-20 times

Posted on September 2, 2014 by briancaos

Sitecore Membership performance can be increased dramatically by changing stored procedures and create new indexes. Try this before you write your own membership provider. Continue reading →

Posted in Sitecore, Sitecore 6, Sitecore 7 | Tagged , , , | 8 Comments

Sitecore poor database performance

Posted on February 10, 2012 by briancaos

If you experience decreasing performance in your Sitecore solution, it’s not always your fault. And it’s not always Sitecore’s fault either. The database is usually the last place I would look for performance issues. Most performance issues comes from poor XSLT … Continue reading →

Posted in Sitecore 6 | Tagged , , , , | 1 Comment