Featured Database Articles
In previous articles, we’ve described the main characteristics of two new features known as Virtual Network service endpoints and Azure SQL Database virtual network rules. In this article, we focus on the details of implementing this functionality.
Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages. Read on to learn more...
There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance. Read on to learn how.
It may be necessary to monitor the usage and storage of the TEMP tablespace. Read on to see how to implement a monitoring strategy that makes sense.
Upgrades to the newest Oracle release can create problems depending upon the database configuration. Read on to see what types of issues can arise and how to address them.
If in-memory isn't available to you there may be another option: automatic big table caching. Read on to see how to configure this feature and what it can do for you.
Version 12 of IBM's Db2 for z/OS (Db2 12 for z/OS) contains many new features and functions for DBAs and application developers. This latest Db2 version emphasizes performance enhancements across a wide variety of areas, including enhanced on-line transaction performance, improved efficiency for analytical query access paths, removal of some size limitations and exploitation of operating system and storage hardware characteristics.
Is DBaaS a possible strategic direction for your company’s IT infrastructure? In order to determine this, there are several issues you must address. This article lists the most common risks that require mitigation before embarking upon delegating all or most of your database storage and management to an outside firm.
Application and database definitions are now spread among multiple firms across multiple platforms. Business rules are implemented in (potentially) many places, and many support staff skills are not under your control. This raises the complexity of the application and increases the risks of failure during application changes, maintenance or upgrades. This article addresses how to measure and maintain the quality of your application when you take advantage of database as a service (DBaaS).