Using the Distributed System Designers to Visually Design and Validate

he purpose this lab is to illustrate the benefits of the Distributed System Designers available in Whidbey to application architects, operations teams, and developers. These designers help application architects and developers construct service-oriented applications and prepare them for deployment in a target datacenter modeled by operations.

Embedding SQL Server Express into Custom Applications

This white paper discusses how to integrate and deploy Microsoft SQL Server Express-based applications by using configuration files and the ClickOnce deployment technology in Microsoft Visual Studio.

An Introduction to SQL Server 2005 Integration Services

This paper discusses the challenges that face businesses that rely on data integration technologies to provide meaningful, reliable information to maintain a competitive advantage in today’s business world. It discusses how SQL Server 2005 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are included.

Using SQL Server 2005 Integration Services in a Scalable Business Inte

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

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