Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles

Hybrid Histograms in Oracle 12c 09/26/2016

The right statistics and histograms can provide improved performance for queries and reports.  Read on to find out about Oracle’s new Hybrid histogram.

Real-time Operational Analytics in SQL Server 2016 - Part 2 09/19/2016

Arshad Ali discusses the different design considerations for leveraging the Real-time Operational Analytics feature of SQL Server 2016, covering the different scenarios where it fits or does not fit, and how to get started with it for disk based tables.

Automating Data Warehouse Support 09/15/2016

As budgets tighten, how can database administrators keep up with the rapidly-changing new technology environment? The solution: automation. In this article we discuss various ways to automate common processes and relieve the infrastructure staff from repetitive tasks, so that then can concentrate on more urgent priorities.

The Oracle Bug That Could Bite You Has No Teeth 09/12/2016

In a previous article Oracle declared bug 24390197 shouldn’t be; it’s the normal behavior for locally managed tablespaces with system-managed extents. Read on to see the details.

Selecting the Top N Results by Group in MySQL 09/08/2016

A common business requirement is to fetch the top N rows of each group, for example, largest cities for each country. Unfortunately many solutions utilize non-MySQL vendor-specific functions. Rob Gravelle covers a couple of approaches that will work with MySQL.

Azure SQL Database - Azure AD Authentication 09/06/2016

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, we will provide an overview of this functionality.

Database News

Microsoft's SQL Server Database Is Heading to Linux 03/08/2016

Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.

Oracle MySQL 5.7 Database Nears General Availability 10/19/2015

More Database News...

Recent Headlines
Hybrid Histograms in Oracle 12c 09/26
The Oracle Bug That Could Bite You Has No Teeth 09/12
This Oracle Bug Could Bite You 08/29
Real-time Operational Analytics in SQL Server 2016 - Part 2 09/19
Azure SQL Database - Azure AD Authentication 09/06
Managing SQL Server Backup and Restore History Information 09/01
MS Access
Automating Data Warehouse Support 09/15
DB2 Data Warehouse Capacity Planning 08/15
Is Your DB2 Subsystem Healthy? 07/18