by Bhagwan Mer – Description: I created these small snippets of dynamic PL/SQL programs for easy reference. I hope they are helpful.
Community
Log-File Growth and DBCC DBREINDEX
From SQLMag – I have a 30GB database, and I use the Full recovery model. Whenever I use Database Consistency Checker (DBCC) DBREINDEX to periodically reindex certain large tables, I change the recovery model to Bulk_Logged, then return it to Full after the reindexing is complete. I expected that thi
SQL Server & XML integration
By Jonathan Lurie & Timothy Stockstill – Microsoft was initially slow to develop an Internet product. I recently read a quote from a ranking Microsoft employee who said, “If you cut us, we bleed XML.” While this may seem a little dramatic, it happens to be true: XML seems to be everywhere in Microso
Guidelines for the Use of XML within IETF Protocols
There are a wide variety of Internet protocols being developed; many have need for a representation for structured data relevant to their application. There has been much interest in the use of XML as a representation method. This document describes basic XML concepts, analyzes various alternatives
Build an XML Based Scheduling Utility
by Manoj Sharma – Complex applications often consist of many individual tasks, each of which may depend upon the successful completion of other tasks. For example, you may want an application to execute only if a preceding series of steps occur without failure, in a specific sequence. Managing such
Comparing and Replacing Strings
by Bob DuCharme – In last month's column we looked at XSLT techniques for splitting up strings of text, for checking whether strings had certain substrings, and for normalizing white space out of an element. This month we'll learn more ways to gain control over strings in your source documen
Linux Gets Boost From Dell, Oracle
In yet another strong show of support for the Linux operating system, market leaders Oracle, Dell Computer and Red Hat Software combined strengths to make the software more reliable, higher performance and easier to buy. For the first time, Dell will resell licenses for Oracle’s 9i database a
QUALCOMM BREWs with Oracle
By Matthew A. Peretz – QUALCOMM Incorporated yesterday announced plans to work with Oracle Corporation to extend Oracle 9i Lite to support QUALCOMM’s Binary Runtime Environment for Wireless (BREW) platform, allowing companies to develop and deploy mobile enterprise applications for BREW-enabled devi
Programming Analysis Services
Sample chapter – Learn the basics of how to program Analysis Services using ADO MD from the book, Professional SQL Server 2000 Data Warehousing with Analysis Services from Wrox Press.
Transaction Log Monitor Tracks SQL Server Activity
Software introduced by Lumigent Technologies Inc. audits Microsoft SQL Server database activity by monitoring the product’s transaction log. The goal is to identify causes of database problems and recover lost data.