Josef Richberg's Blog

Josef Richberg

Josef Richberg

2 followers

I have over 31 years in the world of RDBMS. I have in-depth knowledge of Microsoft SQL Server and the Azure platform (Data Factories, Logic Apps, Functions, Event Grids).

Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# application

Sep 18, 20231 min read 17 views

If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas. Using this connection...

Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# application

How to curb aggressive parallelism in Microsoft SQL Server

Sep 6, 20232 min read 24 views

Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is...

How to curb aggressive parallelism in Microsoft SQL Server

Efficient calculation of an ISBN-13 check digit

Jul 10, 20231 min read 68 views

I thought I might pass along, what I have found to be, the most efficient way to validate the check digit within Azure SQL Server. I was looking to go...

Efficient calculation of an ISBN-13 check digit

Pulling Azure Analysis Services logs from Azure Log Analytics into PowerBI using Kusto Query Language (KQL)

May 17, 20232 min read 168 views

We have very large Analysis Services(SSAS) cubes with billions of records and hundreds of users so we need to be able to monitor the performance of...

Pulling Azure Analysis Services logs from Azure Log Analytics into PowerBI using Kusto Query Language (KQL)

Moving dates to a weekending date

Nov 5, 20222 min read 253 views

Aligning dates · In publishing, and I’m sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two...

Moving dates to a weekending date

Improved data loads from Snowflake to Azure Synapse Analytics

Oct 30, 20223 min read 325 views

My responsibilities revolve around providing the business with the data they need to make informed business decisions. One of those processes requires...

Improved data loads from Snowflake to Azure Synapse Analytics