(Marcin Policht) In the first article of this short series covering new and improved utilities of SQL Server 2005 Beta 2, we presented the SQL Server Management Studio, which provides a single, uniform interface for the majority of administration and programming tasks. We also discussed SQL Profiler

(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

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

(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

(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

(Allen G. Traylor) Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically design

(Ciprian Jichici) This article describes the CLR integration into the SQL Server 2005 Database Engine in detail and provides some background for answering two integration-related questions.

(Itzik Ben-Gan) A tiebreaker is a rule used to determine precedence between candidates when there’s a tie. For example, when soccer teams have the same number of points in the league, the one with the higher goal difference takes precedence. A tiebreaker in T-SQL is a rule that determines which

(Robert L. Bogue) You can’t teach an old dog new tricks—at least that’s what the cliché says. Many developers intentionally try to be the “old dog” so they don’t have to learn new tricks. Some developers, even those who have been developing client server, Web-based, and smart client applications

(Serdar Yegulalp) Data source drivers, such as Microsoft’s Open Database Connectivity (ODBC) drivers, sit between one’s programming language and a data source and provide a common way to connect to a data source and query it. Most programmers who use SQL Server to drive Web applications are familiar