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).

How to Skip Rows in Azure Data Factory Pipeline's Excel Source

Jul 19, 20241 min read15 views

I was building a data factory source the other day and I needed to skip the first 5 rows. This is intuitive and easy within a text (csv) source as...

How to Skip Rows in Azure Data Factory Pipeline's Excel Source

Why Bit Masks?

Jul 3, 20244 min read19 views

Publishing is one of those industries where the possibilities are endless. This translates into 'endless combinations' as well. To sell a book you...

Why Bit Masks?

Prevent SQL Injection Attacks Using SQL Server Stored Procedures

Jun 4, 20242 min read45 views

SQL injection is a very serious topic and there are numerous libraries and best practices to help you secure your connection between your app and your...

Prevent SQL Injection Attacks Using SQL Server Stored Procedures

Extracting Azure Analysis Services Metrics from your Log Analytics workspace into PowerBI

Feb 6, 20242 min read129 views

We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run....

Extracting Azure Analysis Services Metrics from your Log Analytics workspace into PowerBI

About those Read-Only Replicas

Oct 26, 20233 min read57 views

In a post, I wrote last month I showed how you can take advantage of your replicas in SQL Sever by adding a single attribute to your connection string...

About those Read-Only Replicas

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

Sep 18, 20231 min read518 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