Change Data Capture (CDC) *as a tool for Disaster
Download
Report
Transcript Change Data Capture (CDC) *as a tool for Disaster
Presented by: Wes Springob
Business Intelligence Developer, Agile Bay, Inc.
Customers & Partners
Wes Springob
Current Positions:
Business Intelligence Developer at Agile Bay
Member of SQL Pass Tampa
Blog:
[http://SQLWes.com]
Twitter:
[@SQLWes]
Linked-in: http://www.linkedin.com/in/SQLWes
Email:
nsert Picture
[email protected]
w w w . a g i l e b a y. c o m
Session Agenda
Brief overview of Reporting Services.
Demonstration, Building your first report.
Q&A
Terms and Acronyms
(SSRS) SQL Server Reporting Services: Microsoft’s
Reporting solution.
(BI) Business Intelligence: Reporting and Analysis of
business data.
(.rdl) RDL: Report Definition Language (XML), or a
Reporting Services report definition file.
More than just reports
SQL Server Reporting SERVICES
Provides a presentation method for sharing reporting and analysis
throughout an organization and to the public.
Provides administration tools to manage versions, branding, security
and distribution of reports.
Provides tools for developers to create reports.
SQL Server Reporting Services
Supports virtually any database or data source.
OLE (Deprecated)
ODBC
SQL Server
Parallel Data Warehouse (PDW)
SQL Azure (Cloud Database)
SQL Server Analysis Services
Oracle
XML
Teradata
Can be presented in a variety of methods
Through Report Manager
Embedded in a web page using the Report Viewer .Net Control
Through SharePoint
In a Windows application
As HTML in an Email
SQL Server Reporting Services
Reports can be easily transformed into popular formats.
Word
Excel
CSV
PDF
HTML
Tif
XML
RSS Data Feed
Building your first report
Demo:
Introduction to Report Manager
Shared vs. embedded Data Sources
Shared vs. embedded Data Sets
Report Builder
Deploying your report
Securing your report
Distributing your report
Enhancements
Summary
SSRS is more than just reports.
Report Manager is the hub of SSRS
administration.
Report Builder provides an easy to use
development environment for creating
RDLs.
Additional Resources
Technet (2008R2)
http://technet.microsoft.com/en-us/library/ms159106(v=sql.105).aspx
Brian Swan’s MSDN Blog
http://blogs.msdn.com/b/brian_swan/archive/2010/04/29/getting-started-with-sqlserver-reporting-services-ssrs.aspx
Report Builder 3.0 (2008R2)
http://technet.microsoft.com/en-us/library/dd207008(v=sql.105).aspx
Blog:
http://SQLWes
Twitter:
@SQLWes
Linked-in: http://www.linkedin.com/in/SQLWes
Email:
[email protected]