SQL Zone is brought to you in partnership with:
  • submit to reddit
Brian O' Neill10/22/14
1852 views
0 replies

Sqoop Oracle Example : Getting Started with Oracle -> HDFS Import/Extract

In this post, we'll get Sqoop (1.99.3) connected to an Oracle database, extracting records to HDFS.

Rajat Jaiswal10/22/14
654 views
0 replies

Find Last Statistics Updated Date Detail: Maintenance TIP #59

One of the pain points for any SQL engineer is “Performance”. There are various reasons due to which your SQL Server database is slow.

Lukas Eder10/21/14
2033 views
6 replies

Stop Claiming That You’re Using a Schemaless Database

One of MongoDB’s arguments when evangelising MongoDB is the fact that MongoDB is a “schemaless” database... But it doesn’t mean that there is no schema.

Peter Zaitsev10/20/14
3277 views
0 replies

MySQL Compression: Compressed and Uncompressed Data Size

MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.

Joydeep Das10/18/14
1124 views
0 replies

Understanding of Execution Plan - III - B [ The OPERATORS ]

IN my previous Article we focused on Cluster Index Scan and Clustered Index Seek operators. Continuing my Article series named Understanding of Execution Plan – part III, we are moving on with some other operators.

Joydeep Das10/17/14
1558 views
0 replies

Understanding of Execution Plan - III - A [ The OPERATORS ]

In this article we are mostly focusing on the Logical and Physical Operators and trying to understand each as it is very important to understand them before understanding the Execution Plan.

Peter Zaitsev10/16/14
1100 views
0 replies

MySQL Ring Replication: Why It Is a Bad Option

I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability.

Rajat Jaiswal10/16/14
2282 views
0 replies

Good to Know SQL JARGON - An interview TIP #56

Hello friends, just wanted to share some technical words here again...

Sayem Ahmed10/15/14
6836 views
0 replies

JPA Tutorial: Mapping Entities – Part 3

When field access mode is used, JPA directly reads the state values from the fields of an entity using reflection.

Peter Zaitsev10/15/14
2442 views
0 replies

MySQL Replication: 'Got fatal error 1236' Causes and Cures

MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue data synchronization.

Kathiravelu Pra...10/15/14
972 views
1 replies

Fault-Tolerant Data Replication and Synchronization with Infinispan

Having multiple instances running over different nodes provide fault-tolerance, as when one node terminates, the other nodes have the backup replica of the partitions stored in the terminated node.

Peter Zaitsev10/13/14
2685 views
0 replies

Percona XtraBackup 2.2.5 Now Available (Free MySQL Hot Backup Software)

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime.

Anders Karlsson10/11/14
3757 views
0 replies

OraMySQL 1.0 Alpha Released - Replication from Oracle to MariaDB and MySQL!!

Now it's time to release something useful! At least I hope so. I have been going through how I came up with this idea and how I came up with the implementation in a series of blog posts, but now it's time for the real deal, the software itself.

G. Ryan Spain10/10/14
5278 views
1 replies

SQLite - Now 50% Faster!

SQLite developer Richard Hipp posted recently that the database has become 50% faster than it was 16 months ago.

Anders Karlsson10/10/14
1031 views
0 replies

Replication from Oracle to MariaDB the Simple Way - Part 4

Now it's time to get serious about replicating to MariaDB from Oracle, and we are real close now, right?

Anders Karlsson10/09/14
314 views
0 replies

Replication from Oracle to MariaDB the Simple Way - Part 3

In this third installment in this series, I'll explain why the smart solution I described in the previous post actually wasn't that good, and then I go on to explain how to fix it, and why that fix wasn't such a smart thing after all.

Anders Karlsson10/08/14
1321 views
1 replies

Replication from Oracle to MariaDB the Simple Way - Part 2

The theme for this series of posts is, and indicated in the previous post, "Try and try, again", and there will be more of this now when I start to make this work by playing with Oracle, with PL/SQL and with the restrictions of Oracle Express.

Peter Zaitsev10/07/14
880 views
0 replies

Percona Server, OpenStack and the Tesora DBaaS Platform

The Tesora platform is an enterprise-ready database as a service (DBaaS) platform based on the OpenStack Trove project. Percona Server was certified by Tesora in August as part of their Tesora DBaaS Platform certification program.

Mark Needham10/07/14
1177 views
0 replies

PostgreSQL: ERROR: Column Does Not Exist

A short article about the troubles that letter case can cause in PostgreSQL queries.

Anders Karlsson10/07/14
757 views
0 replies

Replication from Oracle to MariaDB the Simple Way - Part 1

Yes, there is a simple way to do this. Although it might not be so simple unless you know how to do it, so let me show you how this can be done. It's actually pretty cool.

Sayem Ahmed10/06/14
3963 views
2 replies

JPA Tutorial: Mapping Entities – Part 2

How should we override the default table names to match the existing data model?

Lukas Eder10/06/14
1929 views
1 replies

Using Your RDBMS for Messaging is Totally OK

Controversial database topics are a guaranteed success on reddit, because everyone has an opinion on those topics. More importantly, many people have a dogmatic opinion, which always triggers more debate than pragmatism.

Vlad Mihalcea10/05/14
2800 views
0 replies

Logical vs Physical Clock Optimistic Locking

This article will demonstrate why logical clocks are better suited for optimistic locking mechanisms.

Erik Ejlskov Jensen10/04/14
6021 views
0 replies

Comparison of SQL Server Compact, SQLite, SQL Server Express and LocalDB

Now that SQL Server 2014 and SQL Server Compact 4 has been released, some developers are curious about the differences between SQL Server Compact 4.0 and SQL Server Express 2014 (including LocalDB). I have updated the comparison table from the excellent discussion of the differences between Compact 3.5 and Express 2005 here to reflect the changes in the newer versions of each product.