(TIL) TSQL: Basic T-SQL
```sql – Show all databases. select name from master.sys.databases;
Recent Posts
(TIL) SQL: List Columns in Table
The ANSI standard way of listing all columns in a database table is:
(TIL) Docker: Filtered system prune
Every now and then I run:
(TIL) Spark: Date Arithmetic with Multiple Columns
Say you have a timestamp column created_at, and an integer column number that represents a number of weeks, how do you use the date_add function to calculate...
(TIL) Spark: Count number of duplicate rows
To count the number of duplicate rows in a pyspark DataFrame, you want to groupBy() all the columns and count(), then select the sum of the counts for the ro...