Business case: Create the alert message to Slack with MS Flow/Automate

-

 Business case:

Automatically post the alert message when it hits the criteria by using the store procedure in MS SQL Azure

Solution:

Assumption that we already had the data as following by writing it in the store procedure.









Comments

Post a Comment

Popular posts from this blog

Featured Projects: Automation and AI Systems I Built and Run

-
This is a living index of the systems I'm most proud of — each one is in daily production use, and each links to a deeper technical write-up. If you're a recruiter or hiring manager, this page is the fastest way to see what I actually build. 1. AI Email-Triage Pipeline (LLM classification in production) A pipeline that classifies hundreds of ticketing emails per day (presales, releases, cancellations) using multimodal LLMs, then distributes summarized reports automatically to the relevant business departments. I fine-tuned GPT-4o-mini on a labelled dataset I built from PDF archives, put OpenAI and Gemini behind a single interchangeable JSON contract for cost/performance trade-offs, and wrote a defensive C# parsing layer — balanced-brace JSON extraction, tolerant custom JsonConverters, code-enforced business invariants — so a single malformed model response never breaks the batch. Stack: C#/.NET, OpenAI API (fine-tuning), Gemini, IMAP, SQL Server Read more: Classifying E...
Read more

AWS API gateway, S3

-
Image
  Tutorial: Create a REST API as an Amazon S3 proxy in API Gateway - Amazon API Gateway Using REST API to upload files to the S3 bucket - BlueGrid : BlueGrid AIM role Edit Trust Relationship {   "Version": "2012-10-17",   "Statement": [     {       "Effect": "Allow",       "Principal": {         "Service": "s3.amazonaws.com"       },       "Action": "sts:AssumeRole"     },     {       "Effect": "Allow",       "Principal": {         "Service": "apigateway.amazonaws.com"       },       "Action": "sts:AssumeRole"     }   ] } Next, go to API Gateway --> create a REST API. Create the folder & item resource create GET -->  with "tanldttestingapigateway" is a S3 bucket name. /{folder}/{item} - GET - Method Execution --> to add URL path parameters Create the fo...
Read more

Two Features, Two Days: What Spec-Driven Development with Spec Kit Taught Me

-
For most of this year my way of working with an AI coding agent was simple: I wrote a planning document, asked the agent for step 1, reviewed it, then asked for step 2. It worked, but everything important lived in my head and in a chat history that disappeared when the session ended. This month I tried the opposite approach. I adopted Spec Kit , GitHub's open-source toolkit for spec-driven development , and used it with Claude Code to ship two real features into production. People have started calling this kind of workflow an ADLC , an agentic development lifecycle: the classic spec → design → build → verify loop, redrawn so that an agent does most of the writing and a human owns the decisions. This post covers what that looked like over two days. It covers what worked, what surprised me, and where production proved the spec wrong. The setting The project is a domain-name intelligence SaaS: an ASP.NET Core 8 API and a React 19 front end, in two repositories, on top of Azure SQ...
Read more