PinnedPossibly Hiring Soon — 2025 And BeyondOver the next two years, I will be looking for top level talented data engineers. as I am working with several clients across the globe…Sep 23Sep 23
Row Level Security Deep Dive In SQL ServerRow level security (RLS) provides us with a security tool that can limit data access on the row level of data. This security technique…May 3May 3
VNet Injection With Azure DatabricksOne challenge that we can face with labor division involves two teams that must design the appropriate technical architecture with neither…Apr 6Apr 6
Dynamic Data Masking Basics In SQL ServerIn this post, we’ll look at an example of data masking in SQL Server using three data masking functions with email. I use emails across the…Feb 18Feb 18
How To Create A Date Dimension In Python PandasIn this post, we look at creating a date dimension using python pandas. Pandas is one of the easiest libraries to use in python and can…Feb 17Feb 17
Azure Storage Access Deep DiveIn this post we look at some of the basics of Azure RBAC roles with Azure storage before diving into deeper access levels with Azure…Feb 15Feb 15
Using the OPENJSON Function In SQL ServerIn this post we look at using the OPENJSON function in SQL Server to parse some example JSON documents. As a quick note, I would not use…Feb 14Feb 14
Storage and Resource Sharding and Partitioning With Azure ResourcesIn this post, we look at sharding and partitioning approaches with various Azure technologies. This post is a work in progress and will be…Feb 12Feb 12