Many people have posed the question of how to generate sequential numbers for some report when the underlying data has no numbering system. The solutions have always been complicated derived or temporary tables and are difficult to implement. SQL Server 2005, however, brings us the ROW_NUMBER() function and author Michael Coles shows us how this can be used to easily add sequential numbering to your results.
By using Microsoft® SQL Server™ 2005 Integration Services (SSIS) to perform metrics calculations on data extracted from the Siebel Call Center database, the cross-IT (XIT) group in Microsoft Information Technology (Microsoft IT) was able to replace a former reporting application with a new scalable and flexible reporting application to improve reporting throughout the organization
Merge replication is probably not used as often as it could be, mainly because of the potential complexities of this tool. New author Satia Madimchetty brings us a great article that simplifies one part of this SQL Server feature, the conflict resolution issues.
SQL Server Integration Services (SSIS) is an enterprise-level data integration platform. SSIS is an entirely new subsystem in SQL Server 2005. This paper tells you how to take advantage of the SSIS management and deployment features.
Our very own Brian will be giving 2 2-day classes in 2 weeks in Jacksonille, FL. One will be on SSIS and another on SSAS.
There are lots of systems for developing software, but it often seems that DBAs don't adhere to any of them. New author Sudheer Palyam brings us a look at one that he has used in developing T-SQL applications, whereby the test scripts are written first.
This month we will begin creating reports using the SQL Server Business Intelligence Development Studio (BIDS).
The online world is full of content that is free, as in beer, but not free as in speech. Steve Jones talks about some guidelines for developing your own content.
One of the many new features that have been added to SQL Server 2005 is DDL triggers. We use DML triggers in SQL Server 7.0 and 2000, which executes a bunch of SQL statements or procedures whenever an INSERT, UPDATE or DELETE statement is executed and limited to a table or view object.
This article discusses:
* How SQL injection attacks work
* Testing for vulnerabilities
* Validating user input
* Using .NET features to prevent attacks
* Importance of handling exceptions
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Comments posted to this topic are about the item What is the PRODUCT
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers