Modified Friday 30-08 10:08

time duration is known as interval in SQL. An SQL interval data type descriptor contains: the name of the interval data type (INTERVAL); an indication of whether the interval data type is : a year-month interval. It can include only YEAR, MONTHfielfields...

Modified Friday 30-08 10:08

in SQL. A join is a SQL clause statement which define the set operation such as: intersection, union, that the database must perform between two or more relation (table, view, query, ...). The result set is beautifully illustrated with a Venn_diagram....

Modified Friday 30-08 10:08

lag and lead are Sql window functions that provide access to a row at a given offset prior to/after the current row position.

Modified Friday 30-08 10:08

A Left Outer is a join that shows: All data from the left table and any data that matches the join predicate with the right table. In some databases, LEFT JOIN is called LEFT OUTER JOIN. Causes the data of the shared records found in the second...

Modified Friday 30-08 10:08

The term large object (LOB) refers to a data item that is too large to be stored directly in a database table. Instead, a pointer is stored in the database table, which points to the location of the actual data: ie: a file in the local file system...

Modified Friday 30-08 10:08

A materialized view is an auxiliary data structure that persist the result of a query in a table format managed by the cache system of the database. The refresh of the data is defined in criteria: at time interval, or incrementally via the the...

Modified Friday 30-08 10:08

A merge statement execute an expression if an expression matches and an other if not. Database Upsert style MySQL INSERT .. ON DUPLICATE KEY REPLACE .. Oracle MERGE .. PostgreSQL INSERT .. ON CONFLICT .. DO UPDATE SET .. SQLite INSERT OR...

Modified Friday 30-08 10:08

A natural join is an equi-join on the same attribute name (column) of each relation (table, query, ...) It's a shorthand equi-join where the equality predicate applied to all shared attributes. Create the table And insert Natural Join Select...

Created Friday 30-08 10:11

An Action Plugin is a type of module that: set up some values on the controller, (ie create a start state) then invoke an other module on the managed node that does something with these values.

Created Friday 30-08 10:11

Adhoc command are command executed as in the shell via ansible. You can therefore execute command on a whole cluster of server. This is because the default module of the ansible command line is command We define the servers in a ini inventory...

Created Friday 30-08 10:11

You may get this problem when one of your file that defines ansible property has no content (ie is empty)

Created Friday 30-08 10:11

ansible-pull is command line client that runs playbook in a pull way (ie on the localhost) whereas ansible-playbook will run them in a push way. It is a small script that will checkout a repo of configuration instructions from git, and then run ansible-playbook...

Created Friday 30-08 10:11

ansible-vault is a command line utility that permits to add/get sensitive data (file or property value) into an encrypted format called a vault Example of sensitive data: password private keys When running a playbook, Ansible finds: the sensitive...

Created Friday 30-08 10:11

Created Friday 30-08 10:11

Ansible define and run a single playbook task against a set of hosts. Ansible “raw” module is a command line for executing commands in a quick and dirty way. The script module don’t even need Python installed. /usr/bin/ansible Running...

Created Friday 30-08 10:11

in Azure ansible/ansible/blob/devel/contrib/inventory/azure_rm.iniazure_rm.ini config Then Command in all host of resourceGroup with the ansible cli The playbook Run ...