Skip to main content
  • Log in

Menu principal

  • Quienes somos
  • Para Profesionales IT
  • Publicidad y servicios
  • Contact
  • twitter
  • linkedin
  • facebook

Dataprix main menu

  • Blogs
  • Software
  • News and resources
Home

Main tematic navigation

  • Business Intelligence
  • Data Science
  • ERP
  • Databases
  • Cloud
  • Security

Software destacado

SEMrush

SEMrushSEMrush is a web tool for SEO and SEM analysis, focused on the search for keywords (Keyword Research) and competitive analysis.
This web tool, pay per use, provides a user-friendly analysis using data giving access to organic positioning and pay…

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by Recommended by NetLine

Popular today

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…

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…

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…

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…

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…

db2look – Create DDL for table or full schema

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

Use SYSDUMMY1 in DB2 to obtain the actual server name

By using the auxiliar table sysdummy1 you can query information about a server with DB2 installed.

How to build a profitable on-demand app?

In this guide, we’ll touch upon the phenomenon of on-demand service apps, mentioning their most popular types and discussing why they have…

MySql: Slow queries, queries to optimize control

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

Breadcrumb

  1. Home

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