PinnedSQLInSix MinutesPossibly 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
SQLInSix MinutesData Notes From A Recent SolutionSome thoughts from a recent data solution:Jul 16Jul 16
SQLInSix MinutesRow 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
SQLInSix MinutesVNet 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
SQLInSix MinutesAzure Data Factory Error — Substantial Concurrent MappingDataflow ExecutionsErrorMar 5Mar 5
SQLInSix MinutesDynamic 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
SQLInSix MinutesHow 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
SQLInSix MinutesAzure 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
SQLInSix MinutesUsing 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
SQLInSix MinutesStorage 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