advanced sql server 2005 reporting services. new data sources in ssrs 2005 reporting services data...
TRANSCRIPT
![Page 1: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/1.jpg)
Advanced SQL Server 2005 Reporting Services
![Page 2: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/2.jpg)
• New Data Sources in SSRS 2005
• Reporting Services Data Extensions
• Working with SSAS and SSIS Data
• End-User Sort and Parameterization
• Schedules and Subscriptions
What Will We Cover?
![Page 3: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/3.jpg)
Level 300
• Knowledge of Reporting Services
• Familiarity with SSIS and SSAS
• Experience with SQL Server
Helpful Experience
![Page 4: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/4.jpg)
• Understanding Data Extensions
• Using Report Models
• Building SSAS-Based Reports
• Building Parameterized Reports
• Creating Schedules and Subscriptions
Agenda
![Page 5: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/5.jpg)
SQL Server 2005 BI
![Page 6: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/6.jpg)
SQL Server 2005 BI
Data acquisition Data acquisition from source from source systems and systems and integrationintegrationData Data transformation transformation and synthesisand synthesis
IntegrateIntegrate
![Page 7: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/7.jpg)
SQL Server 2005 BI
Data acquisition Data acquisition from source from source systems and systems and integrationintegrationData Data transformation transformation and synthesisand synthesis
Data enrichment Data enrichment with business logic with business logic and hierarchical and hierarchical viewsviewsData discovery Data discovery through data through data miningmining
IntegrateIntegrate AnalyzeAnalyze
![Page 8: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/8.jpg)
SQL Server 2005 BI
Data acquisition Data acquisition from source from source systems and systems and integrationintegrationData Data transformation transformation and synthesisand synthesis
Data enrichment Data enrichment with business logic with business logic and hierarchical and hierarchical viewsviewsData discovery Data discovery through data through data miningmining
Data Data presentation and presentation and distributiondistributionData access for Data access for the massesthe masses
IntegrateIntegrate AnalyzeAnalyze ReportReport
![Page 9: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/9.jpg)
SQL Server 2005 BI
Data acquisition Data acquisition from source from source systems and systems and integrationintegrationData Data transformation transformation and synthesisand synthesis
Data enrichment Data enrichment with business logic with business logic and hierarchical and hierarchical viewsviewsData discovery Data discovery through data through data miningmining
Data Data presentation and presentation and distributiondistributionData access for Data access for the massesthe masses
IntegrateIntegrate AnalyzeAnalyze ReportReport
![Page 10: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/10.jpg)
Data Sources and Extensions
• SQL Server • OLE DB• ODBC• Oracle• Other .NET Providers
SP1
• SSIS • SSAS• XML• Report Models• SAP R/3
• SAP BW
![Page 11: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/11.jpg)
Data Sources and Extensions
• SQL Server • OLE DB• ODBC• Oracle• Other .NET Providers
SP1• SSIS • SSAS• XML• Report Models• SAP R/3
• SAP BW
ReportReport ServerServer
Report ProcessingReport Processing
Data ProcessingData Processing
Data Sources(SQL, OLE DB,
ODBC, Oracle, Custom)
SQL Server Report CatalogSQL Server Report Catalog
![Page 12: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/12.jpg)
Data Sources and Extensions
• SQL Server • OLE DB• ODBC• Oracle• Other .NET Providers
SP1• SSIS • SSAS• XML• Report Models• SAP R/3
• SAP BW
ReportReport ServerServer
Report ProcessingReport Processing
Data ProcessingData Processing
Data Sources(SQL, OLE DB,
ODBC, Oracle, Custom)
SQL Server Report CatalogSQL Server Report Catalog
RenderingRendering
Output Formats (HTML, Excel, PDF, Custom)
![Page 13: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/13.jpg)
Integrating SSIS and SSRS
Install SSIS; uncomment extension entry
\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config
![Page 14: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/14.jpg)
Integrating SSIS and SSRS
Install SSIS; uncomment extension entry
Design the package properly
\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config
![Page 15: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/15.jpg)
Integrating SSIS and SSRS
Install SSIS; uncomment extension entry
Design the package properly
Set up account for unattended reports
\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config\MSSQL.n\Reporting Services\ReportServer\rsreportserver.config
![Page 16: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/16.jpg)
Demo
Creating Reports on Integration Services Packages
View the IS Package in Visual Studio Design a Report that Consumes the IS
Package
demonstration
![Page 17: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/17.jpg)
• Understanding Data Extensions
• Using Report Models
• Building SSAS-Based Reports
• Building Parameterized Reports
• Creating Schedules and Subscriptions
Agenda
![Page 18: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/18.jpg)
Report Model Data Extension
![Page 19: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/19.jpg)
Report Model Data Extension
![Page 20: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/20.jpg)
Demo
Designing Reports that Use Report Models
Design a Report in Report Builder Design a Report in Report Designer Use a Drill-through Report
demonstration
![Page 21: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/21.jpg)
• Understanding Data Extensions
• Using Report Models
• Building SSAS-Based Reports
• Building Parameterized Reports
• Creating Schedules and Subscriptions
Agenda
![Page 22: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/22.jpg)
Analysis Services Integration
ReportReport ServerServer
Report ProcessingReport Processing
Data ProcessingData Processing
Analysis ServicesData Sources
SQL Server Report CatalogSQL Server Report Catalog
OLAP Cube
Data Mining Model
MDX queries
DMX queries
![Page 23: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/23.jpg)
Analysis Services Integration
ReportReport ServerServer
Report ProcessingReport Processing
Data ProcessingData Processing
Analysis ServicesData Sources
SQL Server Report CatalogSQL Server Report Catalog
OLAP Cube
Data Mining Model
MDX queries
DMX queries
MDX parametersMember extended properties
Server aggregates
![Page 24: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/24.jpg)
Demo
Creating Reports on Analysis Services Build a Report that Uses a Data Mining
Model Build a Report that Uses a Cube Add Programmatic Padding and
Show/Hide Functionality
demonstration
![Page 25: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/25.jpg)
• Understanding Data Extensions
• Using Report Models
• Building SSAS-Based Reports
• Building Parameterized Reports
• Creating Schedules and Subscriptions
Agenda
![Page 26: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/26.jpg)
Parameters in Reports
Complete a Complete a data querydata query
Filter the Filter the query dataquery data
Link Link reportsreports
Populate Populate drop-downsdrop-downs
Change Change report layoutreport layout
![Page 27: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/27.jpg)
Parameters in Reports
Complete a Complete a data querydata query
Filter the Filter the query dataquery data
Link Link reportsreports
Populate Populate drop-downsdrop-downs
Change Change report layoutreport layout
![Page 28: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/28.jpg)
Parameters in Reports
Complete a Complete a data querydata query
Filter the Filter the query dataquery data
Link Link reportsreports
Populate Populate drop-downsdrop-downs
Change Change report layoutreport layout
![Page 29: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/29.jpg)
Parameters in Reports
Complete a Complete a data querydata query
Filter the Filter the query dataquery data
Link Link reportsreports
Populate Populate drop-downsdrop-downs
Change Change report layoutreport layout
![Page 30: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/30.jpg)
Parameters in Reports
Complete a Complete a data querydata query
Filter the Filter the query dataquery data
Link Link reportsreports
Populate Populate drop-downsdrop-downs
Change Change report layoutreport layout
![Page 31: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/31.jpg)
Demo
Adding End-User Sorting and Parameters to Reports
Build a New Report Enable Detail-Level Sorting Enable Group-Level Sorting
demonstration
![Page 32: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/32.jpg)
• Understanding Data Extensions
• Using Report Models
• Building SSAS-Based Reports
• Building Parameterized Reports
• Creating Schedules and Subscriptions
Agenda
![Page 33: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/33.jpg)
Schedules• Management events
Caching, subscriptions, history
![Page 34: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/34.jpg)
Schedules• Management events
Caching, subscriptions, history
• Stored in databaseIntegrated with SQL Agent
![Page 35: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/35.jpg)
Schedules• Management events
Caching, subscriptions, history
• Stored in databaseIntegrated with SQL Agent
• Polled by Windows service
![Page 36: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/36.jpg)
Schedules - Notes• Management events
Caching, subscriptions, history
• Stored in databaseIntegrated with SQL Agent
• Polled by Windows service
• Calls the Report ProcessorShared schedules
![Page 37: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/37.jpg)
Subscriptions
• Event-triggered
![Page 38: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/38.jpg)
Subscriptions
• Event-triggered
• Delivery extension specifies delivery type
![Page 39: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/39.jpg)
Subscriptions
• Event-triggered
• Delivery extension specifies delivery type
• Specify parameters and format
![Page 40: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/40.jpg)
Subscriptions
• Event-triggered
• Delivery extension specifies delivery type
• Specify parameters and format
• Deliver links and rendered reportshttp://
![Page 41: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/41.jpg)
Subscription Types
Standard
Single report to one or more
addresses
Subscribe with User!UserID
and User!Language
![Page 42: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/42.jpg)
Subscription Types - Notes
Standard
Data-Driven
Single report to one or more
addresses
Subscribe with User!UserID
and User!Language
Dynamic destination list
Customized content for each
destination
![Page 43: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/43.jpg)
• New data sources, especially SSIS and SSAS
• End-user sort and parameterization
• Subscriptions automate report deliveries
Session Summary
![Page 44: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/44.jpg)
www.microsoft.com/technet/SQL-07
Visit TechNet at www.microsoft.com/technet
Visit the following site for additional information
For More Information
![Page 45: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/45.jpg)
These books can be found at all major bookstores and online retailers.
Non-Microsoft Publications
![Page 46: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/46.jpg)
Course ID Title
2944 Updating Your Reporting Skills to
SQL Server 2005 Reporting
Services
For training information and availability www.microsoft.com/learning
Training Resources
![Page 47: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/47.jpg)
• Self-study learning tool free to anyone
• Determines skills gaps
• Provides learning plans
• Post your score; see how you stack up
Visitwww.microsoft.com/assessment
Readiness with Skills Assessment
![Page 48: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/48.jpg)
Become a Microsoft Certified Professional • What are MCP certifications?
Validation in performing critical IT functions.
• Why certify?
Wide recognition of skills gained through experience
More effective deployments with reduced costs
• What certifications are there for IT pros?
MCP, MCSE, MCSA, MCDST, MCDBA
www.microsoft.com/learning/mcp
![Page 49: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/49.jpg)
www.microsoft.com/technet/subscriptions
Heard the News about TechNet?
• Software without time limits
• Complimentary technical support
• The most current resources on hand
![Page 50: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/50.jpg)
Find all these support options at www.microsoft.com/technet/supportMicrosoft offers a progressive series of support options starting with no-charge online support and developing through subscription, incident, and contract support.
1. No-Charge Online Support
Knowledge BaseSearch a vast database of articles to pinpoint the information you need.
NewsgroupsAccess over 20,000 active newsgroups on scores of topics.
Product Support CentersGet answers to frequently asked questions, plus how-to articles and step-by-step instructions organized by product.
DLL Help Database Search here to identify the software used to install a specific DLL version.
Events and Errors Message CenterResolve event and error messages fast with explanations, recommendations, and links to support and resources.
Support WebcastsTune in to live technical presentations by Microsoft experts and take part in real-time Q&A.
ChatsChat online with Microsoft specialists or search the transcript archives.
User Group ProgramAccess information and support for IT and other interest-specific user groups.
TechNet Security Resource CenterGet ahead of security risks with resources that keep you current, including security newsletters and the Microsoft notification service.
2. Subscription-Based Support
TechNet SubscriptionSubscribe to TechNet for a personal library of articles, service packs, how-to’s, resource kits, tools, utilities, and more. Your subscription includes monthly updates delivered on CD or DVD, so you always have the latest information, straight from the source.
Upgrade to a TechNet Plus subscription and add all this:
1. Full-version evaluation software, including Microsoft Office System and Windows Server System™ products, without time restrictions.
2. Free support — two complimentary incidents, plus a discount on other support calls.
3. Unlimited, next-business-day access to reliable answers from the IT community and Microsoft Support Professionals through Managed Newsgroups (English only).
3. Assisted Incident Support
E-mail SupportGet online incident help via e-mail from a Microsoft Support Professional.
Phone SupportGet incident help over the phone from a Microsoft Support Professional.
Phone Support ContractSave with a discounted 5-Pack Phone Support contract.
Advisory ServicesAdd remotely delivered consultation options from Microsoft Advisory Services for proactive support that goes far beyond routine product maintenance.
4. Contract-Based Support
Premier SupportGet the flexibility to match support options to your organization and enjoy direct access to Microsoft technical experts at any time, day or night. Premier Support delivers customized options for businesses with complex needs, including dedicated technical professionals to oversee your support, 24x7 problem resolution, and training and workshops that keep your IT staff up to date.
Essential SupportEssential Support offers prepackaged options specifically designed to meet the fundamental support requirements of any business, large or small. Includes account management, problem resolution, and information services.
![Page 51: Advanced SQL Server 2005 Reporting Services. New Data Sources in SSRS 2005 Reporting Services Data Extensions Working with SSAS and SSIS Data End-User](https://reader035.vdocuments.us/reader035/viewer/2022062511/551a11875503462e378b4ec2/html5/thumbnails/51.jpg)
• Free chats and webcasts
• List of newsgroups
• Microsoft community sites
• Community events and columns
Where Else Can I Get Help?
www.microsoft.com/sql/community