Jump to content

Databases

  • Database Design

  • SQL Optimization

  • Database Administration

  • NoSQL Databases

  • Data Warehousing

  • Performance Tuning

  • Cloud Databases

  • Query Troubleshooting

  1. 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

  2. “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

  3. 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

    • 0 replies
    • 16 views
  4. 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…

  5. 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…

    • 0 replies
    • 18 views
  6. 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

  7. 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

    • 0 replies
    • 21 views
  8. 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 …

  9. 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…

  10. 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

    • 0 replies
    • 18 views
  11. 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…

  12. 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

    • 0 replies
    • 39 views
  13. 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

    • 0 replies
    • 15 views
  14. 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…

    • 0 replies
    • 86 views
  15. 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 …

  16. 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, …

  17. 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…

  18. 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,…

  19. 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…

    • 0 replies
    • 95 views
  20. 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…

  21. 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…

  22. 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…

    • 0 replies
    • 25 views
  23. 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…

    • 0 replies
    • 52 views
  24. 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…

  25. 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 …

  26. 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…

  27. 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…

  28. 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…

  29. 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…

  30. 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

    • 0 replies
    • 18 views
  31. 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…

  32. 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.…

  33. 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 …

  34. 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…

  35. 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…

  36. 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…

    • 0 replies
    • 41 views
  37. 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…

  38. 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

    • 0 replies
    • 31 views
  39. 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

    • 0 replies
    • 32 views
  40. 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

    • 0 replies
    • 27 views
  41. Amazon Redshift Data API, which lets you connect to Amazon Redshift through a secure HTTPS endpoint, now supports single sign-on (SSO) through AWS IAM Identity Center. Amazon Redshift Data API removes the need to manage database drivers, connections, network configurations, and data buffering, simplifying how you access your data warehouses and data lakes. AWS IAM Identity Center lets customers connect existing identity providers from a centrally managed location. You can now use AWS IAM Identity Center with your preferred identity provider, including Microsoft Entra Id, Okta, and Ping, to connect to Amazon Redshift clusters through Amazon Redshift Data API. This new S…

  42. Amazon Relational Database (RDS) for Db2 now supports M7i and R7i database instance types. M7i and R7i are the latest Intel-based offering and are available with a new maximum instance size of 48xlarge, which brings 50% more vCPU and memory than the maximum size of M6i and R6i instance types. M7i and R7i instances are available for Amazon RDS for Db2 in Bring-Your-Own-License (BYOL) model and in hourly Db2 licensing model available through AWS Marketplace. You can launch the new database instance in the Amazon RDS Management Console or using the AWS CLI. Amazon RDS for Db2 is a fully managed commercial database that makes it easy to set up, operate, and scale Db2 de…