Sitecore MVP 2022
Legal Notice
The opinions expressed herein are my own personal opinions and do not represent my employer’s view in anyway.Top Posts
- C# HttpClient POST or PUT Json with content type application/json
- C# DateTime to UNIX timestamps
- C# get results from Task.WhenAll
- Run tasks in parallel using .NET Core, C# and async coding
- C# Log to Application Insights and File from your .NET 6 Application
- Using C# HttpClient from Sync and Async code
- C# Get expiry timestamp from JWT token
Archive
Meta
Tag Archives: SQL
C# SQL Connection Using Azure Managed Identity
Azure Managed Identity is Microsoft’s solution to manage credentials for you, eliminating the need to store usernames, passwords, certificates and other secrets in your config files. Basically, with Managed Identity you establish a trust between a server and a resource. … Continue reading
Posted in .net, .NET Core, c#, General .NET, Microsoft Azure
Tagged Azure, Dapper, Managed Identity, SQL
Leave a comment
Create C# Class from SQL
I hate doing plumbing code. Especially entity model classes that are exact replicas of SQL tables. I do this all the time when using Dapper. So I did some googling and found some SQL statements that you can run in … Continue reading
Sitecore high CPU usage – is the SQL Session State Provider the villain?
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 Performance, Session state, Sitecore, SQL
Leave a comment
Sitecore read from Custom Database
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 Configuration, Dapper, Sitecore, SQL
Leave a comment
Create a custom Azure Dashboard Tile Using an Azure Function and Markdown Format
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 Azure, Azure Dashboard, Azure Function, Grafana, SQL
1 Comment
C# Using Dapper as your SQL framework in .NET Core
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
System.DllNotFoundException: Unable to load DLL ‘sni.dll’ or one of its dependencies: The specified module could n ot be found. (0x8007007E)
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
Improve Sitecore Membership provider performance 2-20 times
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
Sitecore poor database performance
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
Brian Pedersen's Sitecore and .NET Blog 