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 … Continue reading ELI5: The Various Types of Joins in SQL


Reverse Engineering Command-Line Commands

As someone who still has a lot to learn about using the command line, I find it all too easy to just Google my problem then blindly copy the results. It's only recently that I've invested some time and energy into working out exactly what's going on with each argument to firstly make sure that … Continue reading Reverse Engineering Command-Line Commands