Your newsletter subscriptions

Popular today

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…

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…

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…

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…

In a LinkedIn debate about how to update from a select with summarized registers in SQL Server, Sergio Romero has shared an interesting…

How to Repair Corrupt SQL Database with the help of Stellar Re

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

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…

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…

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