All DSA ProblemsFind the element with the highest repeats in an array # Online Python compiler (interpreter) to run Python online maxFre = 0 maxEle = 0 arr = [5, 6, 5, 6, 9, 6] map = {} # iterate through arr and populate map {} tp track how many times something wa...Sep 17, 2025 · 12 min readsihan.hashnode.dev
Simple trick to Bulk Insert in Slow Changing Dimension Task in SSISI am sure my readers have a very good understanding of how SSIS Data Flow Task “Slow Changing Dimension” works. The point of this blog is not to introduce you to slow changing dimension task rather to point out something interesting you can do with i...Nov 2, 2024 · 2 min readsihan.hashnode.dev
Azure DevOps Automated CICD pipeline with SQL Server Git IntegrationRecently I realised working with quite a few data teams across UK and US that many of these data teams still using VM hosted SQL Server and manually merging into main. To be honest, I helped the teams to get started with simple azure CICD build and r...Oct 21, 2024 · 3 min readsihan.hashnode.dev
Don't hire DevOps Engineers for your cloud data pipelines.Many DevOps engineers will hate me for saying these, but I believe, that having a background in data and from the experience of working with DevOps engineers trying to be data engineers, I definitely qualify to say what I am going to say. Data is the...May 12, 2024 · 2 min readsihan.hashnode.dev
DBT for SQL Server? Yes possible.Installing DBT using SQL server is extremely simple. I had many clients coming to me and asking if they could use DBT with SQL Server on-prem or managed instances. They look surprised when I answered them, "Yes, why not". Now you might ask me, what i...May 4, 2024 · 5 min readsihan.hashnode.dev