by Dianne Siebold – Debugging is an integral part of writing an application. Visual Studio .NET provides numerous enhancements to the debugger, including a unified debugging interface, Web service debugging, and cross-language debugging. One of the debugger’s most useful new features is the ability
Other News
Calculating Working Days Without Using a Function
by Mike Selvaggio – If you need to calculate working days between two dates and you can’t create the Oracle-recommended working days function, here is SQL that can accomplish the same task:
Slammer may not feed on Microsoft alone
By Robert Lemos – Other companies also make products containing the Microsoft database software that has been exploited by the worm. More than 30 products, from security scanners to backup servers, use the vulnerable Microsoft SQL Server 2000 and Microsoft SQL Desktop Edition (MDSE) 2000 software, a
Web Services Vendors See Need for Improvement
By Caron Carlson – Web services are gaining momentum in the enterprise, but the leading providers agree that the technology needs several improvements, including better security and greater standardization, to reach its potential.
Serving Business Graphics from a Web Service
In this previous article, you built a VB.NET chart server that used XML and XPath to serve up business graphics. This article explains how, with the help of a couple extra tools, you can extend the chart server to consume and display results specifically from a Web service.
Expressing mixed content in RELAX NG versus WXS
Many XML vocabularies use mixed content, and RELAX NG and W3C XML Schema offer varying expression for mixed content. This article compares the two approaches.
Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions
by Brad M. McGehee – Learn the basics of SQL Server disaster recovery from a leading industry expert in this exclusive interview.
SP3: To Install or Not to Install?
By Brian Moran – Microsoft released SQL Server 2000 Service Pack 3 (SP3) on January 17, raising the inevitable question, “To install or not to install?” Brian Moran is aggressive about applying service packs, find out why.
Table Functions and Cursor Expressions
Steven Feuerstein introduces cursor expressions and shows how they can be used with table functions in this article, cowritten with Bryn Llewellyn. Get all of your PL/SQL questions answered with Oracle PL/SQL Programming, 3rd Edition.
Truncate tables using PL/SQL
By Kevin Shidler – This tip truncates data from tables using PL/SQL for Oracle8i. It first disables all foreign key constraints that would cause the “ORA-02266: unique/primary keys in table referenced by enabled foreign keys” error, truncates the tables, and then re-enables all the foreign keys.