tr command in UNIX is a text processing command which is used to either replace or delete characters. The syntax of the command is as such – tr [OPTION] string1 string2 Remember, anything that is written in square brackets is optional. Now, let us understand how tr works. tr “a” “A” (enter) Now when the Continue reading

SEQUENCE is used to generate automatically incrementing number but unlike IDENTITY it is not associated with any tables. The sequence of numeric values is generated in ascending or descending order at a defined interval and can be configured to restart cycle when exhausted. Like IDENTITY, sequence can be generated using INT data types. The data Continue reading

An instance of the server contains one or more databases. Each database has one or more schemas. Each schema has one or more database objects like tables, views, stored procedures etc. The database in SQL server consists of tables containing rows and columns used to store structured data. Each column contains data such as name, Continue reading

Data is valuable and we have been storing data since a very long time. Before computers arrived, data was stored manually in registers or any other files and kept in the file cabinets. But with the arrival of computers, data started getting stored in disks, floppies etc. But storing data this way was quite risky. Continue reading

The central point of Business Intelligence is data. The whole point of why we need Business Intelligence is that there is lot of data and we need to analyze it to take efficient decisions. But then data in real life, does not comes from one single source. Neither it is the easy way i.e. you Continue reading