System


MS-SQL Joins explained: Inner, Outer, Left, Right Join; Union

MS-SQL Joins explained: Inner, Outer, Left, Right Join; Union

created: 2023-02-22 from Bernhard

Joins can be used to get data in SQL from one or more tables in a single output. Joins are often combined with other queries in practice: For example, most often for the selection of data is not, as used here, a "select * from", but the respective columns are selected: "select column1,column2 from", or, of course, the joins can be combined or nested with "where" or other queries. ... continue reading

Bash function and logging for an rsync backup script

Bash function and logging for an rsync backup script

created: 2022-11-30 from Bernhard

To synchronize multiple folders via rsync, the individual folders for the sync can be written into a bash file as follows, so far so simple: ... continue reading