Featured Database Articles
Data imports represent some of the more commonly performed database management tasks. Learn about a number of traditional SQL Server data import techniques that you can leverage when importing data into Azure SQL Database.
Learn how to find the current identify column value in your Microsoft SQL Server tables.
Learn how to create default database compression for your SQL Server databases.
Does a single-column primary key need a histogram? That may not be as silly of a question as might appear. Read on to find out why.
Changes in the way Oracle sets the flag value for the UNDO tablespace in version 12.x make the output from DBA_TABLESPACE_USAGE_METRICS either incomplete (12.1) or missing (12.2). Read on for more information.
With Oracle's Automatic Memory Management the spfile is updated with some interesting settings. Read on to see what the settings are and what they do.
IBM has enhanced its Operations Analytics software on the IBM Z platform by leveraging IBM Watson Machine Learning (WML) for z/OS. WML is implemented as a service that interfaces with several varieties of data, creates and trains machine learning models, scores them and compares the models with live metrics. The operations analytics software then classifies and analyzes the results to detect and predict problems. Read on to learn more!
Your production database environment stores personally identifiable information in an encrypted form, limits access to these fields and masks them when displayed. However, some types of data encryption create potential performance problems as well as security issues. Your data may be at risk unless you mask it effectively.
IBM’s machine learning is being used to improve the performance of analytical queries as well as operational queries and their associated applications. This requires management attention, as you must verify that your business is prepared to consume these ML and AI conclusions. Learn more…