Blazing Disk IO with Java

It’s well known that mmap helps to improve performance in particular use-cases (especially if your working set fits an available memory). This doesn’t mean that the file itself has to fit memory. mmaps provides real benefits over the other IO…

Read More >

Simple Steps to Perform oPatch Maintenance with Ansible

Like the Universe, IT growth seems to be infinite, we always have more environments, more servers, more users, more disk usage, more databases to manage and it won’t stop. In fact, we are pretty sure that this expansion is going…

Read More >

Log Buffer #509: A Carnival of the Vanities for DBAs

This log buffer edition covers Oracle, MySQL, and SQL Server.

Read More >

Grow and Innovate Your Business with Powerful Analytics with Cassandra and Spark (Part 1)

Organizations are tapping into increasingly sophisticated analytics techniques to improve opportunities for growth, innovation and competitive advantage. Organizations are increasing the sophistication of their analytics strategies to improve opportunities for growth, innovation and to take a competitive advantage. The analytics…

Read More >

Azure SQL Managed Instance: New Member of the Family!

SQL Server is one of Microsoft’s strongest enterprise software products. Both in terms of revenue and industry reputation, it is widely adopted for its ease of use while at the same time offering high end features in terms of security,…

Read More >

Error ORA-01033 After Doing a Switchover in a 12.1 RAC Environment

The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary, I kept getting the following error: SELECT dest_name,STATUS,error FROM gv$archive_dest_status WHERE dest_id=2;   DEST_NAME ——————————————————————————–…

Read More >

Datascape Podcast Episode 7 – Discussing Data Governance with Dennis Walker

In this episode we discuss the ins and outs of data governance with Dennis Walker. We’ll cover why it’s important, how it’s changed and how to get started.

Read More >

Hadoop as Part of Your Big Data Strategy

If you’re thinking about moving from a traditional relational database management system (RDBMS), you should consider Apache™ Hadoop®—because your competitors probably are. According to Gartner, Hadoop joined the mainstream in 2016. And Allied Research says the Hadoop market will likely…

Read More >

Using Transportable Tablespaces with Partitioned Tables

Overview In this post I will explain how to transfer a partitioned table using transportable tablespaces on MySQL 5.6. Note that the operation is not officially supported until MySQL 5.7, as the discard tablespace operation will fail if it is…

Read More >

Bushy Join Trees in Oracle 12.2

There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post. First, I’ll create four tables with two indexes: CREATE TABLE t1 AS SELECT rownum n1,…

Read More >
Page 1 of 29112345...10...Last Page »