(Tony Patton) Microsoft’s submission of the C# language and the CLR (Common Language Runtime) as industry standards has led to many open source projects based on the .NET platform. One such notable project is NUnit, a unit-testing framework for all .NET languages. I’ll demonstrate the simplicity
Other News
Unit Testing the Data Access Layer
(Tim Stall) Unit testing is becoming very popular among .NET projects, but unit testing the Data Access Layer (DAL) still remains a common obstacle. The problem stems from the very nature of databases: they are slow, common, persistent, external, and relational. This conflicts the nature of unit tes
Constructing or Traversing URIs?
(Joe Gregorio) Here is a quick review of where we ended in the last column. We answered all four questions about our resources and their representations. All of that work is summarized in the table below.
Step 1: Segregate your scan results
(Chip Andrews) First, sort your list of SQL Server instances by SQL Server product release (SQL Server 6.5, 7.0, 2000, etc.), then by service pack, and finally by build. Identify which instances do not have the latest service pack for the current product, and calculate how long it will take to insta
Why Oracle hashing is so cool
(Craig A. Shallahamer) Like politics, culture, and life’s adventures, searching algorithms can be diverse and fascinating. But what’s the best algorithm? (R)
Banking On IT
(Kim Moutsos) “The room we worked in was like a Western Union office. We’d get orders coming in from all over the place, and the machines would just be humming. It was like a telegraph room, except the messages were coming in from really exotic places like Kansas City, and for really exotic things l
FIX: You may receive a ‘SQL Server could not spawn process_loginread thread’ error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000
When you cancel a remote query that returns many data rows in Microsoft SQL Server 2000, a memory leak may occur. The size of the memory leak depends on the size and the type of data that is being retrieved from the remote server. You may receive an error message that is similar to one of the follow
The Bacula Philosophy
(Nathan Valentine) An often overlooked but essential ingredient of any smooth-running IT environment is reliable data backup and restore capabilities. Thankfully, the free software/open source community has provided several centralized over-the-network backup and restore solutions. Dan Langille cove
The Baker’s Dozen: 13 Productivity Tips for Database Development Using Transact-SQL
(Kevin S. Goff) Many application developers face the challenges of working with SQL Server 2000. These challenges include retrieving and grouping large amounts of data, building result sets, and tracking changes to data. All require professional strategies that hold water against a seemingly endless
Formatted emails from SQL Server
(Muthusamy Anantha Kumar) Collaboration Data Objects, also called CDO, is designed to simplify writing programs that create or manipulate Internet messages. CDO for Windows 2000 is an integral part of the Windows 2000 and higher series of operating systems. It is easy to send SMTP email from SQL Ser