Cloud Operations
Security
Writing Cloud Security Posture Checks in SQL
Write cloud security checks in SQL instead of proprietary policy languages. See practical queries for public buckets, MFA, encryption, and more.
Joe Karlsson •
Blog Archive Page 5
Cloud Operations
Governance
Beyond Deploy-Time Checks: Continuous Cloud Governance
Deploy-time policy checks miss console changes, configuration drift, and external changes. Continuous governance catches what CI/CD pipelines cannot.
Joe Karlsson •
Engineering
Third Normal Form (3NF) vs Star Schema: When to Use Each
Learn the differences between Third Normal Form (3NF) and star schema with SQL examples, table diagrams, and guidance on when to use each in a data warehouse.
Tim Armstrong •
AWS
Security
AWS Delegated Administrator: Setup Guide
Set up AWS Delegated Administrator across 37+ services. Covers CLI and Terraform setup, IAM policies, delegation patterns, and auditing with CloudQuery.
Jason Kao •
AWS
Security
Tutorials
Set Up AWS CLI with SSO (IAM Identity Center) — Step by Step
Configure AWS CLI v2 with IAM Identity Center in 5 minutes. Covers sso-session setup, automatic token refresh, and switching between multi-account profiles.
Yevgeny Pats •
Comparisons
Steampipe vs CloudQuery: Architecture and Trade-offs
Steampipe queries cloud APIs in real time via SQL. CloudQuery syncs data into a persistent inventory. Compare architectures, integrations, and use cases.
Joe Karlsson •
Cloud Infrastructure
Cloud Operations
Governance
Visibility-First Cloud Governance: Why You Should Start with Data
Most governance models fail because they enforce rules about infrastructure they cannot see. The Visibility-First model starts with a queryable foundation.
Joe Karlsson •
Cloud Operations
FinOps
Calculating the True Cost of Cloud Operations Toil
Engineering toil from fragmented cloud visibility costs $47K-$90K per engineer yearly. Use our calculator to measure the real cost at your organization.
Joe Karlsson •