@josefrichberg
Principal Data Architect, Azure @ Penguin Random House
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.
Nothing here yet.
Sep 8, 2025 · 2 min read · 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...
Join discussion
Jun 25, 2025 · 1 min read · 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...
Join discussion
Jun 3, 2025 · 2 min read · 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 ...
Join discussion
Jun 2, 2025 · 1 min read · 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...
Join discussion
May 22, 2025 · 2 min read · 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...
Join discussion