Database Journal – Daily Database Management & Administration News and Tutorials

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

Introduction to Azure SQL Database Hyperscale

12/10/2018

Since its inception, Azure SQL Database offering …

New Preview of SQL Server Management Studio Available for Download

12/06/2018

On September 24th Microsoft released …

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now

12/03/2018

Microsoft announced the release or CTP 2.1 for SQL …

IBM Db2 Statistical Functions for Analytics

11/27/2018

Until recently, …

A GUI Might Not Be An Oracle DBA's Best Friend

11/20/2018

Oracle DBAs should know how Oracle behaves and should also be able to address issues …

Hybrid Histograms in Oracle 18

11/15/2018

iOracle version 12 introduced the hybrid histogram as a performance improvement. Learn …

A Guide to MySQL Prepared Statements and Parameterized Queries

11/05/2018

A prepared statement, or parameterized query, is used to execute the same statement …

HOME