A lot of new documentation was published recently around Fabric capacities, including documentation on how to size and govern capacities and how to troubleshoot problems with capacities. The latter ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

PostgreSQL is an advanced open-source relational database that has been widely used in the management of big data due to its robustness, scalability, and flexibility. However, with a large volume of ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

Databases are often assumed to have definite content. The reality, though, is that the database at hand may be deficient due to missing, invalid, or uncertain information. As a simple illustration, ...

本文重点尝试从ODPS SQL的逻辑执行计划和Logview中的执行计划出发，分析日常数据研发过程中各种优化方法背后的原理，覆盖了部分调优方法的分析，从知道怎么优化，到为什么这样优化，以及还能怎样优化。 一、背景 使用ODPS SQL进行离线数据研发时，开发同学不 ...

Students of database courses usually encounter difficulties in learning structured query language (SQL). Numerous studies have been conducted to improve how students learn SQL. However, learning SQL ...