By Jay Lyman – Both Oracle and Borland are introducing versions of their software that will allow them to be significant players in the next big revenue-producing segment: Web services.Oracle’s new Oracle 9i Developer Suite includes a new JDeveloper Java development application for building
Author: SSWUG Research
Transforming XML with XSLT and ASP.NET
Sample chapter from XML for ASP.NET Developers by Dan Wahlin – What exactly is XSLT useful for and why would you, as an ASP.NET developer, want to learn about it? The answer boils down to the capability of XSLT to transform XML documents into different formats that can be consumed by a variety of de
Tip: Outputting HTML from an XSL style sheet
By Nicholas Chase – Because HTML is so similar to XML, it should be fairly straightforward to create an XSLT style sheet that outputs HTML. Unfortunately, the differences between HTML and XML that do exist can cause pages to be displayed incorrectly in older browsers. This tip discusses those differ
Take the Sting Out of SAX: Generate SAX Parsers with XML Schemas
By Leon Messerschmidt – Although SAX (the Simple API for XML) parsers are handy tools for parsing XML content, developing and maintaining a SAX parser can prove difficult. In this article, Leon Messerschmidt shows you how to use the information contained in XML Schemas to generate source code for a
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
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.
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
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
Microsoft to revamp portal software
By Wylie Wong – The software kingpin is updating its SharePoint Portal Server software to support the company’s overarching .Net strategy to move computing to the Web. The updated software, slated for availability in the middle of next year, will allow nontechnical employees to build corporate porta
Auto-Audit 2.0 General Info
Auto-Audit proves a comprehensive, enterprise level tool for auditing Micrsoft SQL Server Databases unmatched on the market today. The tool is both configurable and scriptable and ships with the power of Microsoft VBScript and JScript parser. Whether you are relatively new to SQL Server and just n