(Srinivas Sampath) Aggregates have always been part of SQL Server. For example, each one of us would have used functions like SUM, AVG, COUNT etc. These functions iterate over a set of rows (called a group) and then provide the output for each group.

(Kathrine Lord) New to .NET programming or Reporting Services? Get step-by-step instruction on creating a .NET application to create and publish reports using the Reporting Services API.

(Romanth Nirmal) In this 11,000+ word article, you will learn about the basics of how to cluster SQL Server. To make it easier for you to read, it has been divided into 6 sections.

(Itzik Ben-Gan) When you write applications that return query results to the client and display the results on the screen, you need to take into account the end user’s screen-size limitations. If a query’s result set contains too many rows to fit on the screen, you have to introduce logic into t

(Anthony Bressi) If you are working in an Active-Passive clustered SQL Server environment there are often times when you need to initiate a failover so that you can perform routine maintenance tasks on the Passive server – to apply service packs, install software, etc. In this article I outline a qu

(Lisa Vaas) Microsoft Corp. released its second Community Technology Preview of SQL Server 2005 and rolled out a new, free tool to manage SQL Server 2000 and MSDE (Microsoft Desktop Engine) 2000.

(Bruce Johnson) One of the problems that we recently faced was the need to post a message to MSMQ when the data in a SQL table was changed. An extensive search of the various resources that we have led us to this solution. And, although it seems to be complicated, it appears to be the only way, at t

(Don Schlichting) Full Text Searching is a free, optional component of MS SQL 2000. When installed, it offers a vast array of additional string querying abilities. Full Text Searching allows for string comparisons similar to internet search engines, returning both results and a matching score or wei

(Leo Peysakhovich) One of the problems frequently faced by the DBAs or database developers is data comparison. Specifically, data residing in separate databases. The company I am working for has 2 types of databases: Access and SQL Server. Very often I need to compare data in different tables in dif

(Jamie Thomson) One of the age old problems in DTS is moving packages between your development, test and production environments. Typically a series of manual edits needs to be done to all the packages to make sure that all the connection objects are pointing to the correct physical servers. Thi