DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
4 numeric distribution metrics to track in Snowflake (and how to track them)

4 numeric distribution metrics to track in Snowflake (and how to track them)

Comments
9 min read
Detecting table insert misses with adaptive flatline alerts

Detecting table insert misses with adaptive flatline alerts

Comments
3 min read
Three ways to track schema drift in Snowflake

Three ways to track schema drift in Snowflake

Comments
5 min read
Better Postgres Database Migrations and Testing by Ditching Bloated ORMs

Better Postgres Database Migrations and Testing by Ditching Bloated ORMs

Comments
3 min read
Stay Fresh: Four Ways to Track Update Times for BigQuery Tables and Views

Stay Fresh: Four Ways to Track Update Times for BigQuery Tables and Views

Comments
3 min read
Comparing Snowflake Dynamic Tables with dbt

Comparing Snowflake Dynamic Tables with dbt

1
Comments
5 min read
Four Efficient Techniques to Retrieve Row Counts in BigQuery Tables and Views

Four Efficient Techniques to Retrieve Row Counts in BigQuery Tables and Views

Comments
4 min read
Three Ways to Retrieve Row Counts in Redshift Tables and Views

Three Ways to Retrieve Row Counts in Redshift Tables and Views

Comments
3 min read
Stay Fresh: Two Ways to Track Update Times for Snowflake Tables and Views

Stay Fresh: Two Ways to Track Update Times for Snowflake Tables and Views

Comments
3 min read
3 ways to improve data sampling efficiency in Snowflake

3 ways to improve data sampling efficiency in Snowflake

Comments
7 min read
Three Ways to Retrieve Row Counts for Snowflake Tables and Views

Three Ways to Retrieve Row Counts for Snowflake Tables and Views

Comments
2 min read
Query optimisation using database indexes

Query optimisation using database indexes

1
Comments
3 min read
Hey Managers! Don’t Let Developers Break Your Production! Let Metis Help You

Hey Managers! Don’t Let Developers Break Your Production! Let Metis Help You

Comments
7 min read
11 Lessons to learn when using NULLs in PostgreSQL®

11 Lessons to learn when using NULLs in PostgreSQL®

8
Comments
11 min read
Structured Query Language-SQL : Mastering SQL Queries: From Beginner to Expert

Structured Query Language-SQL : Mastering SQL Queries: From Beginner to Expert

6
Comments
6 min read
SQL vs. No SQL | Database Types | Mastering Data Architecture

SQL vs. No SQL | Database Types | Mastering Data Architecture

5
Comments
4 min read
SQLite3 Replication: A Wizard's Guide🧙🏽

SQLite3 Replication: A Wizard's Guide🧙🏽

10
Comments
4 min read
Complete Guide: Fully Uninstalling Microsoft SQL Server 2019 from Your System

Complete Guide: Fully Uninstalling Microsoft SQL Server 2019 from Your System

13
Comments
2 min read
Functions in SQL

Functions in SQL

5
Comments
3 min read
Use EXISTS instead of COUNT > 0 when checking if records exist

Use EXISTS instead of COUNT > 0 when checking if records exist

Comments 2
3 min read
Understanding OVER() Clause in SQL

Understanding OVER() Clause in SQL

1
Comments
2 min read
Unlocking the Power of SQL Server: The Importance of Stored Procedures for Complex Queries

Unlocking the Power of SQL Server: The Importance of Stored Procedures for Complex Queries

Comments
2 min read
Mastering SQL Aggregate Functions: SUM, MAX, MIN, AVG

Mastering SQL Aggregate Functions: SUM, MAX, MIN, AVG

2
Comments
4 min read
Beyond the Basics: Leveraging ACID for Advanced Database Management

Beyond the Basics: Leveraging ACID for Advanced Database Management

Comments
2 min read
Why Python and SQL are Must-Have Skills for Marketing Analysts in the Age of Big Data

Why Python and SQL are Must-Have Skills for Marketing Analysts in the Age of Big Data

10
Comments
6 min read
loading...