Database Management & Programming News, Articles & Tutorials for Database Administrators
Is Your Oracle Invisible Index REALLY Iinvisible? 07/25/2016
If you’re using invisible indexes, they may not be entirely ‘invisible’ to the optimizer. Read on to see why.
Getting started with Query Store feature in SQL Server 2016 – Part 3 07/21/2016
Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.
Is Your DB2 Subsystem Healthy? 07/18/2016
Lockwood Lyon presents simple SQL statements that the database administrator (DBA) can execute against the DB2 catalog to determine if your DB2 subsystem suffers from common maladies, and what the DBA can do to fix or mitigate potential problems.
Returning The Actual DOP When Using Oracle’s Auto Degree Of Parallelism 07/14/2016
Without having an execution plan it’s difficult to know the degree of parallelism Oracle has selected. Read on to see how that can be reported.
MySQL Tuning for Large Datasets 07/11/2016
While there is no silver bullet to keeping your MySQL database running briskly, there are a few performance tweaks that you can do to keep things chugging along when the data starts to pile up. In today’s article, we’ll take a look at a few of these.
Introduction to Azure SQL Database Temporal Tables 07/07/2016
As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.
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...