Reading Time: 16 minutes If you have been working with SQL Server for a while, you might have heard of something called referential integrity. This is basically the idea that references between tables are accurate. In SQL Server, there are plenty of times where we’ll need to reference data from one table in another table. Continue Reading

Reading Time: 12 minutes If you are new to SQL Server and the process of database design, you’ve probably heard of the need to create a primary key column in your tables. You’ve likely been told that “every table needs a primary key“. But do you understand why we need a primary key constraint Continue Reading