by Eric van der Vlist – For many participants, the most memorable event of XML 2002 will be Jean Paoli’s presentation of Office 11, which promises to deliver easier access to XML for hundreds of millions of workstations.
Author: SSWUG Research
Tip: Basics of bootstrapping with DOM, Part 2
By Brett McLaughlin – In this tip, you’ll learn about a better way to bootstrap in your DOM applications. This builds upon the previous tip, which examined the abilities that DOM natively provides for this task.
Automatic Numbering, Part Two
by Bob DuCharme – In last month’s column, we saw how XSLT’s xsl:number element lets you add numbers to your output for numbered lists or chapter and section headers. We looked at some of the attributes of this element that let you control its appearance — for example, how to output the numbers as R
The 10 Technologies that Will Help You Stay Employed
by A. Russell Jones – Keeping up with key technologies is the best thing you can do to give yourself an edge in the employment market now—and in the future. Are you at least semi-proficient with all 10 of the technologies on our list?
XML in the Raw?
by Kurt Cagle – Kurt Cagle says we shouldn’t become so fixated on hiding XML that it disappears. Read his commentary on the fight between the XML Brokers, the XML Linguists, and other groups on whether to “clothe” XML or keep it “naked.”
Oracle, SAP Goal: Speedy Analytics
Oracle Corp. and SAP AG are building software to analyze data within their enterprise applications, but some users say the new and enhanced tools will have to prove themselves more effective than existing business intelligence tools from third-party developers.
Range Comparison in DECODE
by T.R. Bharath Rajkumar – One common requirement when writing queries is to do a range comparison in DECODE. But DECODE allows only exact comparison. Range comparison can be achieved by making use of the function SIGN in DECODE.
Tablespace usage view
By Andrew Barringer – This view allows you to easily see the top 10% by Row Count, Space Used, etc. This is useful for answering the question “what’s taking up all the space in my database?” I wrote it when asked to find what table(s) were using all the space in a particular database.
Serious About Security
By Michael Otey – Even with Microsoft’s ramped-up security efforts, your systems are still only as secure as you make them. Here are some common-sense measures you can take to safeguard your SQL Server systems.
SQL Server 2000 Windows CE Edition 2.0 Query Processor Overview and Performance Tuning Approaches
Get an overview of Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) query processor, followed by some application and query performance tuning approaches.