Reading Time: 8 minutes String manipulation is something you will likely find yourself doing at some point in your career as a database professional. Luckily, SQL Server has many great system functions we can use to make the task of string searching and manipulation very easy. In this week’s tutorial, we’ll cover the TOP Continue Reading
How long can a table name be? Learn this “factoid” and more!
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
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