SQL Server Magazine columnist Itzik Ben-Gan shows you a few tricks for set-based analysis of data relationships using the NOT EXISTS() predicate.

By Vyas Kondreddi – This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of thes

By Michael Otey – The way you use binary large objects (BLOBs) in ADO.NET is completely different from the way you use BLOBs in ADO. These examples will help you see how to incorporate BLOB data into your ADO.NET applications. (R, $)

(Jack D. Herrington) As we race towards better object technology, some people seem content to put relational database systems out to pasture—for no good reason.

In this article from SQL Server Magazine, William Vaughn describes some performance issues with managing connection pools and shows you how to manage your pools to prevent overflow.

By Gregory A. Larsen – This is the first of a series of articles discussing various aspects of T-SQL programming. Whether you are building a stored procedure or writing a small Query Analyzer script you will need to know the basics of T-SQL programming. This first article will discuss defining varia

Marie Huwe, general manager of Microsoft’s Developer Division, announced that Visual Studio Tools for the Microsoft Office System is now available. The Microsoft Office System lets developers create solutions that integrate information stored on different platforms and systems.

By Brian Moran – Creating commodity solutions for complex IT needs has been Microsoft’s key to success over the years and the company’s latest commodity solution, SQL Server 2000 Reporting Services, is sure to make a big splash in the data-management and reporting worlds.

The CLR Proc Container is free software that enhances the capabilities of SQL Server stored procedures by opening a door to the .NET world. Code written in any .NET language can be invoked from stored procedures, providing stored procedures all the functionality of the full .NET runtime. Named proce

Addresses SQL Server vulnerabilities and provides security solutions. Covers installation, administration, and programming–plus security issues such as authentication, encryption, intrusion detection, and more. Written for IT professionals administering or programming any SQL Server-based applicati