HOME

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 …

Steps to Migrate Oracle Database to Azure SQL Database

Many organizations are looking at the prospect of a technology migration, where …

Big Data Analytics on Current Data

IBM now provides an option to configure its Db2 version 12 for z/OS and complementary …

Oracle's ASCIISTR() and Unicode Characters

Although documented, the ASCIISTR() function may return 'interesting' results …

Displaying Leading and Trailing Whitespace on Varchar Columns in MySQL

It's fairly trivial to enclose varchar data within quotes using the CONCAT() function …

Introduction to Azure Cosmos DB Global Distribution

Global distribution of updatable data stores is one of the more challenging goals that …

Placing a Mark in SQL Server's Transaction Log for Fall Back

How many times have you had a programmer come to you and say they want you (the DBA) to …

Using SQL Server's Default Trace to Identify Autogrow Events in tempdb

We all know that you should try to size tempdb appropriately, so it doesn’t need …