A software or programming languages have definite advantages and disadvantages of each, is no exception database (SQL Server). Here are some Advantages and Disadvantages of SQL Server:
Pros / Advantages of SQL Server:
1. Supports SP (Store Procedure). With Store Procedure, we will benefit, especially for security (preventing double input).
2. Supports Trigger, is a set of commands or syntax that will be automatically executed when certain operations occur in a table or view. Trigger is usually used to call one or multiple SQL statements automatically before and after the manipulation process (Create, Read, Update, Delete). Suppose we want to store the data back-up to the history table or the log before the data is deleted from a table.
3. Supports the existence of a cursor, to make a mapping table we record the process.
4. Encourage transact SQL function and a few others. In other words, we can combine all four features that SQL Server.
deficiency / weakness of SQL Server:
1. Paid application which is when we use the application formally, we need to expend substantial funds for the software.
2. Has many BUG, so that if we are not careful, might be exploited from outside. For example, the database file can easily be attached or removed from the SQL server system. Read also other articles about: History of Microsoft SQL Server.
Those are some Advantages and Disadvantages of SQL Server that we need to know before we use SQL Server.
Pros / Advantages of SQL Server:
1. Supports SP (Store Procedure). With Store Procedure, we will benefit, especially for security (preventing double input).
2. Supports Trigger, is a set of commands or syntax that will be automatically executed when certain operations occur in a table or view. Trigger is usually used to call one or multiple SQL statements automatically before and after the manipulation process (Create, Read, Update, Delete). Suppose we want to store the data back-up to the history table or the log before the data is deleted from a table.
3. Supports the existence of a cursor, to make a mapping table we record the process.
4. Encourage transact SQL function and a few others. In other words, we can combine all four features that SQL Server.
deficiency / weakness of SQL Server:
1. Paid application which is when we use the application formally, we need to expend substantial funds for the software.
2. Has many BUG, so that if we are not careful, might be exploited from outside. For example, the database file can easily be attached or removed from the SQL server system. Read also other articles about: History of Microsoft SQL Server.
Those are some Advantages and Disadvantages of SQL Server that we need to know before we use SQL Server.
Comments
Post a Comment