Using the Sort Transform - SQL School Video
This SQL School video shows just how you can sort the data in your SSIS packages.
2008-11-25
3,298 reads
Brian Knight
Using Script Component as a Transformation - SQL School Video
Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.
2008-11-20
4,064 reads
Creating a Basic Policy in SSMS - SQL School Video
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.
2008-11-18
2,764 reads
Using the File System Task - SQL School Video
In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.
2008-11-13
4,332 reads
Creating a Maintenance Plan in SSMS - SQL School Video
Maintaining your database server is something every DBA or developer needs to do. This video shows how to setup a basic maintenance plan.
2008-11-11
6,272 reads
Using Data Viewers - SQL School Video
Integration Services is a great system for performing ETL operations between databases. In this video we show how you can use Data Viewers to determine if you are correctly transforming data.
2008-11-06
2,067 reads
Using Break Points in SSIS - SQL School Video
MVP Brian Knight brings us a look at how you can easily debug your Integration Services packages.
2008-11-04
4,833 reads
SSIS Configuration Files - SQL School Video
This edition of SQL Server examines the various options available in Integration Services configuration files.
2008-10-30
5,305 reads
Restoring a Full Database in SSMS - SQL School Video
This SQL School video will show you how to use Management Studio to restore a database in SQL Server 2005.
2008-10-28
3,951 reads
Parameterizing an Execute SQL Task - SQL School Video
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.
2008-10-23
3,926 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers