create | Dataprix

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

The operator to concatenate in SQL Server is '+', but this operator is also used to add values. Being the same operator for both, the…

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

Have you ever wondered how to disable the autocommit option in Sql Server Management Studio? The answer is quick. Simply uncheck the option…

In MySQL there is a parameter that enables logging of queries that take more than x seconds to execute calls Slow Queries. Basically what…

Dataiku is a platform that systemizes the use of data and AI, bringing people together to deliver amazing business results..

Slowly changing dimensions or SCD (Slowly Changing Dimensions) are dimensions in which their data tend to change over time, either…

In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the…

I tried to create a connection in SQL Developer with a remote SQL Server database.