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. Class is built to include SQL Server 2012 as well. 

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 2000 Professional, or Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista operating system
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server 2008 R2 or SQL Server 2012 Developer Edition, Standard Edition or Enterprise Edition with the client tools, SSIS and SSRS
  • AdventureWorks2008 and AdventureWorksDW2008 databases installed on the 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