Scripts & Serendipity

How I Replaced Legacy SSIS with Real-Time Data Pipelines (and Saved Costs!) A few years into working with SQL Server Integration Services (SSIS), I hit the same wall a lot of data teams eventually hit: nightly batch jobs that took longer every month, a server that needed constant babysitting, and a growing list of "just run it again manually" incidents. This is the story of moving that pipeline to a GCP-native setup — what worked, what I underestimated, and what it actually saved. 📘 The Starting Point The original setup was a fairly typical on-prem pattern: Source SQL Server → SSIS nightly ETL job → Data Warehouse (on-prem) It worked — until data volume grew. The nightly job window kept creeping later, sometimes bleeding into business hours, and every schema change at the source meant manually re-mapping columns in the SSIS designer. 🔧 The Migration Path Rather than a big-bang rewrite, I moved piece by piece: Google Cloud Datastream replaced the extraction step...

PostgreSQL ON CONFLICT Statement - Explained PostgreSQL ON CONFLICT Statement - Explained 📘 Introduction to ON CONFLICT Statement In PostgreSQL, ON CONFLICT provides a powerful mechanism to deal with data clashes during INSERT operations. When inserting into a table that contains a UNIQUE constraint or index, you can define how the database should react—either by updating the existing record or ignoring the new one. 🧪 Syntax Overview INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...) ON CONFLICT (conflict_target) DO UPDATE SET column1 = value1, column2 = value2, ...; conflict_target: typically the column(s) with a UNIQUE constraint (e.g., employee_id) DO UPDATE: specifies what should be updated DO NOTHING: skips the insertion if conflict occurs ...

MySQL MERGE Concept & Alternatives Explained MySQL MERGE Concept & Alternatives MySQL MERGE is not directly supported as a single SQL command like in some other database systems (e.g. SQL Server or Oracle), but the concept can be implemented using a combination of INSERT , UPDATE , and DELETE statements. The MERGE approach is helpful for syncing two tables where data may need to be inserted, updated, or removed depending on conditions. When implemented manually, this requires crafting multiple SQL queries to simulate the behavior. Users should have SELECT, INSERT, DELETE , and UPDATE privileges on both tables used in the MERGE operation. 🔧 Three Logical Cases in a MERGE Operation Case 1 – INSERT If a row exists in the source table but not in the target table, use INSERT to add it to the target. Case 2 – DELETE If a row exists in the tar...

Nasi Lemak Spicy Sambal recipe - Simple Cooking How to Cook Nasi lemak and Spicy Sambal - Malaysian (Simple Recipe) Ingredients for the recipe: Visit my Youtube Channel Link :  Aki13promy - YouTube Visit my Dailymotion Channel Link :  Aki13promy - Dailymotion Check out the Video :

My funny kittens Playing compilation My cute kittens are always wanted to playing with the feather toys. It makes them feels more energitic and athletic.Seems They really enjoying it. Its really fun and very relaxation for me as well. Check out more videos like this Visit my Youtube Channel Link :  Aki13promy - YouTube Visit my Dailymotion Channel Link :  Aki13promy - Dailymotion Check this Video :

My cute relaxing kitten My cute kitten wanted to play outside of the house. Seems Like she enjoying the whether. Its really beautiful. Check out more videos like this Visit my Youtube Channel Link :  Aki13promy - YouTube Visit my Dailymotion Channel Link :  Aki13promy - Dailymotion Check this Video :

Hari Raya Aidilfitri 2022 – A Surprise Celebration Hari Raya Aidilfitri 2022 – Celebration Recap 🌙 After two long years of distancing and quiet festivities, Hari Raya Aidilfitri 2022 in Malaysia was a celebration like no other. The official announcement stunned the nation—it was set a day earlier than expected, on May 2 instead of May 3. Social media exploded as families rushed to prepare last-minute dishes, prayer outfits, and travel plans. The streets came alive, homes gleamed with lanterns and decor, and the joy of returning to tradition could be felt in every smile and salam exchanged. For many, this marked the first real balik kampung after lockdowns, and emotions ran high. ✨ What Made This Raya Truly Memorable? 🥘 Grand feasts of rendang, satay, ketupat, and lemang united families 👗 Baju Raya fashion made a bold return in vibrant colo...

Mama Cat Feeding Her Kittens – Adorable Moment 🐾 Mama Cat Feeding Her Three Kittens – So Adorable! After a long day roaming outdoors, mama cat returns home to feed her three cuddly kittens. Their tiny tails twitch with excitement and they nestle into her lovingly, hungry and content. Watching them bond reminds us that maternal care is just as powerful in the animal world. The ending is extra cute—don’t miss it! Check out more adorable animal clips like this and support my channels: 📺 Aki13promy – YouTube 📹 Aki13promy – Dailymotion 🎥 Watch the Full Video Below: 💡 Did You Know? 🐱 Kittens feed every 2–3 hours in their first weeks 👀 Mama cats often purr while feeding to comfort their babies 🏠 Nesting and grooming during feeding shows strong emotional bonding ...

Cute Kittens Playing with Feather Toy Cute Kittens Playing with Feather Toy 🐾 Quick Summary This video showcases my adorable kittens in full play-mode with a feather toy! Their curious and joyful energy is a reminder of how simple moments can bring the biggest smiles. Visit my channels for more fun pet videos: 📺 YouTube: Aki13promy - YouTube 📹 Dailymotion: Aki13promy - Dailymotion 🎥 Watch the Video 🐱 Why Feather Toys Are Great for Kittens Feather toys trigger your kitten’s playful instincts. They simulate natural hunting behavior, improve reflexes, and offer great mental stimulation—all while being irresistibly fun! 🧠 Kitten Playtime Tips 💡 Use toys that are safe and soft with no sharp edges. 🎯 Keep play sessions short but frequent to avoid overstimulation. 📦 Rotate toy selection weekly to maintain excitem...

Spicy Prawn Masala Recipe 🌶️ Introduction: A Fiery Seafood Favourite Craving something bold and brimming with spice? This Spicy Prawn Masala is a soul-satisfying dish that brings the heat and heart of South Indian kitchens right to your table. Inspired by weekend market hauls and cherished family memories, it’s the kind of recipe that turns ordinary prawns into a culinary celebration. Whether paired with fluffy basmati rice or soft naan, this dish is bound to impress seafood lovers and spice enthusiasts alike. 🧄 Ingredients 500g fresh prawns, cleaned and deveined 2 medium onions, finely chopped 2 tomatoes, pureed 1 tbsp ginger-garlic paste 2 green chillies, slit 1 tsp turmeric powder 1½ tsp red chilli powder 1 tsp coriander powder ½ tsp garam masala Salt to taste Fresh coriander leaves for garnish 2 tbsp oil 🍳 Preparation Heat oil in a pan and sauté the onion...

Welcome to AKI13pro – YouTube Channel Introduction 👋 Welcome to AKI13pro – My Simple Space Online This page is a friendly intro to my YouTube channel AKI13pro . I started this space to share day-to-day activities and personal adventures—from playing with my pets to relaxing hobbies like traveling, gardening, and cooking. I’m still exploring and learning, but every clip and story is real. If you enjoy simple, relatable content and real-life joy, I’d love to have you subscribe and be part of this journey. 📺 Where to Find Me YouTube Channel: AKI13pro – YouTube Dailymotion Channel: Aki13promy – Dailymotion 🎥 Watch My Intro Video 💡 What You'll Find 🐾 Pet interactions and animal care moments 🍳 Simple and fun home coo...