Audit data using SQL Server 2005's COLUMNS_UPDATED function
Take a look at two functions that can track the individual fields that have been modified--useful tools for data audit and debugging database code.
Physically destroy your hard disk for security
Designed to crush over 60 disks in an hour, the Hard Disk Crusher helps keep information confidential.
Tags: Storage
Simplify queries with a Dates table
It can be advantageous to use a Dates table, especially when doing a lot of date calculations.
Tags: Storage
Document SOX compliance with SQL Server 2005
Use the built-in tools in SQL Server 2005Â’s to create a "homegrown auditing system".
Tags: Storage
Diagnose performance issues via sp_lock
A common misconception among IT pros is that "locks are bad", and you must do everything possible to ensure database locking doesn't prevent processes from running.
Tags: Storage
Build a file location on the fly
SQL Server 2005's recursion and XML features help you to easily build file locations.
Tags: Storage
Generate dynamic SQL statements in SQL Server
Learn to generate on the fly SQL statements, which can be used to solve tricky database problems.
Tags: Storage
Write a common sorting algorithm
A sorting algorithm routine helps users to sort a set of data, typically stored in an array, a set or other data structure.
Tags: Storage
Bulk importing data into SQL Server
If you work with databases, at some point, youÂ’ll deal with inserting data into SQL Server from outside data files.
Tags: Storage
Develop an SQL Server Job from scratch
The ability to automate administrative tasks is vital in almost any SQL Server database environment.
Tags: Storage
Correct data casing in SQL Server
Whether data is entered into your SQL Server system from a Web site, internal applications, or through files, the presentation of the data is always a concern.
Tags: Storage
Find blocking processes using recursion in SQL Server 2005
When SQL Server 2005 algorithms find blocking incidents, they can stop one process so another can finish its work.
Tags: Storage
Finding dependencies in SQL Server 2005
Get tips on writing a procedure that will look up all the objects dependent upon other objects, and accidentally deleting objects that have dependencies will become a thing of the past.
Tags: Storage
Oracle posts strong second quarter earnings
Oracle reported fiscal second quarter net income of US$1.3 billion, or 25 cents a share, on revenue of US$5.3 billion, up 28 percent from a year ago.
Tags: Storage
Capture an Oracle 10g audit trail in XML format
Oracle 10g can be configured to write its audit logs to XML files in operating system directories. This tip shows the configuration changes that need to be made, as well as how to access the resulting XML files.
Tags: Storage
Delete rows during updates using Oracle 10g's MERGE statement
In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works.
Tags: Storage
Blogs Oracle developers should bookmark
A list of blogs useful for anyone learning about Oracle, and they're sometimes much more useful than Oracle's own documentation.
Tags: Storage
Sometimes a variables table is better than hard coding into a package
When writing PL/SQL packages, there are times where it's better to store a variable in a table instead of coding it into the package.
Tags: Storage
A surfeit of caches
A cache is useful in theory. By storing a temporary copy of some page or image, the servers can deliver it faster to the client computer.
Tags: Storage
Oracle president sets sights on virtualization
Oracle president Charles Phillips plays tour guide Monday for Oracle OpenWorld attendees, pointing out key areas to watch for in the coming year.
Tags: Storage
Switching Oracle Portal to a new database is easy
Rex Baldazo shares how easy it is to quickly move Oracle Portal to a new metadata database.
Tags: Storage
Play video
