Category: Compute

Amazon DynamoDB is a fully managed service that delivers single-digit millisecond performance at any scale. It is fully managed, highly available through behind-the-scene Multi-AZ data replication, supports native write-through caching with Amazon DynamoDB Accelerator (DAX) as well as multiple global secondary indexes. Developers can interact with DynamoDB using the AWS SDK in a rich set […]

For decades, IT administrators could only run their SQL Server workloads on Windows. However, as of SQL Server 2017, SQL Server is now available to run in the Linux operating system. For IT administrators, this represents an opportunity to run SQL Server workloads on their preferred operating system, save on Windows Server licensing costs, and […]

Storing user names and passwords directly in applications is not a best practice. Saving credentials as plaintext should never occur in a secure application. As a solution, AWS Identity and Access Management (IAM) policies can assign permissions that determine who is allowed to manage Amazon Aurora resources. For example, you can use IAM to determine […]

Microsoft SQL Server 2017 supports Always On availability groups between Windows and Linux to create read-scale workloads without high availability (HA). Unfortunately, you cannot achieve HA between Windows and Linux because there is no clustered solution that can manage that cross-platform configuration. To use HA with Always On availability groups, consider using a Windows Server […]

Microservices-based applications architectures are the norm for building scalable applications. AWS makes creating these types of applications easier with Amazon DocumentDB (with MongoDB compatibility). Just bring your code and deploy an application with this fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. You can use the same MongoDB application […]

AWS offers multiple options to host your databases serving OLTP workloads – host your own managed database on Amazon EC2 instances or use Amazon RDS managed by AWS. RDS manages high availability, automated backups, database upgrades, OS patches, security, and read replica. RDS also offers the cloud-native option Amazon Aurora database engine, which is compatible […]

If you still have Microsoft SQL Server 2008 and 2008 R2 instances deployed, now is the time to upgrade them. Microsoft end of support (EoS) date for each is almost upon us—July 9, 2019. This means that after that there are no further security updates, which has security and also compliance implications, so don’t wait! Today, I’m excited […]

In this blog post, we explain the deployment of Microsoft SQL Server on containers using Amazon Elastic Container Service for Kubernetes (Amazon EKS). The same approach and principles discussed here also apply to any other stateful application that needs high availability (HA) and durability combined with a reusable and repeatable DevOps practice. Example use cases […]

AWS Auto Scaling can scale your AWS resources up and down dynamically based on their traffic patterns. However, a typical application stack has many resources, and managing the individual AWS Auto Scaling policies for all these resources can be an organizational challenge. With scaling plans, you can automate the creation of AWS Auto Scaling policies […]

In this post, I discuss how to integrate a central Amazon Relational Database Service (Amazon RDS) for PostgreSQL database with other systems by streaming its modifications into Amazon Kinesis Data Streams. An earlier post, Streaming Changes in a Database with Amazon Kinesis, described how to integrate a central RDS for MySQL database with other systems […]