Reading Time: 2 minutes There are many, many details one can learn about Microsoft SQL Server over a very long career in data science. This blog, with over 120 posts, only begins to scratch the surface! In this weeks tutorial, I’d like to talk about just a few unique factoids you might find interesting: Continue Reading
Developing Databases
SQL Server DROP IF EXISTS: Explained with Examples
Reading Time: 4 minutes In SQL Server version 2016, Microsoft introduced an extremely handy tool called DROP IF EXISTS to make our database development lives so must easier. In this very brief tutorial, we’ll walk through the syntax of the DROP IF EXISTS tool and show you a few examples of how to use Continue Reading
How to disable a Foreign Key Constraint: Run this ONE simple statement!
Reading Time: 3 minutes Foreign key constraints are an excellent way to preserve the referential integrity of the data in your database. If you’re new to SQL Server and don’t fully understand what a foreign key is or how they work, make sure you check out the full beginner-friendly tutorial first to learn everything Continue Reading
SQL Server Sequence Object: Explained for Beginners
Reading Time: 7 minutes One of the most useful tools available to us in Microsoft SQL Server is the sequence object. Sequence objects are a great way to let SQL Server track and update an integer value that can be used to populate a primary key column. In this very brief tutorial, we’ll discuss Continue Reading
Do you know this IMPORTANT RULE about Foreign Key Constraints?
Reading Time: 5 minutes Foreign Key Constraints in Microsoft SQL Server are excellent for preserving the integrity of our data. We use a foreign key constraint to basically establish a parent-child relationship between two tables. A foreign key constraint will enforce that a value must first exist in the parent table before it can Continue Reading
The Top 7 SQL Server Best Practices You Should Follow!
Reading Time: 8 minutes If you are in the process of learning how to query and develop SQL Server databases, congratulations, you are learning a skill that is extremely valuable in today’s data driven climate. There are many great tools you can use when it comes to querying and developing Microsoft SQL Server databases, Continue Reading