by Alexander Chigrik – You can never know too much about SQL Server trace flags. In this article, find out about those that are undocumented in SQL Server 2000.
Community
Staying Ahead in the Security Game
By Brian Moran – Find out about the latest SQL Server security patch, which you can download from Microsoft’s Web site, and learn how to sign up for Microsoft’s security bulletin service.
Spida spreads venom on MS SQL servers
By Robert Lemos – The new arch-enemy of Microsoft SQL Server has slammed many networks with bogus data–causing traffic to a server port to jump by a factor of 40 in some reported cases.
Manage archive redo log files
By Robert Dow – Here is a simple script that I use on AIX to manage archive redo log files. This will create a empty tar file, and loop through the available arch log files appending to the tar. Once complete, the tar is compressed.
Using Stored Procedures to manage SQL Security
Stored Procedures offer an opportunity to improve your database security. By denying read (SELECT) and write (INSERT, UPDATE, and DELETE) access to all database tables and providing only EXECUTE privileges to your stored procedures you can ensure that your data can be accessed in a much more contro
Battle of the Databases: Oracle Versus Sybase
By Tim McDonald – While Oracle’s relatively high cost appears to be no barrier to its popularity, Sybase seems to have found an unassailable, if small, market niche as well.The Oracle-Sybase rivalry may not be the hottest contest in the technology universe at the moment, but it certainly is
SQL worm taking off
By Robert Lemos – A new worm that targets Microsoft SQL Server software has inundated networks with thousands of scans for vulnerable database servers, system administrators said Tuesday.The worm, which started spreading Monday, has caused traffic to the server port–a channel for data–used
How to select DISTINCT items from XML via XSLT
By Qing-Hua Jiang – How to select DISTINCT items from XML via XSLT Like SQL query "SELECT DISTINCT year FROM projets" ? To use "preceding-sibling", like select="/publish/book[not(year = preceding-sibling::book/year)]<br><br>How to select DISTINCT items from XML via XSLT Like SQ
Is XML the next big thing?
By James A. Cooke – For the past two decades, EDI has served as the mainstay for business-to-business data communication. But many experts believe that an alternative method of computer-to-computer communication–the use of extensible markup language (XML)–has begun to make inroads. To gauge where
XML Europe 2002 Coverage
by Leigh Dodds – In his opening keynote at the XML Europe 2002 conference, Peter Pappamikail, head of the European Union (EU) Information Resource Management Group, gave some background on their activities within European government and the unique challenges which they face in defining a new informa