XMLStream.exe demonstrates how to create an ActiveX Data Objects (ADO) client that uses an SQL XML query to extract an XML stream from a SQL Server 2000 server.

By Wayne Rash – When the team from Protegrity, Inc. called the ZDNet offices last week to tell us about its database content encryption software, Secure.Data, my initial reaction was, “Who needs it?” After all, your databases should be inaccessible to the outside world. If they’re inaccessible, why

By Mark Oldfield – One of the most under appreciated new features of SQL Server 2000 is the usage of functions. It is definitely worthwhile creating a “tool-kit” of commonly used functions to use in each new project. So next time you are hard-coding a common task, take a bit longer and write a funct

Microsoft execs confirmed that the Longhorn version of the Windows client and server–due several years from now–will use as its file system database technology slated for inclusion in the next version of SQL Server, code-named Yukon. The upcoming version of SQL Server will store documents, E-mail,

Book by Mary Chipman and Andy Baron – If you are faced with the task of moving your Access databases to SQL Server, or even if you not, but you want to get more performance and scalability out of Access, then the book Microsoft Access Developer’s Guide to SQL Server is for you.

By Jonathan Lurie and Timothy Stockstill – Rewriting applications because of database security gaps is costly and time consuming. One of the easiest ways to avoid rewrites is to make security a priority during the initial database design and to enforce security at each tier. We’ll discuss som

by taruna paaladugu – The command DBCC TRACESTATUS can be used to get the status information for trace flag(s) currently turned on. Here is the syntax:

By Michael Otey – Although it’s the birthplace of spam, the Internet has many redeeming qualities. Sometimes when you’re stumped by a SQL Server problem, you can use the Internet to find information and solutions. Not all advice is good advice, but the Web provides a way for you to post questions an

By Vyas Kondreddi – This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQ

In addition to testing a SQL Server configuration, it can be helpful to test a database’s settings. This article contains a stored procedure you can use to inspect a database and report whether any of its options differ from the default settings of a new SQL Server 2000 installation.