Posts on ad hoc analysis and reporting.
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