-
Entity-Relationship Diagrams With Sonic the Hedgehog
On first glance, Entity Relationship Diagrams may look like a spaghetti mess. This post hopes to demystify how they fit together with Sonic the Hedgehog
-
The Great Migration: from SQL Server to AWS Aurora
This is a retrospective covering some of the learnings of ‘Project Aurora’. A nine-month project to migrate 60 users from SQL Server to AWS Aurora
-
SQL Concepts From A to Z
This post covers the SQL concepts that pop up during training. If you have a junior analyst in your life, keep reading
-
AWS Concepts From A to Z
The AWS list of services grows each month, here’s a list to help you get to grips with some of them
-
Improve SQL Query Performance by Using Indexes
Scanning millions of rows each time you run a query is going be time-consuming and tedious. That’s where SQL indexes come in
-
Relational Joins Without Venn Diagrams
SQL Joins are the first big learning curve after getting your head around the basics