A daily tech reading list covering AI agents, cloud services, software engineering trends, and new tools like conversational analytics in BigQuery.
Introduces BigQuery's new GROUP BY ALL syntax, which automatically infers grouping keys from SELECT items to simplify complex SQL queries.
Exploring DuckDB's geospatial extensions and features for optimizing a large-scale fiber-optic network data pipeline.
A technical guide on using ClickHouse to export PostgreSQL data to Parquet format for faster loading into Google BigQuery.
Tips for using Google BigQuery's public datasets while managing and minimizing query costs, including using the free tier and setting budgets.
Analyzing C# coding trends on GitHub using BigQuery, covering tabs vs. spaces, brace styles, and popular libraries.
A technical guide on using Google BigQuery to analyze GitHub pull request data, including SQL queries for repository statistics.
