{"_id":"634b7e3ff07be352b6a758e6","wwwPrefixedDomainStatus":{"certIssued":true,"ready":true},"betaFeatures":{"newsletter":false,"embeds":false,"csvImport":false,"customCSS":false,"githubAsSource":false,"payments":false,"rssIntegration":false,"magazineLayout":false,"allowGithubBackupForTeams":false},"views":{"today":0,"thisWeek":125,"lastWeek":90,"thisMonth":469,"allTime":6487},"stripe":{"connected":false},"emailPreferences":{"draftSubmissionNotifications":true},"wwwPrefixedDomain":"www.josefrichberg.com","numFollowers":0,"badgePageEnabled":true,"membersPageEnabled":true,"newsletterPageEnabled":true,"newsletterEnabled":true,"audioBlogEnabled":true,"audioBlogVoiceType":"male","textSelectionSharerEnabled":true,"newsletterFrequency":"asap","staticPages":[],"isFeatured":false,"dailyViewsForCurrentMonth":{"1692921600":9,"1693008000":17,"1693094400":11,"1693180800":16,"1693267200":9,"1693353600":8,"1693440000":14,"1693526400":12,"1693612800":15,"1693699200":14,"1693785600":16,"1693872000":9,"1693958400":30,"1694044800":33,"1694131200":7,"1694217600":18,"1694304000":16,"1694390400":7,"1694476800":15,"1694563200":16,"1694649600":18,"1694736000":11,"1694822400":14,"1694908800":9,"1694995200":24,"1695081600":16,"1695168000":16,"1695254400":16,"1695340800":38,"1695427200":15},"viewCountVisible":true,"readTimeHidden":false,"customCSSEnabled":false,"domainChecklistSkipped":false,"umamiDataImported":true,"isGithubAsSourceConnected":false,"githubAsSourceDetails":null,"blockBackupAllButton":false,"author":{"_id":"634b7e077b9ff55063442c85","socialMedia":{"twitter":"https://twitter.com/josefrichberg","instagram":"","github":"","stackoverflow":"","facebook":"","website":"https://josefrichberg.com","linkedin":"https://linkedin.com/in/josefrichberg","youtube":"https://www.youtube.com/c/JosefRichberg"},"location":"Pennsylvania, US","isBanned":false,"isDeactivated":false,"numFollowers":2,"numFollowing":2,"storiesCreated":[],"totalUpvotesReceived":0,"tagManagerOf":[],"isEvangelist":false,"isAmbassador":false,"hasGoldRing":false,"name":"Josef Richberg","username":"josefrichberg","tagline":"Principal Data Architect, Azure @ Penguin Random House","photo":"https://cdn.hashnode.com/res/hashnode/image/upload/v1665941444184/0U0hZjidU.png","dateJoined":"2022-10-16T03:44:07.665Z","publicationDomain":"josefrichberg.com","bio":"

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.

\n","numReactions":1,"numPosts":1},"isActive":true,"username":"sqlrunner","domain":"josefrichberg.com","urlPattern":"simple","layout":"stacked","title":"","links":{"twitter":"https://twitter.com/josefrichberg","instagram":"","github":"","website":"https://josefrichberg.com","hashnode":"https://hashnode.com/@josefrichberg","youtube":"https://youtube.com/c/josefrichberg","dailydev":"","linkedin":"https://www.linkedin.com/in/josefrichberg","mastodon":""},"domainStatus":{"ready":true,"certIssued":true},"domainUpdatedOn":"2022-10-16T03:45:03.486Z","customRules":[],"menu":[],"__v":0,"umamiWebsiteUUID":"3fcea7de-72e5-452e-8760-795fafc5f557","imprint":"","imprintMarkdown":"","meta":"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).","metaHTML":"

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

\n","headerColor":"","hasBadges":true,"fathomCustomDomain":"","fathomSiteID":"","fbPixelID":"","gaTrackingID":"UA-45725300-1","hotjarSiteID":"","matomoSiteID":null,"matomoURL":"","metaTags":"","wmPaymentPointer":"","metaHTMLSanitized":"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).\n","numPosts":10}

Subscribe to my newsletter

Recent articles

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

How to curb aggressive parallelism in Microsoft SQL Server

Efficient calculation of an ISBN-13 check digit