Voss Software Development announces ItemAction version 2.0! Now with Access DB and SQL Server support, even more options, and cleaner setup. Flexible and affordable task management with special features for bug-tracking, helpdesk, and timesheet. Full Visual Basic Source Code Available.
Other News
Counting Transactions per Hour using a Pivot Table
From SQLTeam – When you create a pivot table you rotate rows to columns. This produces a resultset that facilitates trend analysis. In the example shown in this article I show how to use a pivot table to display the number of transactions that occur per hour per day. Before we get to that, though, l
Installing Service Pack 1 for SQL Server 2000
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don’t let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide y
What Are XForms?
by Micah Dubinko – Think about how many times a day you use forms, electronic or otherwise. On the Web, forms have truly become commonplace for search engines, polls, surveys, electronic commerce, and even on-line applications. Nearly all user interaction on the Web is through forms of some sort. Th
Smart Tags: Dumb Technology?
With the introduction of smart tags in Microsoft Office XP, you can enhance hyperlinking by associating text with not only multiple resources but also information provided by custom applications as well. Or so they say.
Using Python modules xml2sql and dtd2sql
An earlier column explored the generation of XML documents from SQL queries. Now David Mertz shows that the reverse direction of translating an XML document and DTD back into an RDBMS storage format is equally possible, but with its own set of constraints and complications. The Python public-domain
XML for Microsoft SQL Server 2000 Web Release 2 (SQLXML 2.0) Beta 2
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of XML for SQL Server added Updategrams and Bulk load functionality as well as a host of other features to the SQL Server 2000 base.
Windows 2000 Performance Tools
By Curt Aubley – Whether you’re sleuthing server-performance problems, determining how to tune your system, or sizing a server for new applications, the first step is to learn how to leverage your OS’s native performance tools. As Windows NT 4.0 became more popular and IT professionals creatively us
Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
Cleaned-up RDF syntax in prospect
The RDF Core working group at the W3C has released the first Working Draft of Refactoring RDF/XML Syntax. The document describes the updates made to the formal grammar for the XML syntax for RDF after amendments and clarifications made by the working group. In particular, containers (Alt, Seq