Performance Tuning Workshop
Thank you guys so much for coming to Denver. That was the best DBA class I have taken. I really hope you're coming back next year to talk 2014!

- Michael Husler, NOAA Federal

Performance Tuning Workshop
Class was overflowing with value delivered by extremely competent professionals and instructors and I have walked away truly enriched by it.

- Zoran Cvijetic
Sr. SQL Server DBA /
Database Systems Architect
20th Century Fox
Master SSIS Workshop
I have taken probably 50 training classes in my career and this one was, by far, the best one I've taken. Perfect match for what I was looking for. Great job!

- Peter Tassmer, ConnectiCare

Performance Tuning Workshop
If you have the time and money, please take the workshop. You might even learn something like this old IT guy did.

-John F Miner III, Senior SQL Developer at Total Quality Management
Fine Tune Your SQL Skills in 2 Days

Join Pragmatic Works as we tour the country with our live two-day sessions on SSIS, SSRS & Performance Tuning.  We target major cities providing affordable SQL training courses sure to be near your local home base. 

Microsoft SQL industry experts delivering quality training. 

Master SSRS Workshop

Duration: 2 Days
  • Report Design Patterns
  • .Net Integration
  • Using SSAS as a Data Source
  • Advanced SSRS Expressions
  • Report Manager
  • Report Builder 3.0
  • Configuration
  • Report Utilization
  • Security
  • Performance
  • Sharepoint Integration
  • Web Farm
  • Data Driven Subscriptions
  • Accessing Report Server Remotely

Overview

Master Report Developers must hold unique traits to set themselves and their work apart from others. This two day class is designed to take you to the next level in your understanding of SQL Server 2008 R2 Reporting Services (SSRS). You will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies. This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage. This class is built to work for students using one of the following versions of SQL Server: 2008R2/2012/2014. Audience participation is encouraged so bring your laptop ready to go with the system requirements below.

Scheduled Classes

Class Date/Time Location Cost Details Purchase
Boston Master SSRS Workshop 9/9/2014 - 9/10/2014
8:30 AM - 5:00 PM
Microsoft Office
One Cambridge Center
Cambridge, MA 02142
$399.00

Outline

Day 1 – Report Development and User Interface

  1. Report Design Patterns
    • 5 Second Rule
    • Spotting Design Mistakes
    • Choosing Colors
    • Choosing Charts
  2. .Net Integration
    • Why use Custom Code?
    • Direct Embedding
    • External Assemblies
  3. Using SSAS as a Data Source
    • Building a Dynamic Cube Report
    • Tips and Tricks
    • Building a Data Mining Report
  4. Advanced SSRS Expressions
    • Advanced Functions
    • Launch Office Tools from your report
    • Launching Bing Maps
  5. Report Manager
    • Linked Reports
    • Object Visibility
    • My Reports
  6. Report Builder 3.0
    • Train the Trainer: How to Teach End Users
    • Using Report Parts

Day 2 – Administration and Enterprise Solutions

  1. Configuration
    • Setting up an Email Server
    • Configuring an Execution Account
    • Understanding and Enabling Encryption Keys
    • Using SSL within SSRS
  2. Report Utilization
    • Setting up a Monitoring database
    • Scheduling Monitoring Database Updates
    • Usage Reports
  3. Security
    • Role based security explained
    • Creating System-Level Permissions
    • Creating Item-Level Permissions
    • Creating Custom Security Roles
  4. Performance
    • Creating Snapshots
    • Performance Tuning with Report Caching
    • SSRS Performance Counters
  5. Sharepoint Integration
    • Report Server Database
    • Configuration
    • Deployment
  6. Web Farm
    • Understanding Scaling-Out Architecture
    • Setup and Configuration
    • Network Load Balancing
  7. Data Driven Subscriptions
    • Building a Subscription
    • Monitoring Subscriptions
    • Debugging Failed Subscriptions
  8. Accessing Report Server Remotely
    • Report Server Internet Architecture
    • Setup Considerations
  9. Miscellaneous
    • Creating a Report Viewer Control
    • Creating Report Templates
    • Using Document Maps
    • Reporting on Recursive Data
    • Refresh Report Data from Word, PowerPoint, etc...
    • Using Reports to Start SQL Agent Jobs

Prerequisites

The target of this class is at developers, architects or IT professionals who have above average T-SQL skills already and a basic understanding of MDX and VB. This class assumes that you have a strong understanding of SSRS fundamentals. For example, you should already know and use the majority of the toolbox items before attending this class. It is not mandatory but ideally you should have an instance of SharePoint to follow some sections of the class.

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Some features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Reporting Services
    • SQL Server Analysis Services
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
  • **Optional** Full Visual Studio .Net Components. Used for only one module so this is not mandatory.
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance.
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance.
  • AdventureWorks Cube installed on the Analysis Services instance.

Terms & Conditions

Cancellation or rescheduling with less than 1 week email notice is subject to a cancellation/reschedule fee of 100% of the total price. Please contact Sales at sales@pragmaticworks.com or call at 904-638-5743 if you need to cancel or reschedule a class.

Expiration Policy
Must use class and Virtual Mentoring time within 12 months of initial purchase
Copyright 2014 by Pragmatic Works