New in SQL Server 2005, Synonyms replace aliases from previous versions. Brian Knight shows how they can be created and used.
Runtime: 1:52 minutes
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
Reporting Services makes it easy to get data from a variety of sources, including Analysis Services cubes. In this SQL School video, Brian Knight shows how to use an SSAS cube as the dataa source for your reporting needs.
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.