Database Journal – Daily Database Management & Administration News and Tutorials

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 …

Overview of Azure SQL Database Information Protection

11/01/2018

Information protection becomes one of the dominant factors that drive modern database …

Oracle OEM Agent 13c and Perl

10/25/2018

Perl can sometimes 'misbehave' with the Oracle Enterprise Manager (OEM) agent for …

SQL Server on Amazon Web Services (AWS)

10/22/2018

Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two …

IBM Offers AI-Assisted SQL Tuning

10/18/2018

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

Oracle Network Encryption

10/15/2018

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

Managing Users and Roles in Oracle's MySQL Cloud

10/11/2018

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

Installing SQL Server 2019 CTP 2.0

10/08/2018

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

Overview of In-Memory Technologies of Azure SQL Database

10/04/2018

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

How Big is Your Transaction Log?

10/01/2018

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

HOME