Dale Young

Oracle 11g Auditing: Who’s Hogging My Space?

Recently the Database Services team upgraded a client from Oracle 8i to 11g via the import/export method. A few months later, we found that the system tablespace was filling up, and that 70%+ of the space was used by the sys.aud$ table. Digging in, we discovered that when you create a new Oracle 11g database...
Read More

GUI Enhancements to SQL Server 2012: SQL Denali’s Page Level Restore

With the new release of SQL Server Denali just around the corner, there are several new features that will be included. This article is going to focus on the improved Graphical User Interface (GUI) enhancements for Page Level Restore. I am only trying to familiarize you with the new features that will be available with...
Read More

Oracle DBA: One Read-Only User Setup or User-by-User Setup?

I recently had an inquiry from one of our Database Services clients. They have an Oracle database, the entire data model is in a single schema with a single username. They have recently started adding additional reporting users and roles to their business, but that has not been reflected in the database yet. The developer...
Read More