HOME

Modern Data Warehouse Design Pattern – Part II

Join Anoop Kumar as he discusses two modern design patterns to handle Advanced …

Db2 Application Performance Enhancements

Db2 Version 12 includes many new and improved features specifically aimed at improving …

Oracle's LOCAL_TEMP_TABLESPACE

Oracle has provided a new setting, local_temp_tablespace, for RAC installations. …

Exploring Oracle's MySQL Cloud Service

Oracle MySQL Cloud Service is a MySQL database service that provides an enterprise …

Azure SQL Database High Availability

Site-wide or region-wide disasters, while undoubtedly more impactful, happen …

Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data

There are times when you might need to look at your SQL Server data in hexadecimal …

Oracle's ddl_lock_timeout in Version 12.2.0.1

With some ports of Oracle 12.2, attempting to set ddl_lock_timeout at the session level …

Modern Data Warehouse Design Pattern – Part I

The modern data warehouse design helps in building a hub for all types of data to …

High-Performance Data Encryption and Db2

IBM’s Db2 Version 12 for z/OS was designed to synergize with new IBM z14 …

Oracle's Transparent Data Encryption

Keeping data secure also means keeping it obscured should a breach occur.  Read on …

The Best (and Worst) Cloud Services for MySQL

Each and every day, new cloud-based database providers are cropping up to meet the …

Azure SQL Database Business Continuity Enhancements

Marcin Policht provides an overview of a number of new features that facilitate Azure …

How to Resize tempdb

When you are setting up a new SQL Server machine you need to determine how big you …

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of …

Oracle's 'cursor_sharing = force' May Not Behave as Expected

The cursor_sharing=force setting is designed to substitute system-generated bind …