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

Add Auto-Increment to a Column in SQL Server

25 February, 2022

Knowing how to add auto-incrementing to a numeric column in SQL Server is a skill all database admins should have. It is an exceptionally common use case, whether it be on the Primary Key column of your table, or you need a column to identify insert order or similar.

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.