Where is my backup? by Kenneth Fisher

http://www.sqlservercentral.com/blogs/sqlstudies/2012/12/12/where-is-my-backup/

by Kenneth Fisher









SELECT bs.machine_name,bs.database_name,bs.type, bs.name, bs.is_damaged,bs.user_name,
bf.physical_device_name, bs.backup_start_date, datediff(second,bs.backup_start_date,bs.backup_finish_date) as SecondsSpent,
bf.device_type
FROM msdb.dbo.backupset bs
JOIN msdb.dbo.backupmediafamily bf
ON bs.media_set_id = bf.media_set_id
WHERE bs.type = 'D' --and DATEDIFF(day,bs.backup_start_date, GETDATE()) <=1
ORDER BY bs.database_name, bs.backup_finish_date

Report Builder 3.0: Adding Matrices to Your Reports by Robert Sheldon

http://www.simple-talk.com/sql/reporting-services/report-builder-3.0-adding-matrices-to-your-reports/

 by Robert Sheldon

It is easy to create a basic matrix in Report Builder. However, it takes some practice in order to format  and dispay the matrix exactly how you want it. There are a large number of options available to enhance the matrix and Robert provides enough information to get you the point where you can experiment easily.

Stairway to SSRS series from MVP Jessica Moss

Source: http://www.sqlservercentral.com/stairway/72382/

Learn how to get started with Reporting Services in this easy to read series from MVP Jessica Moss that examines how you might start dealing with reporting requests from management.

SSRS In a Flash - Level 1 in the Stairway to Reporting Services

Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.  Read more...

By Jessica M. Moss 2012/12/19 (first published: 2010/04/06) | Source: SQLServerCentral.com | Category: reporting services (ssrs)

Rating:     |   Discuss |   Briefcase | 19,851 reads

The Basics of SSRS - Level 2 in the Stairway to Reporting Services

In this part of our series on Reporting Services (SSRS), Jessica Moss examines the basics of the Report Builder and BIDS.  Read more...

By Jessica M. Moss 2010/08/26 | Source: SQLServerCentral.com | Category: reporting services (ssrs)

Rating:     |   Discuss |   Briefcase | 25,321 reads

Data Everywhere - Level 3 in the Stairway to Reporting Services

In this article, MVP Jessica Moss talks about data sources and how to connect them to your report. Learn how to add the reusable data sets and data sources for your reporting projects.  Read more...

By Jessica M. Moss 2013/01/18 (first published: 2011/02/22) | Source: SQLServerCentral.com | Category: reporting services (ssrs)

Rating:     |   Discuss |   Briefcase | 14,998 reads

Tablix Tutorial – Level 4 in the Stairway to Reporting Services

This article shows how to group information, adjust for dynamic column and row groups, and generally use the tablix in Reporting Services.  Read more...

By Jessica M. Moss 2013/02/08 (first published: 2011/04/13) | Source: SQLServerCentral.com | Category: stairway series

Rating:     |   Discuss |   Briefcase | 15,666 reads

Charting the Unknown – Level 5 in the Stairway to Reporting Services

This article will explain different types of visualizations, including charts and maps, and when you would use each type.  Read more...

By Jessica M. Moss 2011/06/07 | Source: SQLServerCentral.com | Category: stairway series

Rating:     |   Discuss |   Briefcase | 8,688 reads

Designing a Dashboard - Level 6 in the Stairway to Reporting Services

This article walks through a sample dashboard, highlighting sparklines, databars, and indicators.  Read more...

By Jessica M. Moss 2013/03/15 (first published: 2011/08/04) | Source: SQLServerCentral.com | Category: stairway series

Rating:     |   Discuss |   Briefcase | 13,242 reads

Extra, Extras - Level 7 in the Stairway to Reporting Services

This article highlights each of the additional items needed to create a clean but beautiful report. Using the simple items of headers and footers, textboxes, and other layout options will increase the readability and manageability of your reports.  Read more...

By Jessica M. Moss 2011/12/02 | Source: SQLServerCentral.com | Category: stairway series

Rating:     |   Discuss |   Briefcase | 6,062 reads

Report Customization - Level 8 in the Stairway to Reporting Services

This article discusses how to create custom functions, methods, and expressions so that you can make your data do things that Reporting Services won't!  Read more...

By Jessica M. Moss 2012/04/11 | Source: SQLServerCentral.com | Category: stairway series

Rating:     |   Discuss |   Briefcase | 8,031 reads

Management - Level 9 in the Stairway to Reporting Services

In the last article of the series, you will learn how to manage your reports once you've finished development, including how to use the Report Manager, deploy reports, and send reports to the appropriate end users.  Read more...

By Jessica M. Moss 2012/05/23 | Source: SQLServerCentral.com | Category: stairway series

Rating:     |   Discuss |   Briefcase | 5,567 reads