HOME

IBM Offers AI-Assisted SQL Tuning

A new separately-priced software offering from IBM on z/OS systems uses machine …

Oracle Network Encryption

Oracle provides a method of encrypting networked database connections, with a few …

Managing Users and Roles in Oracle's MySQL Cloud

Rob Gravelle shows you how to create and manage user accounts in Oracle's MySQL Cloud …

Installing SQL Server 2019 CTP 2.0

Greg Larsen offers detailed instructions on how to install SQL Server 2019 CTP 2.0.

Overview of In-Memory Technologies of Azure SQL Database

Azure SQL Database offers a straightforward approach to controlling its performance …

How Big is Your Transaction Log?

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

SQL Server 2019 is Here

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

Tuning Oracle Queries with an Optimizer Trace

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

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 …