Thank you for taking the time to explore data-related insights with me. I appreciate your engagement. If you find this information helpful, I invite you to follow me or connect with me on LinkedIn.

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

本案例本质上属于有序数据合并问题，按照时间顺序合并数据集。本文对腾讯互娱某用户玩游戏的先后顺序链条、轨迹进行分析，给出了解决此类问题的技巧和方法，关键点是能识别出本题所属的问题类别，并利用相应的技巧求解。本题的难点在于断点数据去重 ...

本套路应用于子查询中含有row_number over(partition by order by) rn，并仅把rn列用于分类排序后筛选最大值的场景。 GaussDB中SQL语句的 ...

When you build a Power Apps canvas app there are many different data sources you can choose to use such as SharePoint, Microsoft Dataverse, SQL (on-premises), Azure SQL (online), Excel, and others ...

As I discussed in my review of Google Cloud Bigtable in 2016, Google’s 2006 Bigtable paper inspired several large-scale distributed open source NoSQL databases, including Apache HBase and Apache ...

Management Reporter (CU10+) integration for Dynamics AX 2012 pulls subsets of AX financial data first into staging tables in the data mart database. The Maintenance Task, which is run every minute by ...

In a new book titled Next Generation Databases: NoSQL, NewSQL, and Big Data, Guy Harrison shares what every data professional needs to know about the future of databases in a world of NoSQL and big ...