(K. S. Ganesh) SQL Server Reporting Services is a comprehensive, server-based platform for creating, managing, and delivering reports that contain data from relational and multidimensional data sources.

(Steve Jones) The short answer is “no”. And there isn’t really a long answer. So is this article over? Well, I suppose I should explain why this isn’t possible, so let’s begin by looking at other systems. (R)

Microsoft SQL Server and the Sybase relational database systems were developed together until their respective 4.2 versions. This commonality provides for a unique, low-cost opportunity for Sybase customers to migrate their databases to SQL Server and, therefore, to benefit from the new functionalit

With more concurrent users on the same system, you run the risk of being forced to wait for each other or reading inconsistent data due to in-progress changes. The trade-off between accuracy and throughput is critical; it can have a major impact on your SQL Server performance. Download Quest Soft

Aggregate functions perform a calculation on a set of values and return a single value. With the exception of COUNT, aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.

Traditionally, SQL Server database developers are accustomed to using SELECT for assigning values to variables. This was fine and a perfectly valid practice right until SQL Server 6.5. Microsoft released SQL Server 7.0 in 1999. SQL Server 7.0 introduced the new SET statement for initializing and ass

(Dinesh Priyankara) My article Optimize your application spoke about web-based application and this is the time to speak about windows-based application. Couple of questions had been arisen regarding first article and I hope that all your questions have been answered now. (R)

(Muthusamy Anantha Kumar) DTS is a set of graphical tools and programmable objects that let you extract, transform, and consolidate data from disparate sources into single or multiple destinations that can be bundled and saved as a package and executed. In large organizations, it is a usual practice

The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL Server data wherever you are. Using its built-in features, you can do the following from Internet Explorer or your favorite Web browser: –Create and edit databases in Microsoft SQL S

(Randy Dyess) It seems sometimes that every time you turn around you see a new article concerning SQL Injection. Recently when I was brushing up on my ASP to create www.Database-Security.Info, I found out why SQL Injection seems to be a reoccurring problem within ASP pages. Most of the basic example