AWS Database Blog

Category: Database

Making coordinated changes to multiple items with Amazon DynamoDB transactions

The use of NoSQL databases has increased significantly in recent years as more and more organizations see NoSQL databases as solutions that free them from the constraints of a relational database management system (RDBMS). While the flexibility, agility, and performance of NoSQL databases are the main benefits triggering the shift towards them, the popularity of […]

Read More

Amazon Neptune now supports TinkerPop 3.4 features

Amazon Neptune now supports the Apache TinkerPop 3.4.1 release. In this post, you will find examples of new features in the Gremlin query and traversal language such as text predicates, changes to valueMap, nested repeat steps, named repeat steps, non-numerical comparisons, and changes to the order step. It is worth pointing out that TinkerPop 3.4 […]

Read More

Analyzing the impact of Python version on Amazon DynamoDB scan performance

Amazon DynamoDB is a NoSQL database that allows for a flexible schema. This means that items in the same table may differ from each other in terms of what attributes are present for each item. In an earlier AWS Blog post, we looked at the performance impact of attribute counts per item. Recently, when helping […]

Read More

Simulating Amazon DynamoDB unique constraints using transactions

Most relational database systems—and some non-relational database systems—have a construct known as a unique key or a unique constraint. This feature ensures that all values in a column or field are unique across rows. For example, if you have a User table, you might have a UUID as a primary key that uniquely identifies each […]

Read More

Performing SQL database client-side encryption for multi-Region high availability

Amazon Relational Database Service (RDS) and Amazon Aurora natively provide encryption at rest to protect the underlying storage of database instances, automated backups, Read Replicas, and snapshots. However, some customers may have greater data protection requirements which require encrypting data in use. For example, encryption is required where tokenization solutions do not fit, such as when […]

Read More

Deploying and configuring Active Directory authentication with SQL Server 2017 on Amazon Linux 2

SQL Server on Windows allows you to configure SQL Server instances to use Windows authentication with Active Directory accounts. This post addresses how to do that with SQL Server 2017 on Amazon Linux 2. This solution allows you to log in with your Active Directory accounts using Windows authentication to manage SQL Server Linux instances […]

Read More

Automating database migration and refreshing activities with AWS DMS

Application developers and system administrators replicate data across datastores to migrate, refresh, and mask data. For most organizations, data replication is a complex, multiphase process, including assessment, schema conversion, script conversion, data migration, functional testing, performance tuning, and other tasks. Multiple tools are available to support data replication. AWS Database Migration Service (DMS) helps you quickly […]

Read More

Configuring SQL Server Reporting Service 2016 on SQL Server 2012 and 2016

Attempting to connect to SQL Server Reporting Services (SSRS) may sometimes fail with the error “The Reporting Services instance could not be found.” This error can happen when using Amazon Machine Images (AMIs) installed with SSRS, SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS). This post explains the step-by-step procedures on how […]

Read More

Refactoring to Amazon DynamoDB

Do you want to move from a relational database to NoSQL? In the following post, I walk you through reading, transforming, and writing SQL Server data from an Amazon EC2 instance to Amazon DynamoDB. I use AWS Glue to transform the source data model of multiple tables into two target tables in DynamoDB. There are […]

Read More

Running AWS Lambda-based applications with Amazon DocumentDB

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 […]

Read More