ELI5: The Various Types of Joins in SQL

One of the things you'll need to use the most when writing stored procedures and views in SQL are joins. These allow you to retrieve data from multiple tables at once. This article will be mostly focusing on T-SQL and SQL Server Management Studio. From my experience people can get slightly overwhelmed by the numbers [...]

How and why: Normalize your Data

When we talk about normalizing data within a database we really just mean that we're organizing our data properly in order to make our database run more efficiently and reduce needless duplication. We can put our data through 5 different levels of organization, which we call "forms". Basic rules for normalization: Each table should have [...]