Database Journal – Daily Database Management & Administration News and Tutorials

IBM Db2 Query Optimization Using AI

02/18/2019

IBM’s machine learning is being used to improve the performance of analytical …

Oracle's Interesting Treatment of IN-LISTS

02/13/2019

Whether it's a bug or by design Oracle's 1000-element in-list restriction isn't always …

New Truncation Error Message in SQL Server 2019

02/07/2019

A new error message in SQL Server 2019 will make your life much easier!? Learn …

Getting Approximate Count in Microsoft SQL Server

02/04/2019

Sometimes performance is more important than exact accuracy. Learn how to get an …

Top 10 Databases for 2019

01/31/2019

A look at ten top databases fighting for mind-share in 2019.

Is UNION The Best Choice When Joining Result Sets?

01/29/2019

Generate Dynamic MySQL Multi-row INSERT Statements

01/21/2019

Discover how to generate a multiple-row insert statement dynamically using the …

Handling Disaster Recovery When Using Oracle Managed Files

01/16/2019

HTAP - Hybrid Transaction and Analytical Processing

01/10/2019

The IT enterprise has grown, databases are bigger, companies have more product lines, …

Overview of Azure SQL Database Performance Monitoring

01/08/2019

Transitioning to the Platform-as-a-Service model typically implies relinquishing …

Customizing the Default Azure Data Studio Dashboards

01/03/2019

Explore the Azure Data Studio dashboards and see how to customize one of these …

Choosing Between Oracle's Bitmap and Function-based Indexes

12/26/2018

Oracle provides two ways to create an index that can reliably be used with nulls; a …

Optimize MySQL Inserts Using Batch Processing

12/20/2018

It's become a challenge to whittle down the speed of database transactions to the …

Big Data: Health Checking Your System

12/18/2018

As big data solutions grow in size and complexity, concerns can rise about future …

Improvements in Oracle's Join Elimination

12/13/2018

HOME