Author: SSWUG Research

Community

Privacy and XML, Part 2

by Paul Madsen, Carlisle Adams – There are a number of efforts currently underway in standards bodies and other organizations to address various aspects of privacy with XML-based technologies. This section gives an overview of this work, noting which of the privacy concepts discussed in the first pa

Community

Understanding DBCC SHOWCONTIG

by Dean Thompson – DBCC SHOWCONTIG is a wonderful tool which helps you to understand quite a bit more about your system than is obvious at first glance. And, frankly, the documentation doesn’t use terminology that makes it very obvious either. So, this article will focus on a few of the big ideas

Community

Accessing Data From SQL Server

By Subhagata Swarnakar – Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO).The ADO.NET components have been des

Community

Full Outer Joins in Oracle9i

by Sanjay Mishra – Among several new features, Oracle9i has introduced the ANSI standard join syntax. The new join syntax is not only SQL92 compliant, but it is elegant and makes the outer join syntax more intuitive. The biggest advantage of the new join syntax is its support for full outer joins, w