Blog card feature

How to Add a Column to a Microsoft SQL Server Table

02 June, 2022

Modifying 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.

Blog card feature

Connecting to a SQL Server Database via NodeJs

01 November, 2021

Every 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.

Blog card feature

How to Create a SQL Server Index

21 February, 2022

Adding 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.

Blog card feature

SQL Server Insert or Update Query with T-SQL & Merge

31 July, 2021

A standard SQL Server query to execute that will insert a new row or update an existing one

Blog card feature

What is a Foreign Key?

01 May, 2023

Foreign Keys are a necessity in any relational database. They help connect distinct data tables together by creating a tightly-bound reference between the tables.

Blog card feature

What is a SQL Index?

04 January, 2022

SQL 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.