(Greg Robidoux) Selecting the recovery model and backup options can be simple for your SQL Server implementation. The best scenario is to select the options that provide the most flexibility. The following are some guidelines that can be used for selecting the appropriate backup and recovery model a
Other News
Oracle: Cluster file systems ease DBAs lives
By Ellen O’Brien – Oracle says its Cluster File System (OCFS) can make database administration simpler by eliminating the need to manage and set up raw devices, a task Oracle developers say they know is dreaded by DBAs. A cluster file system, which allows a number of nodes in a cluster to concurrent
Tip: Using entity references
By Brett McLaughlin – XML is primarily a static language. However, by using entity references, you can perform a limited amount of dynamic substitution. This tip explains how to use entity references, and illustrates their usefulness.
Migrating Unstructured Data to XML
By Renee Boucher Ferguson – CambridgeDocs, which facilitates XML-based content integration, announced a new tool for migrating unstructured content from legacy sources.The xDoc Converter migrates unstructured data from the likes of Microsoft Word, HTML and Adobe PDF documents into any XML sc
Transforming XML Schemas
by Eric Gropp – As an example, this article describes an XSLT document which creates an XHTML form based on the WXS definition of a complex element. For brevity and clarity, the article omits several WXS and XHTML form aspects, including attribute definitions, keys, imported/included schemas, and qu
A Large Order of PL/SQL Please, Easy on the PL
From both a business and a data perspective, Alan Beaulieu illustrates how SQL alone can handle complex business logic that previously required the combination of PL/SQL. Alan is a coauthor of Mastering Oracle SQL.
Cracking the Code of Life
By Alan Joch – Sophisticated database and analytical systems bring new efficiencies to life scientists.
Using DTS and FTP to Push Files
From SQLTeam – This article comes to us from Bill Twomey. Bill writes “I had to automate a daily extract process. This job had to extract a set of records, and deliver them to a remote system. At first this seemed like an easy task, but the requirements of outgoing transfer, a new filename each day
True DBA Blooper #8: Cleaning up disk drive mess
By Ellen O’Brien – Experienced DBA Peter Gooley had to dig deep in his memory archives to come up with his favorite blunders, mistakes that make him laugh today, but were not so funny then. He shared his two blunders, one that started as a mystery and another that began with bored DBAs playing silly
Web Services Nirvana: Fast Track or Slow Boat?
By Ed Raymond – The trend toward Web services, which promise to provide dramatically easier integration between enterprise applications, has taken over the e-business spotlight recently. For instance, Siebel’s (Nasdaq: SEBL) Universal Application Network, featured in Siebel 7.5, relies in part on We