Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.
In SQL Server 2008, we have a new way of enforcing rules on our servers. This video has MVP Brian Knight showing us how to create a basic policy in Policy Based Management.
Maintaining your database server is something every DBA or developer needs to do. This video shows how to setup a basic maintenance plan.
This SQL School video will show you how to use Management Studio to restore a database in SQL Server 2005.
In this SQL School video, MVP Brian Knight dives into the Execute SQL task in Integration Services. You will learn how to add parameters to this task to customize its behavior.