MarquinSmith

Analytical – Honest – Passionate

  • Home
  • Services
  • Mini Projects
    • Data Analytics Helper Tools
    • Bitcoin Price Dashboard
    • Journey to data engineering
    • Tarantino Film Dashboard
    • Woolworths stock price tracker
    • How to reason and argue
  • Reference
    • The BookShelf
    • SQL Cheat Sheet
    • Dockerfile Cheat Sheet
  • Health, fitness and wellbeing
    • Crossfit Workouts
    • Gymnastics
    • Strength and fitness masterclass
    • Nutrition Course
    • Workout Stats
    • Physical Activity Stats
    • 6 week pre season soccer fitness plan
  • About

Author: M Smith

Data Analysis

Calculate a reasonable daily usage quota for BigQuery

28th July 202528th July 2025 M SmithLeave a comment

A previous post showed how to set a ‘daily query usage‘ quota in BigQuery, and what that quota should be to stay within the free tier of BigQuery. Well, what …

Read More ›
Automation

Archive (tar + gzip) a folder using bash

24th July 202523rd July 2025 M SmithLeave a comment

The following command will create a gzipped (compressed) tar file (many files into one file) for a folder called “Downloads”. In other words all the files and folders in the …

Read More ›
Data Analysis

Set a daily query usage quota in BigQuery

23rd July 202523rd July 2025 M SmithLeave a comment

In BigQuery there is a free tier for querying data. As long as less than 1 tebibyte of data is queried in a month there are no charges associated with …

Read More ›
Personal Development

Learn Hard Concepts by Colin Galen

5th July 20255th July 2025 M SmithLeave a comment

AI summary: The video “Focusing Your Unconscious Mind: Learn Hard Concepts Intuitively (And Forever)” presents a method for deeply and intuitively learning complex concepts so they become second nature and …

Read More ›
Personal Development

Self improvement inspired by the founders – Art of Manliness

5th July 20255th July 2025 M SmithLeave a comment

A podcast from the Art of Manliness podcast about self improvement and surrounding philosophy from some of the most influential characters in the formation of modern day United States of …

Read More ›
Automation

Python script to send an email with Sendgrid API

5th July 2025 M SmithLeave a comment

A short python script that uses the Sendgrid API to send a basic email.

Read More ›
Automation

gitleaks – a tool for detecting secrets

2nd July 2025 M SmithLeave a comment

I came across this great tool today called gitleaks. This tool will search through directories and git repos (all locally) to see if it can find any secrets, API keys, …

Read More ›
Data Analysis

All roads lead to SQLite

1st July 20251st July 2025 M SmithLeave a comment

SQLite is a great choice for doing data analytics locally. SQLite is a robust database that has been battle tested for over a decade. It is a single file which …

Read More ›
Data Analysis

The Nature of code genetic algorithm videos

30th June 202530th June 2025 M SmithLeave a comment

Videos about genetic algorithms from the Nature of Code playlist from “The Coding Train” YouTube channel. Nature of Code genetic algorithm section.

Read More ›
Automation

How to revoke read access to a single table in BigQuery using SQL

29th June 202528th June 2025 M SmithLeave a comment

If a particular user has been added read access to a table these permissions can be removed using the REVOKE keyword in SQL:

Read More ›

Posts pagination

1 2 3 4 … 16

Recent Posts

  • Calculate a reasonable daily usage quota for BigQuery
  • Archive (tar + gzip) a folder using bash
  • Set a daily query usage quota in BigQuery
  • Learn Hard Concepts by Colin Galen
  • Self improvement inspired by the founders – Art of Manliness

Categories

  • Automation
  • Business
  • cybersecurity
  • Data Analysis
  • Finance
  • Personal Development
  • Python
  • Uncategorised
  • Web Analytics

Archives

Copyright © 2025 MarquinSmith.
Theme Easthill by ThemeMunk. Powered by WordPress.