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.

SQL 2005 Reporting Services Part 2

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

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

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

A case for canned SQL

Should you use dynamic or static SQL in your SQL Server application? This is a hotly debated topic and Arthur Fuller brings his thoughts to this debate.

Survival tips for PowerPoint

there are occasions in all of our working lives when sitting through a PowerPoint presentation is inevitable. Fortunately, there are techniques for feigning interest, many of which have developed over hundreds of years. All you need is a handful of like-minded colleagues with a sporting attitude

Implementing Row- and Cell-Level Security in Classified Databases Usin

This paper describes how SQL Server 2005 can be used to support row- and cell-level security (RLS/CLS). The examples provided in this white paper show how RLS and CLS can be used to meet classified database security requirements.

Implementing Smart Reports with the Microsoft Business Intelligence Pl

This article presents an excerpt from the book, Applied Microsoft Analysis Services, by Teo Lachev. Learn how to author “smart” reports using Reporting Services (SSRS), Analysis Services (SSAS), and SQL Server CLR stored procedures. Get the reports demonstrated in this article by downloading the sample code.