Top Reporting Tools for MySQL in 2018

News Via RSS Feed Featured Database Articles Posted June 11, 2018 By Rob Gravelle Top Reporting Tools for MySQL in 2018 SeekTable SeekTable is an online ad-hoc reporting web tool that supports pivot tables and pivot charts. The company behind SeekTable.com is located...

Azure SQL Database and GDPR Compliance

In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. As recent revelations related to improper use of consumer data by...

Databases with MAXSIZE Set

Every DBA needs to appropriately manage database growth.  No DBA wants an application to fail because the database is out of space.  A database can run out of space a number of different ways.  One of those ways is to set the MAXSIZE of a database.  When the database...

Indexes That Have Not Been Used but Are Being Updated

We all know indexes are important for improving your query performance, but to store and maintain indexes SQL Server requires disk space and compute resources.  If you have indexes that are not being used, they are costing you valuable resources and causing your...

Moving from Oracle Solaris to x86

Oracle has decided that Solaris needs to retire, giving those who are running Oracle on Solaris roughly two years to move to another operating system. A possible choice involves commodity hardware (x86) and Linux. Since OEL is a ‘ready to use’ version of...

Adaptive Query Processing in SQL Server

Introduction Adaptive query processing is the latest, improved query processing feature introduced in the SQL Server database engine. This method is available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database.  Query performance is always a...