#TIL about the different migration strategies that we can use to migration from one #database to another.
1. One step migration
2. Two steps migration
3. Iterative migration
#TIL about #AWS Snow family devices that include physical devices shipped to your place. These can be used to ship data in and out of AWS.
https://t.co/f7HmeQ2KTn
#TIL that we can use the recluster option during VACUUM operation in #AWS Redshift to sort the unsorted table portions without merging the data with the automatically sorted portions of the table.
#DoYouKnow That #AWS Redshift uses ATO (Automatic table optimization) to automatically optimize the tables by configuring sort keys, dist keys and encoding when the table is created with the AUTO option.
#TIL The SQL Row values syntax can also be used in the WHERE clauses. It is most commonly seen in the INSERT statements.
Check out the usage here - https://t.co/bXOi3gHTbL
#SQL#Databases
#DoYouKnow Ensuring that the database executes the query in a pipelined manner is more important than a fast execution!
Read more here - https://t.co/98znxU1dWL
#SQL#Databases