Posted inAzure Microsoft Fabric tenant settings
Microsoft Fabric Tenant Settings Deep Guide
A deep guide to Microsoft Fabric tenant settings: what the key settings control, how access is layered, and the safest defaults for production.
AWS serverless streaming analytics
A fully serverless streaming analytics pipeline on AWS using Kinesis Data Streams, Lambda, S3 and QuickSight, from ingestion to dashboards.
Advanced : Deep Dive into Complex SQL Functionalities
Advanced SQL deep dive: window functions, CTEs, subqueries, pivoting and performance tips to tackle complex data analysis challenges.
Foundation of SQL for Beginners
SQL foundations for beginners: SELECT, filtering, sorting, joins and aggregations to start querying relational databases with confidence.
SQL for Data Analytics: A Comprehensive Guide
SQL for data analytics: a comprehensive guide to the queries, functions and techniques analysts, engineers and data scientists use daily.
Posted inBig data
Data Modeling a 100 TB Data Lake into 5 TBs Using STRUCT and Array
How to model a 100 TB data lake into 5 TB using STRUCT and ARRAY types: nested data design, compression and faster analytics queries.
Posted inBig data
Data Lake Fundamentals, Apache Iceberg, and Parquet
Data lake fundamentals explained, plus how Apache Iceberg and Parquet make large-scale data storage fast, reliable and easy to manage.
Posted inBig data
How to Optimize Your Cloud Usage and Avoid AWS Pitfalls
Optimise your cloud usage and avoid common AWS pitfalls: keep costs under control, reduce dependency on one provider and choose the right services.