How to disable a Foreign Key Constraint: Run this ONE simple statement!

Reading Time: 3 minutesForeign 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 Implicit Transaction Mode: Proceed with Caution!

Reading Time: 4 minutesImplicit transactions are a strange thing in SQL Server. It’s very important to understand how transactions work in Microsoft SQL Server and to understand the different tools available to us when writing transactions. One such tool is the “IMPLICIT_TRANSACTIONS” mode. But beware. Enabling this feature can have unforeseen consequences! In Continue Reading