Skip to main content
  • Log in
  • twitter
  • linkedin
  • facebook

Dataprix main menu

  • Blogs
  • Software
  • News and resources
Home

Main tematic navigation

  • Business Intelligence
  • Data Science
  • Cloud
  • Databases
  • Security
  • ERP
Subscribe to Last blog posts

Most viewed

How to do an update from a select with summarized registers in SQLServer

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…

Useful Oracle SQL queries and scripts

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…

Easily export data from Oracle to flat file

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…

Avoiding errors concatenating fields with numerical values in SQL Server

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

Tips for UPSERT or update using insert in SQL Server

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…

How to recover the password of the user sa on SQL Server

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…

How to connect from Oracle SQL Developer with a remote SQL Server

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

Improve MySQL performance by adjusting some parameters

MySQL, like most database managers, can easily modify the parameters that control memory sizes engaged in certain tasks, resource…

How to connect to a remote MySQL database

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…

Data Warehouse Security Best Practices

Data warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized…

The Time Dimension Structure and Loading script for SQLServer

  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…

How to disable autocommit option in SQL Server Management Studio

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

Slowly Changing Dimensions

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

Four questions to identify a developer with no knowledge of database

I leave here this link to a page where a small test posed to do in job interviews for database developers. Here this kind of test I do not…

db2look – Create DDL for table or full schema

Db2look is an utility to extract the definition of database objects.

How to use Openquery to make a join between a SSAS cube and a table from any other database

Imagine you need a report with data from an OLAP sales cube, and have to include data from a table of the relational data source, or from…

Defragment to optimize MySQL tables

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

Listagg: New Oracle 11.2 function to summarize and aggregate strings

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

Export data from a SQL Server table

To import and export data from SQL Server,  Microsoft provides the tool bpc, which operates by command line. Although it would be…

Popular Agile Testing Metrics and KPIs and How to Use Them

Agile test metrics and KPIs are measurements that enable Agile teams to assess how effective their software tests are and whether their…
Most viewed posts

Breadcrumb

  1. Home
  2. Últimas publicaciones en los blogs

Creative Commons License  This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.

Footer menu

  • Contact
Clear keys input element