Tsql Tips

Sometimes you need random numbers from 1 to 1000 and without duplicated numbers, here is the link:

http://sqlperformance.com/2013/09/t-sql-queries/random-collisions

Backup all databases at once from a SQL Server?
https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/

Reindex all tables in a DB TSQL
http://blog.sqlauthority.com/2015/02/15/interview-question-of-the-week-007-how-to-reindex-every-table-of-the-database/