Databases

Amazon DocumentDB (with MongoDB compatibility), a fully managed, native JSON database that makes it simple and cost-effective to operate critical document workloads at virtually any scale without managing infrastructure, is now available in the AWS Europe (Stockholm) Region. Amazon DocumentDB provides scalability and durability for mission-critical MongoDB workloads, supporting millions of requests per second and can be scaled to 15 low latency read replicas in minutes without application downtime. Storage scales automatically up to 128 TiB without any impact to your application. In addition, Amazon DocumentDB natively integrates with AWS Database Migration Service (DMS),…

Amazon Aurora PostgreSQL Limitless Database is now available with PostgreSQL version 16.8 compatibility, bringing significant improvements and new features. This release contains product improvements and bug fixes made by the PostgreSQL community, along with Aurora Limitless-specific additions such as support for the ltree extension, the btree_gist extension, and improved query performance. Aurora PostgreSQL Limitless Database makes it easy for you to scale your relational database workloads by providing a serverless endpoint that automatically distributes data and queries across multiple Amazon Aurora Serverless instances while maintaining the transactional consistenc…

Amazon Relational Database Service (RDS) for PostgreSQL now supports the latest minor versions 17.5, 16.9, 15.13, 14.18, and 13.21. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of PostgreSQL, and to benefit from the bug fixes added by the PostgreSQL community. This release also includes updates for PostgreSQL extensions such as pg_repack 1.5.1, pg_logical 2.4.5 and others. You can use automatic minor version upgrades to automatically upgrade your databases to more recent minor versions during scheduled maintenance windows. You can also use Amazon RDS Blue/Green deployments for RDS for PostgreSQL usin…

Amazon Relational Database Service (RDS) for Oracle now supports version 24.2 of Oracle Application Express (APEX) for 19c and 21c versions of Oracle Database. Oracle APEX is a low-code development platform that enables developers to build applications entirely within their web browser. To learn more about the latest features of APEX 24.2, please refer to Oracle’s documentation. For more details on supported APEX versions and how to add or modify APEX options for your RDS for Oracle database, please refer to the Amazon RDS for Oracle APEX Documentation. APEX 24.2 is available in all AWS regions where Amazon RDS for Oracle is available. See Amazon RDS for Oracle Pric…

In the modern business landscape, data drives innovation and efficiency. Gone are the days when data could be stored in just one place. Today’s world demands that data be updated and synchronized in real-time across systems, platforms, and time zones. To keep everything in sync without downtime, businesses rely on tools like Fivetran HVR for […]View the full article

Based on a report, Apache Kafka stores and streams more than 7 trillion real-time messages per day. However, fetching real-time messages from external sources or applications is a tedious process as it involves writing extensive code for implementing the data exchange. To eradicate such complexities, you can use database connecting tools like Debezium and Kafka […]View the full article

Data integration is an essential task in most organizations. Many organizations generate huge volumes of data, which is not always stored in a single location but in different locations, including on-premise databases and the cloud. To analyze this data, it should be integrated into a single location like in a database or a data warehouse. […]View the full article

Companies today have structured and unstructured data in multiple SaaS applications, databases, etc. Moving their data into a data warehouse/ data lake for analytics can be a challenge. Many companies have realized that it is more efficient to use tools that build and maintain data pipelines rather than code in-house. In this article, let us […]View the full article

No matter where you work or what you do, data will always be a part of your process. With every organization generating data like never before, it is essential to orchestrate tasks and automate data workflows in order to make sure they are properly executed without any delay. Apache Airflow is one of the most […]View the full article

Data integration is central to making informed business decisions for any organization in this data-driven world. ETL tools are central to this since they enable organizations to manage their data from different sources effectively and integrate it efficiently. Out of the many available ETL tools in the market, Fivetran and Stitch are two of the […]View the full article

