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
Author: SSWUG Research
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
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
Writing SAX Drivers for Non-XML Data
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
An introduction to XML encryption and XML signature
By Murdoch Mactaggart – XML is a major enabler of what the Internet, and latterly Web services, require in order to continue growing and developing. Yet a lot of work remains to be done on security-related issues before the full capabilities of XML languages can be realised. At present, encrypting a
RDF test cases
The W3C has released an initial Working Draft of RDF Test Cases, providing a foundation for testing compliance to RDF and RDF Schema.
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
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
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
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.