Articles tagged with "AWS"

SQL Server 2019 Failover Cluster on EC2 – Lessons Learned

Customer requirements demanded the setup of a SQL Failover Cluster on EC2. Following AWS’s reference setup, I encountered some issues that cost me a couple of hours. In this blog post, I’ll share my experience and the solutions I found, hopefully saving you valuable time and making your journey to set up a SQL 2019 Failover Cluster with Windows Server 2019 on EC2 smoother and more enjoyable.

Embedded Embeddings Database: Building a low cost serverless RAG solution

Retrieval-Augmented Generation (RAG) solutions are an impressive way to talk to one’s data. One of the challenges of RAG solutions is the associated cost, often driven by the vector database. In a previous blog article I presented how to tackle this issue by using Athena with Locality Sensitive Hashing (LSH) as a knowledge database. One the of the main limitations with Athena is the latency and the low number of concurrent queries. In this new blog article, I present a new low-cost serverless solution that makes use of an embedded vector database, SQLite, to achieve a low cost while maintaining high concurrency.

Advanced API Gateway Throttling: Time-Based Adjustments, Budget Alerts, and WAF Configured with Terraform

In the previous post, “API Gateway and Lambda Throttling with Terraform”, we covered the basics of setting up throttling for your API Gateway and Lambda functions. In this follow-up, we’ll take it to the next level, adding budget controls, time-based throttling adjustments, and AWS WAF security integration to safeguard your API while optimizing both performance and cost-efficiency.

API Gateway and Lambda Throttling with Terraform: A Comprehensive Guide

In today’s cloud-native world, effectively managing API and serverless function performance is crucial for building reliable and cost-effective applications. This guide explores advanced throttling techniques for AWS API Gateway and Lambda using Terraform, incorporating best practices from the AWS Well-Architected Framework and real-world implementation patterns.

Comprehensive Guide to AWS AI/ML Services: The Ultimate Decision Maker’s Playbook

Looking to integrate artificial intelligence and machine learning into your business strategy? AWS has an ever-growing suite of AI/ML services, which can sometimes feel overwhelming to navigate. But don’t worry—this playbook is designed to provide a clear, simple guide to help you find the right tools for your business. Explore how AWS AI/ML services can empower your business and simplify your processes—no expert knowledge needed!

Regaining Amazon QuickSight SPICE capacity

When using Business Intelligence solutions, it can quickly become difficult to manage all the resources created by numerous users. In this blog article, we will see how the Amazon QuickSight API was leveraged to determine which resources used up all the available SPICE capacity in our Amazon QuickSight account.