Updates and recent posts about BigQuery..

Posts
Description

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

GitHub Copilot DevOps Excellence: Prompt Files vs Instructions vs Chat Modes

GitHub Copilot just leveled up:prompt files,custom instructions, andcustom chat modesare live. Now it's not just tagging along—it’s shaping how you work. Automate code reviews, security scans, or implementation plans. Reuse setups across teams. Control it all from VS Code... read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

GitOps Done Right: 10 Best Practices That Make It Work

GitOps ditches hand-rolled deployment scripts for a cleaner, declarative model. Git becomes the truth. Agents likeArgo CDorFlux CDwatch for changes and sync your clusters on their own. It’s not just about pushing YAML. Good GitOps setups lean onKustomizefor modular config, wire inautomated image up.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

Indexed Views in SQL Server: A Production DBA's Complete Guide

Indexed viewsare apowerfulyet underutilized feature in SQL Server for optimizing complex query performance, with potential for significant performance gains in read-heavy applications. Automatic query substitution is a game-changer when it comes to leveragingindexed viewsfor performance optimization.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

How I Scanned all of GitHub’s “Oops Commits” for Leaked Secrets

Truffle Security dropped a sharp new open-source tool that digs through GitHub’s public commit history looking forzero-commit force pushes—a tactic devs use to erase mistakes, usually secrets. Problem is, they don’t go quietly. By tapping into historical GitHub PushEvents via GH Archive, the tool h.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

You might not need tmux

A dev swapped outtmuxfor a slick combo:Zellij,SSH multiplexing, andsystemdsocket daemons. No more virtual splits. Just clean session persistence and tight remote control. This setup brings scrollback back where it belongs—your terminal’s native buffer. It plays nice with extras like theKitty graphi.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

Writing a basic service for GNU Guix

A developer walks through building acustom GNU Guix system serviceforkmonad—yes, the keyboard remapper—by wiring up a newservice-typethat plugs intoShepherdandaccount-service-type. To get there, they lift patterns from services likewesnothd, usemake-forkexec-constructorto spin up the daemon, and de.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

Automating infrastructure deployments in the Cloud with Terraform and Azure Pipelines

This Azure lab wires upTerraformwithAzure Pipelines CI/CDto spin up infrastructure and deploy a .NET Core app using IaC. It handles remote state with Azure Storage, automatesplanandapplyin pipelines, and swaps in config values via token replacement during deploy... read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

Cloudflare and the infinite sadness of migrations

A recent Cloudflare DNS outage traced back to legacy gear tangled with global config changes. Turns out, incomplete migrations can still pack a punch. Their newer topology system does support progressive rollouts—but running it side-by-side with the old one just made the blast radius bigger. System.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

Amazon DocumentDB Serverless is now available

Amazon DocumentDB Serverless is out of preview and ready to roll. It auto-scales compute and memory usingDCUsfor MongoDB-compatible clusters. No migration needed—just upgrade your existing instance and go. Available starting in version5.0, with per-second billing based on DCU burn. What’s new:Fixed.. read more

Link

@faun shared a link, 10 months, 2 weeks ago

FAUN.dev()

Supply chain attack compromises npm packages to spread backdoor malware

A fresh supply chain ambush—Scavenger—slipped into npm through the front door. Attackers phished maintainers of high-profile packages likeis,eslint-plugin-prettier, andsynckit, then dropped cross-platform JavaScript malware straight into the codebase. Real-time C2 channels included. They typosquatt.. read more

BigQuery is a cloud-native, serverless analytics platform designed to store, query, and analyze massive volumes of structured and semi-structured data using standard SQL. It separates storage from compute, automatically scales resources, and eliminates the need for infrastructure management, indexing, or capacity planning.

BigQuery is optimized for analytical workloads such as business intelligence, log analysis, data science, and machine learning. It supports real-time data ingestion via streaming, batch loading from cloud storage, and federated queries across external data sources like Cloud Storage, Bigtable, and Google Drive.

Query execution is distributed and highly parallel, enabling interactive performance even on petabyte-scale datasets. The platform integrates deeply with the Google Cloud ecosystem, including Looker for BI, Vertex AI for ML workflows, Dataflow for streaming pipelines, and BigQuery ML, which allows users to train and run machine learning models directly using SQL.

Built-in security features include fine-grained IAM controls, column- and row-level security, encryption by default, and audit logging. BigQuery follows a consumption-based pricing model, charging for storage and queries (on-demand or reserved capacity).