Your database doesn’t just contain your data. It also contains data about your data. Here’s how to use System Tables to search

As I was having a hard time switching off from work this week, I thought: a ballet lesson would be a great way to discuss database concepts

This post covers the SQL concepts that pop up during training. If you have a junior analyst in your life, keep reading

Scanning millions of rows each time you run a query is going be time-consuming and tedious. That’s where SQL indexes come in

SQL Joins are the first big learning curve after getting your head around the basics

SQL Server Management Studio (SSMS) is a highly customisable tool, here’s 10 ways to make it work best for you