In this article, Alexander Chigrik describes general concepts concerning validating data for Transactional replication using SQL Server. He then provides a step-by-step guideillustrating the data validation process.
Author: SSWUG Research
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
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.
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
SQL Server backup and restore, part II: Best practices
(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
Granting Permissions on Database Objects
Q. Why do I have to give permissions on the underlying database objects when I’m using dynamic SQL statements? A. These permissions are required for security reasons. Consider the following simple stored procedure:
SQL Server Stored Procedures Optimization Tips
In his latest article, Alexander Chigrik offers twelve useful tips for ensuring that you’ve constructed your SQL Server stored procedures to perform in the most efficient manner possible.
Prolifics Unveils XMLink Universal Gateway
Prolifics® (a JYACC company), an international e-business solutions provider, announced the release of XMLink Universal Gateway(TM). XMLink Universal Gateway is designed to provide BEA Tuxedo(1) applications access to business services made available from IBM WebSphere(2) and IBM WebSphere MQ
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
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