To differentiate between OrderIDs that are identical, it is suggested to include a SubOrderID as an additional field with a serial number suffix. For example,
Category: RDBMS
Anonymity with Random Values in MySQL
Organisations can use data anonymization as a strategy to abide by strict data privacy rules that require the protection of personally identifiable information (PII), such
SQL Sample Datasets and Assignments
Here is a compilation of earlier blog posts that were relevant to Sample datasets, Sample projects, and Sample assignments. For quick reference only.
Hadoop Default Ports
Computers are able to distinguish between various traffic types with the use of ports. A default open port is a port number that is preconfigured
Metadata Information from SYS tables – SQL Server
The underlying tables which store the metadata for a certain database are called system tables. A system table called sys tables is used to keep
Get the information about the backup and restore operations
The msdb database keeps a complete record of every SQL Server backup and restore procedure performed on a server instance. The data for the SQL
Big Data & SQL 