DSData Senseiinsihan.hashnode.dev·Sep 17, 2025 · 12 min readAll 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...00
DSData Senseiinsihan.hashnode.dev·Nov 2, 2024 · 2 min readSimple 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...00
DSData Senseiinsihan.hashnode.dev·Oct 21, 2024 · 3 min readAzure 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...00
DSData Senseiinsihan.hashnode.dev·May 12, 2024 · 2 min readDon'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...00
DSData Senseiinsihan.hashnode.dev·May 4, 2024 · 5 min readDBT 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...00