Your newsletter subscriptions

Popular today

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…

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 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…

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

With SQL Server, when we forget or we lose the password of the DBA user 'sa', and we are the administrators of the database, we have a…

In MySQL, when you delete records from a table, space is reallocated automatically. It is as empty space and forming new attachments will…

In a Data Warehouse there are a number of common dimensions such as Geographic and Time. I leave here a script to create the Time…

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…

MySQL has some special features when making a connection from a remote client that if we do not know can complicate access to a MySQL…

Cloud computing is the new normal. Every time you are using a service or an application through an internet connection, you are using the…