by Uche Ogbuji – Fredrik Lundh, well known in Python circles as “the effbot”, has been an important contributor to Python and to PyXML. He has also developed a variety of useful tools, many of which involve Python and XML. One of these is elementtree, a collection of lightweight utilities for XML pr
Other News
INF: Troubleshooting Application Performance with SQL Server
Troubleshooting performance issues involves using a series of steps to isolate and determine the cause of an application slowdown. Possible causes include blocking, system resource contention, application design problems, or a particular set of queries or stored procedures with long execution times.
Using Java stored procedures: AOL instant messaging from Oracle
(Bradley D. Brown) Have you been wondering how you might use Java stored procedures instead of Oracle’s native PL/SQL stored procedures? This article discusses the pros and cons of Java stored procedures, guidelines on how to build them, the separation line for the database vs. App Server Java, perf
Determine How Deep FK Constraints
by Zlatko Sirotic – How do you determine how deep some foreign key constraints are? For example, EMP has a foreign key on DEPT, DEPT has a foreign key on DEPT_TYPE … With following solution, you don’t need to use a temporary table to determine the depth of foreign keys:
Web Services Land in Yukon
By Darryl K. Taft – Web services will play a key role in Yukon, the next version of Microsoft Corp.’s SQL Server database, a company executive said. Giving a preview of the upcoming technology at the VSLive show here, David Campbell, product unit manager of the SQL Server Engine at Microsoft,
Formatting XML with the XmlTextWriter
This example demonstrates one way of formatting a string containing XML data using the XmlTextWriter. After loading the XML string into a DOM structure, the WriteTo() method of the XmlDocument is called to run the XML through the writer which will indent the different nodes appropriately.
HTML to Formatting Objects (FO) conversion guide
By Doug Tidwell – Need help converting HTML documents to PDF? This reference guide shows by example how to use XSLT templates to convert 45 commonly used HTML elements to formatting objects (from the XSL-FO vocabulary) for easy transformation to PDF using XSLT. The examples assume that you’re using
Introduction to CCXML
By Hitesh Seth – When building interactive voice recognition applications, we are inevitably faced with the challenge of providing advanced telephony call-control capabilities. In some scenarios we’d like to bridge two calls for a conferencing application, in others we’d like to provide basic call r
Implementing full text search with T-SQL stored procedures
By Eli Leiba – Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager. Nonetheless, it can be useful in certain situations. Here are the steps to implement FTS in T-SQL.
SQL Server DBAs Deserve an Apology
Brian Moran apologizes for oversimplifying the the problem of the SQL Slammer Worm and a DBA’s responsibility to their system’s security.