Скачать или смотреть RDS Proxy for SQL Server with AWS Lambda and .NET 6

When building serverless application it's easy to exhaust the resources of your SQL Server databases. As a default, AWS Lambda can run 1000 concurrent executions in your account. That's 1000 separate connections to your SQL Server database. Using RDS for SQL Server also requires the management of connection strings and secrets within your applications.

RDS Proxy for SQL server is a highly available, fully managed proxy that eases these two problems. It allows applications to pool and share connections to the database, improving efficiency and scalability. It also enables IAM based authentication, allowing your application to authenticate with IAM instead of database credentials.

In this video we dive into how you can build serverless applications on AWS Lambda with .NET 6 whilst also leveraging RDS Proxy for SQL Server.

00:00 - Introduction to RDS Proxy
01:05 - Introduction to RDS Proxy IAM authentication
01:45 - Deploying a proxy
03:45 - Configure a proxy in the AWS Console
05:35 - Using RDS Proxy endpoints
07:10 - Loading connection strings from Secrets Manager
09:40 - Adding IAM authentication
10:45 - Entity Framework Interceptors
11:45 - Generate RDS Auth Tokens
13:50 - Configure SAM template
15:05 - Add IAM permissions in the AWS Console
16:10 - Configure IAM permissions in AWS SAM template
17:35 - IMPORTANT! ARN Changes
18:40 - Recap

Links
GitHub Link - https://github.com/jeastham1993/dotne...
RDS Proxy - https://aws.amazon.com/rds/proxy/
RDS Proxy for SQL Server - https://aws.amazon.com/about-aws/what...
RDS Proxy Launch Blog - https://aws.amazon.com/blogs/database...
RDS Proxy developer docs - https://docs.aws.amazon.com/AmazonRDS...

Web - https://jameseastham.co.uk
Twitter -   / plantpowerjames  
LinkedIn -   / james-eastham