InfoQ Homepage SQL Content on InfoQ
-
Email Classification at Slack: Designing an Eventually Consistent Custom Classifier
Slack recently published the details of how it built an email address classification engine that can determine if an email address is internal or external. Slack engineers utilized an eventually consistent near real-time representation of the data in its system and implemented a drift detection mechanism to fix erroneous data, keeping the engine's operation in order.
-
Oracle Introduces MySQL Autopilot with Machine-Learning Capabilities for MySQL Heatwave
Oracle released updates to its MySQL HeatWave service earlier this month. The new MySQL Autopilot feature uses machine learning to automate database provisioning and optimisation tasks, making recommendations and query optimisations based on each database’s usage patterns.
-
Microsoft Announces the General Availability of Azure Arc-Enabled SQL
Recently Microsoft announced the general availability as per the end of July of Azure Arc-enabled SQL, which extends the Azure SQL instances to be hosted on an edge data center or in a multi-cloud environment. An Azure Arc enabled SQL Managed Instance has near 100% compatibility with the latest SQL Server database engine.
-
Google Logica Aims to Make SQL Queries More Reusable and Readable
Logica is a Datalog-like declarative logic programming language for database querying. It supports the creation of reusable abstractions to build complex queries and compiles to SQL, thus making it suitable for wide application.
-
Microsoft Announces Azure Monitor SQL Insights for Azure SQL in Public Preview
Recently Microsoft announced Azure Monitor SQL Insights for Azure SQL in public preview. With the preview, customers will get a flexible canvas for telemetry collection, analysis, and rich custom visualization.
-
Amazon Redshift Data Sharing Now Generally Available
Amazon has recently announced the general availability of the Amazon Redshift Data Sharing functionality to share live data across Amazon Redshift clusters. This allows the use of a single data warehouse cluster for multi-cluster deployments and sharing data instantly without the need to copy or move them.
-
Hazelcast Jet 4.4 Released - the Four-Year Anniversary Release as Seen by Scott McMahon
Hazelcast Jet recently celebrated its four-year anniversary with the release of version 4.4. Besides the normal bug fixes and performance enhancements, this new version ships with new features such as the unified file connector and the first beta version of the SQL interface. InfoQ spoke to Scott McMahon, technical director of field engineering at Hazelcast, about this new release.
-
AWS Introduces HealthLake and Redshift ML in Preview
AWS introduced preview releases of Amazon HealthLake service and a feature for Amazon Redshift called Redshift ML during re:Invent 2020 in December. Amazon HealthLake is a data lake service that helps healthcare, health insurance, and pharmaceutical companies to derive value out of their data with the help of NLP. Redshift ML is a service that provides a gateway into SageMaker to Redshift users.
-
PASS to Cease Operations on January 15
PASS, formerly known as the Professional Association for SQL Server, will cease operations on January 15. The non-profit organization, which was known primarily for its conferences, is unable to meet its financial obligations.
-
AWS Announces New Database Service Babelfish for Aurora PostgreSQL in Preview
During the AWS re:Invent keynote, AWS announced the new database service Babelfish for Aurora PostgreSQL in Preview. The service is a fully-managed, PostgreSQL-compatible and ACID-compliant relational database engine that runs in the Amazon cloud and is open-source.
-
AWS Introduces Preview of Aurora Serverless v2
During the first keynote of re:Invent 2020, AWS announced the next version of Amazon Aurora Serverless in preview. The new serverless version for the MySQL 5.7-compatible edition of Amazon Aurora scales in fraction of a second and introduces multi-AZ support, global databases, and read replicas.
-
Google Launches a New Serverless Database Migration Service
Recently, Google announced a new serverless Database Migrates Service (DMS) in preview. The service supports migrations of self-hosted MySQL databases, either on-premises or in the cloud, and managed databases from other clouds, to Cloud SQL for MySQL.
-
Oracle Introduces the MySQL Database Service on Its Cloud Infrastructure
In a recent blog post, Oracle introduced the MySQL Database Service in the Oracle Cloud Infrastructure (OCI). The service is now available as a fully-managed service running on Oracle Generation 2 Cloud Infrastructure.
-
Google Cloud SQL Supports MySQL 8.0
Google Cloud has recently made MySQL 8.0 available on Cloud SQL, the managed relational database service for MySQL, PostgreSQL, and SQL Server.
-
GitHub Was down Multiple Times Last February: Here's Why
GitHub completed its internal investigation about what caused multiple service interruptions that affected its service last February for over eight hours. The root cause for this was a combination of unexpected database load variation and database configuration issues.