Database Recovery

Learn the Role of Triggers and Where They Can Be Used in SQL Server Database

This article explains the role of Triggers in SQL Server database, while also addressing the right way to use them in the database management system. Triggers are a type of advanced storage procedure, which are written to perform actions in a table like UPDATE, DELETE or INSERT. Users often make the mistake of overusing Triggers which is the leading cause for issues in their system’s performance. It is very essential for the users to properly use Triggers, or they could end up losing their...

Read more »

How to Use Integrity Constraints in SQL Server Database Design

In this article we learn about the Integrity Constraints feature in Database design, and how it helps users to safeguard what is entered in the database tables. SQL Server databases are a storehouse of data, although the access to enter data in the database should be limited to only a few people, there are other measures as well that need to be taken to ensure only relevant data is entered in the tables. One such measure is making use of Integrity Constraints for SQL databases. Integrity...

Read more »

Understand the Capabilities of Data Migration Assistant for Upgrading Your SQL Server Edition

In this article we understand the Data Migration Assistant in SQL Server and how it helps when upgrading a SQL Server instance to Azure. The Data Migration Assistant in SQL Server helps detect compatibility issues between the data platform in use, the more recent edition of SQL Server, and Azure databases, that you might be willing to update to. On the basis of this detection, it suggests the user a modern data platform to which they should update for better functionality of the database....

Read more »