×
SQL

Overview of New Features of SQL Server 2022

This article describes an overview of the newly released features in SQL Server 2022 and the authors’s personal understanding of each function as a user.

Protecting Your Website: How WAFs Are Enhancing Website Security

In a bypass attack, the attacker's primary goal is to acquire information and inject a file or web shell code into the targeted system.

Using PostgreSQL Recursive SQL and the PL/pgSQL Function to Draw Fractal Graphs

This article explains how to use PostgreSQL Recursive SQL and the PL/pgSQL function to draw fractal graphs (with examples).

The Principle of SQL Optimizer

All well-known open-source products (such as MySQL, Spark, and Presto) have optimizers. This article explains the principle of SQL optimizers with an easy-to-understand approach.

Learning about Distributed Systems - Part 20: Rule-Based Optimization (RBO)

Part 20 of this series discusses another important SQL optimization method: rule-based optimization (RBO).

Learning about Distributed Systems – Part 19: Performance-Impacting Operations in SQL

Part 19 of this series discusses SQL performance optimization.

Combine OpenAI to Convert Natural Language Instructions into SQL Queries

This short article uses a demo to explain how to use OpenAI to convert natural language instructions into SQL queries.

How to Write Simple and Efficient Flink SQL

This article is compiled from Xiaolin He’s presentation at the 2022 Flink Forward Asia (FFA) Conference, discussing Flink SQL insight, best practices, and future works.

Relational Algebra and SQL Syntax – Part 1

Part 1 of this series introduces the theoretical basis and focuses on various high-end SQL operations.

Relational Algebra and SQL Syntax – Part 2

Part 2 of this series focuses on various SQL syntaxes.

How to Efficiently Implement SQL LIKE Syntax in Java

This article mainly introduces how mainstream parsers implement the LIKE syntax logic.

Learn about Distinctive SQL Writings and Write Efficient SQL Quickly

This article mainly explains common SQL development scenarios, distinctive SQL writing, and execution plans.

What Is SQL Injection Vulnerability and How to Avoid It?

This article explains what SQL injection is, the potential risks of an attack, and how to avoid it in web applications.

Performance Optimization of RDS AliSQL for Binlog – Extreme IO Optimization

This article introduces RDS AliSQL, binlog, and performance optimization tactics.

Backing up a Self-Managed SQL Server on Alibaba Cloud

This article discusses the options available to safeguard your self-managed Microsoft SQL Server database running on Alibaba Cloud using different backup and restore approaches.

Flink 1.16: How Does Hive SQL Migrate to Flink SQL?

This article was compiled from a speech from the Apache Flink Meetup, discussing the release of Flink 1.16.

What I Think Really Matters for Personal Growth in Software Development | From Junior Engineer to Expert

This article follows Øystein Grøvlen's path from a Norwegian employee to an Alibaba Cloud Architect.

An In-Depth Understanding of Presto (1): Presto Architecture

Part 1 of this series introduces some principles of Presto from a macro perspective, from the outside to the inside.

An In-Depth Understanding of Presto (2): Presto Memory Management

Part 2 of this series discusses Presto memory management.

Pandas + SLS SQL: Data Pivot with Flexibility and High Performance

This short article discusses Pandas and the advantages/disadvantages of SQL Language.