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.
Find more stories in: StorageSimplify queries with a Dates table
It can be advantageous to use a Dates table, especially when doing a lot of date calculations.
Find more stories in: Microsoft Server 2003Document SOX compliance with SQL Server 2005
Use the built-in tools in SQL Server 2005’s to create a "homegrown auditing system".
Find more stories in: StorageDiagnose 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.
Find more stories in: Microsoft Server 2003Build a file location on the fly
SQL Server 2005's recursion and XML features help you to easily build file locations.
Find more stories in: Database managementGenerate dynamic SQL statements in SQL Server
Learn to generate on the fly SQL statements, which can be used to solve tricky database problems.
Find more stories in: Database management, Databases, ServersWrite 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.
Find more stories in: Databases, Database managementBulk 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.
Find more stories in: Databases, StorageDevelop an SQL Server Job from scratch
The ability to automate administrative tasks is vital in almost any SQL Server database environment.
Find more stories in: DatabasesCorrect 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.
Find more stories in: Software, Data ManagementFind 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.
Find more stories in: Microsoft Server 2003Finding 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.
Find more stories in: DatabasesOracle 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.
Find more stories in: Sales/revenue, Cost controlCapture 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.
Find more stories in: Storage, Databases, Database managementDelete 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.
Find more stories in: Storage software, Database management, DatabasesBlogs 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.
Find more stories in: Databases, Database managementSometimes 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.
Find more stories in: Database management, DatabasesA 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.
Find more stories in: Databases, Database managementOracle 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.
Find more stories in: Servers, App serversSwitching 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.
Find more stories in: Databases, Database management
Play video
Test Drive Now!
» Powerful server blade for SMBs
