Managing and Deploying SQL Server Integration Services

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.

New SSIS and SSAS Class

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.

An Introduction to Test Driven Development

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.

SQL 2005 Reporting Services Part 2

This month we will begin creating reports using the SQL Server Business Intelligence Development Studio (BIDS).

Free As In Speech

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.

SQL Server 2005 - Data Definition Language Triggers

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.

Stop SQL Injection Attacks Before They Stop You

This article discusses:

* How SQL injection attacks work
* Testing for vulnerabilities
* Validating user input
* Using .NET features to prevent attacks
* Importance of handling exceptions

Deduping Data in SQL Server 2005

One of the neatest T-SQL enhancements in SQL Server 2005 is the ROW_NUMBER() function. New author Charles Hawkins brings us an explanation of how you can use this function along with a Common Table Expression to remove duplicate data.

The Myth of Bandwidth and Application Performance

This whitepaper is intended to shed light on the issues affecting application performance in the wide area, and to give IT managers the knowledge required to design strategic enterprise application acceleration and deployment solutions

Practical Uses of PatIndex

String manipulation is not one of the strong points of T-SQL, but there are some functions that can greatly assist you with searching and working with character values. New author Robert Davis brings us a look at PATINDEX, one of the search functions and also explains the differences between it and the often used CHARINDEX.