This week I got to thinking, a ballet class is a good way to describe database concepts.
This post covers the SQL concepts that pop up during training. If you need a refresher or have a junior analyst in your life who needs a resource to refer to, keep reading.
Your query is running slow, have you checked your indexes?
Joining tables is the first big learning curve after getting your head around SQL basics.
VLOOKUP lets Excel do the hard work of matching up a value from one spreadsheet to another. It saves time and is an essential Excel tool.
SSMS is highly customisable, here’s 10 ways to make it work best for you.