Blog : What's On Our Mind?

Sharing Our Point of View

Automation of database processes and the shift to the cloud has changed the “traditional” role of DBAs. How can they remain relevant?

Read More

Don’t be fooled by the term “self-service BI” — you still need some support and solid infrastructure to make it work.

Read More

Temporal tables, also known as system-versioned tables, are used for time trend analysis, audit, slowly changing dimensions, and repairing record-level corruptions.

Read More

Both DB2 for z/OS and DB2 for LUW support the INTERSECT and EXCEPT operations in SQL SELECT statements. They both are similar to UNION in the way in which they work and are coded. But there a differences.

Read More

This post will show how to do a Point in Time Restore of one pluggable database in a container with multiple pluggable databases.

Read More

Data visualization has gained popularity within business intelligence and analytics as a visual tool to help understand data instead of the usual static reporting.

Read More

This blog post will is to show a table restore for one table in a container database

Read More

Upgrade your database from SQL2000 to SQL2014 with a 2-hop migration plan, steps outlined here to reduce outages.

Read More

These days, we need to convey complex insights, trends and data-based analyses quickly. Data visualization tools can help present and analyze data.

Read More

Sometimes an application can require different, perhaps even somewhat “odd” data sorting. Often you can conjure up an answer by properly understanding the problem and applying some creative SQL.

Read More