by Kip Hampton – In a previous column, we covered the basics of the Simple API for XML (SAX) and the modules that implement that interface in Perl. Over the course of the next two months we will move beyond these basic topics to look at two slightly more advanced ones: creating drivers that generate
Other News
Server Pack 1 Installation Steps
By Michael Otey – It’s hard to believe, but it’s service pack time already. Service Pack 1 (SP1) for SQL Server 2000 installs like earlier service packs; however, in addition to the service pack for the database engine and SQL Server 2000 Analysis Services, SP1 includes a service pack component just
Embarcadero Technologies Expands Microsoft SQL Server Solution Offering to Include Log Analysis Tool
This relationship involves Embarcadero™ adding Lumigent’s Log Explorer™ product to its Microsoft® SQL Server™ database management product portfolio. Log Explorer makes direct use of the Microsoft SQL Server transaction log to help resolve elusive application or user problems, quickly and selectively
SQL Server 2000: New Features Provide Unmatched Ease of Use and Scalability to Admins and Users
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as we
Let's talk about X, baby – XML assessment
By Nick Langley – XML is promoted as the universal language for e-commerce, enabling business partners' IT systems to talk to one another by exchanging documents, which can be acted upon at the process level, rather than the data level. Currently, however, business partners need to work together
Being Too Generous
by Leigh Dodds – This week the XML-Deviant looks at some recent community criticism over the XML support in Internet Explorer, which has been resolved with some promising feedback from Microsoft.
Conferences postponed
The XML World 2001 San Francisco and the O'Reilly Peer to Peer & Web Services conferences, due to take place this month, have been postponed.
Storing Computations
By Itzik Ben-Gan – Using expressions in queries is a common practice. But did you know that you can base a column in a query’s resultset on a computation rather than simply using the query to return a base column from a table? If you use the same computation in many queries against the same table, s
SQL Server Fast Facts
Got two minutes? SQL Server 2000 can give you over one million transactions. SQL Server 2000 running on Microsoft Windows® 2000 achieved the highest performance ever for the TPC-C benchmark, with 688,220 transactions per minute, type “C” (tpmC) and price/performance of $28.89 per tpmC. SQL Server 20
Some Useful Undocumented SQL Server 6.5 DBCC Commands
by Alexander Chigrik – In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 6.5 for administering and monitoring. DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the p