What is a Foreign Key?
01 May, 2023Foreign Keys are a necessity in any relational database. They help connect distinct data tables together by creating a tightly-bound reference between the tables.
How to Add a Column to a Microsoft SQL Server Table
02 June, 2022Modifying existing SQL tables is a common use case as the data models for your application change over time. The most basic of these modifications is adding a new column to a SQL table to capture more data.
How to Create a SQL Server Index
21 February, 2022Adding indexes to your SQL Server tables is something that you will do plenty of times throughout your career, either as a full-stack developer or as a specialist database admin. Fortunately, adding indexes to tables in your database is a pretty simple task.
What is a SQL Index?
04 January, 2022SQL databases are fundamentally pretty simple. Data is organised into tables and the tables have columns that connect each other together. The key for a SQL database is to be performant. Sometimes, queries can be extremely slow to return the filtered down dataset that our app is looking for. This is where SQL indexes come in.
Connecting to a SQL Server Database via NodeJs
01 November, 2021Every full-stack application in production today probably connects to a database of some variety, whether that be a NoSQL database like MongoDB, a MySQL database like MariaDB, a SQL Server database like those provided by Azure or any other variety. This means that knowing how to wire up a stable connection to these databases from your NodeJs API is a critical skill.
SQL Server Insert or Update Query with T-SQL & Merge
31 July, 2021A standard SQL Server query to execute that will insert a new row or update an existing one