By David Mertz – Most hitherto existing XML APIs have enforced well-formedness at a programmatic level, but hardly any can guarantee validity. This is a serious weakness in the whole field of XML processing. This installment discusses the author’s gnosis.xml.validity library for enforcing validity i
Author: SSWUG Research
Create and Manage SQL Server Stored Procedures using Transact-SQL
By Randy Dyess – Learn the basics of how to create and manage SQL Server stored procedures.
Avoid Database Deadlocks with Planning
By Andrew Georgopulos – In this 10-Minute Solution, I discuss the controls and settings that go into transaction management and describe how to debug deadlocks by integrating resources in a manner that balances concurrency and integrity.
Calif. Cancels Oracle Contract
By Matt Hicks – The state of California has ended its controversial enterprise licensing agreement with Oracle Corp. following months of legislative hearings and high-level resignations over a state audit report criticizing the deal.
Microsoft offers plug for ‘critical’ SQL Server holes
By Joris Evers – Microsoft warned of five vulnerabilities in its SQL Server 2000 database product, the most serious of which could allow an attacker to take over the server.
Copy Archive Logs
This script will copy archived redo logs to a secondary standby destination for an NT database.
Another German Yak … with a suprise
From SQLTeam – This Reader Challenge #3 solution is quite a bit different from the first solution I posted. And it’s chock full of “sqlicious” goodness. And a suprise at the end!
How to overwrite DTS package logs everytime the package executes?
This article provides the required code for a DTS ActiveX Script task, that overwrites the DTS package error files, and prevents them from growing huge!
Create and Manage SQL Server Stored Procedures using Transact-SQL
As we learn more about SQL Server and Transact-SQL it is easy to become overwhelmed with the amount of information out there. I can recall hundreds of times when I have said, “I know there is a (stored proc, DBCC command, SQL statement, ect) out there that does that, I just can’t remember its name.”
Database Link ‘Panic’ Backup Script
by Galina Petrenko – This script produces readable output (backup) for database links in the database. It can be used in the restore/recovery process. Note that passwords for database links are also spooled in a readable format.