HOME

A Guide to MySQL Prepared Statements and Parameterized Queries

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

Overview of Azure SQL Database Information Protection

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

Oracle OEM Agent 13c and Perl

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

SQL Server on Amazon Web Services (AWS)

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

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. …