Watch the complete video and easily migrate Microsoft 365 to Google Workspace . Whether you're a small business or a large enterprise, this video is designed to help you make the Office 365 to Goggle Workspace smoothly. You’ll learn how to: 1: Successfully transfer your emails, contacts, and files from Office 365 to Google Workspace. 2: Navigate the key steps and best practices for a hassle-free migration. 3: Overcome common challenges that may arise during the process. Watch Video: Office 365 to G Suite Migration Method

“Data scientists spend 80% of their time cleaning and organizing data—and only 20% actually analyzing it.” – Forbes It’s a painful truth. You hire a data team to uncover insights, predict trends, and drive growth. But instead, they spend most of their time wrangling messy data from 20 different tools that barely speak to each […]View the full article

Welcome to Snowflake’s Startup Spotlight, where we learn about awesome companies building businesses on Snowflake. In this edition, discover how Houssam Fahs, CEO and Co-founder of KAWA Analytics, is on a mission to revolutionize the creation of data-driven applications with a cutting-edge, AI-native platform built for scalability... View the full article

Amazon Bedrock Knowledge Bases now extends support for hybrid search to knowledge bases created using Amazon Aurora PostgreSQL and MongoDB Atlas vector stores. This capability, which can improve relevance of the results, previously only worked with Opensearch Serverless and Opensearch Managed Clusters in Bedrock Knowledge Bases. Retrieval augmented generation (RAG) applications use semantic search, based on vectors, to search unstructured text. These vectors are created using foundation models to capture contextual and linguistic meaning within data to answer human-like questions. Hybrid search merges semantic and full-text search methods, executing dual queries and co…

Organizations across industries are achieving unprecedented efficiency and scale along with robust compliance by using data and AI. At Snowflake’s most recent virtual events for industries, Accelerate Retail & Consumer Goods, in partnership with Microsoft, and Accelerate Advertising, Media & Entertainment, attendees heard how industry leaders are accelerating innovation, business insights, customer experience and more with robust enterprise AI and data strategies. Snowflake experts, customers, partners and leaders provided strategic insights, practical tips, best practices and demos for key industry use cases. Here are a few key takeaways from both events... View…

As organizations continue to prioritize cloud-first strategies to accelerate innovation and gain competitive advantage, legacy databases remain a bottleneck by hindering modernization and stifling growth with unfriendly licensing, complex agreements, and rigid infrastructure. That's why this week at Google Cloud Next, we're announcing that Database Migration Service (DMS) is extending its comprehensive database modernization offering to support SQL Server to PostgreSQL migrations, enabling you to unlock the potential of open-source databases in the cloud and build modern, scalable, and cost-effective applications... View the full article

The Department of Defense (DOD) is driving action toward improving readiness, rebuilding the military and industrial base, delivering the best systems available and ensuring fiscal accountability. Data is the underlying asset that must be leveraged to drive successful completion in these goals. As the DOD continues to evolve as a data-centric organization, storing and securely accessing controlled data is integral to operations — whether on the battlefield or in the back office — and the need for efficient and security-driven enterprise solutions is increasing... View the full article

Amazon Relational Database Service (Amazon RDS) for Oracle now supports R6id and M6id instances. These instances offer up to 7.6 TB of NVMe-based local storage, making them well-suited for database workloads that require access to large amounts of intermediate data beyond the instance's memory capacity. Customers can configure their Oracle database to use the local storage for temporary tablespace and Database Smart Flash Cache. Operations such as sorts, hash joins, and aggregations can generate large amounts of intermediate data that doesn’t fit in memory and is stored in temporary tablespace. With R6id and M6id, Customers can place temporary tablespaces in the local …

Amazon Aurora PostgreSQL-Compatible Edition now supports PostgreSQL versions 16.8, 15.12, 14.17 and 13.20. Please note, this release supports the versions released by the PostgreSQL community on February 20,2025 which replaces the previous February 13, 2025 release. These releases contain product improvements and bug fixes made by the PostgreSQL community, along with Aurora-specific security and feature improvements such as dynamic resizing of the allocated space for Optimized Reads-enabled temporary objects on Aurora I/O-Optimized clusters and new features for Babelfish. For more details, please refer to the release notes. These releases are now available in all comme…

