Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
Please be aware that you'll need to have the Adobe Flash Player 9 Plug-in installed to watch this video.
Runtime: 5:03 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,272 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,447 reads
SQL School continues with our series on Reporting services, this time examining how tabular reports can be easily built.
2008-09-11
4,873 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
