Apr 8Member-onlyCache angular components using RouteReuseStrategyThe project I have worked on has several pages that load data in Angular Material tables. The application’s user interface consists of a left menu with multiple tabs, and clicking on each tab loads the corresponding component and its child on the right. …Angular6 min readAngular6 min read
Mar 2Member-onlyUsing MSAL angular to authenticate a user against azure ADB2C via authorization code flow with Proof Key for Code Exchange.Previously, I switched from using oidc-client to MSAL Angular to integrate an Angular app with Azure AD for authentication. If you’re interested, you can read more here. More recently, I used MSAL Angular again to connect another application, but this time to an Azure AD B2C tenant. Since I had…Msal8 min readMsal8 min read
Feb 1Member-onlyUsing Azure Application Insights for centralized loggingA typical enterprise system usually runs on multiple servers behind a load balancer. The simplest logging option could be logging locally to a location on the server where the app runs. However, this setup makes triaging an issue using the logs difficult. The problem is more prominent if the system…Azure3 min readAzure3 min read
Dec 31, 2022Member-onlyAnalyzing a rental property through automationIn this post, I write about building an API to help me analyze real estate properties. One of the best ways to build passive incomes is through investing in real estate. I have read a few books on real estate investing and bought my first rental property back in 2020…Net Operating Income7 min readNet Operating Income7 min read
Oct 16, 2022Member-onlyWeb scraping in C# using HtmlAgilityPackIn this post, I show an example of scraping data in C# using HtmlAgilityPack. I come across HtmlAgilityPack because I need to get data from Zillow to analyze properties deals. …Htmlagilitypack4 min readHtmlagilitypack4 min read
Sep 23, 2022Member-onlyEasily test sending and receiving email locally using MailHogA java application which I work on has a feature to send emails via the corporate SMTP server to notify certain personnel whenever an error occurs. For security reasons, only servers within a certain networks can access the SMTP server and send emails. For instance, the computer which I use…Email3 min readEmail3 min read
Aug 20, 2022Member-onlyBuilding multitenant application — Part 3: AuthenticationIn this post, I continue to share what I have learned while building a multitenant application by ultilizing Microsoft Identity Framework and SQL role level security. Specifically, I share what I have learned following Microsoft example project and documentations to make authentication works in a multitenant environment. First, it’s helpful…Azure Active Directory5 min readAzure Active Directory5 min read
Aug 13, 2022Member-onlyBuilding multitenant application — Part 2: Storing value into database session context from ASP.NET core web APIIn the previous post about row level security in SQL server, I gave an example of reading a value from the database session context to feed into the security function for filtering data. In this post, I show examples of calling the sp_set_session_context store procedure from an ASP.NET …Entity Framework Core3 min readEntity Framework Core3 min read
Jul 29, 2022Member-onlyMulti-tenant database using Row Level SecurityIn this and upcoming posts, I’ll be sharing what I have learned while implementing a multi-tenant solution. …Row Level Security5 min readRow Level Security5 min read
Jun 16, 2022Member-onlyDisplaying text in a tool tip when text overflows its containerIn several apps I work on, we use angular material to display data in a table. Sometimes, long text causes the height of the table cells to increase, resulting in an unaesthetic UI. Using CSS, we can set the max width of the table cells, hide overflow and show ellipsis…Angular Material3 min readAngular Material3 min read
