The Rapidfuzz Library As A Golden Record SolutionI recently used the python library rapidfuzz to golden some records. This post provides some thoughts on data curation that you can use…Jan 7Jan 7
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 3, 2024May 3, 2024
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 6, 20241Apr 6, 20241
Azure Data Factory Error — Substantial Concurrent MappingDataflow ExecutionsErrorMar 5, 2024Mar 5, 2024
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 18, 2024Feb 18, 2024
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 17, 2024Feb 17, 2024
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 15, 2024Feb 15, 2024
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 14, 2024Feb 14, 2024
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 12, 2024Feb 12, 2024
