Database Journal – Daily Database Management & Administration News and Tutorials

How Big is Your Transaction Log?

10/01/2018

If you are not managing the transaction log space used by a database, the transaction …

SQL Server 2019 is Here

10/01/2018

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first …

Tuning Oracle Queries with an Optimizer Trace

09/24/2018

Sometimes the obvious isn't when it comes to query performance; that's when event 10053 …

Modern Data Warehouse Design Pattern – Part II

09/20/2018

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

Db2 Application Performance Enhancements

09/17/2018

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

Oracle's LOCAL_TEMP_TABLESPACE

09/13/2018

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

Exploring Oracle's MySQL Cloud Service

09/10/2018

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

Azure SQL Database High Availability

09/06/2018

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

Displaying and Removing Unprintable Hexadecimal Characters from SQL Server Data

09/04/2018

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

08/27/2018

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

Modern Data Warehouse Design Pattern – Part I

08/20/2018

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

High-Performance Data Encryption and Db2

08/16/2018

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

Oracle's Transparent Data Encryption

08/13/2018

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

The Best (and Worst) Cloud Services for MySQL

08/09/2018

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

Azure SQL Database Business Continuity Enhancements

08/06/2018

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

HOME