New Blog Space

UpdatedOctober 17, 2022

•1 min read

I've been working in and around SQL for over 3 decades.

I am currently working on making our business intelligence systems self-driven by using an event-based architecture. This involves providing curated data in some of the largest SQL Azure Analysis Services cubes ever built (over 6 billion records in 1 table alone).

I've developed several APIs leveraging a serverless Azure architecture to provide real-time data to various internal processes and projects.

Currently working on Project Dormouse; Durable select messaging queue that enables polling processes to extract specific messages.

I've decided to move my blog here. You'll see some old content being uploaded in the next few days. Look around, I hope you find some tidbits of information.

Older content focused on SQL Server and SSIS. Now I focus on the Azure ecosystem.

#azure #azure-functions #azure-data-factory #azure-sql-database

55 views

Comments (1)

Join the discussion

Eleftheria Batsou3y ago

Hi Josef Richberg, welcome to our community!

More from this blog

Analysis Services models in Azure Fabric -- METADATA$ROW_ID gotcha

For those of you entering the Microsoft Fabric foray, there is a big caveat you must be aware of. If you are using Fabric Mirroring or Delta Lake tables you will see an additional column in your data source: METADATA$ROW_ID. This column is added auto...

Sep 8, 20252 min read13

Analysis Services models in Azure Fabric -- METADATA$ROW_ID gotcha

Permissions required for user defined table types in Microsoft SQL Server

This has bitten me so many times, I’m putting this here where I can find it in the future. You might want to bookmark this page :) I rely heavily on stored procedures for interaction both internally and externally. The improve performance and efficie...

Jun 25, 20251 min read115

Permissions required for user defined table types in Microsoft SQL Server

Azure Data Factory utcNow() nuances

For those of you who work with Azure Data Factories I thought I’d help you out with, what I would consider a bug in how pipelines work. For the record, I work with pipelines on almost a daily basis, but I am generally pushing data into Microsoft SQL ...

Jun 3, 20252 min read75

Microsoft SQL Server permission chaining

Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta...

Jun 2, 20251 min read35

Microsoft SQL Server permission chaining

Using a stored procedure as a source for PowerBI Paginated reports

If the reports that you are building do not need to be interactive, you can use Microsoft Paginated Reports (or SSRS). One of the benefits of a paginated report is that it’s source(s) can be stored procedures. I really, really like that option.In Mic...

May 22, 20252 min read179

Using a stored procedure as a source for PowerBI Paginated reports

Untitled Publication

20 posts

I have over 34 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).

Command Palette

Comments (1)

More from this blog