A general rule of thumb for tuning database applications is "80 percent application, 20 percent database." This means that, on average, developers can tune 20 percent of performance problems by ...

We've got a new infrastructure manager, and he's big on monitoring (he's looking at getting a 42" plasma to display various monitoring systems)<BR><BR>We're looking for options on monitoring our SQL ...

SQL Server Integration Services (SSIS) is now officially supported in the latest SQL Server Management Studio (SSMS) 22 ...

This chapter provides reference information for using the PL/SQL packages provided with ConText to administer ConText servers and queues, as well as to obtain product information about ConText.

Yes, I can run a SQL 7 DTS package just fine from my development PC but when I create a intall package for the VB executable, it doesn't work on the client PC.<BR><BR ...

With the introduction of Oracle compatibility in MariaDB Server 10.3, it’s now possible to use Oracle PL/SQL and Oracle sequences in an open source database — making it easier for DBAs and developers ...

The PL/SQL package DBMS_RANDOM can generate random text and date values as well as numbers. Check out these code examples to learn how you can generate these values in your development work. Numbers, ...

Update: Microsoft released SQL Server 2019 CU8 with a fix for the reliability issue that impacted SQL Server 2019 CU7. Microsoft pulled the Cumulative Update package 7 (CU7) for SQL Server 2019 ...

Clearing the attribute buffer is not required to create a preference. The buffer is cleared automatically after each call to CTX_DDL.CREATE_PREFERENCE. CLEAR_ATTRIBUTE is used primarily for clearing ...

Database security vendor Sentrigo has released an open-source fuzz testing tool to help pinpoint security-related coding deficiencies in Oracle databases. The tool, called FuzzOr, runs on Oracle 8i ...