Build a Secure AI Medical Assistant on AWS: The Boundaries That Actually Leak

A practical architecture for a secure AI medical assistant on AWS, organised by the boundary the data crosses: the input box, your own invocation logs, cross-Region inference routing, the retrieval index, and clinical accuracy. Includes real commands, the failure modes that stay invisible until an audit, and the trade-offs worth knowing before you build.

Continue ReadingBuild a Secure AI Medical Assistant on AWS: The Boundaries That Actually Leak

A 100 Score and a Failing Report: Fixing Core Web Vitals on a Real WordPress Site

You got PageSpeed Insights to 98 and six weeks later Search Console still says the same URLs are failing. The score and the assessment measure different things, and Lighthouse cannot measure INP at all. Here is how to fix Core Web Vitals on WordPress in the order that actually moves the report.

Continue ReadingA 100 Score and a Failing Report: Fixing Core Web Vitals on a Real WordPress Site

Zero Errors, Zero Records: Monitoring Salesforce Integrations with CloudWatch and Grafana

The error count was zero every day for three weeks. So was the invocation count. A stopped integration and a healthy one produce identical graphs, and every CloudWatch default is tuned to stay quiet when data stops arriving. Four signals worth emitting, and the alarm config that actually fires.

Continue ReadingZero Errors, Zero Records: Monitoring Salesforce Integrations with CloudWatch and Grafana

Run It Twice, Get Two Answers: Building an ETL Pipeline From Zoho CRM to Amazon S3

You re-run the same extract for the same window and get a different set of rows. Nothing errored. You were paginating a result set that kept changing while you read it. Here's how to build a Zoho CRM to S3 pipeline whose runs are repeatable, from closed read windows to Bulk Read and deletions.

Continue ReadingRun It Twice, Get Two Answers: Building an ETL Pipeline From Zoho CRM to Amazon S3

The Column That Never Shows Up: Fixing Redshift and Zoho Analytics Schema Mismatches

You added a column in Redshift, clicked Sync Design, and it reported success. The column still isn't in the dashboard. That's documented behaviour: one unresolved mismatch anywhere blocks new column information everywhere. Here's how to clear them and stop them coming back.

Continue ReadingThe Column That Never Shows Up: Fixing Redshift and Zoho Analytics Schema Mismatches

Connect Amazon Redshift to Zoho Analytics Without Putting Your Warehouse on the Internet

Every guide tells you to tick "Publicly Accessible" and move on. That works, and it also puts your warehouse on the internet with whatever credentials were to hand. Here's the full setup done deliberately: least-privilege user, narrow network access, and the outbound-only option nobody mentions.

Continue ReadingConnect Amazon Redshift to Zoho Analytics Without Putting Your Warehouse on the Internet