- ANSI mode errors on Databricks Runtime 17+: CAST_INVALID_INPUT, DIVIDE_BY_ZERO and overflow fixes cheat sheetDatabricks on Azure · 12 Nov 2026
- Databricks materialized view does a full recompute on every refresh - reading planning_information and making it incrementalDatabricks on Azure · 11 Nov 2026
- dbt model contracts and versions: enforce a public schema and ship breaking changes without breaking consumersData Platform · 11 Nov 2026
- Surrogate keys on Delta at scale: identity columns, their concurrency limits and hash-key alternatives on Azure DatabricksDatabricks on Azure · 11 Nov 2026
- Text-to-SQL agent returns wrong numbers or runs runaway queries: schema grounding, read-only roles, statement timeouts and AST validationAI & GenAI · 11 Nov 2026
- Snowflake masking and row access policies: protect PII columns and rows by roleData Platform · 10 Nov 2026
- Snowflake unload basics: export query results to a stage as CSV or Parquet with COPY INTOData Platform · 9 Nov 2026
- dbt test failed: see the failing rows, set severity and thresholds, and stop noisy tests blocking buildsData Platform · 8 Nov 2026
- Unity Catalog information_schema cheat sheet: find tables, owners, columns, grants and tags with SQLDatabricks on Azure · 8 Nov 2026
- Snowflake MERGE fails with 'Duplicate row detected during DML action' (100090): find and fix itData Platform · 7 Nov 2026
- Delta table inspection cheat sheet: DESCRIBE HISTORY, DETAIL and who changed whatDatabricks on Azure · 6 Nov 2026
- Snowflake basics: warehouses, roles and your first queries without wasting creditsData Platform · 6 Nov 2026
- dbt incremental model drifted from source: repair duplicates, missed rows and new columnsData Platform · 5 Nov 2026
- Oracle ORA-01000 maximum open cursors exceeded: find the leak and fix itDatabases · 5 Nov 2026
- dbt source freshness: alert when a source stops loadingData Platform · 4 Nov 2026
- Stop a runaway Snowflake query: cancel by query ID, session, user or warehouse, then set timeoutsData Platform · 4 Nov 2026
- Timestamps off by hours in Azure Databricks: session time zones, TIMESTAMP vs TIMESTAMP_NTZ and daily totals that shiftDatabricks on Azure · 3 Nov 2026
- Snowflake ACCOUNT_USAGE ops cheat sheet: failed queries, long runners, failed logins, locks and grant changesData Platform · 2 Nov 2026
- Oracle Flashback cheat sheet: undo bad changes with Flashback Query, Table, Drop and DatabaseDatabases · 31 Oct 2026
- Oracle Data Pump cheat sheet: expdp, impdp, remaps, monitoring and the errors you'll hitDatabases · 30 Oct 2026
- Snowflake key-pair authentication for service users: setup and zero-downtime key rotationData Platform · 30 Oct 2026
- dbt basics: your first project with sources, models, ref, tests and docsData Platform · 29 Oct 2026
- Delta Lake basics: create a table, append, MERGE, and use time travel to undo mistakesData Platform · 29 Oct 2026
- Snowflake dynamic tables not refreshing - suspended tables, failed refreshes and lag that keeps growingData Platform · 29 Oct 2026
- Unity Catalog basics: metastore, catalogs, schemas, tables, volumes and who can see whatDatabricks on Azure · 29 Oct 2026
- Autonomous Database queries waiting on resmgr:cpu quantum: services, consumer groups and concurrency limitsOCI · 28 Oct 2026
- Fabric SQL analytics endpoint shows stale or missing data: Lakehouse metadata sync delays, skipped tables and how to refreshData Platform · 28 Oct 2026
- Oracle library cache: mutex X and cursor: pin S wait on X - high version counts, hard parsing and hot objectsDatabases · 28 Oct 2026
- Lakeflow pipeline event log cheat sheet: SQL for failures, expectations, backlog and lineageDatabricks on Azure · 27 Oct 2026
- METRIC_VIEW_WINDOW_MEASURE_REFERENCES_WINDOW_MEASURE - fixing metric views after the June 2026 Databricks validation changeDatabricks on Azure · 27 Oct 2026
- Oracle ORA-01555 snapshot too old: finding the long query, sizing undo and stopping it coming backDatabases · 27 Oct 2026
- Snowflake tasks not running: suspended graphs, skipped runs and stale streamsData Platform · 27 Oct 2026
- Unity Catalog row filters and column masks: restricting rows and hiding sensitive columns in Azure DatabricksDatabricks on Azure · 27 Oct 2026
- Databricks system tables for cost - SQL cheat sheet for DBU usage by job, cluster, warehouse, user and tagDatabricks on Azure · 26 Oct 2026
- dbt snapshots for slowly changing dimensions (SCD type 2) - setup, strategies and fixing common mistakesData Platform · 26 Oct 2026
- Oracle blocking sessions and \"enq: TX - row lock contention\" - finding the blocker, the SQL and the objectDatabases · 26 Oct 2026
- PostgreSQL roles and privileges cheat sheet - read-only users, app owners, default privileges and \"permission denied\"Databases · 26 Oct 2026
- Snowpipe not loading files: pipe status, COPY_HISTORY and safe reloadsData Platform · 26 Oct 2026
- Unity Catalog grants cheat sheet - USE CATALOG, USE SCHEMA, SELECT, ownership and fixing \"permission denied\"Databricks on Azure · 26 Oct 2026
- Sev1: Synapse dedicated SQL pool — every query queued, dashboards timing outData Platform · 25 Oct 2026
- dbt node selection and CLI cheat sheet: run exactly what you meanData Platform · 24 Oct 2026
- Snowflake credit spike: find the warehouse, query or serverless feature that burned itData Platform · 24 Oct 2026
- Autonomous Database is slow: Performance Hub, ECPU scaling and service choiceOCI · 22 Oct 2026
- Azure SQL Database is slow: high CPU, DTU limits and throttlingAzure · 22 Oct 2026
- Data quality checks that catch customer-visible problems before the customer doesData Platform · 22 Oct 2026
- dbt run failures: the common errors and how to fix them fastData Platform · 22 Oct 2026
- MySQL replication lag: finding the cause and fixing itDatabases · 22 Oct 2026
- Oracle tablespace full (ORA-01653 / ORA-01652): a runbookDatabases · 22 Oct 2026
- RDS database at high CPU: finding the culprit with Performance InsightsAWS · 22 Oct 2026
- Snowflake 'Object does not exist or not authorized': fixing role and grant issuesData Platform · 22 Oct 2026
- Snowflake queries are slow: queuing, spilling and pruningData Platform · 22 Oct 2026
- Synapse dedicated SQL pool slow queries: distribution skew and data movementData Platform · 22 Oct 2026
- PostgreSQL: finding table bloat and fixing autovacuum lagDatabases · 12 Oct 2026
- SQL Server blocking and deadlock triageDatabases · 30 Sept 2026