Are you looking for online training opportunities for next week for you or your staff?  We have two sessions next week - both qualify for our Special Mid-Summer Training Sale providing high-quality training to you for only $99! 

Here are our offerings at SQL Server Pro for the week of July 26, 2015:


High Availability and Disaster Recovery with SQL Server 2014 AlwaysOn Availability Groups

Presented by Michael Otey

Wednesday, July 29th

Special Mid-Summer Training Sale!

$237 $99


Join Michael Otey for this technical online training course that gives you a deep dive into SQL Server AlwaysOn Availability Groups.

You'll see how to setup basic AlwaysOn Availability Groups as well as how to setup more advanced configurations where you mix both synchronous and asynchronous replicas for high availability and disaster recovery.

In addition, you'll learn how to create read-only AlwaysOn Availability Group replicas and how to create AlwaysOn Availability Group replicas in Azure for cloud-based disaster recovery.

By the end of this course, you will know how to:

  • Create Windows Server 2012 R2 Failover Clusters
  • Setup synchronous and asynchronous AlwaysOn Availability Groups
  • Setup read-only replicas
  • Setup an AlwaysOn Availability Group Replica in Azure

In addition to the technical sessions, Michael will be available during each session for LIVE Q&A. PLUS if you miss a live session or want to review the recordings, you will have access to the complete course recordings and materials for 12 months.


Course Agenda:


Session 1: Understanding AlwaysOn Availability Groups – 11am EDT

Michael begins the course by teaching you how to create Windows Server Failover Clusters as well as teaching you a basic guide to setting up SQL Server AlwaysOn Availability Groups.


Session 2: Creating Synchronous, Asynchronous and Read-Only Replicas – 1pm EDT

In this session, you'll see how you can create AlwaysOn Availability Groups that contain both synchronous and asynchronous replicas. You'll also see how you can offload reporting and backups to read-only replicas.


Session 3: Creating AlwaysOn Availability Groups in Azure – 3pm EDT

In the final session, you'll see how you can create SQL Server AlwaysOn Availability group replicas in Azure and use them for cloud-based disaster recovery.


About our instructor:

Michael Otey is senior contributing editor for Windows IT Pro and SQL Server Pro and is president of TECA a technical writing, software-development and consulting company in Portland, Oregon. Michael covers the topics of SQL Server, Windows Server, VMware vSphere, virtualization, PowerShell and .NET development. Michael performs hardware and software product reviews for the Windows IT Pro labs. He does frequent webcasts, is a presenter at IT/Dev Connections and has written several books on SQL Server and .NET development


Designing a Mobile Dashboard Solution with Microsoft DataZen

Presented by Paul Turley

Thursday, July 30th @ 11am, 1pm, 3pm EDT

Special Mid-Summer Training Sale!

$237 $99


Microsoft DataZen is a new tool from Microsoft built on a mature and time-tested foundation of enterprise services and visualization components. Analytic dashboards created by data professionals are available to users on desktops and practically all modern mobile device platforms. Enabling a stunning user experience requires BI solution developers to set up servers, configure services and data sources, write queries and design dashboards.

This class will guide students through this complex process and show them how to create a comprehensive dashboard solution; beginning with the essentials and then exploring advanced capabilities to integrate dashboards into an enterprise BI ecosystem.

By the end of the course you will learn:

  • How DataZen fits into an enterprise BI strategy & works with other Microsoft BI & reporting technologies
  • How to build and configure a secure DataZen Enterprise Server
  • How to build and configure a secure DataZen Enterprise Server
  • How to apply advanced features like parameters and expressions to create dashboard navigation & drill-through capabilities

In addition to the technical sessions, Paul will be available during each session for LIVE Q&A. PLUS if you miss a live session or want to review the recordings, you will have access to the complete course recordings and materials for 12 months.


Course Agenda:

Session 1: Introducing DataZen and Building a Server – 11am EDT

In this introductory session, we tour DataZen mobile dashboard solutions, learn about scenarios where the tool is effectively used to provide business value and enable users to visualize data on various mobile devices. Learn how DataZen fits in the Microsoft BI product spectrum and how it can be used to create an integrated BI and reporting solution.

Get started building a solution by installing and configuring DataZen Enterprise Server. Enable email delivery, dashboard hubs, users, branding and caching options. Prepare for dashboard design by creating data sources and data view queries.


Session 2: Essential Mobile Dashboard Design – 1pm EDT

Using the DataZen Publisher and integrated dashboard designer, learn to create functional dashboards for tablet, phone and desktop devices. You will learn to use several visualization controls to create an interactive dashboard experience with navigators and data selectors, gauges, charts, maps and data grids.

This session builds on the foundation of server objects created in the first session, using data sources and data views to drive dashboards and KPIs based on server-hosted data in SQL Server and Analysis Services.


Session 3: Advanced Dashboard Design & Techniques – 3pm EDT

We begin with a tour of sophisticated capabilities used to integrated dashboards into a complete Business Intelligence and enterprise reporting solution. You will learn how parameters and expressions are used to pass selections and context to another dashboard, web site or report. Use expressions and variables to customize the user's navigation experience, providing drill-through paths to dashboards and detail reports.


About Our Instructor:

Paul Turley is a SolidQ mentor and SQL Server MVP. He's an active member of the SQL Server community and director of the Oregon SQL user group. He has authored or coauthored 12 books, including the SSRS, BI, and database reporting series from Wrox.


Need to be invoiced or interested in registering 2 or more people? Please contact our customer service team at or by phone at 800-262-1954 or 913-967-1719. Invoicing options and group discounts are available.