The traditional five-year anniversary gift is wood. Since snowboards often have a wooden core, and because a snowboard is the traditional “trophy” for the Snowflake Startup Challenge, we’re going to go ahead and say that the snowboard trophy qualifies as a present for the fifth anniversary of our Startup Challenge. The only difference is that instead of receiving the gift, we’ll be giving it to one of the 10 semifinalists listed below! ... View the full article

As part of my role as Service Architect here at SpecterOps, one of the things I’m tasked with is exploring all kinds of technologies to help those on assessments with advancing their engagement. Not long after starting this new role, I was approached with an interesting problem. A SQL Server database backup for a ManageEngine’s ADSelfService Plus product had been recovered and, while the team had walked through the database recovery, SQL Server database encryption was in use. With a ticking clock, the request was clear… can we do anything to recover sensitive information from the database with only a .bak file available? One of the things that I love about this job is get…

Welcome to Snowflake’s Startup Spotlight, where we learn about amazing companies building businesses on Snowflake. This time, we’re casting the spotlight on Innova-Q, where the founders are stirring things up in the food and beverage industry. With the power of modern generative AI, they’re improving product safety, streamlining operations and simplifying regulatory compliance… View the full article

Welcome to Snowflake’s Startup Spotlight, where we learn about amazing companies building businesses on Snowflake. This time, we’re casting the spotlight on Innova-Q, where the founders are stirring things up in the food and beverage industry. With the power of modern generative AI, they’re improving product safety, streamlining operations and simplifying regulatory compliance... View the full article

At Snowflake, we are committed to providing our customers with industry-leading LLMs. We’re pleased to bring Meta’s latest Llama 4 models to Snowflake Cortex AI! Llama 4 models deliver performant inference so customers can build enterprise-grade generative AI applications and deliver personalized experiences. The Llama 4 Maverick and Llama 4 Scout models can be accessed within the secure Snowflake perimeter on Cortex AI. According to Meta, Llama 4 Scout is the best multimodal model in the world in its class and supports an industry-leading context window of up to 10M tokens. According to Meta, these models are trained with large amounts of unlabeled text, image and video…

Amazon Relational Database Service (Amazon RDS) Custom for SQL Server now supports a new minor version for SQL Server 2019 (CU32 - 15.0.4430.1). This minor version includes performance improvements and bug fixes, and is available for SQL Server Developer, Web, Standard, and Enterprise editions. Review the Microsoft release notes for CU32 for details. We recommend that you upgrade to the latest minor version to benefit from the performance improvements and bug fixes. You can upgrade with just a few clicks in the Amazon RDS Management Console or by using the AWS SDK or CLI. Learn more about upgrading your database instances from the Amazon RDS Custom User Guide. This …

Today, AWS announces an updated service level agreement (SLA) for Amazon Neptune, increasing the Monthly Uptime Percentage for Multi-AZ DB Instance, Multi-AZ DB Cluster, and Multi-AZ Graph from 99.90% to 99.99%. This enhancement reflects AWS’s continued commitment to providing a highly available and reliable graph database service for your mission-critical applications. With this new SLA, AWS will use commercially reasonable efforts to make each Amazon Neptune’s Multi-AZ DB Instance, Multi-AZ DB Cluster, and Multi-AZ Graph available with a Monthly Uptime Percentage, during any monthly billing cycle, of at least 99.99%. If Neptune does not meet this Service Commitment, …

