How to import an Excel file into SQL Server 2005 using Integration Services

Integration Services, which replaces Data Transformation Services (DTS) in SQL Server 2005, is a tool for extracting, transforming, and loading data.

Data Comparison with Data Dude

In this article Dinesh Priyankara shows how Visual Studio Team Edition for Database Professionals can be used to perform data comparison.

Encryption

SQL Server Database Requirements

In our organization, I have noticed that database requirements are never included as a portion of the system requirements. The requirements always focus on the interface and we derive the database design from the interface as well as fill in some of the gaps.

Column-Store Databases and DW Appliances

With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.

Dynamic Search Conditions

ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.

Measures

Password Issues

SQL Server 2008 security and compliance features reduce security risks

Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.

Five steps to designing event handlers in SSIS

Construct event handlers in SQL Server Integration Services (SSIS) for executables. Get the flexibility of Control Flow and Data Flow tabs in Event Handler.