In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.
Integration Services is an ETL programming environment that gives you a tremendous number of options. In this video, MVP Brian Knight shows how you can change your connections dynamically.
This video shows how you can use Management Studio to execute your Integration Services packages.
Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.
In this new SQL School video, MVP Brian Knight shows us how to get started with data mining and Reporting Services retrieving data from an Analysis Services cube.