Amazon Relational Database Service (RDS) for PostgreSQL announces Amazon RDS Extended Support minor version 11.22-rds.20250220 and 12.22-rds.20250220. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of PostgreSQL. Amazon RDS Extended Support provides you more time, up to three years, to upgrade to a new major version to help you meet your business requirements. During Extended Support, Amazon RDS will provide critical security and bug fixes for your RDS for PostgreSQL databases after the community ends support for a major version. You can run your PostgreSQL databases on Amazon RDS with Extended Support for…

Amazon RDS for MariaDB now supports MariaDB Innovation Release 11.8 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MariaDB. You can deploy MariaDB 11.8 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases. MariaDB 11.8 is the latest Innovation Release from the MariaDB community, and includes support for vector datatype, indexing, and search capabilities. MariaDB Innovation releases are supported by the community until the next Innovation release, whereas MariaDB Long Term Maintenance Releases,…

Data storage has been evolving, from databases to data warehouses and expansive data lakes, with each architecture responding to different business and data needs. Traditional databases excelled at structured data and transactional workloads but struggled with performance at scale as data volumes grew. The data warehouse solved for performance and scale but, much like the databases that preceded it, relied on proprietary formats to build vertically integrated systems. Data lake systems moved to more open formats but lacked the functional benefits that warehouses provide, such as ACID-compliant transactions, comprehensive governance and more. Ultimately, users found themse…

Amazon Relational Database Service (RDS) Proxy now supports version 1.3 of the Transport Layer Security (TLS) protocol for Proxy connections to Amazon Aurora PostgreSQL and RDS for PostgreSQL database instances. TLS 1.3 provides improved security through stronger cryptographic algorithms and simplified handshake process as compared to older TLS versions. With this release, RDS Proxy can use TLS 1.3 for connections to Aurora PostgreSQL and RDS for PostgreSQL databases. During connection establishment, Proxy will automatically negotiate the most secure supported TLS version supported with the database. Customers can also configure their PostgreSQL database to require TLS…

Amazon Relational Database Service (RDS) for PostgreSQL now supports modifying the ssl_ciphers parameter. SSL Ciphers (or cipher suites) are combinations of algorithms used to secure network connections between a client and server. They handle key exchange, authentication, encryption, and message integrity verification to ensure secure and confidential communication. Amazon RDS for PostgreSQL 16.1 and later will support modification of the ssl_ciphers parameter. You can select cipher suites from the Amazon RDS for PostgreSQL allow list to align with your organization's security standards and maintain consistent security configurations across database deployments. Am…

Despite the best efforts of many ML teams, most models still never make it to production due to disparate tooling, which often leads to fragmented data and ML pipelines and complex infrastructure management. Snowflake has continuously focused on making it easier and faster for customers to bring advanced models into production. In 2024, we launched over 200 AI features, including a full suite of end-to-end ML features in Snowflake ML, our integrated set of capabilities for machine learning model development, inference and operationalization. We are thrilled to continue the momentum this year by announcing that the following capabilities for GPU-powered ML workflows are no…

Despite the best efforts of many ML teams, most models still never make it to production due to disparate tooling, which often leads to fragmented data and ML pipelines and complex infrastructure management. Snowflake has continuously focused on making it easier and faster for customers to bring advanced models into production. In 2024, we launched over 200 AI features, including a full suite of end-to-end ML features in Snowflake ML, our integrated set of capabilities for machine learning model development, inference and operationalization. We are thrilled to continue the momentum this year by announcing that the following capabilities for GPU-powered ML workflows are no…

Amazon DynamoDB Streams now comes with AWS PrivateLink support, allowing you to invoke DynamoDB Streams APIs from within your Amazon Virtual Private Cloud (VPC) without traversing the public internet. With AWS PrivateLink, you can simplify private network connectivity between virtual private clouds (VPCs), DynamoDB, and your on-premises data centers using interface VPC endpoints and private IP addresses. AWS PrivateLink is compatible with AWS Direct Connect and AWS Virtual Private Network (VPN) to facilitate private network connectivity, and helps you eliminate the need to use public IP addresses, configure firewall rules, or configure an internet gateway to access Dyn…

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports linked servers to Teradata databases. Linked server is a SQL Server feature that enables customers to read data and execute commands on remote database servers outside of the SQL Server instance. With this launch, customers can link their RDS for SQL Server instance to a Teradata database running on AWS or on premises. To start setting up a linked server for Teradata, add the ODBC_TERADATA option to your RDS for SQL Server instance's Option Group. Amazon RDS automatically installs and configures the Teradata ODBC driver, enabling you to run distributed queries, and execute SQL commands on your …

Amazon Redshift announces the general availability of Query Editor V2 with Amazon Redshift in the AWS Mexico (Central) and Asia Pacific (Thailand) regions. Amazon Redshift Query Editor V2 makes data in your Amazon Redshift data warehouse and data lake more accessible with a web-based tool for SQL users such as data analysts, data scientists, and database developers. With Query Editor V2, users can explore, analyze, and collaborate on data. It reduces the operational costs of managing query tools by providing a web-based application that allows you to focus on exploring your data without managing your infrastructure. The Amazon Redshift Query Editor V2 is a separate web…

Amazon RDS for MySQL now supports MySQL Innovation Release 9.2 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 9.2 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases. MySQL 9.2 is the latest Innovation Release from the MySQL community. MySQL Innovation releases include bug fixes, security patches, as well as new features. MySQL Innovation releases are supported by the community until the next major & minor release, whereas MySQL Long Term Support (LTS) Releases…

AWS Database Migration Service (DMS) Schema Conversion is a fully managed feature of DMS that automatically assesses and converts database schemas to formats compatible with AWS target database services. Today, we are excited to announce that Schema Conversion now supports conversions from IBM Db2 for z/OS to Amazon Relational Database Service (RDS) for Db2. Using Schema Conversion, you can automatically convert database objects from your IBM Db2 for z/OS source to an Amazon RDS for Db2 target, including stored procedures, functions, views, and other database structures. This is especially valuable for mainframe migrations as it simplifies complex processes by resolvin…

Amazon Redshift Serverless, which allows you to run and scale analytics without having to provision and manage data warehouse clusters, is now generally available in the AWS Mexico (Central) and Asia Pacific (Thailand) regions. With Amazon Redshift Serverless, all users, including data analysts, developers, and data scientists, can use Amazon Redshift to get insights from data in seconds. Amazon Redshift Serverless automatically provisions and intelligently scales data warehouse capacity to deliver high performance for all your analytics. You only pay for the compute used for the duration of the workloads on a per-second basis. You can benefit from this simplicity without…

Oracle releases Java 24 with new AI capabilities, post-quantum cryptography and simplified programming features while celebrating 30 years of Java innovation. View the full article

Amazon Redshift Serverless is now available on two different release cycles - Current Track and Trailing Track. With the Current Track you will get the most up-to-date certified release version with the latest features, security updates, and performance enhancements. With the Trailing Track you will be on the previous certified release. With the Trailing Track feature, you now have the option to run a subset of Amazon Redshift Serverless workgroups in the Amazon Redshift Serverless Trailing Track to allow for a few weeks of integration validation in your environment before adopting the release across all your workgroups. Each Amazon Redshift Serverless release undergoe…

A new minor version of Microsoft SQL Server is now available on Amazon Relational Database Service (Amazon RDS) Custom for SQL Server, providing performance enhancements and security fixes. Amazon RDS Custom for SQL Server now supports this latest minor version of SQL Server 2022 across the Developer, Web, Standard, and Enterprise editions. We encourage you to upgrade your Amazon RDS for SQL Server database instances at your convenience. You can upgrade with just a few clicks in the Amazon RDS Management Console or by using the AWS CLI. Learn more about upgrading your database instances from the Amazon RDS User Guide. The new minor version is SQL Server 2022 CU17 16.0.…

