by Dare Obasanjo – W3C XML Schema is one to specify the structure of and constraints on XML documents. As usage of W3C XML Schema has grown, certain usage patterns have become common and this article, the first in a series, will tackle various aspects of the creation and usage of W3C XML Schema. Thi
Community
Book Review: Microsoft SQL Server 2000 Performance Tuning Technical Reference
This is a book for DBAs who want to delve deep into SQL Server 7.0/2000 performance tuning. Vyas takes a closer look at this SQL Server performance tuning guide from Microsoft Press.
OmniView Makes SQL Server Data Access Easy
by Brad M. McGehee – In the past, tools such as Microsoft Access, Microsoft Excel, and Crystal Reports have been used by end-users, but each of these have a fairly steep learning curve, and have their own limitations. Are there any tools that are easy enough for non-technical users to access SQL Ser
Moving ALL SQL Server 2000 Data Structures
This article expands on the following two Microsoft Knowledge Base Articles: INF: Moving SQL Server Databases to a New Location with Detach/Attach (Q224071) and INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files (Q240867). Whilst these articles focus on moving the actual databas
Edgar Online Pushes XBRL For Financial
By Eileen Colkin – Edgar Online Inc., the Internet-based company that provides electronic versions of Securities and Exchange Commission filings, is pushing hard for an XML-type standard for financial reporting. The eXtensible Business Reporting Language, XBRL, creates a standards-based method for c
OmniAudit 1.5 Offers Comprehensive SQL Server Database Auditing
by Brad M. McGehee – If you have been a DBA for any time at all, you know how “users” sometimes make claims that may not be all that “truthful.” For example, the user tells you, I changed a record yesterday, but today, it went back to its original value. As a DBA, you know that a record can’t myster
Buffer Overrun Vulnerability in SQL Server 2000
Mark Litchfield of Next Generation Security Software (NGSSoftware)discovered a vulnerability in SQL Server 2000 when used in conjunction with the Microsoft Jet 4.0 database engine that can lead to an attacker executing arbitrary code on the vulnerable system.
Database Wipeout Turns Into Unsolved Mystery
By Tuesday, Vince – ONE NIGHT last week, I was rushing to get home at a decent time when the head of our software support team slipped me a note suggesting that I look into an issue with data loss on one of our production database servers. I was tempted to just leave it until the next day, but I […]
Setting up Snapshot replication: step by step guide
By Alexander Chigrik – In this article, I want to tell you about some general Microsoft SQL Server replication’s topics: replication topologies, replication types, replication agents; and about Snapshot replication: how to check necessary conditions for this replication type, how to backup and resto
Tip for installing Oracle 8i on Solaris
By Mohsin Jamil Qureshi – Oracle 8i for Solaris is on two CDs. When you run universal installer, the first CD does not eject unless you close the installer. The following is a work-around for this problem.