Tera-Tom

@TomCoffing@mastodon.cloud
0 Followers
6 Following
25 Posts

Not only can you join data across databases, but you can join it across clouds! The sky is no longer the limit.

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

ROW_NUMBER seems like a silly analytic, but it is one of my favorites because of the absolute power it brings me. They say absolute power corrupts, but the ROW_NUMBER erupts, absolutely!

https://coffingdw.com/row_number-analytic-across-all-databases/

#snowflake #databricks #db2 #teradata #oracle #bigquery #ibm #sqlserver #synapse #postgres #vertica #greenplum #redshift #aws #googlecloud #awscloud #azurecloud #cloud #sql #etl #postgres #yellowbrick #mysql #vmware #netezza

If you are drowning in data and must migrate thousands of tables, just breathe! Help! Someone throw them a Nexus.

#teradata #oracle #snowflake #aws #googlecloud #awscloud #azurecloud #cloud #redshift #sql #etl #postgres #yellowbrick #mysql #ibm #db2 #synapse #vertica #greenplum #vmware #sqlserver #netezza #bigquery #databricks #netezza

Ordered Analytics and Window functions can be confusing, but not anymore. Master them today and thank me forever! Here are examples of all the analytic functions on all systems, with easy-to-understand examples.

https://coffingdw.com/analytic-and-window-functions-for-all-systems-over-100-blogs/

#teradata #oracle #snowflake #aws #googlecloud #awscloud #azurecloud #cloud #redshift #sql #etl #postgres #yellowbrick #mysql #ibm #db2 #synapse #vertica #greenplum #vmware #sqlserver #netezza #bigquery #databricks #netezza