AWS announces Amazon Redshift Query Editor V2 now supports increased maximum result set and export size to 100MB of your query result sets with no row limit in AWS GovCloud (US) Regions. Prior to this limit of your query result sets was* 5MB or 100,000 rows. This enhancement provides greater flexibility for you and your team to work with large datasets, enabling you to generate, analyze, and export more comprehensive data without previous constraints. If you work with large datasets, such as security logs, gaming data, and other big data workloads, that require in-depth analysis, the previous 5MB or 100,000-row limit on result sets and exports often fell short of your …

Amazon Relational Database Service (RDS) for PostgreSQL, MySQL, and MariaDB now supports AWS Graviton4-based M8g database instances in the Europe (Spain), Europe (Stockholm), and Europe (London) Regions and R8g database instances in Europe (Ireland), Europe (Spain), Europe (Stockholm), Asia Pacific (Mumbai), Asia Pacific (Sydney), Asia Pacific (Tokyo) regions. Graviton4-based instances provide up to a 40% performance improvement and up to 29% price/performance improvement for on-demand pricing over Graviton3-based instances of equivalent sizes on Amazon RDS open source databases, depending on database engine, version, and workload. M8g and R8g database instances ar…

A new minor version of Microsoft SQL Server is now available on Amazon RDS for SQL Server, providing performance enhancements and security fixes. Amazon RDS for SQL Server now supports this latest minor version of SQL Server 2019 across the Express, Web, Standard, and Enterprise editions. We encourage you to upgrade your Amazon RDS for SQL Server database instances at your convenience. You can upgrade with just a few clicks in the Amazon RDS Management Console or by using the AWS CLI. Learn more about upgrading your database instances from the Amazon RDS User Guide. The new minor version is SQL Server 2019 CU31 15.0.4420.2. This minor version is available in all AWS…

As privacy standards continue to evolve, businesses face a dual challenge: to uphold ethical standards for data use while seizing the opportunities offered by data collaboration. Enter data clean rooms: a privacy-enhancing solution that allows organizations to share valuable insights without compromising compliance.* If you're new to data clean rooms, our recent blog post “Data Clean Rooms Explained: What You Need to Know About Privacy-First Collaboration” breaks down the fundamentals. While the potential of data clean rooms is vast, implementing them successfully can be as complex as any enterprise technology project. Between navigating regulatory policies and addressing…

Amazon Relational Database Service (RDS) for MySQL announces Amazon RDS Extended Support minor version 5.7.44-RDS.20250213. We recommend that you upgrade to this version to fix known security vulnerabilities and bugs in prior versions of MySQL. Learn more about upgrading your database instances, including minor and major version upgrades, in the Amazon RDS User Guide. Amazon RDS Extended Support provides you more time, up to three years, to upgrade to a new major version to help you meet your business requirements. During Extended Support, Amazon RDS will provide critical security and bug fixes for your MySQL databases on Aurora and RDS after the community ends support…

Relational databases like Oracle have been the backbone of enterprise data management for years. However, as data volumes grow and the need for flexibility, scalability, and advanced analytics increases, modern solutions like Apache Iceberg are becoming essential. Iceberg’s open architecture and advanced features make it a compelling choice for organizations looking to optimize their data […]View the full article

Does your organization rely on real-time analytics for decision-making, or is your product itself a real-time application? Either way, systems majorly fail when the database can’t keep up. That’s why Amazon introduced DynamoDB, a serverless, cloud database that tracks data modifications in real time through change data capture(CDC). In this article, we’ll discuss DynamoDB CDC, […]View the full article

Relational databases like Postgres have been the backbone of enterprise data management for years. However, as data volumes grow and the need for flexibility, scalability, and advanced analytics increases, modern solutions like Apache Iceberg are becoming essential. Iceberg’s open architecture and advanced features make it a compelling choice for organizations looking to optimize their data […]View the full article