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 MySQL

Promoted Resources

Today's Top Picks for Our Readers:
Recommended by Recommended by NetLine

Popular today

Oracle to PostgreSQL Migration: Avoiding the Obstacles

When organizations look to migrate from Oracle to PostgreSQL database, they usually see the advanced features, high performance, flexible…

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…

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…

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…

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…

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…

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.

Breadcrumb

  1. Home
  2. MySQL

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