The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
Please be aware that you'll need to have the Adobe Flash Player 9 Plug-in installed to watch this video.
Runtime: 3:42 minutes
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.
2008-10-14
5,368 reads
In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.
2008-10-02
5,275 reads
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.
2008-09-16
4,448 reads
SQL School continues with our series on Reporting services, this time examining how tabular reports can be easily built.
2008-09-11
4,874 reads
In this video, you will learn how to use Reporting Services to build a report that contains a matrix of data.
2008-09-09
5,120 reads
