AWS Database Blog

December 2022:  Neptune Notebooks now include an air-routes tutorial. We’re pleased to announce the start of a multi-part series of posts for Amazon Neptune in which we explore graph application datasets and queries drawn from many different domains and problem spaces. Amazon Neptune is a fast and reliable, fully-managed graph database, optimized for storing and […]

With so many instance types to choose from, it can be challenging for architects and customers to choose the best ones to migrate their SQL Server workloads to AWS. Detailed specifications are available for each instance type and storage options, however all of this information may be difficult to map to real-world scenarios. We are […]

December 2022: Whether you’re new to graphs and want to learn and experiment, or you’re experienced and want to refine your queries, Neptune graph notebooks offer a great development platform and can be a huge time-saver. About the Authors Ian Robinson is an architect with the Database Services Customer Advisory Team. He is a coauthor […]

Update [11/04/2020]:  We’re happy to announce that Amazon RDS for SQL Server now fully supports SQL Server Database Mail. With the release of Database Mail for SQL Server, you can enable Database Mail seamlessly by using database parameter groups. Check this blog post for more information.     Database Mail is one of the heavily […]

Amazon Relational Database Service (Amazon RDS) is the primary mechanism for running relational databases in the AWS Cloud. Amazon RDS for SQL Server supports running SQL Server versions from SQL Server 2008 R2 to SQL Server 2017. The RDS for SQL Server team has recently released two key improvements around backup and restore for native […]

Elasticsearch has REST API operations for everything—including its indexing capabilities. Besides the REST API, there are AWS SDKs for the most popular development languages. In this guide, we use the REST API so that you can learn about the underlying technology in a language-agnostic way. Indexing is the core of Elasticsearch. It’s what allows you […]

July 2023: This post was reviewed for accuracy. Migrating and operating a database includes layers of complexity and thorough planning. Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility can help you manage a variety of use cases. While migrating from Oracle to PostgreSQL, it’s very common to come across Oracle Autonomous Transactions. This […]

So your organization is looking to deploy an application to the cloud, and you plan to use Amazon RDS for MySQL for the data tier… great! Let’s look at some of the best practices to ensure that you get the most out of your architecture.

It’s easy to start filling an Amazon DynamoDB table with data. However, without forethought about organizing your data, you can limit your data-retrieval options later. Data organization and planning for data retrieval are critical steps when designing a table. Without proper data organization, the only options for retrieving data are retrieval by partition key or […]

In preparation for the deprecation of Microsoft SQL Server 2008 R2, this blog post focuses on how to upgrade from SQL Server 2008 R2 to SQL Server 2016 on Amazon RDS for SQL Server. In addition, you can apply many of the practices in this post to all versions of SQL Server or even other […]