Lmst

Have you seen the syntax of INNER JOIN? Of course! What about NATURAL INNER JOIN?

https://coffingdw.com/new-to-sql-is-the-keyword-natural-join/

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

https://coffingdw.com/date-functions-date-formats-and-timestamp-formats-for-all-databases-45-blogs-in-one/

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

My comprehensive study compiled a staggering 35,000 date format examples across the top 15 databases.

https://coffingdw.com/35000-date-format-examples-across-the-top-15-databases/

#snowflake #databricks #oracle #ibm #db2 #bigquery #teradata #redshift #postgres #yellowbrick #mysql #synapse #vertica #greenplum #sqlserver #netezza

Little #SQLServer Tricks: Fix a Database Stuck in Restoring Mode

https://improveandrepeat.com/2025/07/little-sql-server-tricks-fix-a-database-stuck-in-restoring-mode/

If someone told me I could be an expert in Ordered Analytics and Windows functions in 20 minutes, I would pinch myself because I would have to be dreaming.

https://coffingdw.com/learn-ordered-analytics-in-20-minutes/

#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

Technology & Friends - Jerry Nixon on SQL Server Extension for VS Code with host David Giard. buff.ly/4wxHVS4 #vscode #podcast #devcommunity #sqlserver #database #azuresql

Jerry Nixon on SQL Server Exte...

Technology & Friends - Jerry Nixon on SQL Server Extension for VS Code with host David Giard.

https://davidgiard.com/jerry-nixon-on-sql-server-extension-for-vs-code

#vscode #podcast #devcommunity #sqlserver #database #azuresql

Here are all the analytic and window functions for every database platform.

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

What makes me a special teacher is that I teach two types of classes on opposite extremes. I can teach your marketing and salespeople how to give world-class presentations, and I will teach every person on your IT staff all aspects of every database system and how to write and tune the SQL.

https://coffingdw.com/on-site-and-virtual-cloud-training-and-sql/

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

You will never forget the first time you saw a 30-table join spanning 30 systems in a single query.

https://coffingdw.com/30-table-join-across-30-different-systems-shocks-the-it-world/

#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 your business users want to raise the bar, then federated queries are the quickest way to business gold. Nexus is the best federated query tool in the world.

#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