Published: 25 September 2021
Identity columns are the SQL Server's equivalent of Postgresql's serial type. Since this column can be the underpinning of what you use as the ID for a table, it's important to be aware of it. In this informative article, Greg Larsen outlines how to manage identity columns for uniqueness, their associated functions, and caching.
Published: 28 September 2021
A space leak is when something in a program takes up more memory than expected (as a very broad definition). Theses are an issue, because they can eventually lead to your program crashing. In this article, Tom Ellis demonstrates how the bang operator can be used to prevent such leaks, highlights issues with the solution, and provides an alternative.
Published: 29 September 2021
When writing code, often times you'll want to keep track of brackets, paranthesis, and other symbols that outline the current scope. This extensive article by Henning Dieterichs covers the algorithms and data structures required to achieve the titular claim in VSCode.